3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'wa2303_db2.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

[ERROR:] func-db.php (0)
[ERROR:] mod-product-lists.php (0)
[ERROR:] index.php (0)

SELECT DISTINCT p.products_id, p.products_ean, p.products_model, p.non_cart, p.non_price, p.shipping_profile, p.products_weight, slp.slp_value, slp.slp_value2, pi.images_file AS products_image, p.products_top_new, pd.products_name, pd.products_short_description, f.status, pd.products_head_title_tag AS products_title, m.manufacturers_id, m.manufacturers_name, mi.title_tag AS manufacturers_title FROM products p left join products_images pi on (p.products_id = pi.products_id and pi.sort = 0 and pi.options_id = 0) LEFT JOIN featured f ON p.products_id = f.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = '2') LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN manufacturers_info mi ON (p.manufacturers_id = mi.manufacturers_id AND mi.languages_id = '2') LEFT JOIN slp slp ON (p.products_unit_id = slp.slp_id AND slp.slp_type = 'pu' AND slp.language_id = '2') WHERE p.products_model NOT LIKE 'GIFT%' AND p.products_ordered > '0' AND p.products_status = '1' ORDER BY p.products_ordered DESC LIMIT 10;