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

CD Vitoria

Entrenador: Jokin Aranbarri

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CD Vitoria	31	60	15	75
2	Beasain KE	31	52	31	60
3	Portugalete	31	52	28	59
4	CD Basconia	31	47	29	55
5	Deusto	31	42	29	52
6	Lagun Onak	31	36	29	51
7	SCD Durango	31	40	42	46
8	San Ignacio	31	43	35	45
9	Urduliz FT	31	36	39	42
10	Leioa	31	40	44	41
11	CD Derio	31	31	31	38
12	CD Padura	31	31	42	38
13	Deportivo	31	29	39	35
14	CD Touring	31	34	44	33
15	Anaitasuna	31	30	44	29
16	Pasaia KE	31	16	38	27
17	Aurrera KE	31	20	48	21
18	Añorga	31	25	57	15

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Barakaldo	30	67	11	76
2	CD Vitoria	30	49	18	58
3	Leioa	30	49	36	56
4	CD Basconia	30	59	37	54
5	Deusto	30	38	26	47
6	Portugalete	30	32	32	41
7	Pasaia KE	30	36	53	38
8	SCD Durango	30	40	41	37
9	Aurrera KE	30	29	37	37
10	Anaitasuna	30	36	36	37
11	Urduliz FT	30	31	38	33
12	Lagun Onak	30	25	29	33
13	CD Padura	30	28	39	32
14	CD Touring	30	34	52	32
15	San Ignacio	30	30	53	26
16	Aurrera	30	17	62	12

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	72	31	76
2	Beasain KE	38	65	36	70
3	Portugalete	38	60	33	70
4	Barakaldo	38	64	46	69
5	CD Basconia	38	45	32	65
6	CD Vitoria	38	55	49	59
7	San Ignacio	38	57	48	58
8	SCD Durango	38	42	29	57
9	Leioa	38	55	38	56
10	Anaitasuna	38	48	49	52
11	Lagun Onak	38	42	44	51
12	Pasaia KE	38	36	43	50
13	Deusto	38	42	40	49
14	Urduliz FT	38	39	57	45
15	Aurrera KE	38	36	55	38
16	Santutxu	38	42	60	38
17	Uritarra CD	38	38	52	38
18	Amurrio	38	39	45	37
19	Beti Gazte	38	34	80	26
20	Tolosa CF	38	43	87	26

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SD Gernika	20	39	16	43
2	Real	20	48	27	40
3	Sestao River	20	40	13	39
4	Deusto	20	30	24	36
5	Santutxu	20	20	23	29
6	Beasain KE	20	20	14	27
7	Tolosa CF	20	21	26	24
8	Aurrera KE	20	23	31	20
9	Balmaseda	20	22	27	18
10	Somorrostro	20	20	31	17
11	Urgatzi KK	20	11	62	10
12	CD Vitoria	20	20	4	35
13	Urduliz FT	20	28	18	35
14	Pasaia KE	20	22	14	34
15	CD Basconia	20	24	15	30
16	Anaitasuna	20	20	19	30
17	San Ignacio	20	19	19	29
18	Santurtzi	20	18	27	23
19	SCD Durango	20	17	20	22
20	Sodupe	20	21	23	20
21	Ariznabarra	20	12	28	16
22	Lagun Onak	20	17	31	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Portugalete	28	48	22	56
2	Sestao River	28	52	24	56
3	CD Vitoria	28	35	14	55
4	CD Basconia	28	38	26	47
5	Somorrostro	28	38	27	46
6	SD Gernika	28	42	26	45
7	San Ignacio	28	38	29	39
8	Pasaia KE	28	27	27	39
9	Santutxu	28	26	26	39
10	Balmaseda	28	29	28	37
11	Sodupe	28	27	31	36
12	Santurtzi	28	21	27	36
13	Real	28	33	39	34
14	Beasain KE	28	31	31	33
15	SCD Durango	28	33	35	29
16	Urduliz FT	28	20	26	28
17	Tolosa CF	28	20	42	26
18	Deusto	28	28	49	26
19	Lagun Onak	28	19	32	26
20	Ariznabarra	28	17	61	17

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	38	66	25	78
2	Logroñés	38	44	22	72
3	Mirandés	38	53	32	69
4	Barakaldo	38	41	40	61
5	Real Oviedo	38	55	45	59
6	Bilbao Ath.	38	67	45	57
7	Leioa	38	43	40	53
8	Amorebieta	38	44	45	53
9	Langreo	38	43	48	52
10	Calahorra	38	45	52	50
11	Sporting	38	42	43	49
12	Real	38	47	42	45
13	Izarra	38	33	44	45
14	Tudelano	38	33	42	45
15	Arenas Getxo	38	33	40	45
16	Real Unión	38	39	44	44
17	SD Gernika	38	32	42	42
18	CD Vitoria	38	34	51	35
19	Gimnástica	38	25	44	32
20	SCD Durango	38	32	65	30

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mirandés	38	53	33	76
2	Sporting	38	61	36	75
3	Real	38	49	24	74
4	Bilbao Ath.	38	67	27	73
5	Racing	38	44	33	68
6	Barakaldo	38	50	28	63
7	Logroñés	38	55	35	61
8	SD Gernika	38	46	41	59
9	Tudelano	38	38	32	53
10	Leioa	38	47	42	51
11	Burgos	38	28	28	51
12	Arenas Getxo	38	46	43	46
13	Real Unión	38	32	46	46
14	Amorebieta	38	44	46	44
15	CD Vitoria	38	40	44	43
16	Izarra	38	32	58	39
17	Peña Sport	38	33	62	35
18	Lealtad	38	26	60	28
19	Osasuna	38	25	63	24
20	Caudal	38	19	54	19

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	57	20	74
2	CD Vitoria	38	60	39	72
3	SCD Durango	38	56	27	71
4	Beasain KE	38	51	29	70
5	Portugalete	38	56	39	69
6	Club Bermeo	38	53	41	56
7	Deusto	38	46	45	55
8	Santurtzi	38	44	38	53
9	Balmaseda	38	41	40	51
10	CD Basconia	38	50	55	48
11	Sodupe	38	55	67	47
12	Amurrio	38	39	39	46
13	CD Getxo	38	39	45	45
14	Lagun Onak	38	30	47	45
15	Real	38	36	35	44
16	Santutxu	38	38	45	41
17	Tolosa CF	38	32	49	39
18	Aurrera KE	38	27	54	38
19	Zalla	38	39	63	33
20	Pasaia KE	38	35	67	29

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SD Zamudio	38	65	40	74
2	Club Bermeo	38	57	35	67
3	Lagun Onak	38	39	26	66
4	Balmaseda	38	50	35	64
5	Beasain KE	38	54	36	63
6	CD Vitoria	38	47	32	61
7	Santutxu	38	39	33	53
8	Zalla	38	54	43	52
9	Pasaia KE	38	36	48	52
10	SCD Durango	38	29	34	50
11	CD Getxo	38	43	38	50
12	Deportivo	38	54	52	48
13	Real	38	44	48	47
14	CD Basconia	38	53	62	46
15	Santurtzi	38	40	46	46
16	Deusto	38	38	46	45
17	Aurrera KE	38	50	76	41
18	Aurrera	38	33	50	40
19	Elgorriaga	38	36	56	32
20	Aretxabaleta	38	34	59	28

TEMPORADA 2014/2015

REGIONAL PREFERENTE ÁLAVA
Equipo		PJ	GF	GC	Puntos
1	CD Vitoria	34	74	25	78
2	Elgorriaga	34	81	25	74
3	Iru-Bat	34	67	30	71
4	Martín	34	67	44	67
5	Salvatierra	34	66	29	64
6	Laudio	34	61	23	63
7	San Ignacio	34	61	39	62
8	Ariznabarra	34	51	41	55
9	Zaramaga	34	38	39	42
10	Pilar	34	38	42	38
11	Vitoria B	34	50	81	38
12	Abetxuko	34	45	68	37
13	Prudencio	34	32	49	34
14	Zuia Fútbol	34	32	59	34
15	CD Alipendi	34	35	74	29
16	Condado	34	51	77	27
17	Lantarón	34	32	84	20
18	Nanclares	34	28	80	15

TEMPORADA 2013/2014

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Aurrera	34	96	25	82
2	Club Ignacio	34	90	25	81
3	Salvatierra	34	78	25	77
4	Martín	34	76	37	73
5	CD Vitoria	34	69	38	67
6	Ariznabarra	34	66	40	63
7	Nanclares	34	68	59	56
8	Iru-Bat	34	65	39	52
9	Pilar	34	65	62	52
10	Lantarón	34	37	62	37
11	CD Alipendi	34	44	63	36
12	Zaramaga	34	44	59	34
13	Prudencio	34	47	69	32
14	Laudio	34	45	63	32
15	Vitoria B	34	41	77	32
16	Abetxuko	34	23	64	29
17	Gasteiz	34	36	116	14
18	Rioja	34	32	99	12

TEMPORADA 2012/2013

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Amurrio	34	114	37	81
2	Salvatierra	34	88	33	74
3	Club Ignacio	34	81	28	73
4	Ariznabarra	34	69	40	66
5	Pilar	34	77	45	65
6	CD Vitoria	34	53	36	64
7	Martín	34	55	35	63
8	Zaramaga	34	70	48	60
9	CDF Lakua	34	62	73	48
10	Abetxuko	34	57	63	43
11	Nanclares	34	49	59	40
12	Iru-Bat	34	49	73	38
13	Condado	34	37	55	36
14	Laudio	34	43	62	31
15	Prudencio	34	44	81	29
16	Lantarón	34	36	62	25
17	Zuia Fútbol	34	40	78	24
18	Vulcano	34	36	152	3

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Laudio	38	70	24	77
2	Barakaldo	38	57	30	76
3	Portugalete	38	60	29	74
4	Beasain KE	38	58	34	72
5	Zalla	38	57	34	72
6	SD Gernika	38	50	37	64
7	SCD Durango	38	49	41	63
8	SD Zamudio	38	42	42	54
9	Leioa	38	44	37	53
10	CD Basconia	38	67	67	47
11	Lagun Onak	38	29	31	46
12	CD Elgoibar	38	41	49	45
13	Eibar B	38	36	45	44
14	Arenas Getxo	38	43	44	42
15	Santutxu	38	35	56	40
16	Balmaseda	38	48	57	40
17	Deportivo	38	49	71	40
18	CD Vitoria	38	42	64	32
19	CD Hernani	38	31	71	26
20	Zarauzko Ke	38	29	74	20

TEMPORADA 2010/2011

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	34	83	24	83
2	Laudio	34	63	32	82
3	CD Vitoria	34	78	20	78
4	Salvatierra	34	60	36	59
5	Club Ignacio	34	45	33	55
6	Zaramaga	34	56	42	54
7	Pilar	34	58	52	53
8	Abetxuko	34	54	54	46
9	Ariznabarra	34	46	42	44
10	Lantarón	34	37	48	43
11	Aurrera	34	34	46	43
12	Amurrio Club	34	38	44	41
13	Nanclares	34	35	51	36
14	Condado	34	32	53	35
15	CDF Lakua	34	38	51	34
16	Martín	34	41	68	34
17	Prudencio	34	26	58	22
18	Alegría	34	29	99	6

TEMPORADA 2009/2010

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Aurrera	34	76	24	79
2	San Ignacio	34	73	29	70
3	Martín	34	78	47	69
4	Ariznabarra	34	59	41	64
5	Deportivo	34	75	29	63
6	CD Vitoria	34	58	38	61
7	Zaramaga	34	53	39	59
8	Nanclares	34	61	45	53
9	Alegría	34	58	60	50
10	Pilar	34	72	57	48
11	CDF Lakua	34	55	54	48
12	Condado	34	37	58	37
13	Prudencio	34	43	59	36
14	Laudio	34	35	61	34
15	Bruno	34	47	74	32
16	Zuia Fútbol	34	27	66	21
17	Vulcano	34	36	88	15
18	Izarra Gorri	34	21	95	12

TEMPORADA 2008/2009

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salvatierra	34	84	24	81
2	CD Vitoria	34	103	32	79
3	Aurrera	34	83	36	78
4	CDF Lakua	34	75	47	60
5	Vulcano	34	76	55	57
6	Ariznabarra	34	56	38	53
7	Martín	34	64	60	52
8	Alegría	34	54	58	50
9	Prudencio	34	55	55	49
10	Bruno	34	50	47	48
11	Pilar	34	62	51	45
12	Zaramaga	34	59	56	43
13	Izarra Gorri	34	63	75	42
14	Nanclares	34	49	51	41
15	Abetxuko	34	42	83	36
16	Iru-Bat	34	49	82	33
17	Lantarón	34	24	114	14
18	Baskonia	34	20	104	4

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Portugalete	38	56	31	69
2	SD Gernika	38	52	37	68
3	Amurrio	38	55	30	67
4	SD Zamudio	38	56	40	66
5	CD Basconia	38	51	35	65
6	Lagun Onak	38	50	32	63
7	Zalla	38	53	47	63
8	Eibar B	38	60	47	58
9	Santurtzi	38	34	44	51
10	Amorebieta	38	46	47	49
11	CD Elgoibar	38	37	40	47
12	Arenas Getxo	38	39	44	46
13	Deportivo	38	39	37	45
14	Beasain KE	38	43	52	43
15	Laudio	38	36	38	42
16	Zarautz	38	28	43	41
17	SCD Durango	38	42	51	41
18	Pedro	38	37	52	41
19	Tolosa CF	38	37	53	39
20	CD Vitoria	38	34	85	23

TEMPORADA 1961/1962

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Eibar	32	80	26	49
2	Logroñés	32	73	38	46
3	Bergara KE	32	73	58	38
4	Real Unión	32	70	41	37
5	Beasain KE	32	57	57	37
6	Mirandés	32	65	56	36
7	CD Alfaro	32	53	43	35
8	CD Iruña	32	60	61	33
9	Villafranca	32	58	76	31
10	Euskalduna	32	65	52	30
11	Tolosa CF	32	48	58	29
12	CD Touring	32	61	56	28
13	Azkoyen	32	44	61	27
14	CD Vitoria	32	40	66	25
15	Calahorra	32	38	71	22
16	Recreacion	32	37	69	21
17	CD Elgoibar	32	40	73	20

Competiciones que juega

Tercera Federación Grupo 4

Pos	Equipos		Pts
1		CD Vitoria	75
2		Beasain KE	60
3		Portugalete	59
4		CD Basconia	55
5		Deusto	52
6		CD Lagun Onak	51
7		SCD Durango	46
8		San Ignacio	45
9		Urduliz FT	42
10		Leioa	41
11		CD Derio	38
12		CD Padura	38
13		Deportivo Alavés C	35
14		CD Touring	33
15		Anaitasuna FT	29
16		Pasaia KE	27
17		Aurrera KE	21
18		Añorga	15

	Ascenso : CD Vitoria
	Playoff Ascenso : Beasain KE, Portugalete, CD Basconia, Deusto
	Descenso : Pasaia KE, Aurrera KE, Añorga

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,714,848 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1143
Total Execution Time	0.1161

CADENA URL

/historico/Cd-Vitoria-Senior

GET DATOS

$_GET['/historico/Cd-Vitoria-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (25)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10131 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10131 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (93102,225942,234064,241720,244449) ORDER BY n.cover_points DESC, update_date 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 = '10131' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72263 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72263 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030	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 = 10131 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67978 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `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 = 62388 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.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* `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 = 58582 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 50272 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44096 AND t.round = 38 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* `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 = 38807 AND t.round = 38 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* `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 = 33354 AND t.round = 38 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* `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 = 15445 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* `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 = 4338 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* `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 = 2736 AND t.round = 34 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* `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 = 1981 AND t.round = 34 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* `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 = 1401 AND t.round = 38 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* `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 = 1144 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* `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 = 850 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* `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 = 308 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 11 AND t.round = 38 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* `tables1962` 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 = 21535 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 72263 ORDER BY nameShow LIMIT 100

CD Vitoria

CD Vitoria

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 4

RIVALES EN Tercera Federaci.