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 B. Dortmund

Enviar Datos
Información
  • Nombre del equipo B. Dortmund
  • Nombre completo Ballspielverein Borussia 09 e.V. Dortmun
  • Nombre corto BVB
  • País Alemania
  • Ciudad Dortmund
  • Entrenador Edin Terzic
  • URL del equipo en RF //m.resultados-futbol.com/Borussia-Dortmund
Otros Datos
  • Año de Fundación 1909
  • Patrocinador 1&1
  • Marca de Ropa Puma
  • Socios 78003
Internet
  • Sitio Web www.bvb.de
  • Correo electrónico info@bvb.de
  • Twitter principal @BVB

Información sobre el estadio

  • Nombre del estadio Signal Iduna Park
  • Capacidad 81359
  • Dirección Strobelalle 50
  • Teléfono +49 (231) 902 00
  • Fax +49 (231) 902 0105
  • Año de construcción 1974
  • Tamaño 104x66 metros
Signal Iduna Park

Histórico de participación

DFB Pokal
64 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, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1953, 1939, 1937)
Bundesliga
57 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, 1981, 1980, 1979, 1978, 1977, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964)
Champions League Grupo 6
34 veces
(2024, 2024, 2023, 2023, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2017, 2017, 2015, 2015, 2014, 2014, 2013, 2013, 2012, 2003, 2003, 2002, 2000, 1998, 1998, 1997, 1997, 1996, 1996, 1964, 1958, 1957)
Partidos Amistosos
17 veces
(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2009, 2008)
Oberliga Grupo 2
16 veces
(1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948)
Europa League Grupo 0
15 veces
(2022, 2018, 2016, 2016, 2011, 2009, 2004, 2002, 2000, 1995, 1994, 1993, 1991, 1988, 1983)
Supercopa de Alemania
12 veces
(2022, 2021, 2020, 2018, 2017, 2015, 2014, 2013, 2012, 1997, 1996, 1990)
Liga Pokal
6 veces
(2004, 2003, 2002, 2000, 1998, 1973)
Fase Previa Champions League Grupo 3
3 veces
(2004, 2002, 2000)
Fase Previa Europa League Grupo 3
3 veces
(2016, 2016, 2011)
International Champions Cup
3 veces
(2019, 2018, 2017)
Recopa de Europa
3 veces
(1990, 1967, 1966)
2. Bundesliga Grupo 2
2 veces
(1976, 1975)
Bundesliga - Play Offs Ascenso
2 veces
(1986, 1976)
Copa Intertoto
2 veces
(2006, 2005)
Trofeo Costa del Sol
2 veces
(2008, 1965)
Trofeo Joan Gamper
1 vez
(1984)
Amistosos Selecciones No Oficiales
1 vez
(2023)
Copa de Ferias
1 vez
(1965)
Copa Intercontinental
1 vez
(1998)
Regionalliga Grupo 3
1 vez
(1974)
Supercopa Europa
1 vez
(1998)
Copa Telekom
1 vez
(2013)

Partidos del B. Dortmund

Ir al LIVESCORE
Champions League Champions League »
06 Dic 17  Finalizado Real Madrid
3 - 2
 B. Dortmund 906
21 Nov 17  Finalizado B. Dortmund
1 - 2
 Tottenham Hotspur 314
01 Nov 17  Finalizado B. Dortmund
1 - 1
 APOEL 286
17 Oct 17  Finalizado APOEL
1 - 1
 B. Dortmund 551
26 Sep 17  Finalizado B. Dortmund
1 - 3
 Real Madrid 2032
13 Sep 17  Finalizado Tarjeta RojaTottenham Hotspur
3 - 1
 B. Dortmund 356
Europa League Europa League »
15 Mar 18  Finalizado Salzburg
0 - 0
 B. Dortmund 369
08 Mar 18  Finalizado B. Dortmund
1 - 2
 Salzburg 386
22 Feb 18  Finalizado Atalanta
1 - 1
 B. Dortmund 223
15 Feb 18  Finalizado B. Dortmund
3 - 2
 Atalanta 422
Bundesliga Bundesliga »
12 May 18  Finalizado Hoffenheim
3 - 1
 B. Dortmund 94
05 May 18  Finalizado B. Dortmund
1 - 2
 Mainz 05 175
29 Abr 18  Finalizado Werder Bremen
1 - 1
 B. Dortmund 70
21 Abr 18  Finalizado B. Dortmund
4 - 0
 B. Leverkusen 131
15 Abr 18  Finalizado Schalke 04
2 - 0
 B. Dortmund 152
08 Abr 18  Finalizado B. Dortmund
3 - 0
 Stuttgart 83
31 Mar 18  Finalizado Bayern München
6 - 0
 B. Dortmund 468
18 Mar 18  Finalizado B. Dortmund
1 - 0
 Hannover 96 129
11 Mar 18  Finalizado B. Dortmund
3 - 2
 Eintracht Frankfurt 206
03 Mar 18  Finalizado RB Leipzig
1 - 1
 B. Dortmund 104
26 Feb 18  Finalizado B. Dortmund
1 - 1
 FC Augsburg 335
18 Feb 18  Finalizado B. Mönchengladbach
0 - 1
 B. Dortmund 165
10 Feb 18  Finalizado B. Dortmund
2 - 0
 Hamburger SV 89
02 Feb 18  Finalizado Köln
2 - 3
 B. Dortmund 271
27 Ene 18  Finalizado B. Dortmund
2 - 2
 SC Freiburg 104
19 Ene 18  Finalizado Hertha BSC
1 - 1
 B. Dortmund 204
14 Ene 18  Finalizado B. Dortmund
0 - 0
 Wolfsburg 102
16 Dic 17  Finalizado B. Dortmund
2 - 1
 Hoffenheim 150
12 Dic 17  Finalizado Mainz 05
0 - 2
 B. Dortmund 153
09 Dic 17  Finalizado B. Dortmund
1 - 2
 Werder Bremen 207
02 Dic 17  Finalizado Tarjeta RojaB. Leverkusen
1 - 1
 B. Dortmund 122
25 Nov 17  Finalizado B. Dortmund
4 - 4
 Schalke 04 377
17 Nov 17  Finalizado Stuttgart
2 - 1
 B. Dortmund 213
04 Nov 17  Finalizado B. Dortmund
1 - 3
 Bayern München 411
28 Oct 17  Finalizado Hannover 96
4 - 2
 B. DortmundTarjeta Roja 198
21 Oct 17  Finalizado Eintracht Frankfurt
2 - 2
 B. Dortmund 120
14 Oct 17  Finalizado Tarjeta RojaB. Dortmund
2 - 3
 RB LeipzigTarjeta Roja 143
30 Sep 17  Finalizado FC Augsburg
1 - 2
 B. Dortmund 124
23 Sep 17  Finalizado B. Dortmund
6 - 1
 B. Mönchengladbach 88
20 Sep 17  Finalizado Hamburger SV
0 - 3
 B. Dortmund 67
17 Sep 17  Finalizado B. Dortmund
5 - 0
 Köln 73
09 Sep 17  Finalizado Tarjeta RojaSC Freiburg
0 - 0
 B. Dortmund 222
26 Ago 17  Finalizado B. Dortmund
2 - 0
 Hertha BSC 58
19 Ago 17  Finalizado Wolfsburg
0 - 3
 B. Dortmund 128
DFB Pokal DFB Pokal »
20 Dic 17  Finalizado Bayern München
2 - 1
 B. Dortmund 184
24 Oct 17  Finalizado Magdeburg
0 - 5
 B. Dortmund 49
12 Ago 17  Finalizado 1.FC Rielasingen-Arlen
0 - 4
 B. Dortmund 31
Partidos Amistosos Partidos Amistosos »
23 May 18  Finalizado Los Angeles FC
1 - 1
 B. Dortmund 130
14 May 18  Finalizado Zwickau
4 - 4
 B. Dortmund 24
08 Ene 18  Finalizado B. Dortmund
3 - 2
 Zulte-Waregem 33
06 Ene 18  Finalizado Fortuna Düsseldorf
0 - 2
 B. Dortmund 20
13 Ago 17  Aplazado Zwickau
-
 B. Dortmund 5
06 Ago 17  Finalizado Rot-Weiss Erfurt
2 - 5
 B. Dortmund 23
01 Ago 17  Finalizado B. Dortmund
0 - 1
 Atalanta 92
28 Jul 17  Finalizado B. Dortmund
0 - 1
 Espanyol 297
22 Jul 17  Finalizado VfL Bochum
2 - 2
 B. Dortmund 48
20 Jul 17  Finalizado B. Dortmund
0 - 2
 Alemannia Aachen 0
15 Jul 17  Finalizado Urawa Reds
2 - 3
 B. Dortmund 90
11 Jul 17  Finalizado Rot-Weiss Essen
3 - 2
 B. Dortmund 129

Plantilla del B. Dortmund Temporada 2017/2018

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
35 26 de 186 75 - - -
38 33 ch 187 85 - - 4
1 43 de 190 85 - - -
Defensa
2 24 fr 196 90 1 1 -
37 31 de 183 73 - - -
15 29 de 182 76 1 - 1
26 38 pl 184 73 - - 3
16 28 ch 188 91 - - 2
29 36 de 180 74 - - 3
36 34 tr 187 81 - - 1
13 30 pt 170 71 1 - -
34 23 es 171 62 - - -
25 35 gr 186 85 2 1 5
Centrocampista
27 36 de 171 72 - - 3
33 28 de 186 71 1 - 4
19 28 sy 178 68 - - 4
20 30 de 183 74 9 - -
11 34 de 180 71 7 - 1
10 31 de 176 64 2 - 1
8 35 tr 180 73 2 - 2
23 35 jp 175 68 5 - -
18 33 de 179 67 - - -
Delantero
21 33 de 175 63 1 - -
9 34 ua 189 81 3 - -
14 24 se 192 77 - - -
22 25 us 177 63 4 - 1
7 24 gb 180 74 1 - -
44 30 be 185 78 7 - 2

Noticias del B. Dortmund

Ver últimas noticias

Alas de Champions

BeSoccer - Sábado, 27 Abril 2024
0 207

El RB Leipzig goleó al Borussia Dortmund (4-1) en la jornada 31 de la Bundesliga. Loïs Openda, Benjamin Sesko, Mohamed Simakan y Christoph Baumgartner levantaron el gol inicial de Jadon Sancho para colocarse con 5 puntos de margen y 9 por disputar en la lucha por la última plaza de Champions League.

El Borussia es solo un testigo más

BeSoccer - Domingo, 21 Abril 2024
0 2.391

El Borussia Dortmund estuvo a punto de acabar con la racha invicta del Bayer Leverkusen en la jornada 30 de la Bundesliga, pero encajó un gol de Josip Stanisic de cabeza en el minuto 97 y tuvo que conformarse con el empate. Las tablas son insuficientes para revalidar la oposición del Signal Iduna Park a la Champions League de la temporada que viene, pero, este año, todos parecen testigos de una historia en que los de Xabi Alonso son los actores principales.

El Borussia se quita la presión de quedar cuarto

BeSoccer - Sábado, 20 Abril 2024
2 23.029

Las buenas actuaciones de los equipos alemanes en la Champions League unido a las eliminaciones de los equipos ingleses hace que la Bundesliga tenga prácticamente asegurada la quinta posición para ir a la máxima competición continental.

El Salzburgo, último clasificado UEFA para el Mundial de Clubes de 2025

BeSoccer - Jueves, 18 Abril 2024
7 18.209

El Mundial de Clubes de 2025, que contará con 32 participantes, ya conoce a todos los equipos que representarán a la UEFA (Europa). Tras la derrota del Arsenal frente al Bayern en Champions League, el Salzburgo aseguró su presencia en la competición como el 12º equipo de la confederación.

Hasta Terzic se sorprendió por hacerle cinco goles al Atlético

BeSoccer - Miércoles, 17 Abril 2024
0 996

Elogió el carácter competitivo del Atlético, pero Edin Terzic dio muchísimo valor al papel de su Borussia Dortmund para colarse en las cuartas semifinales de Champions de toda su historia.

Ver más noticias del equipo»



  USO DE MEMORIA  
7,000,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3423
Total Execution Time  0.3451
  CADENA URL  
/borussia-dortmund/2018
  GET DATOS  
$_GET['/borussia-dortmund/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0107  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 = 'borussia-dortmund' AND l.year = 2018 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.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 39623
0.0027  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 = 41795
0.0026  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 = 38691
0.0024  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 = 38617
0.0025  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 = 38071
0.0082  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 = '530' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0096  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 = '530' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 38635 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 39623 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 38691 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 41795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 38617 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  (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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 530 or c.datateam2 = 530) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0097  (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 calendars2018 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 = 530 or c.datateam2 = 530) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0054  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 530 or c.datateam2 = 530) AND l.year = 2018)
0.0161  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=530 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0024  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 (48457,43809,43544,43475,43268,41795,38617) 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.0075  SELECT count(id) as num_players from rel_players WHERE league_id = 43544 AND teamId = 530
0.0073  SELECT count(id) as num_players from rel_players WHERE league_id = 48457 AND teamId = 530
0.0059  SELECT count(id) as num_players from rel_players WHERE league_id = 41795 AND teamId = 530
0.0072  SELECT count(id) as num_players from rel_players WHERE league_id = 43809 AND teamId = 530
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 38617 AND teamId = 530
0.0066  SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 530
0.0427  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 530
0.0035  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2018` 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 = 38635 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0065  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 events2018 e ON e.player_id = p.id AND e.league_id = 38635 WHERE rp.league_id = 38635 AND rp.teamId = 530 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.0065  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 events2018 e ON e.player_id = p.id AND e.league_id = 38635 WHERE rp.league_id = 38635 AND rp.teamId = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052  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 events2018 e ON e.player_id = p.id AND e.league_id = 38635 WHERE rp.league_id = 38635 AND rp.teamId = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048  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 = 530 AND rp.league_id = 38635 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0038  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=782911 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=782911
0.0043  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782911 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.0045  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782911 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0031  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782911 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0041   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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782911 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0044  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782911 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0021  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 = 38635 ORDER BY nameShow LIMIT 100