Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

B. Dortmund II

Entrenador: Jan Zimmermann

Temporada 2018/2019

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	62	30	67
2	Rot-Weiß	34	58	41	64
3	Rödinghause	34	58	29	63
4	Mönchenglad	34	47	38	57
5	Dortmund	34	62	36	56
6	Alemannia	34	48	39	49
7	Verl	34	51	46	46
8	Rot-Weiss	34	42	40	46
9	Köln II	34	54	46	45
10	Wuppertaler	34	45	49	44
11	Wattenscheid	34	44	44	43
12	Fortuna	34	47	62	42
13	Lippstadt	34	36	48	41
14	Bonner SC	34	42	51	40
15	Kaan-Marienb	34	50	54	39
16	SV Straelen	34	36	62	39
17	Wiedenbrück	34	42	52	38
18	Herkenrath	34	34	91	15

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Uerdingen	34	68	24	76
2	Viktoria	34	85	36	72
3	Wuppertaler	34	61	47	56
4	Dortmund	34	55	46	55
5	Rödinghause	34	76	63	53
6	Alemannia	34	59	47	53
7	Wiedenbrück	34	55	48	52
8	Verl	34	47	33	50
9	Rot-Weiß	34	50	41	50
10	Rot-Weiss	34	55	43	49
11	Wattenscheid	34	58	52	45
12	Mönchenglad	34	49	49	43
13	Bonner SC	34	47	62	38
14	Köln II	34	49	62	37
15	Fortuna	34	42	59	36
16	Wegberg-Beec	34	37	78	28
17	Erndtebrück	34	28	67	26
18	Westfalia	34	29	93	19

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	91	42	72
2	Dortmund	34	54	25	63
3	Mönchenglad	34	71	42	62
4	Rot-Weiß	34	69	50	59
5	Alemannia	34	51	39	59
6	Rot-Weiss	34	48	35	55
7	Köln II	34	59	54	51
8	Wattenscheid	34	51	44	50
9	Bonner SC	34	60	61	48
10	Rödinghause	34	55	57	48
11	Wuppertaler	34	47	47	42
12	Fortuna	34	44	51	41
13	Verl	34	37	49	40
14	Wiedenbrück	34	43	52	39
15	Weiss Ahlen	34	43	66	32
16	Schalke	34	32	48	30
17	Sprockhövel	34	31	73	24
18	Siegen	34	31	82	21

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sportfreunde	36	67	23	83
2	Mönchenglad	36	80	46	68
3	Viktoria	36	66	36	63
4	Dortmund	36	57	36	60
5	Rot-Weiß	36	58	44	59
6	Fortuna	36	63	51	59
7	Alemannia	36	52	43	56
8	Wattenscheid	36	61	52	55
9	Schalke	36	44	44	51
10	Verl	36	43	46	51
11	Wiedenbrück	36	50	45	50
12	Rot-Weiss	36	48	49	48
13	Weiss Ahlen	36	56	60	46
14	Rödinghause	36	43	42	43
15	Köln II	36	44	51	41
16	Velbert	36	38	65	36
17	Erndtebrück	36	42	68	32
18	Kray	36	36	81	18
19	Wegberg-Beec	36	30	96	16

TEMPORADA 2014/2015

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Arminia	38	75	41	74
2	Duisburg	38	63	40	71
3	Holstein	38	53	30	67
4	Stuttgarter	38	61	47	65
5	Chemnitzer	38	44	36	59
6	Dynamo	38	52	48	56
7	Energie	38	50	50	56
8	Preußen	38	53	49	54
9	Wehen	38	54	44	53
10	Hallescher	38	51	53	53
11	Osnabrück	38	49	51	52
12	Rot-Weiss	38	47	54	51
13	Stuttgart	38	48	57	47
14	Fortuna	38	38	47	46
15	Sonnenhof	38	39	60	46
16	Mainz 05 II	38	43	52	42
17	Hansa	38	54	68	41
18	Dortmund	38	41	51	39
19	Unterhaching	38	51	67	39
20	Jahn	38	44	65	31

TEMPORADA 2013/2014

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Heidenheim	38	59	25	79
2	RB Leipzig	38	65	34	79
3	Darmstadt	38	58	29	72
4	Wehen	38	43	44	56
5	Osnabrück	38	50	39	55
6	Preußen	38	55	50	53
7	Duisburg	38	43	43	52
8	Stuttgarter	38	45	46	51
9	Hallescher	38	50	55	51
10	Rot-Weiss	38	53	49	50
11	Jahn	38	51	51	49
12	Chemnitzer	38	43	46	49
13	Hansa	38	45	55	49
14	Dortmund	38	47	55	46
15	Stuttgart	38	45	54	46
16	Holstein	38	42	38	45
17	Unterhaching	38	50	65	43
18	Elversberg	38	32	54	40
19	Wacker	38	39	58	37
20	Saarbrücken	38	38	63	32

TEMPORADA 2012/2013

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	38	69	27	79
2	Arminia	38	59	32	76
3	Osnabrück	38	64	35	73
4	Preußen	38	63	33	72
5	Heidenheim	38	69	47	72
6	Chemnitzer	38	56	47	55
7	Wehen	38	51	51	51
8	Wacker	38	45	45	51
9	Unterhaching	38	48	55	51
10	Hallescher	38	37	50	46
11	Saarbrücken	38	52	62	45
12	Hansa	38	39	52	44
13	Rot-Weiss	38	44	58	44
14	Stuttgart	38	35	42	43
15	Kickers	38	41	44	42
16	Dortmund	38	39	58	41
17	Stuttgarter	38	39	48	40
18	Darmstadt	38	32	46	38
19	Babelsberg	38	32	54	37
20	Alemannia	38	40	68	26

TEMPORADA 2011/2012

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dortmund	36	84	39	77
2	Sportfreunde	36	64	31	76
3	Mönchenglad	36	67	45	69
4	Eintracht	36	57	34	64
5	Wuppertaler	36	68	49	57
6	Köln II	36	59	48	56
7	Fortuna	36	54	56	53
8	Rot-Weiss	36	52	57	52
9	Kaiserslaute	36	56	55	51
10	Verl	36	39	48	46
11	Schalke	36	55	63	45
12	Mainz 05 II	36	49	47	43
13	Elversberg	36	39	60	42
14	Bochum	36	42	64	41
15	Wiedenbrück	36	44	52	40
16	Idar-Oberste	36	38	62	39
17	TuS Koblenz	36	32	51	31
18	Leverkusen	36	34	57	31
19	Fortuna	36	39	54	29

TEMPORADA 2010/2011

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Preußen	34	56	24	72
2	Eintracht	34	58	34	62
3	Sportfreunde	34	43	29	62
4	Kaiserslaute	34	53	36	59
5	Mönchenglad	34	53	41	59
6	Dortmund	34	56	47	52
7	Köln II	34	61	43	51
8	Wuppertaler	34	52	59	50
9	Verl	34	40	34	48
10	Wiedenbrück	34	50	55	46
11	Schalke	34	34	45	44
12	Elversberg	34	39	44	43
13	Mainz 05 II	34	48	51	41
14	Bochum	34	49	64	34
15	Leverkusen	34	43	58	33
16	Fortuna	34	41	55	31
17	Homburg	34	29	49	30
18	Arminia	34	30	67	21

TEMPORADA 2009/2010

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	38	55	37	69
2	Erzgebirge	38	57	41	68
3	Ingolstadt	38	72	46	64
4	Eintracht	38	55	37	62
5	Carl Zeiss.	38	54	44	60
6	Heidenheim	38	66	56	59
7	Kickers	38	55	35	57
8	Bayern	38	55	65	54
9	Rot-Weiss	38	41	41	53
10	Stuttgart	38	53	50	52
11	Unterhaching	38	52	52	50
12	Dynamo	38	39	46	50
13	Werder	38	49	54	47
14	Sandhausen	38	54	63	47
15	Wehen	38	52	64	47
16	Jahn	38	43	48	46
17	Wacker	38	45	64	46
18	Dortmund	38	43	58	39
19	Holstein	38	43	61	38
20	Wuppertaler	38	40	61	38

TEMPORADA 2008/2009

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	34	86	49	68
2	Kaiserslaute	34	59	42	65
3	Köln II	34	53	34	60
4	Preußen	34	51	36	53
5	Mainz 05 II	34	58	45	52
6	Mönchenglad	34	50	49	51
7	Rot-Weiss	34	61	41	49
8	Verl	34	45	42	49
9	Leverkusen	34	53	56	49
10	Sportfreunde	34	53	57	49
11	Elversberg	34	39	37	46
12	Oggersheim	34	43	58	42
13	Eintracht	34	37	51	41
14	Bochum	34	51	59	40
15	Schalke	34	41	54	39
16	Wormatia	34	39	55	33
17	Cloppenburg	34	51	76	28
18	Kleve	34	44	73	27

TEMPORADA 2007/2008

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Weiss Ahlen	36	73	41	67
2	Rot-Weiß	36	64	32	66
3	Fortuna	36	49	29	64
4	Union Berlin	36	67	49	60
5	Werder	36	52	43	59
6	Wuppertaler	36	60	50	58
7	Rot-Weiss	36	70	46	56
8	Dynamo	36	45	39	55
9	Kickers	36	43	39	54
10	Eintracht	36	55	50	53
11	Magdeburg	36	39	37	53
12	Rot-Weiss	36	42	36	51
13	Dortmund	36	35	37	48
14	Energie	36	31	44	44
15	Babelsberg	36	33	53	34
16	VfB Lübeck	36	32	58	34
17	Hamburger	36	36	58	33
18	Verl	36	31	55	32
19	Wolfsburg	36	20	81	22

TEMPORADA 2006/2007

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2005/2006

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Dortmund	34	79	25	79
2	Verl	34	75	43	70
3	Gutersloh	34	71	41	59
4	Schalke	34	64	43	58
5	Sportfreunde	34	49	43	56
6	Bochum	34	61	52	51
7	Hüls	34	48	53	46
8	Westfalia	34	47	51	44
9	Emsdetten	34	44	57	43
10	Arminia	34	36	38	42
11	Weiss Ahlen	34	36	43	42
12	Delbrücker	34	35	46	41
13	Lippstadt	34	43	65	41
14	Eintracht	34	44	65	39
15	SpVgg	34	32	45	38
16	Siegen	34	42	63	34
17	Schermbeck	34	43	46	33
18	Fichte	34	31	61	31

TEMPORADA 2004/2005

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Eintracht	36	59	35	70
2	Paderborn	36	63	40	70
3	VfB Lübeck	36	62	40	69
4	Osnabrück	36	67	44	67
5	Wuppertaler	36	46	48	54
6	Hamburger	36	49	48	53
7	FC St Pauli	36	43	39	52
8	Fortuna	36	46	42	49
9	Uerdingen	36	43	50	49
10	Holstein	36	54	46	48
11	Hertha	36	61	55	47
12	Preußen	36	52	58	46
13	Köln II	36	58	65	46
14	Werder	36	48	57	42
15	Chemnitzer	36	33	38	40
16	Dortmund	36	57	64	40
17	Wolfsburg	36	37	58	34
18	Bielefeld	36	50	83	29
19	Union Berlin	36	32	50	27

TEMPORADA 2003/2004

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	34	77	26	74
2	Dynamo	34	51	26	65
3	Paderborn	34	56	40	62
4	Wuppertaler	34	49	37	62
5	Werder	34	55	44	55
6	Eintracht	34	49	42	52
7	Uerdingen	34	46	48	46
8	FC St Pauli	34	44	40	44
9	Hamburger	34	33	46	44
10	Dortmund	34	43	47	43
11	Chemnitzer	34	31	49	43
12	Holstein	34	52	56	42
13	Preußen	34	40	45	42
14	Köln II	34	53	53	41
15	Wattenscheid	34	51	60	40
16	Schalke	34	54	70	38
17	Sachsen	34	34	56	24
18	Neumunster	34	32	65	23

TEMPORADA 2002/2003

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	34	58	27	68
2	Erzgebirge	34	59	34	66
3	Rot-Weiss	34	56	33	60
4	Wattenscheid	34	66	48	56
5	Dortmund	34	61	49	54
6	Werder	34	59	53	50
7	Dynamo	34	34	34	50
8	Paderborn	34	58	49	47
9	Köln II	34	52	54	45
10	Uerdingen	34	43	52	45
11	Chemnitzer	34	47	56	44
12	Preußen	34	46	55	43
13	Holstein	34	53	54	42
14	Verl	34	46	65	40
15	Hamburger	34	43	53	39
16	Leverkusen	34	46	59	33
17	Babelsberg	34	53	76	32
18	Dresdner SC	34	31	60	26

TEMPORADA 2001/2002

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Dortmund	34	91	34	78
2	Schalke	34	80	40	71
3	Eintracht	34	54	37	67
4	Hüls	34	66	39	60
5	Bochum	34	58	42	59
6	Westfalia	34	50	39	58
7	Fichte	34	55	55	54
8	SC Hassel	34	37	35	43
9	Gutersloh	34	51	58	43
10	Lüner	34	52	58	41
11	Stadtlohn	34	46	52	41
12	TuS Hordel	34	55	59	40
13	Wattenscheid	34	45	59	39
14	Lippstadt	34	42	51	37
15	TSG Dülmen	34	38	52	35
16	Oestrich-Ise	34	41	73	27
17	Preußen	34	41	81	27
18	Hövelhof	34	23	61	25

TEMPORADA 2000/2001

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Union Berlin	36	62	23	73
2	Babelsberg	36	57	41	68
3	VfB Lübeck	36	69	43	62
4	Fortuna	36	58	42	62
5	Preußen	36	66	50	61
6	Verl	36	53	46	55
7	Erzgebirge	36	39	48	54
8	Eintracht	36	55	43	49
9	Dresdner SC	36	38	41	49
10	Wilhelmshave	36	55	55	48
11	Wattenscheid	36	65	66	48
12	Uerdingen	36	50	62	48
13	Rot-Weiss	36	45	54	47
14	Sachsen	36	42	43	45
15	Werder	36	49	53	45
16	Fortuna	36	46	52	42
17	Lüneburger	36	52	73	33
18	Dortmund	36	36	55	30
19	Tennis	36	33	80	23

TEMPORADA 1999/2000

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	37	69	23	77
2	Weiss Ahlen	37	83	35	71
3	Siegen	37	64	43	70
4	Wattenscheid	37	72	42	64
5	Eintracht	37	55	48	61
6	Fortuna	37	53	36	53
7	Dortmund	38	44	40	53
8	Rot-Weiss	37	55	47	52
9	Verl	37	51	45	52
10	Paderborn	38	51	49	52
11	Elversberg	38	51	50	52
12	Preußen	37	52	59	50
13	Uerdingen	37	52	54	48
14	Kaiserslaute	37	49	56	48
15	Bochum	38	60	72	43
16	Leverkusen	37	47	54	39
17	Gutersloh	23	30	24	37
18	Pirmasens	37	39	76	34
19	Idar-Oberste	37	26	80	31
20	Salmrohr	37	19	89	16

Competiciones que juega

Regionalliga Grupo 4

Pos	Equipos		Pts
1		Viktoria Köln	67
2		Rot-Weiß Oberhausen	64
3		Rödinghausen	63
4		B. Mönchengladbach II	57
5		B. Dortmund II	56
6		Alemannia Aachen	49
7		Verl	46
8		Rot-Weiss Essen	46
9		Köln II	45
10		Wuppertaler SV	44
11		Wattenscheid 09	43
12		Fortuna Düsseldorf II	42
13		Lippstadt 08	41
14		Bonner SC	40
15		Kaan-Marienborn	39
16		SV Straelen	39
17		Wiedenbrück	38
18		Herkenrath	15

	Ascenso : Viktoria Köln
	Playoff Descenso : Kaan-Marienborn
	Descenso : SV Straelen, Wiedenbrück, Herkenrath

RIVALES EN Regionalliga

USO DE MEMORIA

7,893,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.8185
Total Execution Time	0.8205

CADENA URL

/historico/Borussia-Dortm-Ii/2019

GET DATOS

$_GET['/historico/Borussia-Dortm-Ii/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0155	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-Dortm-Ii' AND l.year = 2019 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.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=5670 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=5670 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=5670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294	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 = 43944
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5670 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5670 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (97643,97966,244023,292138,422349) ORDER BY n.cover_points DESC, update_date DESC
0.0153	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 = '5670' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '5670' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '5670' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 43944 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=5670 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (50106,49506) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 50106 AND teamId = 5670
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 5670
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2019` 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 = 43944 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '5670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5670' and rp.type = 4
0.0146	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 = '5670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160	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 events2019 e ON e.player_id = p.id AND e.league_id = 43944 WHERE rp.league_id = 43944 AND rp.teamId = 5670 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.0161	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 events2019 e ON e.player_id = p.id AND e.league_id = 43944 WHERE rp.league_id = 43944 AND rp.teamId = 5670 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 events2019 e ON e.player_id = p.id AND e.league_id = 43944 WHERE rp.league_id = 43944 AND rp.teamId = 5670 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 5670 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` 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 = 43944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 33767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2016` 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 = 15532 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 3885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` 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 = 2446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 2004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2012` 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 = 1331 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 16430 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2010` 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 = 885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 16436 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2008` 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 = 16437 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 16441 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 19891 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 16446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2004` 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 = 16445 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 16444 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2002` 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 = 28323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2001` 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 = 16442 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2000` 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 = 22661 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 43944 ORDER BY nameShow LIMIT 100

B. Dortmund II

B. Dortmund II

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 4

RIVALES EN Regionalliga