Partido Ucrania Sub 23 - Paraguay Sub 23 | Amistosos Selecciones Sub 23 2024

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Ucrania Sub 23 - Paraguay Sub 23 Ucrania Sub 23 - Paraguay Sub 23

Jornada 7

FINALIZADO

6 Pts. Elo

Ucrania Sub 23

523 Pts. Elo

Paraguay Sub 23

2-2

Jueves, 18 Julio 2024, 18:00

M. Khlan	31'	1 - 0
O. Fedor	83'	2 - 0
		2 - 1	86'	Kevin Parzajuk
		2 - 2	89'	Marcelo Fernandez

Eventos del partido

Goles

Gol de

M. Khlan

minuto 31'

Gol de

O. Fedor

minuto 83'

minuto 86'

Gol de Kevin Parzajuk

minuto 89'

Gol de Marcelo Fernandez

Tarjetas

T. Amarilla

D. Kryskiv

minuto 58'

T. Amarilla

Yevhen Pavliuk

minuto 92'

Ocasiones

minuto 40'

Penalti fallado Marcelo Pérez

Penalti parado

Kiril Fesiun

minuto 40'

minuto 51'

Penalti fallado Marcelo Fernandez

Penalti parado

Kiril Fesiun

minuto 51'

Cambios

minuto 28'

Entra en el partido Marcelo Fernandez

minuto 28'

Sale del partido Diego González

minuto 46'

Entra en el partido G. Caballero

minuto 46'

Sale del partido F. Balbuena

minuto 60'

Entra en el partido Kevin Parzajuk

minuto 60'

Sale del partido E. González

minuto 60'

Sale del partido L. Rivas

minuto 60'

Entra en el partido Alexis Cantero

Entra en el partido

O. Ocheretko

minuto 63'

Entra en el partido

O. Fedor

minuto 63'

Sale del partido

M. Braharu

minuto 63'

Entra en el partido

I. Krasnopir

minuto 63'

Sale del partido

D. Kryskiv

minuto 63'

Sale del partido

Danylo Sikan

minuto 63'

minuto 66'

Sale del partido Marcelo Pérez

minuto 66'

Entra en el partido Julio Enciso

minuto 66'

Sale del partido G. Flores

minuto 66'

Entra en el partido F. Román

Entra en el partido

Yevhen Pavliuk

minuto 67'

Sale del partido

M. Taloverov

minuto 67'

Entra en el partido

V. Veleten

minuto 76'

Sale del partido

V. Rubchynskyi

minuto 76'

Entra en el partido

Oleksiy Sych

minuto 76'

Sale del partido

M. Khlan

minuto 76'

Entra en el partido

Kyrylo Siheiev

minuto 76'

Sale del partido

I. Krupskyi

minuto 76'

Otros

minuto 28'

Lesionado Diego González

Asistencia

M. Mykhailenko

minuto 31'

Asistencia

O. Ocheretko

minuto 83'

minuto 89'

Asistencia G. Caballero

Alineaciones

Ucrania Sub 23

4-3-3

Alineación Inicial

12

Kiril Fesiun
13

V. Salyuk
4
67'

M. Taloverov
3

O. Martynyuk
2
76'

I. Krupskyi
8

M. Mykhailenko
5
76'

V. Rubchynskyi
18
63'

D. Kryskiv
10
63'

M. Braharu
14
63'

Danylo Sikan
11
76'

M. Khlan

Suplentes

1

G. Yermakov
22

Y. Kinareikin
19
67'

Yevhen Pavliuk
6
76'

Oleksiy Sych
7
63'

O. Ocheretko
20
76'

Kyrylo Siheiev
17
63'

O. Fedor
21

Artem Shulyanskyi
9
63'

I. Krasnopir
15
76'

V. Veleten

Paraguay Sub 23

3-4-3

Alineación Inicial

1

Gatito
16
46'

F. Balbuena
3

R. De Jesús
5
66'

G. Flores
4
60'

L. Rivas
2

Alan Núñez
6

M. Gómez
10

W. Viera
11
60'

E. González
18
66'

Marcelo Pérez
17
28'

Diego González

Suplentes

12

R. Frutos
13
60'

Alexis Cantero
14
66'

F. Román
8

Diego Gómez
15
66'

Julio Enciso
21

Rubén Lezcano
7
28'

Marcelo Fernandez
19

T. Caballero
9
60'

Kevin Parzajuk
20
46'

G. Caballero

Otros partidos

Uzbekistán Sub 23 1-2 Mali Sub 23 25

Argentina Sub 23 2-0 Paraguay Sub 23 31

Egipto Sub 23 2-1 Costa de Marfil Sub 23 0

Mali Sub 23 2-0 Mali Sub 20 0

Francia Sub 23 4-1 Paraguay Sub 23 37

Francia Sub 23 7-0 República Dominicana Sub 23 29

Estados Unidos Sub 23 1-0 Paraguay Sub 23 2

Ucrania Sub 23 1-1 Egipto Sub 23 0

Egipto Sub 23 2-1 Iraq Sub 23 0

Francia Sub 23 1-1 Japón Sub 23 34

Uzbekistán Sub 23 3-1 Nueva Zelanda Sub 23 0

España Sub 23 1-1 Estados Unidos Sub 23 42

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,145,272 bytes

BENCHMARKS

Loading Time Base Classes	0.0009
Controller Execution Time ( Match / Index )	2.0127
Total Execution Time	2.0136

CADENA URL

/partido/Ucrania-Sub-23/Paraguay-Sub23/2024

GET DATOS

$_GET['/partido/Ucrania-Sub-23/Paraguay-Sub23/2024']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0150	SELECT c., c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Ucrania-Sub-23' AND dt2.basealias = 'Paraguay-Sub23'
0.0110	SELECT c., 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Ucrania-Sub-23' AND dt2.basealias = 'Paraguay-Sub23'
0.0108	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=748400 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0118	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=75079 WHERE dp.id IN (901343,917813,989810,922558,427257,949431,970731,895332,3260239,868606,213078,3317026,868725,3239324,879424,870932,3308583,454345,850678,3139501,3171884,866756,894530,852047,926056,3190198,3151585,796166) AND (rp.team_id=6634822 OR rp.team_id=6626897)
0.0106	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=748400 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0113	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=75079 WHERE dp.id IN (922558,3260239,796166,901343,970731,895332,868606,213078,427257,989810,3317026,868725,3239324,879424,917813,870932,3308583,454345,850678,3139501,3171884,949431,866756,894530,852047,926056,3190198,3151585) AND (rp.team_id=6634822 OR rp.team_id=6626897)
0.0105	SELECT data1 FROM stats2024 t WHERE league_id = 75079 AND teamId = 6634822 and type = 33
0.0105	SELECT data1 FROM stats2024 t WHERE league_id = 75079 AND teamId = 6626897 and type = 33
0.0109	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75079 AND id_match = 748400
0.0128	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75079' AND relp.team_id = drea.team_id WHERE rel.team_number=5729053 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0129	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75079' AND relp.team_id = drea.team_id WHERE rel.team_number=5729054 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0137	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='75079' AND relp.team_id=6634822 WHERE mp.`match_id` = '748400' AND mp.year='2024' AND p.id NOT IN (895332,3142724,866756,887776,3151585,796166,852047,427257,870932,454345,901343,72014,213078,1019219,3139501,868725,904909,3155805,851739,3317026,970731,3260239) ORDER BY mp.`team` ASC, p.`role` ASC
0.0122	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='75079' AND relp.team_id=6626897 WHERE mp.`match_id` = '748400' AND mp.year='2024' AND p.id NOT IN (895332,3142724,866756,887776,3151585,796166,852047,427257,870932,454345,901343,72014,213078,1019219,3139501,868725,904909,3155805,851739,3317026,970731,3260239) ORDER BY mp.`team` ASC, p.`role` ASC
0.0106	SELECT kit FROM kit_data_real WHERE league_id = 75079 AND id_match = 748400
0.0106	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '748400' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '748400' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 75079 AND rel.team1 = 6634822 AND rel.team2 = 6626897 ORDER BY FIELD(m.location,'es','en') DESC
0.0105	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 748400 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 748400 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0108	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 75079 AND rel.team1 = 6634822 AND rel.team2 = 6626897 ORDER BY FIELD(m.location,'es','en') DESC
0.0112	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75079 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	SELECT teamId FROM teams WHERE id = 6634822
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 163331 OR c.datateam2 = 163331) ORDER BY shedule DESC LIMIT 10
0.0118	SELECT teamId FROM teams WHERE id = 6634822
0.0106	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 163331 OR c.datateam2 = 163331) ORDER BY shedule ASC LIMIT 10
0.0106	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 75079 AND c.`round` = 7 ORDER BY shedule ASC LIMIT 12
0.0107	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 75079 AND round >= 13 AND round <= 13 AND team = 6634822 ORDER BY round ASC
0.0105	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 75079 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2024 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2024 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2024 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6634822 AND c.team2 = 6626897 AND c.league_id = 75079
0.0133	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='748400' AND `active` = 1 AND year = 2024
0.0126	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='748400' AND `active` = 1 AND year = 2024
0.0107	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='75079' AND relp.team_id=6634822 WHERE relp.in_squad=1 and mp.`match_id` = '748400' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='75079' AND relp.team_id=6626897 WHERE relp.in_squad=1 and mp.`match_id` = '748400' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0107	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '75079' AND id_match = '748400'
0.0105	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5729053' ORDER BY rating DESC LIMIT 1
0.0105	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5729054' ORDER BY rating DESC LIMIT 1
0.0108	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=748400 AND extraId = 75079 AND type_rel = 4
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1989 AND type_rel = 3
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1989 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0106	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1323872,1318954,1284418,1284397,1283233) ORDER BY n.cover_points DESC, update_date DESC
0.0105	SELECT rating1, rating2 FROM calendars_elo WHERE id=748400 AND league_id=75079 AND year=2024
0.0105	SELECT position FROM tables2024 WHERE team=6634822 AND league_id=75079 AND round=7
0.0105	SELECT position FROM tables2024 WHERE team=6626897 AND league_id=75079 AND round=7
0.0105	SELECT * FROM futbol.calendars_lineups WHERE id = 748400 AND league_id = 75079 AND year = 2024


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra: