Error in sql statement:
SELECT d.did, d.durl, d.dname,d.customer_reviews, d.img, d.message, d.star stars, p.*, DATE_FORMAT(p.date, '%D %M %Y') tour_date, DATE_FORMAT(p.date, '%m') tour_month, DATEDIFF(p.date,curdate()) AS DiffDate, holi.holiday_name, hot.hname, ad.airport_id,ad.am_id FROM destinations d JOIN price_list p ON p.destination=d.did JOIN holiday holi ON p.holiday=holi.hid JOIN hotels hot ON p.hotel=hot.hid JOIN airport_destination ad ON find_in_set(d.did, ad.destinations) WHERE p.status='1' AND date(p.`date`) >'2019-12-12' GROUP BY p.pid ORDER BY p.date ASC
Expression #46 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'solitair_newsite1.ad.airport_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by