Sort by:
Japanese Chocolate
Japan has been producing mouth-watering creamy chocolate for a long time, and they're not shy with flavours and textures! Try divine Meltykiss truffles, classic Meiji chocolate bars, and a huge range of Japanese Kit Kat varieties.
|
select count(distinct p.products_id) as total select distinct p.products_id, pd.products_name, pd.products_tag, 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, case when p.products_quantity > 0 then '1' else '0' end as stockquant from products p inner join products_to_categories p2c on p.products_id = p2c.products_id inner join products_description pd on p.products_id = pd.products_id left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and (p.products_archive != '1' or (p.products_archive = '1' and p.products_quantity > 0)) and p2c.categories_id in (24) and p.products_veg = '1' and p.products_quantity > 0 [TEP STOP] |