Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Resultados de Fútbol

Burgos

Entrenador: Bolo

Temporada 1957/1958

TEMPORADA 1957/1958

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Ponferradina	38	83	35	56
2	Burgos	38	108	41	54
3	Salamanca	38	103	44	51
4	CA Zamora	38	84	42	50
5	Plasencia	38	116	67	47
6	Béjar	38	98	66	43
7	Cacereño	38	119	65	42
8	Hullera	38	81	76	38
9	Júpiter	38	55	66	36
10	Palencia	38	55	68	36
11	Atl. Astorga	38	63	82	35
12	Gimnástica	38	68	77	35
13	CD Juventud	38	69	87	34
14	Real	38	68	98	34
15	Pedro	38	46	78	34
16	Benavente	38	80	115	32
17	Ciudad	38	60	95	32
18	Deportivo	38	58	86	30
19	Castilla	38	37	102	21
20	Júpiter	38	42	103	20

TEMPORADA 1956/1957

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real	38	107	26	62
2	CE Sabadell	38	92	39	54
3	SD Indautxu	38	72	45	48
4	Real Oviedo	38	77	60	46
5	Deportivo	38	61	52	43
6	Cultural	38	63	61	41
7	Real Avilés	38	75	60	39
8	Girona	38	54	53	37
9	Racing	38	60	62	37
10	Eibar	38	63	79	36
11	Rayo	38	45	45	35
12	Caudal	38	66	72	35
13	Terrassa FC	38	57	60	34
14	Sestao Sport	38	60	67	34
15	Circulo	38	46	62	34
16	Racing	38	51	72	33
17	Logroñés	38	44	70	32
18	Barakaldo	38	50	83	31
19	Burgos	38	46	65	30
20	Lleida	38	37	93	19

TEMPORADA 1955/1956

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Burgos	22	64	21	35
2	SCD Durango	22	37	26	28
3	CD Getxo	22	37	27	27
4	SD Erandio	22	39	31	26
5	Arenas Getxo	22	38	24	26
6	CD Basconia	22	46	41	23
7	Portugalete	22	35	41	20
8	Balmaseda	22	35	45	20
9	CD Padura	22	27	39	18
10	Begoña SD	22	34	44	16
11	Laudio	22	30	52	13
12	Club Bermeo	22	35	66	12

TEMPORADA 1954/1955

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Burgos	18	38	18	26
2	SD Indautxu	18	32	17	24
3	CD Basconia	18	29	32	23
4	Mirandés	18	24	23	19
5	SD Erandio	18	23	23	19
6	Laudio	18	30	23	18
7	CD Getxo	18	28	33	15
8	Begoña SD	18	24	27	14
9	Arenas Getxo	18	20	29	12
10	Portugalete	18	22	45	10

TEMPORADA 1953/1954

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sestao Sport	36	91	41	53
2	UD Huesca	36	76	50	45
3	Arenas Getxo	36	69	48	45
4	Mondragón	36	68	49	44
5	Portugalete	36	76	59	40
6	Anaitasuna	35	89	71	39
7	Burgos	36	65	59	38
8	Deportivo	35	69	71	36
9	SD Indautxu	35	55	61	35
10	CD Getxo	36	69	65	33
11	SD Erandio	35	73	71	33
12	Numancia	36	69	83	32
13	CD Basconia	36	50	62	31
14	Azcoyen	36	52	84	31
15	Tudelano	36	50	63	30
16	Begoña SD	36	59	65	30
17	Izarra	36	57	71	30
18	Mirandés	36	51	93	25
19	CD Binéfar	34	52	74	0

TEMPORADA 1952/1953

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Osasuna	30	61	37	40
2	Condal CD	30	65	43	37
3	Real Avilés	30	59	46	37
4	Deportivo	30	58	48	35
5	Logroñés	30	59	44	34
6	Lleida	30	48	37	32
7	Barakaldo	30	54	41	31
8	Sant Andreu	30	50	58	30
9	Racing	30	49	41	29
10	Caudal	30	45	48	28
11	CE Sabadell	30	41	55	28
12	Gimnástica	30	41	57	27
13	Salamanca	30	42	53	26
14	Gimnàstic	30	37	56	25
15	UD Huesca	30	36	48	23
16	Burgos	30	34	67	18

TEMPORADA 1951/1952

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Burgos	30	75	42	40
2	Eibar	30	68	38	39
3	Recreacion	30	59	57	34
4	Deportivo	30	48	39	34
5	CD Getxo	30	52	37	33
6	Arenas	29	50	50	32
7	Mirandés	30	57	48	32
8	Portugalete	30	54	55	30
9	CD Basconia	30	43	49	29
10	Sestao Sport	30	54	55	29
11	Izarra	30	51	70	28
12	SD Erandio	30	29	53	26
13	Numancia	29	64	55	26
14	Calahorra	30	42	67	24
15	SD Indautxu	30	50	59	22
16	Arenas Getxo	30	42	64	20

TEMPORADA 1950/1951

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eibar	34	84	45	52
2	Deportivo	34	75	31	47
3	Burgos	34	71	42	47
4	CD Getxo	34	70	38	45
5	SD Indautxu	34	68	63	38
6	Mirandés	34	63	53	38
7	Izarra	34	75	78	34
8	Calahorra	34	54	63	33
9	Sestao Sport	34	58	63	33
10	Arenas Getxo	34	70	59	32
11	CD Naval	34	66	66	30
12	SD Erandio	34	59	63	30
13	CD Basconia	34	52	52	30
14	Recreacion	34	62	71	30
15	Juventud	34	57	76	28
16	Rayo	34	59	74	24
17	Real Unión	34	49	91	22
18	Tudelano	34	43	107	19

TEMPORADA 1949/1950

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UD Huesca	34	82	51	48
2	Logroñés	34	74	39	47
3	Arenas Getxo	34	67	54	43
4	Arenas	34	83	53	41
5	Calatayud	34	73	83	38
6	CD Getxo	34	71	63	36
7	Sestao Sport	34	52	49	36
8	SD Indautxu	34	61	66	35
9	Escoriaza	34	80	66	34
10	Deportivo	34	66	50	33
11	Atlético	34	72	59	33
12	Tudelano	34	55	73	32
13	Mirandés	34	62	76	31
14	Maestranza	34	55	59	30
15	Izarra	34	53	71	27
16	Calahorra	34	37	69	24
17	Real Unión	34	44	84	24
18	Burgos	34	42	64	20

TEMPORADA 1948/1949

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Osasuna	26	69	27	39
2	Gimnástica	26	54	37	36
3	SD Erandio	26	55	41	28
4	Logroñés	25	49	49	25
5	Maestranza	26	45	49	25
6	SD Indautxu	26	63	67	25
7	Sestao Sport	26	41	51	24
8	Mirandés	26	39	45	24
9	Barreda	26	49	62	24
10	Burgos	25	53	47	23
11	Real Unión	26	50	45	23
12	Deportivo	26	36	46	22
13	Tudelano	26	42	67	22
14	Arenas Getxo	26	48	60	22

TEMPORADA 1947/1948

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	26	81	20	44
2	Gimnástica	26	68	50	33
3	Burgos	26	60	33	33
4	Barreda	26	59	42	32
5	Caudal	26	52	37	31
6	Circulo	26	49	34	30
7	Real Avilés	26	61	46	30
8	Gijonés	26	44	40	28
9	Fábrica	26	53	57	24
10	Mirandés	26	32	58	18
11	Racing Sama	26	36	69	18
12	Real	26	32	50	17
13	Deportivo	26	30	63	14
14	Santoña CF	26	27	85	12

TEMPORADA 1946/1947

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Burgos	18	66	11	31
2	Osasuna	18	53	28	28
3	Logroñés	18	40	22	23
4	Maestranza	18	44	39	17
5	Real Unión	18	29	29	17
6	Villafranca	18	29	41	16
7	Deportivo	18	41	42	16
8	Mirandés	18	25	41	14
9	Tolosa CF	18	23	54	11
10	Izarra	18	27	70	7

TEMPORADA 1945/1946

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Real	18	41	22	27
2	Imperio	18	55	33	24
3	Cultural	18	40	25	22
4	Fábrica	18	37	30	19
5	Ferroviaria	18	35	35	17
6	Real Ávila	18	32	41	16
7	Burgos	18	44	37	15
8	CA Zamora	18	31	48	14
9	Béjar	18	28	51	14
10	Gimnástica	18	31	52	12

TEMPORADA 1944/1945

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Salamanca	18	62	25	27
2	Burgos	18	62	27	27
3	Real	18	44	23	25
4	Fábrica	18	44	19	25
5	CA Zamora	18	28	32	20
6	Gimnástica	18	38	42	16
7	Ferroviaria	18	31	44	14
8	Imperio	18	33	63	11
9	Béjar	18	35	50	10
10	Real Ávila	18	17	69	5

TEMPORADA 1943/1944

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	18	71	31	26
2	Oriamendi	18	47	35	23
3	Real Avilés	18	31	29	22
4	Burgos	18	34	25	22
5	Gimnástica	18	35	35	21
6	Real	18	31	30	19
7	Barreda	18	36	37	18
8	Racing Sama	18	28	42	15
9	Circulo	18	23	42	10
10	Tánagra	18	23	53	4

Competiciones que juega

Tercera División Grupo 13

Pos	Equipos		Pts
1		Ponferradina	56
2		Burgos	54
3		UD Salamanca	51
4		CA Zamora	50
5		Plasencia	47
6		Béjar Industrial	43
7		CP Cacereño	42
8		Hullera	38
9		Júpiter Leonés	36
10		Palencia	36
11		Atl. Astorga	35
12		Gimnástica Arandina	35
13		CD Juventud	34
14		Real Valladolid Promesas	34
15		San Pedro Ponferrada	34
16		Benavente	32
17		Ciudad Rodrigo	32
18		Deportivo Aragón	30
19		Castilla Palencia	21
20		Júpiter Valladolid	20

RIVALES EN Tercera División

USO DE MEMORIA

6,856,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1303
Total Execution Time	0.1316

CADENA URL

/historico/Burgos-Cf/1958

GET DATOS

$_GET['/historico/Burgos-Cf/1958']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0068	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 = 'Burgos-Cf' AND l.year = 1958 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=565 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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 2
0.0029	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 565 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (1193652,2598,2826,5092,25391) ORDER BY n.cover_points DESC, update_date DESC
0.0057	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 = '565' ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '565' AND l.year = 1958 ORDER BY l.year DESC,cat.coefficient DESC
0.0034	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 = '565' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 21458 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035	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=565 AND l.year in (1957,1958,1959) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (21505,20965) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 20965 AND teamId = 565
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 21505 AND teamId = 565
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 FROM* `tables1958` 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 = 21458 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 events1958 e ON e.player_id = p.id AND e.league_id = 21458 WHERE rp.league_id = 21458 AND rp.teamId = 565 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.0020	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 events1958 e ON e.player_id = p.id AND e.league_id = 21458 WHERE rp.league_id = 21458 AND rp.teamId = 565 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events1958 e ON e.player_id = p.id AND e.league_id = 21458 WHERE rp.league_id = 21458 AND rp.teamId = 565 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 565 AND l.year <= 1958 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables1957` 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 = 20965 AND t.round = 38 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* `tables1956` 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 = 21461 AND t.round = 22 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* `tables1955` 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 = 21418 AND t.round = 18 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* `tables1954` 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 = 21411 AND t.round = 40 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* `tables1953` 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 = 21049 AND t.round = 30 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* `tables1952` 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 = 21391 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* `tables1951` 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 = 21385 AND t.round = 34 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* `tables1950` 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 = 21380 AND t.round = 34 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* `tables1949` 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 = 21378 AND t.round = 26 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* `tables1948` 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 = 21373 AND t.round = 26 ORDER BY team.conference 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* `tables1947` 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 = 21364 AND t.round = 18 ORDER BY team.conference 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* `tables1946` 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 = 21353 AND t.round = 18 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* `tables1945` 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 = 21343 AND t.round = 18 ORDER BY team.conference 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* `tables1944` 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 = 21321 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 21458 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

Resultados de Fútbol

Burgos

Burgos

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 13

RIVALES EN Tercera División