Specials
0 -
select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, ifnull(hhs.specials_price_happy_hours, s.specials_new_products_price) specials_new_products_price, s.specials_date_added from (products p, products_description pd) left join happy_hours_specials_basic hhs on p.products_id = hhs.products_id and hhs.status_happy_hours = '1' and '07:20:11' BETWEEN hhs.happy_hours_beginning_time and hhs.happy_hours_end_time and now() >= hhs.happy_hours_beginning_date and now() <= hhs.happy_hours_end_date left join specials s on p.products_id = s.products_id and s.status = '1' where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and(s.specials_id is not null or hhs.specials_id is not null) order by hhs.specials_date_added desc, s.specials_date_added desc limit -9, 9
[TEP STOP]