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.main_display_image' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

(SELECT b.main_display_image,cty.cityName,b.website, appssettings.consult_timings,b.branch_name,b.insurances_accepted,d.gender,d.languagesKnown,d.nationality,b.country,b.city,b.locality, d.doctorLogo, d.briefProfile, d.consultancyFeeCurrency,d.requestBooking,d.teleconsultation,d.instantBooking , d.primaryMobileNo, d.counsultancyPrice, b.branch_timings, (TRIM(TRAILING ', ' FROM d.specalities)) AS specalities, a.doctorId AS docId, a.branchId AS branchId, d.clinicId, b.address, b.google_map_latitude, b.google_map_longitude, (CONCAT('Dr. ',CONCAT_WS(' ',d.firstName,d.middleName,d.lastName))) AS DoctorName, ( SELECT count(id) FROM clinic_tbl_doctors_profile_reviews WHERE status='1' AND recommend='1' AND doctorId=a.doctorId ) AS doctorRecommendedCount, ( SELECT count(id) FROM clinic_tbl_doctors_profile_reviews WHERE status='1' AND doctorId=a.doctorId ) AS doctorTotalReviews, c.clinic_name,c.licence_expiry_date FROM clinic_tbl_doctors_profile AS d LEFT JOIN clinic_tbl_doctor_allocated_branches AS a ON a.doctorId=d.id LEFT JOIN clinic_tbl_clinic_branches_list AS b ON b.id=a.branchId LEFT JOIN clinic_tbl_clinic_registered_users AS c ON d.clinicId=c.id LEFT JOIN clinic_tbl_citylist AS cty ON b.city=cty.id left join clinic_tbl_doctor_appointement_settings as appssettings on appssettings.doctorId=d.id and appssettings.branchId=b.id WHERE d.status='1' AND a.branchId IS NOT NULL AND c.publish_status not IN('0') AND FIND_IN_SET('Endocrinologist',trim(', ' from d.specalities)) group by d.id ) UNION (SELECT null,null as cityName, null as website, consultation_timings as consult_timings,null,null,gender,null,null,country,city,null,null,null,null,null,null,null,null,null,consultation_timings,specialisation,id,null,null,address,google_map_latitude,google_map_longitude,doctor_name,null,null,clinic_name,null as licence_expiry_date from clinic_tbl_doctors where id IS NOT NULL AND specialisation LIKE '%Endocrinologist%' )

Filename: controllers/Home.php

Line Number: 907