Чемпионат Европы среди женщин, Отборочный раунд

16 июня 2012, 18:00 | Россия | Красноармейск | "Красноармейск"
Россия
Греция
4 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-04-28 04:17:18' and co.date_to >= '2025-04-28 04:17:18' 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 = 542 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 04:17:18' and co1.date_to >= '2025-04-28 04:17:18' and co1.team=542 WHERE m.id=10920) 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 04:17:18' and co.date_to >= '2025-04-28 04:17:18' 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 = 609 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 04:17:18' and co1.date_to >= '2025-04-28 04:17:18' and co1.team=609 WHERE m.id=10920) 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 04:17:18' and co.date_to >= '2025-04-28 04:17:18' 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 = 542 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 04:17:18' and co1.date_to >= '2025-04-28 04:17:18' and co1.team=542 WHERE m.id=10920) 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 04:17:18' and co.date_to >= '2025-04-28 04:17:18' 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 = 609 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 04:17:18' and co1.date_to >= '2025-04-28 04:17:18' and co1.team=609 WHERE m.id=10920) 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 Суслова Елена 28′
5 Петрова Ольга
7 Машина Олеся
10 Терехова Елена
11 Сочнева Екатерина 60′ 65′
15 Костюкова Анастасия 24′
18 Медведь (Семенченко) Елена 46′
19 Цыбутович Ксения 73′
22 Чоловяга Анна
23 Морозова Елена
Запасные
12 Слащинина Кристина
3 Кожникова Анна 46′
4 Дьячкова Мария
16 Перцева Наталья
17 Шляпина (Мокшанова) Наталья 65′ 68′
20 Утицких Алевтина 73′
21 Родионова Анастасия

Греция

Стартовый состав
1 Хараламбиду Элени
2 Димитриу Харула 90′+2′
3 Ксера Эфи
4 Какамбуки Элени 27′
8 Сидира Данэ-Элени
9 Кангули София 55′
10 Хациянниду Наталия 82′
11 Пантелиаду Димитра 71′
14 Пападопулу Анастасия 82′
15 Москофиду Вассо
17 Митку Мария
Запасные
5 Власиаду Ирини
6 Мичалакиди Ефимия 82′
7 Адамаки Мария 55′
12 Гиакумаки Элени
13 Григориу Исидора
16 Хациоглу Евангелия
18 Арванитаки Андула 71′
Главный судья:
Палома Квинтеро Силис (Испания)
Помощники судьи:
Иоланда Парга Родригес (Испания), Мария Луиса Вилла Гутьеррес (Испания)