select concat('https://', au.name, '.est.ua/') as link, count(eo.record_id) as apps
from auser au
join est_object eo on au.auser_id = eo.auser_id and eo.is_published = 1 and eo.is_import = 0
where au.is_published = 1 and au.is_profi_paket = 0
group by 1
having apps >= 10
order by apps desc
limit 500