SELECT DISTINCT l.id,l.name FROM statistik_ligen l,statistik_results r WHERE r.liga=l.id AND r.endoflife_id is null AND (r.heim=180 OR r.ausw=180) AND DATE_FORMAT(date,'%y')=14 AND MONTH(date)=11 GROUP BY l.id Home - hockeyfans.at