SELECT a.*, b.name as heimname, c.name as gastname, DATE_FORMAT(a.datum,'%d.%m.%Y') AS datum FROM spielplan a LEFT JOIN teams b ON a.heim=b.id LEFT JOIN teams c ON a.gast= c.id WHERE a.liga=3 AND a.heim !=0 AND a.gast !=0 ORDER BY a.spieltag,a.datum