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 = 61 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 Hampstead 2 Tone Dining -
      www.interwoodlimited.com       Email Us:  sales@interwoodvn.com

Quick Find:    

Home » DINING & LIVING » Hampstead 2 Tone Dining

Hampstead 2 Tone 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
other images
other images
other images