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 = 133 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 Interwood Limited - Montreux Pale Oak and Antique White Dining -
      www.interwoodlimited.com       Email Us:  sales@interwoodvn.com

Quick Find:    

Home » DINING & LIVING » Montreux Pale Oak / Antique White Dining

Montreux Pale Oak / Antique White Dining

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