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

Select bl.id branch_id, bl.branch_name,c.clinic_name,city.cityName,d.*,(SELECT GROUP_CONCAT(degree SEPARATOR '
') FROM clinic_tbl_doctors_profile_degrees WHERE doctor_profile_id=d.id) AS degreelist from clinic_tbl_doctors_profile AS d left join clinic_tbl_clinic_registered_users as c on c.id=d.clinicId LEFT JOIN clinic_tbl_doctor_allocated_branches AS a ON a.doctorId=d.id left join clinic_tbl_clinic_branches_list as bl on bl.clinicId=d.clinicId and a.branchId=bl.id left join clinic_tbl_citylist as city on city.id=bl.city WHERE d.status='1' and d.asFeatured='1' and c.publish_status='1' and bl.country=2 group by d.id Order by RAND() limit 0,10

Filename: models/Homemodel.php

Line Number: 416