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

Bremer SV

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hannover	31	79	40	67
2	Phönix	30	75	31	62
3	SV Meppen	31	67	38	62
4	Drochtersen	30	47	39	52
5	Holstein	31	58	49	51
6	Oldenburg	31	57	43	48
7	Hamburger	30	47	42	48
8	Teutonia	31	57	44	45
9	Havelse	29	49	45	45
10	Pauli	31	60	40	43
11	BW Lohne	30	46	46	41
12	Eintracht	31	53	61	37
13	Bremer SV	29	43	52	37
14	Weiche	30	38	53	31
15	Jeddeloh	30	35	58	30
16	Eimsbüttele	30	34	61	22
17	Kilia Kiel	30	31	73	16
18	Spelle-Venha	31	26	87	12

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	VfB Lübeck	36	74	29	76
2	Hamburger	36	78	45	75
3	Hannover	36	81	54	67
4	Teutonia	36	63	57	58
5	Weiche	36	56	47	56
6	Havelse	36	54	47	52
7	Pauli	36	58	68	51
8	Drochtersen	36	55	44	50
9	BW Lohne	36	65	63	49
10	Eintracht	36	55	49	48
11	Jeddeloh	36	58	63	48
12	Holstein	36	61	57	47
13	Phönix	36	59	56	47
14	Bremer SV	36	51	56	46
15	Werder	36	57	61	45
16	BSV Rehden	36	44	56	41
17	Hildesheim	36	53	64	39
18	Atlas	36	53	82	32
19	Kickers	36	26	103	15

TEMPORADA 2021/2022

OBERLIGA GRUPO 29
Equipo		PJ	GF	GC	Puntos
1	Kickers	3	7	4	7
2	Bremer SV	3	6	3	6
3	Todesfelde	3	3	5	2
4	Wandsbeker	3	3	7	1

TEMPORADA 2020/2021

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Brinkumer	8	26	8	22
2	Bremer SV	8	25	8	22
3	Bremerhaven	8	23	15	19
4	Leher	8	17	6	17
5	Geestemünde	8	27	22	13
6	Blumenthaler	8	18	12	12
7	Vatan Sport	6	14	13	12
8	Schwachhause	6	17	9	10
9	Aumund-Veges	8	12	14	9
10	Habenhauser	8	13	19	9
11	Komet Arsten	7	7	9	8
12	Hemelingen	7	16	22	8
13	SC Borgfeld	8	15	31	7
14	Hastedt	8	13	19	6
15	Neustadt	8	22	29	6
16	Bremerhaven	7	9	15	5
17	Union Bremen	7	10	20	4
18	Werder	8	9	22	4

TEMPORADA 2019/2020

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Oberneuland	19	74	18	51
2	Schwachhause	20	55	26	48
3	Brinkumer	21	57	33	47
4	Bremerhaven	21	61	29	45
5	Bremer SV	20	54	24	37
6	Hemelingen	21	47	39	37
7	Blumenthaler	21	59	48	35
8	SC Borgfeld	21	44	53	25
9	Aumund-Veges	21	44	53	24
10	Geestemünde	21	49	65	24
11	Hastedt	21	34	50	23
12	Leher	21	38	61	18
13	Union Bremen	21	31	51	16
14	Neustadt	21	27	67	16
15	Habenhauser	21	29	58	14
16	Werder	21	24	52	12

TEMPORADA 2018/2019

OBERLIGA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Altona 93	2	4	3	4
2	Heider SV	2	2	2	2
3	Bremer SV	2	3	4	1

TEMPORADA 2017/2018

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Brinkumer	30	113	29	71
2	Oberneuland	30	95	29	70
3	Hastedt	30	101	48	61
4	Bremer SV	30	99	41	58
5	Blumenthaler	30	75	60	54
6	Schwachhause	30	67	68	51
7	Aumund-Veges	30	71	76	46
8	Werder	30	65	53	41
9	Geestemünde	30	66	75	40
10	Leher	30	60	67	37
11	Vatan Sport	30	45	71	31
12	Habenhauser	30	40	72	29
13	Bremerhaven	30	46	94	26
14	Neustadt	30	40	75	25
15	VfL Bremen	30	40	94	22
16	Grolland	30	38	109	13

TEMPORADA 2016/2017

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Eutin 08	3	3	0	7
2	Altona 93	3	2	0	7
3	Bremer SV	3	3	3	3
4	Eintracht	3	0	5	0

TEMPORADA 2015/2016

OBERLIGA GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	Germania	3	5	4	5
2	SV Eichede	3	5	4	5
3	Altona 93	3	4	3	4
4	Bremer SV	3	2	5	1

TEMPORADA 2014/2015

OBERLIGA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Schilksee	2	4	4	3
2	Hildesheim	2	4	4	3
3	Bremer SV	2	3	3	3

TEMPORADA 2013/2014

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bremer SV	30	120	21	82
2	Sparta	30	89	26	71
3	Brinkumer	30	84	31	64
4	Aumund-Veges	30	80	31	58
5	Werder	30	87	45	56
6	Schwachhause	30	63	52	51
7	Blumenthaler	30	77	51	48
8	Habenhauser	30	69	61	41
9	Bremerhaven	30	63	55	41
10	Union Bremen	30	43	72	34
11	SV Grohn	30	49	80	29
12	Türkspor	30	35	116	29
13	VfL Bremen	30	33	82	27
14	Vatan Sport	30	39	98	22
15	Osterholz-Te	30	57	103	21
16	Burg	30	41	105	19

TEMPORADA 2012/2013

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Werder	28	103	34	67
2	Bremer SV	28	90	36	64
3	Aumund-Veges	28	99	34	63
4	Sparta	28	67	32	60
5	Brinkumer	28	62	34	58
6	Union Bremen	28	63	53	40
7	Blumenthaler	28	62	53	39
8	Habenhauser	28	69	67	39
9	Bremerhaven	28	55	66	39
10	Vatan Sport	28	51	57	35
11	Schwachhause	28	55	73	30
12	Türkspor	28	45	91	27
13	Burg	28	42	90	19
14	Osterholz-Te	28	46	104	15
15	Lehe-Spaden	28	43	128	9
16	Wulsdorf	0	0	0	0

TEMPORADA 2011/2012

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Oberneuland	30	133	35	75
2	Bremer SV	30	123	35	71
3	Werder	30	107	42	63
4	Sparta	30	73	43	62
5	Aumund-Veges	30	88	38	57
6	Union Bremen	30	68	42	56
7	Bremerhaven	30	60	65	48
8	Habenhauser	30	52	60	44
9	Brinkumer	30	62	77	36
10	Blumenthaler	30	45	74	28
11	Burg	30	51	96	26
12	Schwachhause	30	44	85	25
13	Türkspor	30	51	116	25
14	Wulsdorf	30	43	91	24
15	VfL Bremen	30	36	85	22
16	Woltmershaus	30	43	95	22

TEMPORADA 2010/2011

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Werder	30	113	28	75
2	Bremer SV	30	93	33	69
3	Aumund-Veges	30	96	46	67
4	Bremerhaven	30	66	33	62
5	Blumenthaler	30	75	47	53
6	Sparta	30	74	57	52
7	Burg	30	61	79	42
8	Brinkumer	30	61	67	40
9	Schwachhause	30	54	74	33
10	Habenhauser	30	66	63	32
11	Oberneuland	30	56	134	31
12	Wulsdorf	30	51	61	30
13	VfL Bremen	30	43	60	30
14	Türkspor	30	56	86	25
15	Melchiorshau	30	37	91	21
16	Weyhe	30	36	79	16

TEMPORADA 2009/2010

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Werder	30	110	29	73
2	Bremer SV	30	87	26	68
3	Bremerhaven	30	85	39	64
4	Brinkumer	30	66	46	50
5	Sparta	30	56	56	49
6	Türkspor	30	46	78	42
7	Blumenthaler	30	55	59	41
8	Habenhauser	30	55	60	39
9	Schwachhause	30	46	56	39
10	Wulsdorf	30	62	48	38
11	Aumund-Veges	30	48	67	36
12	VfL Bremen	30	47	56	34
13	Oberneuland	30	49	64	32
14	Melchiorshau	30	42	86	27
15	Osterholz-Te	30	38	81	26
16	SV Grohn	30	38	79	18

Competiciones que juega

Grupo 5

Regionalliga Grupo 5

Pos	Equipos		Pts
1		Hannover 96 II	67
2		1. FC Phönix Lübeck	62
3		SV Meppen	62
4		Drochtersen / Assel	52
5		Holstein Kiel II	51
6		VfB Oldenburg	48
7		Hamburger SV II	48
8		Teutonia Ottensen	45
9		Havelse	45
10		St. Pauli II	43
11		BW Lohne	41
12		Eintracht Norderstedt	37
13		Bremer SV	37
14		Weiche Flensburg	31
15		Jeddeloh	30
16		Eimsbütteler TV	22
17		Kilia Kiel	16
18		Spelle-Venhaus	12

	Ascenso : Hannover 96 II
	Playoff Descenso : Eimsbütteler TV
	Descenso : Kilia Kiel, Spelle-Venhaus

RIVALES EN Regionalliga

USO DE MEMORIA

6,401,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1746
Total Execution Time	0.1759

CADENA URL

/historico/Bremer-Sv

GET DATOS

$_GET['/historico/Bremer-Sv']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0042	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 = 'Bremer-Sv' AND l.year = 2024 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=17078 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17078 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=17078 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 72795
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17078 AND type_rel = 2
0.0029	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 = '17078' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '17078' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034	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=17078 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (72795,71850,71432,67716) 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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72795 AND teamId = 17078
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 67716 AND teamId = 17078
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71850 AND teamId = 17078
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17078
0.0021	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 = '17078' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17078' and rp.type = 4
0.0021	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 = '17078' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0053	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 events2024 e ON e.player_id = p.id AND e.league_id = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 17078 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.0048	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 events2024 e ON e.player_id = p.id AND e.league_id = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 17078 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 events2024 e ON e.player_id = p.id AND e.league_id = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 17078 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 17078 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId FROM* `tables2024` 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 = 72795 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `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 = 68049 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2022` 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 = 63701 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables2022` 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 = 67583 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables2021` 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 = 58499 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables2020` 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 = 50541 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44365 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 49768 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0075	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* `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 = 38843 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 34102 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 38575 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 15536 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 29204 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 4381 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 14763 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 3537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 19819 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 19830 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 19836 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 19847 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Bremer SV

Bremer SV

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 5

RIVALES EN Regionalliga