Международные турниры, Международный турнир во Франции

21 мая 2010, 20:11 | Франция | Тулон
Россия
Чили
0 5
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-05-09 20:32:48' and co.date_to >= '2025-05-09 20:32:48' 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-05-09 20:32:48' and co1.date_to >= '2025-05-09 20:32:48' and co1.team=633 WHERE m.id=11094) 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-05-09 20:32:48' and co.date_to >= '2025-05-09 20:32:48' 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 = 709 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-05-09 20:32:48' and co1.date_to >= '2025-05-09 20:32:48' and co1.team=709 WHERE m.id=11094) 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-05-09 20:32:48' and co.date_to >= '2025-05-09 20:32:48' 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-05-09 20:32:48' and co1.date_to >= '2025-05-09 20:32:48' and co1.team=633 WHERE m.id=11094) 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-05-09 20:32:48' and co.date_to >= '2025-05-09 20:32:48' 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 = 709 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-05-09 20:32:48' and co1.date_to >= '2025-05-09 20:32:48' and co1.team=709 WHERE m.id=11094) 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

В пятницу поздно вечером молодежная сборная России провела на международном турнире "Надежды" в Тулоне второй матч. Подопечные Игоря Колыванова встречались с командой Чили и уступили со четом 0:5.

Чили — Россия 5:0 (1:0)

Голы: Рубио, 39; Павес, 46; Медель, 55; Мартинес, 68; Убилья, 80.

Чили: Тосельи, Лабрин, Торо, Абарка, Карока, Муньос (Убилья, 75), Павес, Медель (Карбахаль, 66), Мена (Гонсалес, 59), Хоркера, Рубио (Мартинес, 57).

Россия: Песьяков, Макеев, Васин, Власов (Валикаев, 58), Мищенко, Ионов, Мамаев, Абдулфаттах, Смолов (Бадяутдинов, 12), Прудников (Померко, 41), Дядюн.

Предупреждения: Павес, 75; Торо, 80 - Абдулфаттах, 44.

Удаление: Васин, 3.

Судья: Исмаил (Иордания).

Тулон. "Майоль".

В сложное положение российская команда попала уже на 3-й минуте. Арбитр из Иордании посчитал игру новобранца российской молодежки Васина слишком грубой и показал ему красную карточку. Вне всяких сомнений, это сразу же заставило тренерский штаб нашей команды перестроить игру, сконцентрировавашись на обороне собственных ворот. Вместо Смолова на поле появился Бадяутдинов, постаравшийся укрепить защитные порядки.

До 39-й минуты победители прошлогоднего турнира "Надежды" чилийы не могли поразить ворота Песьякова, но тут им помог Рубио, отправивший мяч в цель из пределов штрафной. Во втором тайме футболисты сборной Чили раскрепостились, и удача к ним оказалась вполне благосклонна. Павес, Медель, Мартинес, Убилья забивали голы на любой вкус, а вот Дядюн и Мамаев свои шансы не реализовали. В итоге россияне потерпели крупное поражение. В воскресенье им предстоит провести заключительный матч на турнире со сборной Катара. Начало в 20.15 по московскому времени.