borecek

SELECT
CONCAT(umelci.prijmeni,', ' ,LEFT(umelci.jmeno,1),'.') AS 'Příjmení',
staty.nazev_statu AS 'Stát',
CONCAT(DATE_FORMAT(umelci.narozeni,"%e"),".",DATE_FORMAT(umelci.narozeni,"%c"),".",DATE_FORMAT(umelci.narozeni,"%Y")) AS 'Datum narození'

FROM `filmy`
INNER JOIN umelci_ve_filmech ON filmy.idfilmy = umelci_ve_filmech.idfilmy
INNER JOIN umelci ON umelci.idumelci=umelci_ve_filmech.idumelci
INNER JOIN staty ON staty.zkratka_statu=umelci.zkratka_statu
WHERE umelci_ve_filmech.role LIKE 'herec' AND umelci.zkratka_statu NOT LIKE 'CZE'
ORDER BY umelci.prijmeni
LIMIT 5