Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lawsisto.lpa.consultation_fee_by_phone' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `lpa`.`consultation_fee_by_phone`, `lpa`.`consultation_fee_by_email`, `lpa`.`consultation_fee_by_meeting`, `CT`.`name` AS `case`, `CT`.`id` AS `cid`, `CT`.`description1`, `L`.`practicing_since`, `L`.`name_of_law_firm`, `L`.`lawyer_answers`, `L`.`monday_availability_from`, `monday_availability_to`, `L`.`id` AS `Lid`, `L`.`profile_pic`, `CTY`.`name` AS `city`, `AR`.`name` AS `area`, `L`.`date_add`, `L`.`mobile`, `L`.`website`, `L`.`email`, `L`.`profile_pic`, `L`.`profile_rating`, SUM(LR.rating) AS total, count(LR.rating) AS count FROM `lawyer_practice_area` AS `lpa` INNER JOIN `lawyer` AS `L` ON `L`.`id`=`lpa`.`lawyer_id` LEFT JOIN `practice_area` AS `P` ON `P`.`id`=`lpa`.`id_practice_area` LEFT JOIN `case_type` AS `CT` ON `CT`.`id_practice_area`=`lpa`.`id_practice_area` LEFT JOIN `city` AS `CTY` ON `CTY`.`id`=`L`.`city` LEFT JOIN `area` AS `AR` ON `AR`.`id`=`L`.`area` LEFT JOIN `lawyer_ratings` AS `LR` ON `LR`.`lawyer_id`=`L`.`id` WHERE `CTY`.`id` = '571' GROUP BY `lpa`.`lawyer_id` ORDER BY `L`.`position` DESC
Filename: modules/welcome/models/Practicearea_model.php
Line Number: 1246