Executed Query -> select max(t.artistid) as artistid, max(t.avatar) as avatar, max(t.gender) as gender, max(t.is_plan_active) as is_plan_active, max(t.plan_expiry_date) as plan_expiry_date, max(t.profile_pic_name) as profile_pic_name, max(t.sampleid) as sampleid, max(t.createddate) as createddate, max(t.sampletitle) as sampletitle, max(t.samplefile) as samplefile, max(t.category) as category, max(t.language) as language, max(t.voicepriceforbase) as voicepriceforbase, max(t.voicehourtatforbase) as voicehourtatforbase, max(t.voicemintatforbase) as voicemintatforbase from (select distinct artist.id as artistid, artist.avatar, artist.gender, artist.is_plan_active, artist.plan_expiry_date, artist.profile_pic_name, sampl.id as sampleid, sampl.createddate, sampl.sampletitle, sampl.samplefile, cat.categoryname as category, lang.languagename as language from tbl_users as artist left join tbl_artist_samples as sampl on artist.id = sampl.artistid left join tbl_artist_info as info on artist.id = info.artistid left join tbl_category as cat on sampl.categoryid = cat.id left join tbl_languages as lang on sampl.languageid = lang.id left join tbl_city as city on city.cityid = info.city where artist.usertype = "a" and artist.isactive = "y" and artist.is_artist_profile_approved = "a" and sampl.isapproved = "y" and sampl.isactive = "y" and sampl.artistid != "0" and (city.slug = "seoul") order by artist.id ) as t group by t.artistid order by max(t.is_plan_active) desc