select
p.products_id,
p.products_image,
p.products_tax_class_id,
p.ecotax_rates_id,
p.products_price as original_price,
s.status as specials_status,
if(s.status, s.specials_new_products_price, p.products_price) as products_price
from products p
left join specials s
on p.products_id = s.products_id,
products_to_categories p2c,
categories c,
homepage_products hp
where
c.categories_status='1'
and p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and products_status = '1'
and hp.products_id=p.products_id
and (hp.date_publish_begin='0000-00-00' OR hp.date_publish_begin <= CURDATE())
and (hp.date_publish_end='0000-00-00' OR hp.date_publish_end >= CURDATE())
GROUP BY p.products_id
order by hp.products_order asc
Shopping Cart
0 items
Until July 31
FREE SHIPPING
for the following products:
- ORIMAG Ear Acupressure Weight Loss
- CERASOCK Bioceramic Heating Socks
- Dynaroma Anti Stress & Revitalising Bracelet
- Bio-Magnetic Bracelet
- Granite Ware Roasting Pan
- Soda-Quick Soda Maker
- Mega Protect Products
- ZeroSmoke to stop smoking
- ZeroDiet to lose weight
