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

SELECT DISTINCT products.products_id, seo_cpath , products_name, products_model, products.seo_keyword_01 FROM products LEFT JOIN products_description USING(products_id) LEFT JOIN products_extra USING(products_id) LEFT JOIN productstats USING(products_id) LEFT JOIN manufacturers USING(manufacturers_id) LEFT JOIN products_seocpath ON products_seocpath.products_id = products.products_id AND products_seocpath.store_id = "1" WHERE 1=1 AND products.products_id = "1192" ORDER BY productstats.intelligent_sort_order ASC , products.sort_order ASC , products_description.products_name ASC LIMIT 0, 50