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

21 декабря 2017, 11:00 | Турция
Турция
Россия
0 3
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 03:47:16' and co.date_to >= '2025-04-28 03:47:16' 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 = 977 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 03:47:16' and co1.date_to >= '2025-04-28 03:47:16' and co1.team=977 WHERE m.id=18204) 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 03:47:16' and co.date_to >= '2025-04-28 03:47:16' 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 <= '2025-04-28 03:47:16' and co1.date_to >= '2025-04-28 03:47:16' and co1.team=543 WHERE m.id=18204) 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 03:47:16' and co.date_to >= '2025-04-28 03:47:16' 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 = 977 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 03:47:16' and co1.date_to >= '2025-04-28 03:47:16' and co1.team=977 WHERE m.id=18204) 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 03:47:16' and co.date_to >= '2025-04-28 03:47:16' 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 <= '2025-04-28 03:47:16' and co1.date_to >= '2025-04-28 03:47:16' and co1.team=543 WHERE m.id=18204) 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

В четверг, 21 декабря, на сборе в Анталье женская юниорская сборная России U-17 провела второй товарищеский матч с командой Турции. Российские футболистки одержали крупную победу со счетом 3:0.  

Турция – Россия 0:3 (0:2)

Голы: Рубцова, 6 (0:1). Рубцова, 20 (0:2). Говор, 70 (0:3).

Нереализованный пенальти: Сб. Турции, 75 (вратарь).

Россия: Становова, Кулакова, Еремина (Фролова, 65), Фетисова, Абдуллина, Белоусова (к) (Елисеева, 75), Говор, Комиссарова (Тренькина, 30), Солонович (Лазарева, 65), Шалимова (Воронко, 60), Рубцова (Долматова, 65).

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

- Поздравляю девочек с победой! Тренерскому штабу очень понравилась их реакция на итоги нашей первой товарищеской игры со сборной Турции, в которой мы уступили сопернику со счетом 0:3. По сравнению с той встречей мы добавили в агрессии в атаке и сумели реализовать три своих момента. В целом мы играли хорошо, могли забивать больше. На 75-й минуте соперник заработал пенальти за фол в нашей штрафной, но наш вратарь Лена Становова хорошо среагировала на удар и сохранила ворота в неприкосновенности. Отмечу, что все сегодня – молодцы! Девочки боролись, старались. Понравилось, что футболистки, которые выходили на замены, усиливали игру. Но отдыхать не время. Сбор в Турции продолжается. У нас осталось два тренировочных дня, на которые у нас также запланирована насыщенная программа. 

***

Сборная России ведет подготовку к Элитному раунду Чемпионата Европы-2018 U-17. В рамках второго этапа квалификации, 8-14 марта, россиянки сыграют с командами Испании, Дании и принимающего мини-турнир Израиля. Финальный турнир ЕВРО-2018 с 9 по 21 мая пройдет в Литве. Титул лучшей европейской сборной среди девушек до 17 лет оспорят 8 команд. Помимо хозяйки соревнования в нем будут участвовать победители семи отборочных мини-турниров.