Войти

Гражданство:  СССР

Судья

Город: Джамбул

string(741) "SELECT m.*, ty.title as ff_turnir, ty.ff_sezon, mm.ff_round, c1.ff_clubcat as c1, c2.ff_clubcat as c2, c1.ff_clubadd as na1, c2.ff_clubadd as na2 , r.l_matchreferee, c1.ff_hidden AS ff_hidden1, c2.ff_hidden AS ff_hidden2 FROM ff_match m LEFT JOIN `ff_tournament` ty ON ty.id = m.ff_tur1 LEFT JOIN `ff_tournament_match` mm ON l_value = m.id LEFT JOIN `ff_club` c1 ON c1.id = m.l_club1 LEFT JOIN `ff_club` c2 ON c2.id = m.l_club2 INNER JOIN `ff_match_referee` r ON r.item = m.id WHERE 1 AND r.l_value = '680311' AND r.`l_matchreferee` != 4 and m.l_matchvalidity not in (2,9) and m.ff_turmain1 in (86) and r.l_matchreferee in (1,2,3) ORDER BY m.ff_date asc LIMIT 0, 30"
Дата Турнир
25.08.1977 «Янгиер» Янгиер 3:0 «Сигнал» Челябинск Чемпионат СССР 1977, 28-й тур

Фотогалерея

Добавить фото