Query Error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'emall.pr.sort' which is not in SELECT list; this is incompatible with DISTINCT Query: SELECT DISTINCT p.*,p.id,p.sku_id,p.image_id,p.image_filename,p.ext FROM shop_product p JOIN shop_product_related pr ON p.id = pr.related_product_id WHERE p.type_id IN (1,5,6,4,7,9,10,11,15,16,19,20,22,23,24,25,26,27,28,29,30,31,32,33,35,36,37,38,39,40,41,42,43,44,45,46,48,51,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,78,79,81,82,83,84,85,86,87,88,89,90,91,93,94,96,98,99,100) AND p.status = 1 AND pr.type = 'cross_selling' AND pr.product_id = 200 ORDER BY pr.sort ASC LIMIT 12