select distinct p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, p.products_sort_order, 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 p.products_id = s.products_id, products_description pd, manufacturers m, products_to_categories p2c where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id != 72 and m.manufacturers_id = '17' order by p.products_sort_order asc
Candle Impressions has been creating high quality Flameless Candles since 2003. They have become a world leader because of their innovative flameless candle technology that allows them to create candles that look and feel just like a regular candle: made of real (scented) wax with a perfect glow and flicker.Candle Impressions has invented the unique, patent-protected solution that provides you with the true ambiance of candlelight, while eliminating the risk of fire.
Candle Impressions enjoys the recognition and support of important organizations such as the US National Fire Protection Association, the United States Fire Administration (USFA), the Canadian HRSDC, the National Fallen Firefighters Foundation, the Canadian Safety Council and the Spiegel Burn Foundation.
VIEW CART |
