![]() |
![]() |
What's New Here? ![]() ![]() ![]() ![]()
select p.products_id, pd.products_name, products_date_available as date_expected from z_products p, z_products_description pd LEFT JOIN z_products_to_categories pc ON p.products_id = pc.products_id LEFT JOIN z_categories c ON pc.categories_id = c.categories_id where c.display='1' AND to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10 [TEP STOP] |