Товарищеские матчи, Юношеские сборные 2000

14 марта 2017, -:-
Россия
Залаэгерсег 2000
4 0
IOUT - Result
[0] => select * from (SELECT distinct mp.staff, mp.captain, mp.position, co1.team as nowteam, mp.player as pplayer, mp.number as number, (select co.team from tsi.contracts co inner join tsi.teams tt1 on tt1.id=co.team where p.id = co.player and co.date_from <= '2025-04-28 03:52:12' and co.date_to >= '2025-04-28 03:52:12' and tt1.isclub=false ORDER BY tt1.id in (602,633,1154,1138,1096,1050,921,694,629,595,625,613,617,658,663,542,538,543,826,711,712,849,973,994) desc limit 1) as pteam,
mp.staff::int as st, t.title as ttit, p.id as pid, p.surname as pname, p.first_name as pfirst_name, p.patronymic as ppatronymic, me.id, me.match, me.team, me.player, me.firetime, me.injurytime, me.comment, me.timeout, me.goal, me.autogoal, me.goalfrompenalty, me.pin, me.yc, me.ycyc, me.rc, me.unrealizedpenalty, me.pout, me.pinout, me.realtime, me.cornergoal, me.finegoal, a.ord, a.name as aname FROM tsi.matches m LEFT JOIN tsi.matchplayers mp ON mp.team = 1138 and mp.match=m.id LEFT JOIN tsi.matchevents me ON me.team = mp.team and me.match=m.id and me.player=mp.player INNER JOIN tsi.teams t ON t.id=mp.team INNER JOIN tsi.players p ON p.id=mp.player LEFT JOIN tsi.ampluas a ON a.id=p.amplua LEFT JOIN tsi.contracts co1 ON p.id = co1.player and co1.date_from <= '2025-04-28 03:52:12' and co1.date_to >= '2025-04-28 03:52:12' and co1.team=1138 WHERE m.id=18146) as tbl order by staff, case when COALESCE(position,0) > 0 THEN COALESCE(position,0) = 1 ELSE COALESCE(ord,0) = 1 end DESC, number, pid, firetime, injurytime asc
IOUT - Result
[0] => select * from (SELECT distinct mp.staff, mp.captain, mp.position, co1.team as nowteam, mp.player as pplayer, mp.number as number, (select co.team from tsi.contracts co inner join tsi.teams tt1 on tt1.id=co.team where p.id = co.player and co.date_from <= '2025-04-28 03:52:12' and co.date_to >= '2025-04-28 03:52:12' and tt1.isclub=false ORDER BY tt1.id in (602,633,1154,1138,1096,1050,921,694,629,595,625,613,617,658,663,542,538,543,826,711,712,849,973,994) desc limit 1) as pteam,
mp.staff::int as st, t.title as ttit, p.id as pid, p.surname as pname, p.first_name as pfirst_name, p.patronymic as ppatronymic, me.id, me.match, me.team, me.player, me.firetime, me.injurytime, me.comment, me.timeout, me.goal, me.autogoal, me.goalfrompenalty, me.pin, me.yc, me.ycyc, me.rc, me.unrealizedpenalty, me.pout, me.pinout, me.realtime, me.cornergoal, me.finegoal, a.ord, a.name as aname FROM tsi.matches m LEFT JOIN tsi.matchplayers mp ON mp.team = 1207 and mp.match=m.id LEFT JOIN tsi.matchevents me ON me.team = mp.team and me.match=m.id and me.player=mp.player INNER JOIN tsi.teams t ON t.id=mp.team INNER JOIN tsi.players p ON p.id=mp.player LEFT JOIN tsi.ampluas a ON a.id=p.amplua LEFT JOIN tsi.contracts co1 ON p.id = co1.player and co1.date_from <= '2025-04-28 03:52:12' and co1.date_to >= '2025-04-28 03:52:12' and co1.team=1207 WHERE m.id=18146) as tbl order by staff, case when COALESCE(position,0) > 0 THEN COALESCE(position,0) = 1 ELSE COALESCE(ord,0) = 1 end DESC, number, pid, firetime, injurytime asc
IOUT - Result
[0] => select * from (SELECT distinct mp.staff, mp.captain, mp.position, co1.team as nowteam, mp.player as pplayer, mp.number as number, (select co.team from tsi.contracts co inner join tsi.teams tt1 on tt1.id=co.team where p.id = co.player and co.date_from <= '2025-04-28 03:52:12' and co.date_to >= '2025-04-28 03:52:12' and tt1.isclub=false ORDER BY tt1.id in (602,633,1154,1138,1096,1050,921,694,629,595,625,613,617,658,663,542,538,543,826,711,712,849,973,994) desc limit 1) as pteam,
mp.staff::int as st, t.title as ttit, p.id as pid, p.surname as pname, p.first_name as pfirst_name, p.patronymic as ppatronymic, me.id, me.match, me.team, me.player, me.firetime, me.injurytime, me.comment, me.timeout, me.goal, me.autogoal, me.goalfrompenalty, me.pin, me.yc, me.ycyc, me.rc, me.unrealizedpenalty, me.pout, me.pinout, me.realtime, me.cornergoal, me.finegoal, a.ord, a.name as aname FROM tsi.matches m LEFT JOIN tsi.matchplayers mp ON mp.team = 1138 and mp.match=m.id LEFT JOIN tsi.matchevents me ON me.team = mp.team and me.match=m.id and me.player=mp.player INNER JOIN tsi.teams t ON t.id=mp.team INNER JOIN tsi.players p ON p.id=mp.player LEFT JOIN tsi.ampluas a ON a.id=p.amplua LEFT JOIN tsi.contracts co1 ON p.id = co1.player and co1.date_from <= '2025-04-28 03:52:12' and co1.date_to >= '2025-04-28 03:52:12' and co1.team=1138 WHERE m.id=18146) as tbl order by staff, case when COALESCE(position,0) > 0 THEN COALESCE(position,0) = 1 ELSE COALESCE(ord,0) = 1 end DESC, number, pid, firetime, injurytime asc
IOUT - Result
[0] => select * from (SELECT distinct mp.staff, mp.captain, mp.position, co1.team as nowteam, mp.player as pplayer, mp.number as number, (select co.team from tsi.contracts co inner join tsi.teams tt1 on tt1.id=co.team where p.id = co.player and co.date_from <= '2025-04-28 03:52:12' and co.date_to >= '2025-04-28 03:52:12' and tt1.isclub=false ORDER BY tt1.id in (602,633,1154,1138,1096,1050,921,694,629,595,625,613,617,658,663,542,538,543,826,711,712,849,973,994) desc limit 1) as pteam,
mp.staff::int as st, t.title as ttit, p.id as pid, p.surname as pname, p.first_name as pfirst_name, p.patronymic as ppatronymic, me.id, me.match, me.team, me.player, me.firetime, me.injurytime, me.comment, me.timeout, me.goal, me.autogoal, me.goalfrompenalty, me.pin, me.yc, me.ycyc, me.rc, me.unrealizedpenalty, me.pout, me.pinout, me.realtime, me.cornergoal, me.finegoal, a.ord, a.name as aname FROM tsi.matches m LEFT JOIN tsi.matchplayers mp ON mp.team = 1207 and mp.match=m.id LEFT JOIN tsi.matchevents me ON me.team = mp.team and me.match=m.id and me.player=mp.player INNER JOIN tsi.teams t ON t.id=mp.team INNER JOIN tsi.players p ON p.id=mp.player LEFT JOIN tsi.ampluas a ON a.id=p.amplua LEFT JOIN tsi.contracts co1 ON p.id = co1.player and co1.date_from <= '2025-04-28 03:52:12' and co1.date_to >= '2025-04-28 03:52:12' and co1.team=1207 WHERE m.id=18146) as tbl order by staff, case when COALESCE(position,0) > 0 THEN COALESCE(position,0) = 1 ELSE COALESCE(ord,0) = 1 end DESC, number, pid, firetime, injurytime asc

Юношеская сборная России (игроки 2000 г.р.) продолжает подготовку к старту Элитного раунда ЧЕ-2017 U-17 в Венгрии (21-26 марта). Наша команда проводит здесь учебно-тренировочный сбор, начиная с 10 марта.

Во вторник, 14 марта, россияне провели контрольную встречу со сверстниками из венгерского клуба «Залаэгерсег», в котором одержали победу со счетом 4:0.

Россия – «Залаэгерсек» 4:0 (1:0)

Голы: Радостев, 37 (1:0). Умяров, 49 (2:0). Лебедев, 69 (3:0). Классен, 80 (4:0).

Россия: Шитов (Сангаре, 41), Заварухин (Классен, 41), Москвичев (Гюрджан, 55), Абдуллин (Степанов, 55), Мартынов (Анисимов, 55), Умяров (Миронов, 55), Гоманюк, Колесниченко (Жиронкин, 55), Пруцев (Челидзе, 41), Емельянов (Янов, 41), Радостев (Лебедев, 41).

Дмитрий Ульянов, старший тренер сборной России:

-  В первом тайме мы владели значительным территориальным преимуществом, создали несколько голевых моментов, сумели открыть счет. Радостев здорово открылся в чужой штрафной и после передачи с фланга попал в штангу, но сам же первым оказался на добивании. Соперник играл от обороны, до перерыва нам было тяжело раскачивать защиту венгров.

Во втором тайме произошла серия замен в обеих командах, мы стали острее играть впереди и забили еще три мяча. Сначала Умяров хотел сделать передачу на партнера, но вместо этого отправил мяч за шиворот вратарю – получился курьезный гол. Затем Лебедев воспользовался неуверенной игрой голкипера и отправил отскочивший к нему мяч в сетку. Наконец, Классен установил окончательный счет в матче результативным ударом со штрафного. Большого значения результату спарринга придавать не стоит, самые важные игры ждут нас впереди - в Элитном раунде ЧЕ-2017 U-17.