Executed Query -> select artist.is_plan_active, artist.isaboutverified, artist.plan_expiry_date, artist.id as artistid,artist.email,concat(artist.firstname," ",artist.lastname) as artistname,artist.birthdate,artist.about,artist.contactno,artist.gender,artist.companyname,group_concat(distinct(lang.languagename),"") as languages,group_concat(distinct(cat.categoryname)," ") as categories,avt.image,
(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,ainfo.voicepriceforbase,ainfo.voicehourtatforbase,ainfo.voicemintatforbase,artist.profile_pic_name,c.countryname,s.statename,ci.cityname
from tbl_users as artist
left join tbl_artist_info as ainfo
on artist.id = ainfo.artistid
left join tbl_avatars as avt
on artist.avatar = avt.id
left join tbl_artist_language as art_lan
on art_lan.artistid = artist.id
left join tbl_languages as lang
on art_lan.languageid = lang.id
left join tbl_artist_category as art_cat
on art_cat.artistid = artist.id
left join tbl_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 = "vs896360"
group by artist.id
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'voyzapp_dblive2.ainfo.voicePriceForBase' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 398"