a guest Aug 13th, 2017 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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
RAW Paste Data