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

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Chelsea

Enviar Datos
Información
  • Nombre del equipo Chelsea
  • Nombre completo Chelsea Football Club
  • Nombre corto CHL
  • País Inglaterra
  • Ciudad Londres
  • Entrenador Mauricio Pochettino
  • URL del equipo en RF testing.resultados-futbol.com/Chelsea-Fc
Otros Datos
  • Año de Fundación 1905
  • Patrocinador Three
  • Marca de Ropa Nike
  • Socios 34501
Internet

Información sobre el estadio

  • Nombre del estadio Stamford Bridge
  • Capacidad 41841
  • Dirección Fulham Road
  • Teléfono 08719841955
  • Fax 087198419551
  • Año de construcción 1877
  • Tamaño 103 x 67 metros
Stamford Bridge

Histórico de participación

Premier League
90 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1988, 1987, 1986, 1985, 1979, 1978, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1924, 1923, 1922, 1921, 1920, 1915, 1914, 1913, 1910, 1909, 1908)
FA Cup
68 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1978, 1976, 1973, 1972, 1970, 1969, 1968, 1967, 1966, 1965, 1963, 1953, 1952, 1951, 1950, 1948, 1939, 1936, 1932, 1931, 1927, 1921, 1920, 1915, 1911)
EFL Cup
45 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1977, 1973, 1972, 1965, 1961)
Champions League Grupo 5
38 veces
(2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2018, 2018, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2012, 2012, 2011, 2011, 2010, 2010, 2009, 2009, 2008, 2008, 2007, 2007, 2006, 2006, 2005, 2005, 2004, 2004, 2000, 2000, 2000)
Championship
19 veces
(1989, 1984, 1983, 1982, 1981, 1980, 1977, 1976, 1963, 1930, 1929, 1928, 1927, 1926, 1925, 1912, 1911, 1907, 1906)
Partidos Amistosos
14 veces
(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2015, 2014, 2013, 2012, 2011)
Community Shield
13 veces
(2019, 2018, 2016, 2013, 2011, 2010, 2008, 2007, 2006, 2001, 1998, 1971, 1956)
Europa League Grupo 0
6 veces
(2019, 2019, 2013, 2003, 2002, 2001)
International Champions Cup
5 veces
(2019, 2018, 2017, 2016, 2014)
Recopa de Europa
5 veces
(1999, 1998, 1995, 1972, 1971)
Supercopa Europa
5 veces
(2022, 2020, 2014, 2013, 1999)
Copa de Ferias
3 veces
(1969, 1966, 1960)
Fase Previa Champions League Grupo 3
2 veces
(2004, 2000)
Mundial de Clubes
2 veces
(2022, 2013)
Rakuten Cup
1 vez
(2019)
Premier League Summer Series
1 vez
(2024)
Soccer Champions Tour
1 vez
(2025)

Partidos del Chelsea

Ir al LIVESCORE
Champions League Champions League »
12 Abr 11  Finalizado Manchester United
2 - 1
 ChelseaTarjeta Roja 115
06 Abr 11  Finalizado Chelsea
0 - 1
 Manchester United 134
16 Mar 11  Finalizado Chelsea
0 - 0
 Kobenhavn 42
22 Feb 11  Finalizado Kobenhavn
0 - 2
 Chelsea 66
08 Dic 10  Finalizado Olympique Marseille
1 - 0
 Chelsea 23
23 Nov 10  Finalizado Chelsea
2 - 1
 Žilina 39
03 Nov 10  Finalizado Chelsea
4 - 1
 Spartak Moskva 27
19 Oct 10  Finalizado Spartak Moskva
0 - 2
 Chelsea 66
28 Sep 10  Finalizado Chelsea
2 - 0
 Olympique Marseille 19
15 Sep 10  Finalizado Žilina
1 - 4
 Chelsea 15
Premier League Premier League »
22 May 11  Finalizado Tarjeta RojaEverton
1 - 0
 Chelsea 14
15 May 11  Finalizado Chelsea
2 - 2
 Newcastle 15
08 May 11  Finalizado Manchester United
2 - 1
 Chelsea 179
30 Abr 11  Finalizado Chelsea
2 - 1
 Tottenham Hotspur 68
23 Abr 11  Finalizado Chelsea
3 - 0
 West Ham 32
20 Abr 11  Finalizado Chelsea
3 - 1
 Birmingham City 13
16 Abr 11  Finalizado West Bromwich Albion
1 - 3
 Chelsea 46
09 Abr 11  Finalizado Chelsea
1 - 0
 Wigan Athletic 19
02 Abr 11  Finalizado Stoke City
1 - 1
 Chelsea 22
20 Mar 11  Finalizado Chelsea
2 - 0
 Manchester City 68
07 Mar 11  Finalizado Blackpool
1 - 3
 Chelsea 30
01 Mar 11  Finalizado Chelsea
2 - 1
 Manchester UnitedTarjeta Roja 117
14 Feb 11  Finalizado Fulham
0 - 0
 Chelsea 43
06 Feb 11  Finalizado Chelsea
0 - 1
 Liverpool 169
01 Feb 11  Finalizado Sunderland
2 - 4
 Chelsea 55
24 Ene 11  Finalizado Bolton Wanderers
0 - 4
 Chelsea 44
15 Ene 11  Finalizado Chelsea
2 - 0
 Blackburn Rovers 21
05 Ene 11  Finalizado Wolves
1 - 0
 Chelsea 36
02 Ene 11  Finalizado Chelsea
3 - 3
 Aston Villa 84
29 Dic 10  Finalizado Chelsea
1 - 0
 Bolton Wanderers 28
27 Dic 10  Finalizado Arsenal
3 - 1
 Chelsea 187
12 Dic 10  Finalizado Tottenham Hotspur
1 - 1
 Chelsea 95
04 Dic 10  Finalizado Chelsea
1 - 1
 Everton 51
28 Nov 10  Finalizado Newcastle
1 - 1
 Chelsea 58
20 Nov 10  Finalizado Birmingham City
1 - 0
 Chelsea 34
14 Nov 10  Finalizado Chelsea
0 - 3
 Sunderland 80
10 Nov 10  Finalizado Tarjeta RojaChelsea
1 - 0
 Fulham 12
07 Nov 10  Finalizado Liverpool
2 - 0
 Chelsea 108
30 Oct 10  Finalizado Blackburn Rovers
1 - 2
 Chelsea 20
23 Oct 10  Finalizado Chelsea
2 - 0
 Wolves 20
16 Oct 10  Finalizado Aston Villa
0 - 0
 Chelsea 18
03 Oct 10  Finalizado Chelsea
2 - 0
 Arsenal 49
25 Sep 10  Finalizado Manchester City
1 - 0
 Chelsea 58
19 Sep 10  Finalizado Chelsea
4 - 0
 Blackpool 22
11 Sep 10  Finalizado West Ham
1 - 3
 Chelsea 31
28 Ago 10  Finalizado Chelsea
2 - 0
 Stoke City 20
21 Ago 10  Finalizado Wigan Athletic
0 - 6
 Chelsea 112
14 Ago 10  Finalizado Chelsea
6 - 0
 West Bromwich Albion 46
FA Cup FA Cup »
19 Feb 11  Finalizado Chelsea
1 - 1
 Everton 0
29 Ene 11  Finalizado Everton
1 - 1
 Chelsea 0
09 Ene 11  Finalizado Chelsea
7 - 0
 Ipswich Town 0
EFL Cup EFL Cup »
22 Sep 10  Finalizado Chelsea
3 - 4
 Newcastle 0
Partidos Amistosos Partidos Amistosos »
04 Ago 10  Finalizado Hamburger SV
2 - 1
 Chelsea 6
01 Ago 10  Finalizado Eintracht Frankfurt
2 - 1
 Chelsea 5
29 Jul 10  Finalizado Wycombe Wanderers
5 - 1
 Chelsea 14
23 Jul 10  Finalizado Ajax
3 - 1
 Chelsea 11
17 Jul 10  Finalizado Crystal Palace
0 - 1
 Chelsea 0

Plantilla del Chelsea Temporada 2010/2011

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
40 48 pt 189 88 - - -
1 41 cz 196 92 - - -
22 39 gb 193 85 - - -
Defensa
33 41 br 188 90 2 - 3
3 43 gb 176 66 - - 4
2 40 rs 185 88 4 - 12
4 37 br 189 84 2 - 3
17 41 pt 183 75 - - 1
43 32 nl 189 84 - - -
26 43 gb 187 90 3 - 6
19 45 pt 180 76 - - 2
38 33 nl 176 67 - - -
34 34 gb 179 85 - - -
18 40 ru 180 75 - - 1
Centrocampista
8 45 gb 183 90 10 - 2
15 43 gf 181 73 13 - 1
44 32 cd 173 67 1 - -
46 31 gb 178 65 - - 1
52 33 gb 181 69 - - -
12 37 ng 184 85 - - 3
55 32 it 181 75 - - -
5 41 gh 178 84 3 1 5
7 37 br 179 65 2 - 7
10 43 il 178 70 1 - -
Delantero
11 46 ci 190 91 11 - 6
23 34 gb 188 76 8 1 -
45 33 it 180 73 - - -
9 40 es 186 78 10 - 7
39 45 fr 185 77 6 - -
21 38 ci 184 77 10 - 1

Noticias del Chelsea

Ver últimas noticias

Adiós a la temporada para Enzo Fernández: se operará, pero sí llega a la Copa América

BeSoccer - Jueves, 25 Abril 2024
4 2.420

Tal y como apuntó 'AS', el jugador del Chelsea Enzo Fernández pasará por quirófano este mismo jueves para solucionar una hernia inguinal que arrastra desde 2023. Una operación que le hará perderse lo que resta de temporada, aunque sí llegará a la Copa América del próximo verano.

La 2ª manita en 'era Premier' que el Chelsea encaja del Arsenal... y de Arteta

David Caravaca - Miércoles, 24 Abril 2024
0 2.370

El Arsenal pasó por encima del Chelsea en su partido de la jornada 29 de la Premier League. Los 'blues' no caían con tanto estrépito, encajando cinco goles, desde el 29 de octubre de 2011, cuando Mikel Arteta, actual entrenador de los 'gunners', jugaba para Arsène Wenger. Por aquel entonces, los azules estaban comandados por André Villas-Boas, cuyo plan se vio roto por un 'hat trick' de Robin van Persie.

El Arsenal hace trizas al Chelsea

David Caravaca - Martes, 23 Abril 2024
0 9.459

El Arsenal derrotó al Chelsea por 5-0 en la jornada 29 de la Premier League. Los de Mikel Arteta pasaron por encima de los de Mauricio Pochettino en un partido en el que la única propuesta de los 'blues' para tratar de contrarrestar el dominio 'gunner' residió en una batería de contragolpes durante la primera mitad. Sin Cole Palmer, el cuadro de Stamford Bridge no tuvo otro argumento en el Emirates Stadium, telón de fondo de una fiesta. Para mayor crueldad hacia los azules, Kai Havertz, autor del gol de su Champions League de 2021, firmó un doblete. Lo celebró.

"Decían: 'En Navidad, el Chelsea morirá"

BeSoccer - Martes, 23 Abril 2024
5 14.244

José Mourinho, libre desde que fue despedido de la Roma, lleva un tiempo bastante activo en la prensa. No ha tenido inconveniente en conceder entrevistas a periodistas como a Fabrizio Romano o a medios como 'The Telegraph'. Incluso ha escrito columnas de su propia -o presuntamente propia- factura. En uno de sus diálogos más recientes, el que se atribuye el diario británico, comentó su paso por el Chelsea, que, ahora, transita una época de vacas flacas.

Thiago Silva se irá del Chelsea a final de temporada

BeSoccer - Lunes, 22 Abril 2024
1 7.573

Según ha informado Fabrizio Romano, una eminencia en el mercado de fichajes, Thiago Silva abandonará el Chelsea una vez concluya la presente temporada. El defensor brasileño, que rechazó propuestas para seguir en enero, analizará las opciones que tenga sobre la mesa para afrontar otra aventura futbolística.

Ver más noticias del equipo»



  USO DE MEMORIA  
7,093,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.5894
Total Execution Time  0.5918
  CADENA URL  
/Chelsea-Fc/2011
  GET DATOS  
$_GET['/Chelsea-Fc/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
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 = 1239
0.0130  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 = 20548
0.0131  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 = 12810
0.0150  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 = '752' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 1126 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 12810 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 20548 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 14433 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 1068 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  (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 calendars2011 as c ON c.league_id = l.id WHERE (c.datateam1 = 752 or c.datateam2 = 752) AND l.year = 2011 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0136  (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 calendars2011 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 = 752 or c.datateam2 = 752) AND l.year = 2011 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0145  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2011 as c ON c.league_id = l.id INNER JOIN events2011 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 = 752 or c.datateam2 = 752) AND l.year = 2011)
0.0149  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=752 AND l.year in (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (20549,14433,12811,1439,1323,1315) 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.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 1315 AND teamId = 752
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 1439 AND teamId = 752
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 14433 AND teamId = 752
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 20549 AND teamId = 752
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 12811 AND teamId = 752
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 752
0.0141  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 events2011 e ON e.player_id = p.id AND e.league_id = 1068 WHERE rp.league_id = 1068 AND rp.teamId = 752 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.0141  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 events2011 e ON e.player_id = p.id AND e.league_id = 1068 WHERE rp.league_id = 1068 AND rp.teamId = 752 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events2011 e ON e.player_id = p.id AND e.league_id = 1068 WHERE rp.league_id = 1068 AND rp.teamId = 752 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 752 AND rp.league_id = 1068 AND l.year= 2011 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0131  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=24009 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0128  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=24009
0.0134  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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=24009 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.0139  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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=24009 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0133  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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=24009 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0131   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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=24009 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0132  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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=24009 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0126  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 = 1068 ORDER BY nameShow LIMIT 100