Executed Query -> select u.id, u.full_name, if(u.gender = 'm', 'male', 'female') as gender_text, u.firm_name, u.designation, if(u.reliable_internert = 'y', 'yes', 'no') as reliable_internert_text, concat_ws('-', pmc.phonecode, u.mobile_number) as complete_mobile_number, concat_ws('-', wc.phonecode, u.whatsapp_number) as complete_whatsapp_number, u.skype_id, u.passport_number, u.birthdate, u.need_invitation, if(u.need_invitation = 'y', 'yes', 'no') as need_invitation_text, u.origin_country_id, oc.countryname as origin_country_name, u.issue_date, u.expiry_date, u.annual_turnover, u.business_details, u.buying_requirements, u.selling_requirements, u.company_address, u.city_name, u.company_country_id, cc.countryname as company_country_name, concat_ws('-', op.phonecode, u.office_area_code, u.office_number) as complete_office_number, concat_ws('-', mo.phonecode, u.mobile_number_o) as complete_mobile_number_o, concat_ws('-', of.phonecode, u.fax_area_code, u.fax_number) as complete_fax_number, u.signup_email_address, u.website, u.import_license_no, u.import_figures, u.source_info from tbl_users u left join tbl_country pmc on pmc.countryid = u.mobile_country_code left join tbl_country wc on wc.countryid = u.whatsapp_country_code left join tbl_country oc on oc.countryid = u.origin_country_id left join tbl_country cc on cc.countryid = u.company_country_id left join tbl_country op on op.countryid = u.office_country_code left join tbl_country of on of.countryid = u.fax_country_code left join tbl_country mo on mo.countryid = u.mobile_country_code_o where u.status = 'y' group by u.id order by u.id desc limit 15 offset 0
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'svumshow_svum.pmc.phonecode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 311"