3065. Query Error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'admin_new.cp1.sort' which is not in SELECT list; this is incompatible with DISTINCT Query: SELECT DISTINCT p.*,p.id FROM shop_product p JOIN shop_category_products cp1 ON p.id = cp1.product_id WHERE p.status = 1 AND cp1.category_id = 281 ORDER BY cp1.sort ASC LIMIT 30

The requested resource is not available.