Executed Query -> select artist.is_plan_active, artist.plan_expiry_date,artist.id as artistid,artist.email,concat(artist.firstname," ",artist.lastname) 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.studio_name,ainfo.workarea,ainfo.rating from tbl_users as artist left join tbl_studio_info as ainfo on artist.id = ainfo.studioid left join tbl_studio_language as art_lan on art_lan.studioid = artist.id left join tbl_languages as lang on art_lan.languageid = lang.id left join tbl_studio_category as art_cat on art_cat.studioid = artist.id left join tbl_studiop_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 = "sd785765" group by artist.id

ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #15 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"