select concat('https://', au.name, '.est.ua/') as link, ad.first_name, ad.last_name
from auser au
join auser_data ad on au.auser_id = ad.auser_id
where au.is_published = 1 and ad.first_name = ad.last_name and ad.first_name != ''
order by link