select distinct products.products_id,products_description.products_name, products.products_image, products.products_tax_class_id, products.products_price from products,products_description where products.products_status = '1' AND products_description.products_id = products.products_id order by products_date_added desc limit 10