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

20 апреля 2014, 14:00 | Португалия | Порту | Муниципальный
Португалия
Россия
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 06:51:25' and co.date_to >= '2025-04-28 06:51:25' 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 = 632 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 06:51:25' and co1.date_to >= '2025-04-28 06:51:25' and co1.team=632 WHERE m.id=14208) 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 06:51:25' and co.date_to >= '2025-04-28 06:51:25' 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 = 629 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 06:51:25' and co1.date_to >= '2025-04-28 06:51:25' and co1.team=629 WHERE m.id=14208) 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 06:51:25' and co.date_to >= '2025-04-28 06:51:25' 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 = 632 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 06:51:25' and co1.date_to >= '2025-04-28 06:51:25' and co1.team=632 WHERE m.id=14208) 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 06:51:25' and co.date_to >= '2025-04-28 06:51:25' 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 = 629 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 06:51:25' and co1.date_to >= '2025-04-28 06:51:25' and co1.team=629 WHERE m.id=14208) 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

В воскресенье, 20 апреля, юношеская сборная России (игроки 1995 года рождения) провела свой третий и заключительный матч на международном турнире U-19 в Португалии, в котором проиграла хозяевам соревнований со счетом 0:4.

Напомним, что в первом поединке на турнире наша команда сыграла вничью с Чехией (1:1), а во втором - уступила Грузии (2:4).

Португалия – Россия 4:0 (3:0)

Голы: Дуарте, 14 (1:0). Интима, 35 (2:0). Бальде, 40 (3:0). Канде, 62 (4:0).

Португалия: Морейра, Р. Рамос (Канде, 46), Дуарте, Мачадо (Монте, 77), Рафа, Подставски (Палинья, 77), Ф. Рамос (Гуззо, 63), Грача (Рочинья, 63), Интима (Сантос, 63), Бальде, Мартинс (Ребочо, 72).

Россия: Лобанцев, Караваев, Масютин (Каляшин, 87), Ребенко, Лысцов, Мустафин, Мартусевич, Корян (Чуканов, 46), Моргунов (Носов, 90+1), Турик (Салимов, 70), Давыдов.

Грузия - Чехия - 1:2 (0:1)

Итоговое турнирное положение команд.

1. Португалия – 9 очков.
2. Чехия – 4 очка.
2. Грузия – 3 очка.
3. Россия – 1 очко.

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

- В матче с Португалией мы играли вторым номером. Португальцы были посвежее, потехничнее, да и в целом, посильнее, чем мы. Мы пропустили первый гол после исполнения соперником стандартного положения, после чего противостоять хозяевам поля было очень сложно. Явных голевых моментов мы не создали. Плохо, что проиграли. Также не удалось решить задачу, которую мы ставили на турнир – стать его победителями. Но матч против такой сильной сборной, одного из реальных претендентов на звание чемпионов Европы среди футболистов до 19 лет, пойдет в нашу копилку. Мы сделаем выводы, внимательно проанализируем нашу игру, внесем коррективы и подойдем к старту элитного раунда Чемпионата Европы-2014 U-19 в Румынии (5-10 июня) в полной боевой готовности. Крепче, сильнее будем.