<font color="#000000"><b>3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'xeneca.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT<br /><br />select distinct
                                           p.products_id,
                                           p.products_image,
                                           p.products_tax_class_id,
                                           p.products_price
                                           from products p, products_to_categories p2c, categories c
                                           where p.products_status=1
                                           and p.products_id = p2c.products_id
                                           and p.products_id !='0'
                                           and c.categories_id = p2c.categories_id
                                           
                                           
                                           and c.categories_status=1 order by
                                           p.products_date_added desc limit 10<br /><br /><small><font color="#ff0000">[XT SQL Error]</font></small><br /><br /></b></font>