4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Madrid

Real Madrid

Entrenador: Carlo Ancelotti

Presidente: Florentino Pérez

Información
  • Nombre del equipo Real Madrid
  • Nombre completo Real Madrid Club de Fútbol
  • Nombre corto RMA
  • País España
  • Ciudad Madrid
  • Presidente Florentino Pérez
  • Entrenador Carlo Ancelotti
  • URL del equipo en RF //m.resultados-futbol.com/Real-Madrid
Otros Datos
  • Año de Fundación 1902
  • Patrocinador Emirates
  • Equipo Filial RM Castilla
  • Marca de Ropa Adidas
  • Lugar de entrenamiento Valdebebas
  • Socios 86000
Internet

Información sobre el estadio

  • Nombre del estadio Santiago Bernabéu
  • Capacidad 85454
  • Dirección Avenida de Concha Espina 1, Chamartín
  • Teléfono 34 (91) 398 43 00
  • Fax 34 (91) 398 43 82
  • Año de construcción 1947
  • Tamaño 105 x 66 metros
Santiago Bernabéu

Histórico de participación

Copa del Rey
Primera División
Champions League Grupo 0
Trofeo Santiago Bernabéu
Partidos Amistosos
Supercopa de España
Trofeo Teresa Herrera
Trofeo Ramón de Carranza
15 veces
Europa League
9 veces
International Champions Cup
8 veces
Supercopa Europa
8 veces
Mundial de Clubes
7 veces
Trofeo Ciutat de Palma
6 veces
Copa Intercontinental
5 veces
Trofeo Colombino
5 veces
Copa de la Liga de España
4 veces
Recopa de Europa
4 veces
Trofeo Costa del Sol
4 veces
Soccer Champions Tour
3 veces
(2025, 2024, 2023)
Copa Audi
2 veces
(2019, 2015)
Copa Latina
2 veces
(1957, 1955)
Peace Cup Grupo 2
2 veces
(2010, 2010)
Trofeo Naranja
2 veces
(2004, 1991)
Partidos Amistosos No Reconocidos
1 vez
(2012)
Fase Previa Champions League Grupo 3
1 vez
(2005)
Trofeo Ciudad de Zaragoza
1 vez
(2006)
Copa Eva Duarte
1 vez
(1948)
Copa Emirates
1 vez
(2008)
Copa Iberoamericana
1 vez
(1994)
MLS All-Star
1 vez
(2017)
Superliga Europea
1 vez
(2022)

Partidos del Real Madrid

Ir al LIVESCORE
14 May 03  Finalizado Juventus Juventus
3 - 1
Real Madrid Real Madrid 10
06 May 03  Finalizado Real Madrid Real Madrid
2 - 1
Juventus Juventus 2
23 Abr 03  Finalizado Manchester United Manchester United
4 - 3
Real Madrid Real Madrid 4
08 Abr 03  Finalizado Real Madrid Real Madrid
3 - 1
Manchester United Manchester United 1
18 Mar 03  Finalizado Lokomotiv Moskva Lokomotiv Moskva
0 - 1
Real Madrid Real Madrid 0
12 Mar 03  Finalizado Real Madrid Real Madrid
3 - 1
Milan Milan 1
25 Feb 03  Finalizado B. Dortmund B. Dortmund
1 - 1
Real Madrid Real Madrid 2
19 Feb 03  Finalizado Real Madrid Real Madrid
2 - 1
B. Dortmund B. Dortmund 1
11 Dic 02  Finalizado Real Madrid Real Madrid
2 - 2
Lokomotiv Moskva Lokomotiv Moskva 0
26 Nov 02  Finalizado Milan Milan
1 - 0
Real Madrid Real Madrid 0
12 Nov 02  Finalizado Genk Genk
1 - 1
Real Madrid Real Madrid 0
30 Oct 02  Finalizado Real Madrid Real Madrid
0 - 1
Roma Roma 0
22 Oct 02  Finalizado Real Madrid Real Madrid
2 - 2
AEK Athens AEK Athens 0
02 Oct 02  Finalizado AEK Athens AEK Athens
3 - 3
Real Madrid Real Madrid 0
25 Sep 02  Finalizado Real Madrid Real Madrid
6 - 0
Genk Genk 0
17 Sep 02  Finalizado Roma Roma
0 - 3
Real Madrid Real Madrid 1
22 Jun 03  Finalizado Real Madrid Real Madrid
3 - 1
Athletic Athletic 7
15 Jun 03  Finalizado Atlético Atlético
0 - 4
Real Madrid Real Madrid 14
31 May 03  Finalizado Real Madrid Real Madrid
1 - 1
Celta Celta 1
24 May 03  Finalizado Valencia Valencia
1 - 2
Real Madrid Real Madrid 0
18 May 03  Finalizado Real Madrid Real Madrid
5 - 1
Málaga Málaga 0
10 May 03  Finalizado Recreativo Recreativo
0 - 0
Real Madrid Real Madrid 0
03 May 03  Finalizado Real Madrid Real Madrid
1 - 5
Mallorca Mallorca 8
27 Abr 03  Finalizado Sevilla Sevilla
1 - 3
Real Madrid Real Madrid 0
19 Abr 03  Finalizado Real Madrid Tarjeta RojaReal Madrid
1 - 1
Barcelona Barcelona 2
13 Abr 03  Finalizado Real Sociedad Real Sociedad
4 - 2
Real Madrid Real Madrid 3
05 Abr 03  Finalizado Real Madrid Real Madrid
3 - 1
Rayo Vallecano Rayo Vallecano 0
23 Mar 03  Finalizado Real Madrid Real Madrid
2 - 0
RC Deportivo RC Deportivo 0
15 Mar 03  Finalizado Villarreal Villarreal
0 - 1
Real Madrid Real Madrid 0
08 Mar 03  Finalizado Real Madrid Real Madrid
4 - 1
Racing Racing 0
01 Mar 03  Finalizado Deportivo Alavés Deportivo Alavés
1 - 5
Real Madrid Real Madrid 0
22 Feb 03  Finalizado Real Madrid Real Madrid
3 - 1
Real Valladolid Real Valladolid 0
16 Feb 03  Finalizado Osasuna Osasuna
1 - 0
Real Madrid Real MadridTarjeta Roja 0
08 Feb 03  Finalizado Real Madrid Real Madrid
4 - 1
Real Betis Real Betis 1
02 Feb 03  Finalizado Espanyol Tarjeta RojaEspanyol
2 - 2
Real Madrid Real Madrid 0
26 Ene 03  Finalizado Athletic Athletic
1 - 1
Real Madrid Real Madrid 0
19 Ene 03  Finalizado Real Madrid Tarjeta RojaReal Madrid
2 - 2
Atlético AtléticoTarjeta Roja 0
11 Ene 03  Finalizado Celta Celta
0 - 1
Real Madrid Real Madrid 0
05 Ene 03  Finalizado Real Madrid Real Madrid
4 - 1
Valencia ValenciaTarjeta Roja 1
02 Ene 03  Finalizado Real Madrid Real Madrid
3 - 0
Sevilla SevillaTarjeta Roja 0
21 Dic 02  Finalizado Málaga Málaga
2 - 3
Real Madrid Real Madrid 1
15 Dic 02  Finalizado Real Madrid Real Madrid
4 - 2
Recreativo RecreativoTarjeta Roja 1
08 Dic 02  Finalizado Mallorca Tarjeta RojaMallorca
1 - 5
Real Madrid Real Madrid 0
23 Nov 02  Finalizado Barcelona Barcelona
0 - 0
Real Madrid Real Madrid 7
17 Nov 02  Finalizado Real Madrid Real Madrid
0 - 0
Real Sociedad Real Sociedad 0
09 Nov 02  Finalizado Rayo Vallecano Rayo Vallecano
2 - 3
Real Madrid Real Madrid 0
02 Nov 02  Finalizado RC Deportivo RC Deportivo
0 - 0
Real Madrid Real Madrid 0
26 Oct 02  Finalizado Real Madrid Real Madrid
1 - 1
Villarreal Villarreal 0
19 Oct 02  Finalizado Racing Racing
2 - 0
Real Madrid Real Madrid 2
08 Oct 02  Finalizado Real Betis Real Betis
1 - 1
Real Madrid Real Madrid 0
06 Oct 02  Finalizado Real Madrid Real Madrid
5 - 2
Deportivo Alavés Deportivo Alavés 1
28 Sep 02  Finalizado Real Valladolid Real Valladolid
1 - 1
Real Madrid Real MadridTarjeta Roja 1
21 Sep 02  Finalizado Real Madrid Real Madrid
4 - 1
Osasuna Osasuna 0
02 Sep 02  Finalizado Real Madrid Real Madrid
2 - 0
Espanyol Espanyol 0
29 Ene 03  Finalizado Mallorca Mallorca
4 - 0
Real Madrid Real Madrid 4
23 Ene 03  Finalizado Real Madrid Real Madrid
1 - 1
Mallorca Mallorca 0
14 Ene 03  Finalizado Real Madrid Real Madrid
4 - 2
Terrassa FC Terrassa FC 0
08 Ene 03  Finalizado Terrassa FC Terrassa FC
3 - 3
Real Madrid Real Madrid 5
06 Nov 02  Finalizado Real Oviedo Real Oviedo
0 - 4
Real Madrid Real Madrid 0
11 Sep 02  Finalizado UD Sanse UD Sanse
1 - 8
Real Madrid Real Madrid 2

Plantilla del Real Madrid Temporada 2002/2003

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 52 es 185 85 - - -
1 42 es 185 79 - - -
Defensa
4 56 es 187 84 - - 9
22 44 es 188 78 - - 3
6 49 es 185 75 6 1 8
2 48 es - - - 2 12
17 43 es 175 70 - - -
15 43 es 181 70 1 - -
3 51 br 168 70 5 - 5
29 42 es 187 83 - - -
Centrocampista
24 51 fr 170 64 - - 7
20 48 es 175 71 - - 1
19 43 ar 177 78 - - 2
16 49 br 178 73 1 - 3
14 47 es 182 78 4 - 6
10 51 pt 180 75 10 1 5
21 47 ar 170 70 - - 2
8 52 en 185 72 1 - -
12 45 es 177 69 - - -
5 51 fr 185 76 9 - 4
Delantero
9 48 es 186 78 5 - -
18 42 es 180 70 5 - -
7 46 es 180 71 16 - 1
11 47 br 183 90 23 - 1

Noticias del Real Madrid

Ver últimas noticias

Kim Min-Jae le hace un favor al Madrid

El Bayern de Múnich y el Real Madrid empataron 2-2 en la ida de las semifinales de la Champions League. Los de Thomas Tuchel se mostraron superiores desde el comienzo, pero una genialidad entre Toni Kroos y Vinicius, con la venia de Kim Min-Jae, puso el partido de cara para los 'merengues'. Con el correr del cronómetro, los argumentos de los bávaros, más compatibles con una victoria, decantaron la balanza con goles de Leroy Sané y Harry Kane. Entonces, otro error del surcoreano, este un penalti sobre Rodrygo Goes, devolvió las tablas al electrónico.

El escueto "no" de Kroos sobre si ya ha decidido su futuro

Toni Kroos, una de las figuras del Real Madrid, atendió a los medios de comunicación en el Allianz Arena tras el 2-2 con el Bayern y aseguró con un escueto "no" que todavía no ha tomado una decisión sobre su futuro.

"Nos marcaron 2 goles en nuestro mejor momento"

Carlo Ancelotti habló en zona mixta tras el empate entre Bayern de Múnich y Real Madrid (2-2). El técnico italiano lamentó los tantos encajados justo en el momento en el que su equipo estaba mejor a su modo de ver.

"Toca una noche mágica en casa"

Vinicius, autor de un doblete para el Real Madrid ante el Bayern de Múnich, pasó por los micrófonos de 'Movistar Liga de Campeones' y aseguró que ahora les toca una "noche mágica" en el Santiago Bernabéu para acceder a la final.

"Prefiero jugar como mediocentro, pero en defensa lo doy todo como siempre"

El jugador del Real Madrid Aurélien Tchouaméni empezó el partido ante el Bayern como mediocentro y lo terminó como central. El francés, ya ante los micrófonos de 'Movistar Liga de Campeones', dejó muy claro que está al servicio del equipo, aunque su posición favorita es la de centrocampista.




  USO DE MEMORIA  
7,311,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  1.1242
Total Execution Time  1.1262
  CADENA URL  
/real-madrid/2003
  GET DATOS  
$_GET['/real-madrid/2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0340  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'real-madrid' AND l.year = 2003 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2107 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0161  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 = 38
0.0160  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 = 9636
0.0155  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 = 9640
0.0152  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 = 9650
0.0150  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 = 21476
0.0151  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 = 11896
0.0151  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 = 11939
0.0154  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 = 44814
0.0153  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 = 72509
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2107 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2107 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  SELECT /*35 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 (1313367,1313396,1313392,1313384,1313390) ORDER BY n.cover_points DESC, update_date DESC
0.0324  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2107' ORDER BY l.year DESC,cat.coefficient DESC
0.0180  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2107' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0195  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '2107' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9640 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0166  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 21476 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11939 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11896 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0173  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2003 as c ON c.league_id = l.id WHERE (c.datateam1 = 2107 or c.datateam2 = 2107) AND l.year = 2003 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0213  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 2107 or c.datateam2 = 2107) AND l.year = 2003 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0204  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN events2003 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 2107 or c.datateam2 = 2107) AND l.year = 2003)
0.0217  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=2107 AND l.year in (2002,2003,2004) ORDER BY l.id DESC, l.year DESC ;
0.0146  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72822,72689,72512,44815,21477,11939,11896,11809,9665,39) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 39 AND teamId = 2107
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 9665 AND teamId = 2107
0.0166  SELECT count(id) as num_players from rel_players WHERE league_id = 21477 AND teamId = 2107
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 11896 AND teamId = 2107
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 11809 AND teamId = 2107
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 11939 AND teamId = 2107
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 44815 AND teamId = 2107
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72822 AND teamId = 2107
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72512 AND teamId = 2107
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72689 AND teamId = 2107
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2003` 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 = 38 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0165  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2003 e ON e.player_id = p.id AND e.league_id = 38 WHERE rp.league_id = 38 AND rp.teamId = 2107 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0170  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2003 e ON e.player_id = p.id AND e.league_id = 38 WHERE rp.league_id = 38 AND rp.teamId = 2107 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2003 e ON e.player_id = p.id AND e.league_id = 38 WHERE rp.league_id = 38 AND rp.teamId = 2107 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 2107 AND rp.league_id = 38 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0148  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=2220 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2220
0.0155  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2220 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0152  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2220 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0154  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2220 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0150   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2220 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0150  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2220 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 38 ORDER BY nameShow LIMIT 100