A Database Error Occurred

Error Number: 1055

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

SELECT c.licence_expiry_date,ab.doctorId,ab.branchId,dp.consultancyFeeCurrency,dp.counsultancyPrice, CONCAT('Dr. ',dp.firstName,' ',dp.middleName,' ',dp.lastName) AS doctorName, dp.doctorLogo, dp.experience,dp.instantBooking,dp.requestBooking, TRIM(TRAILING ', ' FROM dp.specalities ) AS specalities,b.branch_name, (SELECT COUNT(recommend) FROM clinic_tbl_doctors_profile_reviews WHERE recommend='1' AND clinicId=ab.clinicId AND doctorId=ab.doctorId) AS totalrecommend FROM `clinic_tbl_doctor_allocated_branches` AS ab Left JOIN clinic_tbl_clinic_branches_list AS b ON b.id=ab.branchId left join clinic_tbl_doctors_profile as dp on dp.id=ab.doctorId left join clinic_tbl_clinic_registered_users as c on c.id=dp.clinicId WHERE ab.`clinicId` = 5 and dp.status='1' AND ab.`userType` = 'doctor' group by ab.doctorId

Filename: controllers/Home.php

Line Number: 2750