select distinct p.products_id, p.products_image, p.products_quantity, p.products_price, p.products_retail_price, p.products_tax_class_id, p.products_date_added, pd.products_name, pd.products_description, m.manufacturers_name from (products p, categories c, products_to_categories p2c) left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where c.categories_status='1' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) < 360 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC limit 10
