Товарищеские матчи,

16 апреля 2013, -:- | Монтенегро
Россия
Албания
12 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 <= '2024-09-08 03:59:26' and co.date_to >= '2024-09-08 03:59:26' 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 = 543 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 <= '2024-09-08 03:59:26' and co1.date_to >= '2024-09-08 03:59:26' and co1.team=543 WHERE m.id=12998) 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 <= '2024-09-08 03:59:26' and co.date_to >= '2024-09-08 03:59:26' 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 = 637 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 <= '2024-09-08 03:59:26' and co1.date_to >= '2024-09-08 03:59:26' and co1.team=637 WHERE m.id=12998) 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 <= '2024-09-08 03:59:26' and co.date_to >= '2024-09-08 03:59:26' 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 = 543 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 <= '2024-09-08 03:59:26' and co1.date_to >= '2024-09-08 03:59:26' and co1.team=543 WHERE m.id=12998) 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 <= '2024-09-08 03:59:26' and co.date_to >= '2024-09-08 03:59:26' 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 = 637 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 <= '2024-09-08 03:59:26' and co1.date_to >= '2024-09-08 03:59:26' and co1.team=637 WHERE m.id=12998) 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

Во вторник, 16 апреля, в Монтенегро стартовал международный турнир среди женских юниорских команд (девушки до 17 лет). Россиянки одержали уверенную победу над представительницами Албании – 12:0. 18 апреля наша сборная проведет второй матч против хозяек турнира.

Россия – Албания 12:0 (8:0)

Голы: Машина, 3 (1:0). Хотырева, 9 (2:0). Машина, 10 (3:0). Шахназарова, 17 (4:0). Колесникова, 24 (5:0). Хотырева, 29 (6:0). Шахназарова, 31 (7:0). Шахназарова, 32 (8:0). Зеленова, 49 (9:0). Зеленова, 60 (10:0). Бочаркина, 61 (11:0). Бочаркина, 69 (12:0).

Россия: Шахворостова (Алексеева, 41), Ледяева (Зеленова, 41), Липатова, Колоскова, Симановская, Шахназарова, Колесникова (Малышева, 41), Бычкова (Артемова, 41), Машина (Чугай, 41), Чернова, Хотырева (Бочаркина, 41).

Николай Кочешков, старший тренер сборной России:

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

Ранее старт турнира планировался 15 апреля, но было принято решение предоставить командам дополнительный тренировочный день. Мы рады, что смогли провести два тренировочных занятия накануне соревнования. И уже играли достаточно подготовленными.

Что касается самой команды, мы смогли собрать практически весь основной состав для участия на турнире. По ряду некоторых обстоятельств несколько игроков не смогли приехать.

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