¿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
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 0
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
DFB Pokal DFB Pokal »
18 Oct 75  Finalizado Schalke 04
2 - 1
 B. Dortmund 0
02 Ago 75  Finalizado SpVgg Ludwigsburg
0 - 6
 B. Dortmund 0
2. Bundesliga 2. Bundesliga »
12 Jun 76  Finalizado B. Dortmund
3 - 0
 Schwarz-Weiss Essen 0
05 Jun 76  Finalizado B. Leverkusen
0 - 2
 B. Dortmund 0
29 May 76  Finalizado B. Dortmund
6 - 2
 FC St Pauli 0
26 May 76  Finalizado Preußen Münster
4 - 1
 B. DortmundTarjeta Roja 0
23 May 76  Finalizado B. Dortmund
0 - 0
 Union Solingen 0
16 May 76  Finalizado Spandauer SV
1 - 2
 B. Dortmund 0
01 May 76  Finalizado Fortuna Köln
3 - 1
 B. Dortmund 0
01 May 76  Finalizado B. Dortmund
6 - 0
 SpVgg Erkenschwick 0
17 Abr 76  Finalizado B. Dortmund
2 - 1
 DJK Gütersloh 0
03 Abr 76  Finalizado Tarjeta RojaWattenscheid 09
2 - 1
 B. Dortmund 0
27 Mar 76  Finalizado B. Dortmund
3 - 0
 I. SC Göttingen 0
20 Mar 76  Finalizado B. Dortmund
3 - 0
 Alemannia Aachen 0
13 Mar 76  Finalizado 1. FC Mülheim
1 - 1
 B. Dortmund 0
06 Mar 76  Finalizado B. Dortmund
2 - 1
 Wuppertaler SV 0
21 Feb 76  Finalizado Tennis Borussia
1 - 3
 B. Dortmund 0
14 Feb 76  Finalizado B. Dortmund
6 - 0
 Wacker 04 Berlin 0
07 Feb 76  Finalizado VfL Osnabrück
3 - 2
 B. Dortmund 0
24 Ene 76  Finalizado B. Dortmund
2 - 2
 Arminia Bielefeld 0
17 Ene 76  Finalizado Westfalia Herne
2 - 1
 B. Dortmund 0
27 Dic 75  Finalizado Schwarz-Weiss Essen
1 - 0
 B. Dortmund 0
21 Dic 75  Finalizado B. Dortmund
7 - 0
 B. Leverkusen 0
06 Dic 75  Finalizado FC St Pauli
1 - 1
 B. Dortmund 0
29 Nov 75  Finalizado B. Dortmund
1 - 0
 Preußen Münster 0
22 Nov 75  Finalizado Union Solingen
1 - 1
 B. Dortmund 0
15 Nov 75  Finalizado B. Dortmund
3 - 0
 Spandauer SV 0
08 Nov 75  Finalizado SpVgg Erkenschwick
1 - 4
 B. Dortmund 0
01 Nov 75  Finalizado B. Dortmund
0 - 0
 Fortuna Köln 0
25 Oct 75  Finalizado DJK Gütersloh
0 - 2
 B. Dortmund 0
04 Oct 75  Finalizado B. Dortmund
4 - 1
 Wattenscheid 09 0
27 Sep 75  Finalizado I. SC Göttingen
3 - 0
 B. Dortmund 0
20 Sep 75  Finalizado Alemannia Aachen
1 - 2
 B. Dortmund 0
13 Sep 75  Finalizado B. Dortmund
6 - 0
 1. FC Mülheim 0
06 Sep 75  Finalizado Wuppertaler SV
0 - 3
 B. Dortmund 0
30 Ago 75  Finalizado B. Dortmund
4 - 0
 Tennis Borussia 0
23 Ago 75  Finalizado Wacker 04 Berlin
2 - 1
 B. Dortmund 0
20 Ago 75  Finalizado B. Dortmund
2 - 2
 VfL Osnabrück 0
16 Ago 75  Finalizado Arminia Bielefeld
1 - 1
 B. Dortmund 0
09 Ago 75  Finalizado B. Dortmund
4 - 0
 Westfalia Herne 0

Plantilla del B. Dortmund Temporada 1975/1976

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
75 de 183 80 - - 1
72 de - - - - -
Defensa
71 de 172 66 10 - 3
Centrocampista
73 de - - - - -
73 de 170 74 6 - 2
70 de - - - 1 4
70 de - - - - 2
74 de - - 15 - 2
71 de 172 71 6 - 2
69 de 183 74 3 - 2
77 de - - 18 - 1
76 de - - 10 - 1
67 de - - - - 5
68 de 172 68 1 - -
Delantero
78 de - - 2 - -
71 de 179 82 13 - 4
79 hu 175 - 6 - -

Noticias del B. Dortmund

Ver últimas noticias

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

BeSoccer - Jueves, 18 Abril 2024
5 13.603

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 845

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.

Por algo es el 'Pupas'

Juanma Velasco - Martes, 16 Abril 2024
42 22.739

El Borussia Dortmund firmó la sorpresa en los cuartos de final de la Champions al eliminar al Atlético de Madrid (4-2), en un partido marcado por el intercambio de golpes entre ambos conjuntos. Sabitzer, en 3 minutos soberbios del segundo acto, se encargó de hurgar en la herida 'colchonera' con una asistencia y un golazo. Los alemanes se verán las caras en la antesala a la final con el PSG.

3 goles en 10 minutos para volver loco a todo Dortmund

BeSoccer - Martes, 16 Abril 2024
0 2.062

El partido entre el Borussia Dortmund y el Atlético de Madrid se volvió loco en la segunda mitad. Ángel Correa adelantó en la eliminatoria a los rojiblancos, pero los goles de Füllkrug y Sabtizer, en 3 minutos, devolvieron la ventaja a los germanos.

5 minutos mortales: Brandt y Maatsen sonrojaron al Atleti

BeSoccer - Martes, 16 Abril 2024
0 470

El Borussia Dortmund consiguió remontar la eliminatoria frente al Atlético de Madrid gracias a los goles de Julian Brandt e Ian Maatsen. Ambos tantos llegaron en cuestión de 5 minutos para la decepción de Diego Pablo Simeone.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,183,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.6153
Total Execution Time  0.6177
  CADENA URL  
/Borussia-Dortmund/1976
  GET DATOS  
$_GET['/Borussia-Dortmund/1976']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0104  SELECT type FROM routes WHERE alias = 'borussia-dortmund'
0.0128  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 = 1976 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.0106  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.0106  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.0105  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.0106  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.0111  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 = 9928
0.0111  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 = 59735
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=530 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 530 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107  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 (1311412,1311270,1311236,1311243,1311234) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0117  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 = 1976 ORDER BY l.year DESC,cat.coefficient DESC
0.0119  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.0106  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 = 9928 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 59735 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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 = 22451 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  (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 calendars1976 as c ON c.league_id = l.id WHERE (c.datateam1 = 530 or c.datateam2 = 530) AND l.year = 1976 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0158  (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 calendars1976 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 = 1976 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0195  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1976 as c ON c.league_id = l.id INNER JOIN events1976 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 = 1976)
0.0120  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 (1975,1976,1977) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (59735,22455,9929,5439) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 5439 AND teamId = 530
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 9929 AND teamId = 530
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 59735 AND teamId = 530
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 22455 AND teamId = 530
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1976` 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 = 9928 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0125  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0123  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0119  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 WHERE rp.league_id = 9928 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.0117  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 WHERE rp.league_id = 9928 AND rp.teamId = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 WHERE rp.league_id = 9928 AND rp.teamId = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 9928 AND l.year= 1976 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0110  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=154741 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=154741
0.0112  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 events1976 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=154741 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.0110  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 events1976 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=154741 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0109  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 events1976 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=154741 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0109   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 events1976 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=154741 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0109  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 events1976 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=154741 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC