Error #3065

Shop

Query Error<br /> Query: SELECT DISTINCT p.*,p.id FROM shop_product p JOIN shop_set_products sp1 ON p.id = sp1.product_id WHERE p.status = 1 AND sp1.set_id = 'bestsellers' ORDER BY sp1.sort ASC LIMIT 500<br /> Error: 3065<br /> Message: Expression #1 of ORDER BY clause is not in SELECT list, references column 'ring.sp1.sort' which is not in SELECT list; this is incompatible with DISTINCT

Please contact app developer.