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"