Non Scented and unscented Flameless Candles. Battery Operated Candles have the same function as ordinary candle. Many consumers prefer unscented candles either because they dont like the scents or they are allergic to them. Many Restaurants, hotels and other public places also prefer unscented candles.
select distinct 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, 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 in (48) order by p.products_sort_order asc
VIEW CART |
