select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, pr.date_recommended from products p, products_description pd, products_recommended pr where p.products_status = '1' and p.products_id = pr.products_id and pd.products_id = pr.products_id and pd.language_id = '3' and pr.status_recommended = '1' order by pr.date_recommended desc limit 10