SELECT ml.`name`, CONCAT("https://www.otosilecek.com/hyundai/", ml.`url_rewrite`, "/") AS `url`
FROM `awc_otomodel` m
LEFT JOIN `awc_otomodel_lang` `ml` ON ml.`id_otomodel` = m.`id_otomodel` AND ml.`id_lang` = 2
WHERE (m.`active` = 1 AND m.`id_otobrand` = 14)
ORDER BY ml.`name` ASC