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