Error in sql statement:
SELECT d.did,d.dname,d.img,d.message, p.pid, min(p.smart_price) startingFrom, DATE_FORMAT(min(p.date), '%d %M %Y') startingdate FROM destinations d JOIN price_list p ON p.destination= d.did WHERE p.smart_price > 0 AND p.date > '2019-12-10' AND find_in_set('3',d.categories_id) GROUP BY d.did ORDER BY startingFrom ASC
Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'solitair_newsite1.p.pid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by