Executed Query -> select artist.id as artistid,artist.email,artist.firstname as artistname,artist.birthdate,artist.contactno,artist.gender,artist.companyname,group_concat(distinct(lang.languagename)," ") as languages,group_concat(distinct(cat.categoryname), "") as categories,artist.profile_pic_name, (select ceil(avg(rev.rating)) from tbl_reviews as rev left join tbl_recording_request as req on rev.requestid = req.id where req.artistid = artist.id) as avgrating,artist.profile_pic_name,c.countryname,s.statename,ci.cityname,ainfo.performing_area,ainfo.profile_bio,ainfo.rating from tbl_users as artist left join tbl_model_info as ainfo on artist.id = ainfo.modelid left join tbl_model_language as art_lan on art_lan.modelid = artist.id left join tbl_languages as lang on art_lan.languageid = lang.id left join tbl_model_category as art_cat on art_cat.modelid = artist.id left join tbl_modelp_category as cat on art_cat.categoryid = cat.id left join tbl_country as c on c.countryid=ainfo.country left join tbl_state as s on s.stateid=ainfo.state left join tbl_city as ci on ci.cityid=ainfo.city where artist.id = "md365364" group by artist.id

ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'voyzapp_dblive2.c.countryName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 398"