07 Mar 23	Finalizado	Chelsea	2 - 0	B. Dortmund	1842
15 Feb 23	Finalizado	B. Dortmund	1 - 0	Chelsea	1584
02 Nov 22	Finalizado	Kobenhavn	1 - 1	B. Dortmund	1701
25 Oct 22	Finalizado	B. Dortmund	0 - 0	Manchester City	2060
11 Oct 22	Finalizado	B. Dortmund	1 - 1	Sevilla	480
05 Oct 22	Finalizado	Sevilla	1 - 4	B. Dortmund	698
14 Sep 22	Finalizado	Manchester City	2 - 1	B. Dortmund	743
06 Sep 22	Finalizado	B. Dortmund	3 - 0	Kobenhavn	490

Bundesliga »

27 May 23	Finalizado	B. Dortmund	2 - 2	Mainz 05	1614
21 May 23	Finalizado	FC Augsburg	0 - 3	B. Dortmund	628
13 May 23	Finalizado	B. Dortmund	5 - 2	B. Mönchengladbach	224
07 May 23	Finalizado	B. Dortmund	6 - 0	Wolfsburg	194
28 Abr 23	Finalizado	VfL Bochum	1 - 1	B. Dortmund	1093
22 Abr 23	Finalizado	B. Dortmund	4 - 0	Eintracht Frankfurt	252
15 Abr 23	Finalizado	Stuttgart	3 - 3	B. Dortmund	496
08 Abr 23	Finalizado	B. Dortmund	2 - 1	Union Berlin	176
01 Abr 23	Finalizado	Bayern München	4 - 2	B. Dortmund	412
18 Mar 23	Finalizado	B. Dortmund	6 - 1	Köln	128
11 Mar 23	Finalizado	Schalke 04	2 - 2	B. Dortmund	525
03 Mar 23	Finalizado	B. Dortmund	2 - 1	RB Leipzig	510
25 Feb 23	Finalizado	Hoffenheim	0 - 1	B. Dortmund	363
19 Feb 23	Finalizado	B. Dortmund	4 - 1	Hertha BSC	190
11 Feb 23	Finalizado	Werder Bremen	0 - 2	B. Dortmund	534
04 Feb 23	Finalizado	B. Dortmund	5 - 1	SC Freiburg	283
29 Ene 23	Finalizado	B. Leverkusen	0 - 2	B. Dortmund	439
25 Ene 23	Finalizado	Mainz 05	1 - 2	B. Dortmund	1839
22 Ene 23	Finalizado	B. Dortmund	4 - 3	FC Augsburg	839
11 Nov 22	Finalizado	B. Mönchengladbach	4 - 2	B. Dortmund	787
08 Nov 22	Finalizado	Wolfsburg	2 - 0	B. Dortmund	1551
05 Nov 22	Finalizado	B. Dortmund	3 - 0	VfL Bochum	192
29 Oct 22	Finalizado	Eintracht Frankfurt	1 - 2	B. Dortmund	290
22 Oct 22	Finalizado	B. Dortmund	5 - 0	Stuttgart	267
16 Oct 22	Finalizado	Union Berlin	2 - 0	B. Dortmund	343
08 Oct 22	Finalizado	B. Dortmund	2 - 2	Bayern München	455
01 Oct 22	Finalizado	Köln	3 - 2	B. Dortmund	249
17 Sep 22	Finalizado	B. Dortmund	1 - 0	Schalke 04	279
10 Sep 22	Finalizado	RB Leipzig	3 - 0	B. Dortmund	337
02 Sep 22	Finalizado	B. Dortmund	1 - 0	Hoffenheim	464
27 Ago 22	Finalizado	Hertha BSC	0 - 1	B. Dortmund	117
20 Ago 22	Finalizado	B. Dortmund	2 - 3	Werder Bremen	457
12 Ago 22	Finalizado	SC Freiburg	1 - 3	B. Dortmund	930
06 Ago 22	Finalizado	B. Dortmund	1 - 0	B. Leverkusen	559

DFB Pokal »

05 Abr 23	Finalizado	RB Leipzig	2 - 0	B. Dortmund	612
08 Feb 23	Finalizado	VfL Bochum	1 - 2	B. Dortmund	550
19 Oct 22	Finalizado	Hannover 96	0 - 2	B. Dortmund	160
29 Jul 22	Finalizado	1860 München	0 - 3	B. Dortmund	115

Partidos Amistosos »

13 Ene 23	Finalizado	B. Dortmund	6 - 0	Basel	262
10 Ene 23	Finalizado	B. Dortmund	5 - 1	Fortuna Düsseldorf	112
10 Dic 22	Finalizado	B. Dortmund	0 - 2	Fiorentina	33
10 Dic 22	Finalizado	FC Rapid Bucuresti	1 - 2	B. Dortmund	38
28 Nov 22	Finalizado	Johor FC	1 - 4	B. Dortmund	65
24 Nov 22	Finalizado	Lion City Sailors	2 - 7	B. Dortmund	103
30 Jul 22	Finalizado	B. Dortmund	1 - 1	Antalyaspor	7
22 Jul 22	Finalizado	B. Dortmund	0 - 2	Villarreal	401
18 Jul 22	Finalizado	B. Dortmund	1 - 3	Valencia	254
14 Jul 22	Finalizado	Verl	0 - 5	B. Dortmund	84
09 Jul 22	Finalizado	Dynamo Dresden	0 - 2	B. Dortmund	17
05 Jul 22	Finalizado	Lüner	1 - 3	B. Dortmund	17

Amistosos Selecciones No Oficiales »

30 Nov 22

Finalizado

Vietnam

2 - 1

B. Dortmund

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del B. Dortmund Temporada 2022/2023

		Edad	Altura	Peso
Portero
33	A. Meyer	33	195	90	-	-	-
1	Gregor Kobel	26	196	88	-	-	-
38	L. Unbehaun	23	185	85	-	-	-
35	Marcel Lotka	22	190	87	-	-	-
Defensa
47	A. Papadopoulos	24	186	83	-	-	-
30	F. Passlack	25	170	74	-	-	-
26	Julian Ryerson	26	183	82	1	-	4
15	M. Hummels	35	191	94	1	-	4
17	Marius Wolf	28	187	81	1	-	2
2	Mateu Morey	24	173	67	-	-	-
4	N. Schlotterbeck	24	191	82	4	-	3
14	N. Schulz	31	180	83	-	-	-
25	Niklas Süle	28	195	99	2	-	2
13	R. Guerreiro	30	170	71	4	-	4
44	S. Coulibaly	20	191	87	-	-	-
24	Thomas Meunier	32	191	90	-	-	2
36	Tom Rothe	19	193	-	-	-	-
Centrocampista
32	A. Kamara	19	185	82	-	-	-
23	Emre Can	30	186	86	2	-	8
42	G. Gürpüz	21	176	66	-	-	-
7	Gio Reyna	21	185	73	7	-	2
22	J. Bellingham	20	186	75	8	-	8
19	Julian Brandt	27	185	83	9	-	2
8	M. Dahoud	28	178	68	-	-	1
11	Marco Reus	34	180	71	6	-	4
6	Salih Özcan	26	183	74	-	-	6
Delantero
20	A. Modeste	36	188	83	2	-	4
21	Donyell Malen	25	176	68	9	-	-
43	J. Bynoe-Gittens	19	177	70	3	-	1
16	J. Duranville	17	170	-	-	-	-
27	K. Adeyemi	22	180	67	6	-	9
9	S. Haller	29	191	88	9	-	1
18	Y. Moukoko	19	179	72	7	-	-

Noticias del B. Dortmund

Ver últimas noticias

El Borussia es solo un testigo más

BeSoccer - Domingo, 21 Abril 2024

0 2.366

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.004

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

5 17.921

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.

Por algo es el 'Pupas'

Juanma Velasco - Martes, 16 Abril 2024

44 23.088

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.

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

BeSoccer - Miércoles, 17 Abril 2024

0 995

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»

Competiciones que juega

Grupo 6

Bundesliga

Pos	Equipos		Pts
1		Bayern München	71
2		B. Dortmund	71
3		RB Leipzig	66
4		Union Berlin	62
5		SC Freiburg	59
6		B. Leverkusen	50
7		Eintracht Frankfurt	50
8		Wolfsburg	49
9		Mainz 05	46
10		B. Mönchengladbach	43
11		Köln	42
12		Hoffenheim	36
13		Werder Bremen	36
14		VfL Bochum	35
15		FC Augsburg	34
16		Stuttgart	33
17		Schalke 04	31
18		Hertha BSC	29

	Campeón : Bayern München
	Champions League : B. Dortmund, RB Leipzig, Union Berlin
	Europa League : SC Freiburg, B. Leverkusen
	: Eintracht Frankfurt
	Playoff Descenso : Stuttgart
	Descenso : Schalke 04, Hertha BSC

RIVALES EN Bundesliga

RIVALES EN Champions League

RIVALES EN DFB Pokal

USO DE MEMORIA

6,887,496 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2374
Total Execution Time	0.2393

CADENA URL

/Borussia-Dortmund/2023

GET DATOS

$_GET['/Borussia-Dortmund/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0017	SELECT type FROM routes WHERE alias = 'borussia-dortmund'
0.0071	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 = 2023 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.0020	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.0020	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.0020	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.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 = 67678
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 = 70393
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 = 68172
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=530 AND type_rel = 2
0.0074	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.0022	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 (1311955,1311822,1311412,1311270,1311236) ORDER BY n.cover_points DESC, update_date DESC
0.0041	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 = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0058	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.0024	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 530 or c.datateam2 = 530) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0042	(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 calendars2023 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 = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0028	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 2023)
0.0049	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 (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (74790,72172,72031,71432,68172,66138,62788) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72031 AND teamId = 530
0.0058	SELECT count(id) as num_players from rel_players WHERE league_id = 74790 AND teamId = 530
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 66138 AND teamId = 530
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 530
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 62788 AND teamId = 530
0.0181	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 530
0.0046	SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 530
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2023` 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 = 67678 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0060	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 events2023 e ON e.player_id = p.id AND e.league_id = 67678 WHERE rp.league_id = 67678 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.0043	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 events2023 e ON e.player_id = p.id AND e.league_id = 67678 WHERE rp.league_id = 67678 AND rp.teamId = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 events2023 e ON e.player_id = p.id AND e.league_id = 67678 WHERE rp.league_id = 67678 AND rp.teamId = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 67678 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0029	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=6515103 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0025	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6515103
0.0035	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515103 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515103 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515103 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0029	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515103 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0035	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515103 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0027	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 = 67678 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

B. Dortmund

Información sobre B. Dortmund

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del B. Dortmund

Estadísticas

Plantilla del B. Dortmund Temporada 2022/2023

Noticias del B. Dortmund

B. Dortmund

Selecciona un equipo

Competiciones que juega

RIVALES EN Bundesliga

RIVALES EN Champions League

RIVALES EN DFB Pokal