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 = 138 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 Montreux Pale Oak & Antique White Bedroom -
      www.interwoodlimited.com       Email Us:  sales@interwoodvn.com

Quick Find:    

Home » BEDROOM » Montreux Pale Oak & Antique White Bedroom

Montreux Pale Oak & Antique White 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
other images