MySQL Error Occured
3065: Expression #2 of ORDER BY clause is not in SELECT list, references column 'davoengl_exdb.products.cdate' which is not in SELECT list; this is incompatible with DISTINCT

QUERY = SELECT DISTINCT product_sku, products.product_id, product_list, product_name, file_name, caption, key_features FROM (products, product_category_xref, category) LEFT JOIN product_files ON (product_files.product_id = products.product_id AND product_files.cover = 1) WHERE products.product_id=product_category_xref.product_id AND category.cat_id=product_category_xref.category_id AND category.cat_id='8' AND products.publish='1' ORDER BY product_list,products.cdate DESC