Partido Real Madrid - Atlético | International Champions Cup 2020

Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

Real Madrid - Atlético Real Madrid - Atlético

Jornada 1

FINALIZADO

3646 Pts. Elo

52%

10º

Real Madrid

3427 Pts. Elo

48%

2º

Atlético

3-7

Sábado, 27 Julio 2019, 02:06

Estadio: MetLife Stadium
Asistencia: 57.714 espectadores

		0 - 1	1'	Diego Costa
		0 - 2	8'	João Félix
		0 - 3	19'	Ángel Correa
		0 - 4	28'	Diego Costa
		0 - 5	45'	Diego Costa
		0 - 6	51'	Diego Costa
Nacho	59'	1 - 6
		1 - 7	70'	Vitolo
K. Benzema	85'	2 - 7
Javi Hernández	89'	3 - 7

Eventos del partido

Goles

minuto 1'

Gol de Diego Costa

minuto 8'

Gol de João Félix

minuto 19'

Gol de Ángel Correa

minuto 28'

Gol de Diego Costa

minuto 45'

Gol de penalti Diego Costa

minuto 51'

Gol de Diego Costa

Gol de

Nacho

minuto 59'

minuto 70'

Gol de Vitolo

Gol de penalti

K. Benzema

minuto 85'

Gol de

Javi Hernández

minuto 89'

Tarjetas

T. Amarilla

Isco

minuto 31'

Tarjeta Roja a

Dani Carvajal

minuto 65'

Tarjeta Roja a Diego Costa

minuto 65'

T. Amarilla Saúl

T. Amarilla

Nacho

minuto 88'

Ocasiones

Tiro al palo

Vinícius Júnior

minuto 39'

Tiro al palo

Dela

minuto 89'

Cambios

minuto 13'

Entra en el partido Ángel Correa

minuto 13'

Sale del partido Á. Morata

Sale del partido

Luka Jović

minuto 30'

Entra en el partido

K. Benzema

minuto 30'

Entra en el partido

Dani Carvajal

minuto 46'

Sale del partido

Á. Odriozola

minuto 46'

Entra en el partido

Keylor Navas

minuto 46'

Sale del partido

T. Courtois

minuto 46'

Sale del partido

Vinícius Júnior

minuto 46'

Entra en el partido

Lucas Vázquez

minuto 46'

Entra en el partido

Javi Hernández

minuto 62'

Entra en el partido

Rodrygo

minuto 62'

Entra en el partido

Take Kubo

minuto 62'

Sale del partido

Sergio Ramos

minuto 62'

Sale del partido

Isco

minuto 62'

Sale del partido

Luka Modrić

minuto 62'

Sale del partido

E. Hazard

minuto 62'

Entra en el partido

Dela

minuto 62'

Entra en el partido

G. Bale

minuto 62'

Sale del partido

Marcelo

minuto 62'

minuto 65'

Sale del partido K. Trippier

minuto 65'

Entra en el partido Carlos Isaac

minuto 66'

Sale del partido Koke

minuto 66'

Entra en el partido Felipe

minuto 66'

Sale del partido Stefan Savić

minuto 66'

Entra en el partido M. Llorente

minuto 66'

Sale del partido Ángel Correa

minuto 66'

Sale del partido Saúl

minuto 66'

Entra en el partido Héctor Herrera

minuto 66'

Entra en el partido Sergio Camello

minuto 66'

Entra en el partido F. Montero

minuto 66'

Entra en el partido Vitolo

minuto 66'

Sale del partido Renan Lodi

minuto 66'

Entra en el partido Manu Sánchez

minuto 66'

Sale del partido João Félix

minuto 66'

Entra en el partido Juan Sanabria

minuto 66'

Sale del partido Thomas Lemar

minuto 66'

Sale del partido M. Hermoso

Otros

minuto 1'

Asistencia João Félix

minuto 8'

Asistencia Saúl

minuto 13'

Lesionado Á. Morata

minuto 19'

Asistencia Koke

minuto 28'

Asistencia Saúl

Lesionado

Luka Jović

minuto 30'

minuto 51'

Asistencia João Félix

Alineaciones

Real Madrid

4-3-3

Alineación Inicial

13
46'

T. Courtois
4
62'

Sergio Ramos
6

Nacho
12
62'

Marcelo
19
46'

Á. Odriozola
8

Toni Kroos
22
62'

Isco
10
62'

Luka Modrić
50
62'

E. Hazard
18
30'

Luka Jović
28
46'

Vinícius Júnior

Suplentes

30

Diego Altube
25

Andriy Lunin
1
46'

Keylor Navas
23

Ferland Mendy
17
46'

Lucas Vázquez
5

R. Varane
2
46'

Dani Carvajal
32
62'

Dela
31
62'

Javi Hernández
33

Á. Fidalgo
21

Brahim Díaz
29

Jaime Seoane
26
62'

Take Kubo
11
62'

G. Bale
9
30'

K. Benzema
27
62'

Rodrygo
7

Mariano

Atlético

4-4-2

Alineación Inicial

13

Jan Oblak
22
66'

M. Hermoso
15
66'

Stefan Savić
12
66'

Renan Lodi
23
65'

K. Trippier
8
66'

Saúl
6
66'

Koke
11
66'

Thomas Lemar
7
66'

João Félix
9
13'

Á. Morata
19
4

Diego Costa

Suplentes

1

Antonio Adán
37

Alex
30
66'

F. Montero
33
65'

Carlos Isaac
18
66'

Felipe
36
66'

Juan Sanabria
35
66'

Manu Sánchez
14
66'

M. Llorente
38

Toni Moya
16
66'

Héctor Herrera
10
13'

Ángel Correa
34
66'

Sergio Camello
20
66'

Vitolo
17

Ivan Šaponjić
32

R. Riquelme

Estadísticas del partido

Real Madrid		Atlético
52%	Posesión del balón	48%
3	Goles	7
5	Tiros a puerta	13
11	Tiros fuera	10
16	Total tiros	23
6	Paradas del portero	2
6	Saques de esquina	4
1	Fueras de juego	2
2	Tarjetas Amarillas	1
1	Tarjetas Rojas	1
0	Asistencias	5
2	Tiros al palo	0
1	Lesiones	1
3	Sustituciones	3
20	Faltas	12

Partido televisado en...

Canal	Medio	Idioma
Gol Play	TV	Castellano
Real Madrid TV	TV	Castellano
Sport 1	TV	Alemán
LaLigaSportsTV	TV	Castellano
DirecTV Sport	TV	Latino
Tigo Sports	TV	Latino
DIRECTV Sports	TV	Latino
DIRECTV Sports	TV	Latino
DIRECTV Sports	TV	-
DIRECTV Sports	TV	-
DIRECTV Sports	TV	-

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

Otros partidos

Fiorentina 2-1 Chivas Guadalajara 170

Arsenal 2-1 Bayern München 239

Manchester United 1-0 Inter 150

Benfica 3-0 Chivas Guadalajara 132

Arsenal 3-0 Fiorentina 43

Bayern München 3-1 Real Madrid 1428

Juventus 2-3 Tottenham Hotspur 264

Real Madrid 2-2 Arsenal 1192

Bayern München 1-0 Milan 78

Chivas Guadalajara 0-0 Atlético 318

Juventus 1-1 Inter 192

Fiorentina 1-2 Benfica 56

Clasificación | Jornada 1

LIGAS RELACIONADAS

USO DE MEMORIA

7,731,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0009
Controller Execution Time ( Match / Index )	1.2310
Total Execution Time	1.2319

CADENA URL

/partido_49360/Real-Madrid/Atletico-Madrid/2020?section=legal

GET DATOS

$_GET['/partido_49360/Real-Madrid/Atletico-Madrid/2020']
$_GET['section']	legal

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0129	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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0130	SELECT c., c.stadium as real_stadium, 2025 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* calendars2025 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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0130	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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0130	SELECT c., c.stadium as real_stadium, 2022 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* calendars2022 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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0128	SELECT c., c.stadium as real_stadium, 2021 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* calendars2021 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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0164	SELECT c., c.stadium as real_stadium, 2020 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* calendars2020 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.league_id = 49360 AND dt1.basealias = 'Real-Madrid' AND dt2.basealias = 'Atletico-Madrid'
0.0255	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 = 49360
0.0127	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2020 AS ev WHERE ev.match_id=189 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.0133	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=49360 WHERE dp.id IN (28178,341347,174483,102322,32019,3318,341684,44027,74892,76168,358618,427581,40603,222134,190177,67500,69148,94324,365923,335085,23341,26968,21292,72,23343,65830,284831,33661,133578,75798,147267,161366,426996,341338,342212,776229,357520,200193,147265) AND (rp.team_id=6273507 OR rp.team_id=6273506)
0.0127	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2020 AS ev WHERE ev.match_id=189 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0133	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=49360 WHERE dp.id IN (341347,28178,76168,40603,174483,33661,222134,3318,44027,358618,74892,190177,67500,69148,94324,102322,341684,365923,335085,23341,26968,21292,427581,72,23343,65830,284831,133578,75798,147267,161366,426996,341338,32019,342212,776229,357520,200193,147265) AND (rp.team_id=6273507 OR rp.team_id=6273506)
0.0125	SELECT data1 FROM stats2020 t WHERE league_id = 49360 AND teamId = 6273507 and type = 33
0.0125	SELECT data1 FROM stats2020 t WHERE league_id = 49360 AND teamId = 6273506 and type = 33
0.0126	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 49360 AND id_match = 189
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='49360' AND relp.team_id = drea.team_id WHERE rel.team_number=2886351 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='49360' AND relp.team_id = drea.team_id WHERE rel.team_number=2886352 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='49360' AND relp.team_id=6273507 WHERE mp.`match_id` = '189' AND mp.year='2020' AND p.id NOT IN (69148,23341,102322,23343,190177,2100,44027,26968,21292,222134,358618,70593,147265,75798,342212,65830,76168,33661,200193,341347,40603,28178) ORDER BY mp.`team` ASC, p.`role` ASC
0.0135	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='49360' AND relp.team_id=6273506 WHERE mp.`match_id` = '189' AND mp.year='2020' AND p.id NOT IN (69148,23341,102322,23343,190177,2100,44027,26968,21292,222134,358618,70593,147265,75798,342212,65830,76168,33661,200193,341347,40603,28178) ORDER BY mp.`team` ASC, p.`role` ASC
0.0127	SELECT kit FROM kit_data_real WHERE league_id = 49360 AND id_match = 189
0.0126	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '189' and rp.type = 2020 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '189' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129	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 = 49360 AND rel.team1 = 6273507 AND rel.team2 = 6273506 ORDER BY FIELD(m.location,'es','en') DESC
0.0125	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 189 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0125	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 189 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0130	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 = 49360 AND rel.team1 = 6273507 AND rel.team2 = 6273506 ORDER BY FIELD(m.location,'es','en') DESC
0.0125	SELECT teamId FROM teams WHERE id = 6273507
0.0125	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2020 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2020 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 = 2107 OR c.datateam2 = 2107) ORDER BY shedule DESC LIMIT 10
0.0125	SELECT teamId FROM teams WHERE id = 6273506
0.0125	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2020 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2020 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 = 369 OR c.datateam2 = 369) ORDER BY shedule DESC LIMIT 10
0.0131	SELECT teamId FROM teams WHERE id = 6273507
0.0128	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2020 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2020 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 = 2107 OR c.datateam2 = 2107) ORDER BY shedule ASC LIMIT 10
0.0126	SELECT teamId FROM teams WHERE id = 6273506
0.0126	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2020 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2020 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 = 369 OR c.datateam2 = 369) ORDER BY shedule ASC LIMIT 10
0.0125	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 `calendars2020` 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` = 49360 AND c.`round` = 1 ORDER BY shedule ASC LIMIT 12
0.0125	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* `tables2020` 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 = 49360 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2020` WHERE league_id = 49360 AND round >= 1 AND round <= 1 AND team = 6273507 ORDER BY round ASC
0.0135	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2020 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2020 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=2020 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6273507 AND c.team2 = 6273506 AND c.league_id = 49360
0.0126	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='189' AND `active` = 1 AND year = 2020
0.0126	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='189' AND `active` = 1 AND year = 2020
0.0126	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='49360' AND relp.team_id=6273507 WHERE relp.in_squad=1 and mp.`match_id` = '189' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` 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='49360' AND relp.team_id=6273506 WHERE relp.in_squad=1 and mp.`match_id` = '189' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '49360' AND id_match = '189'
0.0125	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 = '2886351' ORDER BY rating DESC LIMIT 1
0.0141	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 = '2886352' ORDER BY rating DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=189 AND extraId = 49360 AND type_rel = 4
0.0125	SELECT year FROM leagues WHERE id=49360
0.0125	SELECT shedule FROM calendars2020 WHERE id=189
0.0125	SELECT /115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 189 AND rel.extraId = 49360 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2019-05-28 02:06:00' AND n.creation_date<'2019-09-25 02:06:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0125	SELECT rating1, rating2 FROM calendars_elo WHERE id=189 AND league_id=49360 AND year=2020
0.0125	SELECT position FROM tables2020 WHERE team=6273507 AND league_id=49360 AND round=1
0.0125	SELECT position FROM tables2020 WHERE team=6273506 AND league_id=49360 AND round=1
0.0125	SELECT * FROM futbol.calendars_lineups WHERE id = 189 AND league_id = 49360 AND year = 2020


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

Eventos del partido

Goles

Tarjetas

Ocasiones

Cambios

Otros

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Posesión del balón

Goles

Tiros a puerta

Tiros fuera

Total tiros

Paradas del portero

Saques de esquina

Fueras de juego

Tarjetas Amarillas

Tarjetas Rojas

Asistencias

Tiros al palo

Lesiones

Sustituciones

Faltas

NOTICIAS RELACIONADAS

Otros partidos

Clasificación | Jornada 1

LIGAS RELACIONADAS