A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'eezyclin_master_live.b.locality' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

(SELECT b.locality,b.branch_name,Null as country,b.address,b.mobile,b. website,cr.clinic_name AS clinicName,b.clinic_services,b.clinic_specalities,cr.id AS clncId, b.id AS brcId, cty.cityName, ((SELECT COUNT(*) FROM clinic_tbl_doctors_profile_reviews WHERE clinicId=cr.id AND b.id=(SELECT branchId FROM clinic_tbl_patient_booking_slots WHERE id=appointmentId ) )) AS totalreviews, (SELECT COUNT(*) FROM clinic_tbl_doctors_profile_reviews WHERE clinicId=cr.id AND b.id=(SELECT branchId FROM clinic_tbl_patient_booking_slots WHERE id=appointmentId ) AND status='1' AND recommend='1') AS totalrecommend FROM `clinic_tbl_clinic_branches_list` AS b LEFT JOIN clinic_tbl_clinic_registered_users AS cr ON cr.id=b.clinicId LEFT JOIN clinic_tbl_citylist AS cty ON b.city=cty.id WHERE cr.publish_status not IN('0') AND FIND_IN_SET('2',country) AND FIND_IN_SET('13',b.city) group by cr.id ) UNION (SELECT null as locality,null as branch_name,country,address,mobile,null as website,clinic_name,clinic_services,clinic_specialities,insurances_accepted,clinic_timings,city,google_map_latitude,google_map_longitude from clinic_tbl_clinics where id is not NULL AND country='United Arab Emirates' AND city='Ajman' )

Filename: controllers/Home.php

Line Number: 683