Товарищеские матчи, Молодежные сборные

10 октября 2014, 16:00 | Венгрия | Телки | Футбол Глобал Парк
Венгрия
Россия
1 1
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:13:19' and co.date_to >= '2025-04-28 06:13:19' 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 = 1100 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:13:19' and co1.date_to >= '2025-04-28 06:13:19' and co1.team=1100 WHERE m.id=14793) 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:13:19' and co.date_to >= '2025-04-28 06:13:19' 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 = 633 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:13:19' and co1.date_to >= '2025-04-28 06:13:19' and co1.team=633 WHERE m.id=14793) 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:13:19' and co.date_to >= '2025-04-28 06:13:19' 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 = 1100 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:13:19' and co1.date_to >= '2025-04-28 06:13:19' and co1.team=1100 WHERE m.id=14793) 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:13:19' and co.date_to >= '2025-04-28 06:13:19' 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 = 633 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:13:19' and co1.date_to >= '2025-04-28 06:13:19' and co1.team=633 WHERE m.id=14793) 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

Венгрия

Стартовый состав
1 Наги Гергели
2 Ботка Эндре
3 Силваши Петер
4 Хангья Сильвестер
5 Ягодик Бенке
6 Кочиш Герго 56′
7 Бесе Барнабаш
8 Худак Мартин 46′
9 Новак Ксанад 25′ 74′
10 Клейнейслер Ласло 90′
11 Тамаш Кристиан 46′
Запасные
12 Банаи Давид
13 Ангиал Золт 46′
14 Ковач Давид
15 Тот Барна 74′
16 Зираи Мартин 90′
17 Проссер Даниэл 46′

Россия

Стартовый состав
1 Лобанцев Мирослав
3 Зуев Илья
5 Серасхов Александр 46′
6 Миранчук Алексей
9 Моргунов Александр 47′ 69′
10 Сердеров Сердер 46′
11 Давыдов Денис 46′
13 Корян Аршак 74′
17 Соколов Владимир 46′
19 Овсянников Владислав
22 Живоглядов Дмитрий
Запасные
12 Цветков Антон
2 Караваев Вячеслав 46′
4 Карпов Максим
7 Бавин Юрий
8 Чхапелия Ника 74′
14 Ефремов Дмитрий 46′
15 Манзон Вадим 46′ 80′
16 Комличенко Николай 80′
18 Евсеев Алексей 69′
20 Богаев Дмитрий
21 Лысцов Виталий
24 Саламатов Никита 46′ 62′
Главный судья:
Адам Радваньи (Венгрия)
Помощники судьи:
Балаж Фаркаш (Венгрия), Габор Майер (Венгрия)