Partido Dinamarca Sub 19 - Australia Sub 20 | Amistosos Selecciones Sub 20 2023

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

Dinamarca Sub 19 - Australia Sub 20 Dinamarca Sub 19 - Australia Sub 20

Jornada 26

FINALIZADO

517 Pts. Elo

Dinamarca Sub 19

316 Pts. Elo

Australia Sub 20

2(6-7)2

Martes, 17 Octubre 2023, 14:30

		0 - 1	18'	T. Waddingham
Emil Højlund	41'	1 - 1
C. Bischoff	48'	2 - 1
		2 - 2	87'	B. Brandtman

Eventos del partido

Goles

minuto 18'

Gol de T. Waddingham

Gol de

Emil Højlund

minuto 41'

Gol de

C. Bischoff

minuto 48'

minuto 87'

Gol de B. Brandtman

Tarjetas

minuto 67'

T. Amarilla Z. Schreiber

T. Amarilla

Julius Beck

minuto 67'

Cambios

minuto 46'

Entra en el partido Max Vartuli

minuto 46'

Sale del partido A. Pavlešić

minuto 58'

Entra en el partido S. Esposito

minuto 58'

Sale del partido L. Bonetig

minuto 59'

Entra en el partido Z. Schreiber

minuto 59'

Entra en el partido Max Caputo

minuto 59'

Sale del partido M. Mazzone

minuto 59'

Entra en el partido F. Delis

minuto 59'

Sale del partido F. Lino

minuto 59'

Sale del partido Fabian Talladira

Entra en el partido

Z. Sertdemir

minuto 61'

Sale del partido

T. Jørgensen

minuto 61'

Sale del partido

O. Schwartau

minuto 61'

Sale del partido

Emil Højlund

minuto 61'

Entra en el partido

Conrad Harder

minuto 61'

Entra en el partido

Adam Daghim

minuto 61'

minuto 67'

Sale del partido T. Waddingham

minuto 67'

Sale del partido J. Inserra

minuto 67'

Entra en el partido Harry Shillington

minuto 67'

Entra en el partido B. Brandtman

minuto 79'

Entra en el partido L. Jovanović

minuto 79'

Sale del partido A. Badolato

Sale del partido

L. Vraa-Jensen

minuto 82'

Entra en el partido

L. Høgsberg

minuto 82'

Sale del partido

C. Bischoff

minuto 82'

Entra en el partido

Christian Østergaard

minuto 82'

Sale del partido

V. Byskov

minuto 89'

Entra en el partido

Noah Nartey

minuto 89'

Otros

Asistencia

C. Bischoff

minuto 41'

Asistencia

T. Jørgensen

minuto 48'

minuto 87'

Asistencia F. Delis

Tanda de penaltis

Z. Sertdemir

R. Youlley

Adam Daghim

L. Jovanović

Conrad Harder

Paul Okon

Oscar Højlund

Max Caputo

Julius Beck

B. Brandtman

L. Høgsberg

Z. Schreiber

Noah Nartey

S. Esposito

Gustav Fraulo

F. Delis

Villads Nielsen

Harry Shillington

Christian Østergaard

Zach Lisolajski

Alineaciones

Dinamarca Sub 19

4-4-2

Alineación Inicial

1

Theo Sander
4
82'

L. Vraa-Jensen
15

Villads Nielsen
7
82'

C. Bischoff
5

Gustav Fraulo
6

Julius Beck
20

Oscar Højlund
18
89'

V. Byskov
10
61'

T. Jørgensen
17
61'

O. Schwartau
19
61'

Emil Højlund

Suplentes

16

Aske Andrésen
14
82'

Christian Østergaard
3

M. Lauritsen
13
82'

L. Høgsberg
2

Alexander Madsen
8
61'

Z. Sertdemir
12
89'

Noah Nartey
11
61'

Adam Daghim
9
61'

Conrad Harder

Australia Sub 20

4-4-2

Alineación Inicial

18
46'

A. Pavlešić
4

Zach Lisolajski
22
58'

L. Bonetig
25
59'

F. Lino
24
67'

J. Inserra
8
59'

Fabian Talladira
16

Paul Okon
17

R. Youlley
10
79'

A. Badolato
9
59'

M. Mazzone
15
67'

T. Waddingham

Suplentes

12
46'

Max Vartuli
1

S. Hall
13

M. Middleby
2
67'

Harry Shillington
3
58'

S. Esposito
23

B. Bailey
6
59'

F. Delis
5
59'

Z. Schreiber
14

Rawley St. John
20
67'

B. Brandtman
11
59'

Max Caputo
19
79'

L. Jovanović

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,099,736 bytes

BENCHMARKS

Loading Time Base Classes	0.0009
Controller Execution Time ( Match / Index )	2.4145
Total Execution Time	2.4154

CADENA URL

/partido/Dinamarca-Sub19/Australia-Sub-20/2023

GET DATOS

$_GET['/partido/Dinamarca-Sub19/Australia-Sub-20/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0145	SELECT c., c.stadium as real_stadium, 2023 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* calendars2023 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 = 'Dinamarca-Sub19' AND dt2.basealias = 'Australia-Sub-20'
0.0111	SELECT c., 2023 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* calendars2023 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 = 'Dinamarca-Sub19' AND dt2.basealias = 'Australia-Sub-20'
0.0217	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 70836
0.0107	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2023 AS ev WHERE ev.match_id=893248 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.0115	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=70836 WHERE dp.id IN (3275574,3249706,3177125,3384682,3275468,905663,3157660,3382866,3390849,3396203,3159840,1022641,3384705,3416947,3265273,885808,986919,973423,3181197,890880,3401817,3419561,3370594,3212323,3200885,973415,3212797,928177,937130,3306765,3321493,937132,937149,979858,3461624) AND (rp.team_id=6614137 OR rp.team_id=6572610)
0.0107	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2023 AS ev WHERE ev.match_id=893248 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0117	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=70836 WHERE dp.id IN (3275574,3249706,3177125,3157660,3382866,986919,3390849,3396203,3275468,3159840,1022641,3384705,3416947,3265273,885808,973423,3181197,890880,905663,3401817,3419561,3384682,3370594,3212323,3200885,973415,3212797,928177,937130,3306765,3321493,937132,937149,979858,3461624) AND (rp.team_id=6614137 OR rp.team_id=6572610)
0.0105	SELECT data1 FROM stats2023 t WHERE league_id = 70836 AND teamId = 6614137 and type = 33
0.0105	SELECT data1 FROM stats2023 t WHERE league_id = 70836 AND teamId = 6572610 and type = 33
0.0106	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 70836 AND id_match = 893248
0.0111	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='70836' AND relp.team_id = drea.team_id WHERE rel.team_number=4981295 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109	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='70836' AND relp.team_id = drea.team_id WHERE rel.team_number=4981296 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0125	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='70836' AND relp.team_id=6614137 WHERE mp.`match_id` = '893248' AND mp.year='2023' AND p.id NOT IN (3382866,3461624,3396203,3416947,3401817,3265273,3321493,3306765,3212323,1022641,3275574,963774,3200885,979858,3177125,937149,905663,937132,928177,986919,973423,3249706) ORDER BY mp.`team` ASC, p.`role` ASC
0.0142	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='70836' AND relp.team_id=6572610 WHERE mp.`match_id` = '893248' AND mp.year='2023' AND p.id NOT IN (3382866,3461624,3396203,3416947,3401817,3265273,3321493,3306765,3212323,1022641,3275574,963774,3200885,979858,3177125,937149,905663,937132,928177,986919,973423,3249706) ORDER BY mp.`team` ASC, p.`role` ASC
0.0107	SELECT kit FROM kit_data_real WHERE league_id = 70836 AND id_match = 893248
0.0111	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '893248' and rp.type = 2023 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '893248' and rp.type = 2023 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 = 70836 AND rel.team1 = 6614137 AND rel.team2 = 6572610 ORDER BY FIELD(m.location,'es','en') DESC
0.0105	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 893248 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0105	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 893248 AND year = 2023 AND channel = 'Footters' LIMIT 1
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='11' AND rel.active = 1 AND rel.league_id = 70836 AND rel.team1 = 6614137 AND rel.team2 = 6572610 ORDER BY FIELD(m.location,'es','en') DESC
0.0110	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 = 70836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0105	SELECT teamId FROM teams WHERE id = 6614137
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 63128 OR c.datateam2 = 63128) ORDER BY shedule DESC LIMIT 10
0.0105	SELECT teamId FROM teams WHERE id = 6572610
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 6041 OR c.datateam2 = 6041) ORDER BY shedule DESC LIMIT 10
0.0107	SELECT teamId FROM teams WHERE id = 6614137
0.0107	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 63128 OR c.datateam2 = 63128) ORDER BY shedule ASC LIMIT 10
0.0107	SELECT teamId FROM teams WHERE id = 6572610
0.0106	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 6041 OR c.datateam2 = 6041) ORDER BY shedule ASC LIMIT 10
0.0105	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 `calendars2023` 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` = 70836 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 12
0.0105	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2023` WHERE league_id = 70836 AND round >= 35 AND round <= 35 AND team = 6614137 ORDER BY round ASC
0.0137	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* `tables2023` 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 = 70836 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2023 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2023 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=2023 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6614137 AND c.team2 = 6572610 AND c.league_id = 70836
0.0106	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='893248' AND `active` = 1 AND year = 2023
0.0106	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='893248' AND `active` = 1 AND year = 2023
0.0142	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='70836' AND relp.team_id=6614137 WHERE relp.in_squad=1 and mp.`match_id` = '893248' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105	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='70836' AND relp.team_id=6572610 WHERE relp.in_squad=1 and mp.`match_id` = '893248' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '70836' AND id_match = '893248'
0.0107	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 = '4981295' ORDER BY rating DESC LIMIT 1
0.0109	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 = '4981296' ORDER BY rating DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=893248 AND extraId = 70836 AND type_rel = 4
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1988 AND type_rel = 3
0.0109	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1988 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108	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 (1329724,1253756,1253747,1253234,1252467) ORDER BY n.cover_points DESC, update_date DESC
0.0108	SELECT rating1, rating2 FROM calendars_elo WHERE id=893248 AND league_id=70836 AND year=2023
0.0105	SELECT avg_rating FROM elo_teams WHERE id=63128
0.0105	SELECT avg_rating FROM elo_teams WHERE id=6041
0.0105	SELECT position FROM tables2023 WHERE team=6614137 AND league_id=70836 AND round=26
0.0105	SELECT position FROM tables2023 WHERE team=6572610 AND league_id=70836 AND round=26
0.0105	SELECT * FROM futbol.calendars_lineups WHERE id = 893248 AND league_id = 70836 AND year = 2023


	¡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: