SELECT id, team1, team2, goal1, goal2, game_date, nodat, fin, lnk1, lnk2, id_turnir, id_sezon FROM games WHERE game_date NOT LIKE '0000%' AND id_turnir IN(270, 271, 272, 273, 274, 275) AND (team1 = 3 OR team2 = 3) GROUP BY team1 ORDER BY game_date DESC LIMIT 100
Локомотив-Перово
В гостях
Строгино
В гостях
Сокол
В гостях
Локомотив
В гостях
Спартак
В гостях
ФШМ
Дома