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 = 132 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 Chartreuse Aged Oak / Antique White Dining -
      www.interwoodlimited.com       Email Us:  sales@interwoodvn.com

Quick Find:    

Home » DINING & LIVING » Chartreuse Aged Oak / Antique White Dining

Chartreuse Aged 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
other images