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