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

20 сентября 2012, -:- | Ашхабад
Россия
Казахстан
2 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-06-26 20:04:08' and co.date_to >= '2025-06-26 20:04:08' 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 = 921 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-06-26 20:04:08' and co1.date_to >= '2025-06-26 20:04:08' and co1.team=921 WHERE m.id=12712) 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-06-26 20:04:08' and co.date_to >= '2025-06-26 20:04:08' 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 = 642 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-06-26 20:04:08' and co1.date_to >= '2025-06-26 20:04:08' and co1.team=642 WHERE m.id=12712) 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-06-26 20:04:08' and co.date_to >= '2025-06-26 20:04:08' 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 = 921 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-06-26 20:04:08' and co1.date_to >= '2025-06-26 20:04:08' and co1.team=921 WHERE m.id=12712) 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-06-26 20:04:08' and co.date_to >= '2025-06-26 20:04:08' 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 = 642 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-06-26 20:04:08' and co1.date_to >= '2025-06-26 20:04:08' and co1.team=642 WHERE m.id=12712) 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

Юношеская сборная России-1997 успешно стартовала на Международном турнире в Ашхабаде. В своем первом матче подопечные Вячеслава Даева победили Казахстан со счетом 2:0. Следующую игру наша команда проведет в субботу с Киргизией.

Международный турнир на Кубок Президента Туркменистана

Групповой этап. Группа А. 1-й тур

Россия - Казахстан - 2:0 (1:0)

Голы: Маликов, 13 (1:0). Терехов, 75 (2:0).

Россия: Акмурзин, Красильниченко, Скопинцев, Евтушенко, Шигорев, Ямщиков (к) (Мелкадзе, 76), Полубояринов, Гордеочук (Терехов, 41), Могулкин, Обольский (Журавлев, 41), Маликов (Дзюс, 60).

Вячеслав Даев, старший тренер сборной России:

- На протяжении всей встречи мы владели ощутимым преимуществом, играли практически на одной половине поля. Мы создали достаточно голевых моментов. Могу сказать, что тренерский штаб доволен содержанием игры, которую показала команда, движением ребят. В пятницу у нас выходной день, а 22 сентября нас ждет игра с Киргизией.

В плане организации соревнований нареканий у нас нет. Встретили, разместили хорошо. Играем на натуральных полях. В целом всё соответствует уровню международного турнира. Единственное, нам пришлось играть в разгар дня. В Туркменистане сейчас жарко, днем температура прилично за 30 градусов. И команде, конечно, приходится непросто. С другой стороны, для ребят это, своего рода, ценный опыт выступления в таких сложных погодных условиях.