SELECT p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM (products p LEFT JOIN specials s on(s.products_id = p.products_id and s.status = 1 and s.customers_group_id = 0) ) LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c WHERE p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = 1 and p2c.categories_id = 124 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access = "G") ORDER BY p.sort_order , pd.products_name Bordeaux Ivory Bedroom -
      www.interwoodlimited.com       Email Us:  sales@interwoodvn.com

Quick Find:    

Home » BEDROOM » Bordeaux Ivory Bedroom

Bordeaux Ivory Bedroom

ITEMS IN THIS CATEGORY
HIGHLIGHT ITEMS IN THIS CATEGORY
other images
other images
other images
other images
other images
other images
other images
other images
other images
other images
other images
other images
other images