You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by hdr.cislodresu,c.prijmeni,c.jmeno,c.datumnarozeni' at line 1 select hvu.*,ifnull(hdr.jmeno,c.jmeno) jmeno,ifnull(hdr.prijmeni,c.prijmeni) prijmeni,hdr.cislodresu,c.pseudonymizace from hracvutkani hvu left join hracdruzstva hdr on hvu.idhracdruzstva = hdr.id and hvu.idsoutez = 278 left join clen c on hdr.idhrac = c.id where hvu.cisloutkani = 'XAA058' AND hvu.idtym = order by hdr.cislodresu,c.prijmeni,c.jmeno,c.datumnarozeni