Executed Query -> select distinct timestampdiff(year, artist.birthdate, curdate()) as difference,group_concat(distinct(lang.languagename),"") as languages,group_concat(distinct(pa.performingarea)," ") as performingareas,artist.firstname as firstname,artist.lastname as lastname,artist.id as artistid,artist.avatar,artist.gender,artist.profile_pic_name,artist.is_profile_pic_name_approved,sampl.id as sampleid,sampl.createddate,sampl.sampleposition,sampl.samplefile,city.cityname,country.countryname,country.countryid,cat.categoryname as category, (select case when id > "0" then "y" else "n" end as isfav from tbl_favorite_artist where userid = "0" and artistid = artist.id) as isfav, info.weight,info.performing_area,info.rating from tbl_users as artist left join tbl_modelpic_samples as sampl on artist.id = sampl.modelid left join tbl_model_info as info on artist.id = info.modelid left join tbl_performing_area as pa on info.performing_area = pa.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_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_city as city on city.cityid = info.city left join tbl_country as country on country.countryid = info.country where artist.usertype = "m" and artist.isactive = "y" and artist.is_artist_profile_approved = "a" and sampl.isapproved = "y" and sampl.isactive = "y" and sampl.modelid != "0" group by sampl.id order by sampl.id desc