Executed Query -> select p.id, p.first_name, p.last_name, p.email_address, p.firm_name, p.address, bc.category_name as business_category_name, concat_ws('-', mo.phonecode, p.mobile_number) as complete_mobile_number, c.cityname, p.pincode from tbl_patrons p left join tbl_business_category bc on bc.id = p.business_category_id left join tbl_country mo on mo.countryid = p.mobile_country_code left join tbl_city c on c.cityid = p.city_id where p.type = 'p' group by p.id order by p.id asc limit 15 offset 0
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'svumshow_svum.mo.phonecode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 311"