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

Vandalia

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alfacar UD	0	0	0	0
2	Atlético	0	0	0	0
3	CD Dúrcal	0	0	0	0
4	CD Santa Fe	0	0	0	0
5	Celtic	0	0	0	0
6	Villanueva	0	0	0	0
7	Ciudad Baza	0	0	0	0
8	Cubillas FC	0	0	0	0
9	Cullar Vega	0	0	0	0
10	Gabia	0	0	0	0
11	Guadix CF	0	0	0	0
12	Puerto	0	0	0	0
13	Purullena	0	0	0	0
14	Salar CF	0	0	0	0
15	Maracena	0	0	0	0
16	Vandalia	0	0	0	0

TEMPORADA 2022/2023

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Churriana	30	79	22	68
2	Loja	30	66	21	63
3	Vandalia	30	54	36	54
4	Puerto	30	56	35	51
5	CD Santa Fe	30	73	43	51
6	Salar CF	30	46	39	50
7	Cullar Vega	30	60	36	48
8	Guadix CF	30	58	43	48
9	Atlético	30	47	51	39
10	Alhendin	30	40	55	33
11	Purullena	30	35	62	31
12	Celtic	30	43	66	30
13	Gabia	30	35	45	29
14	Ciudad Baza	30	39	66	26
15	Atletismo	30	35	94	19
16	Montefrio	30	36	88	17

TEMPORADA 2021/2022

PRIMERA ANDALUZA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Churriana	30	70	31	67
2	Guadix CF	30	92	48	65
3	Cullar Vega	30	80	46	64
4	Almuñecar	30	84	34	60
5	Alhendin	30	61	37	50
6	Vandalia	30	62	46	47
7	Puerto	30	57	52	43
8	Salar CF	30	44	44	40
9	Medina Lauxa	30	45	60	34
10	Purullena	30	40	54	34
11	CD Santa Fe	30	48	64	33
12	Atletismo	30	37	69	33
13	Cubillas	30	38	64	32
14	Asako Motril	30	38	71	25
15	Alfacar	30	31	76	21
16	Atl. Zubia	30	40	71	21
17	Colomera	0	0	0	0

TEMPORADA 2020/2021

DIVISIÓN HONOR SENIOR GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Cubillas FC	30	37	32	45
2	Celtic	30	48	45	45
3	CD Cantoria	30	47	41	44
4	Casabermeja	30	36	26	44
5	Martos CD	30	36	33	43
6	Athletic	30	36	34	42
7	Berja	30	44	31	42
8	Baeza CF	30	42	44	37
9	Villanueva	30	38	50	34
10	CD Vera	30	27	51	27
11	Vandalia	30	33	63	21
12	Guadix CF	30	27	68	11

TEMPORADA 2019/2020

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Salar CF	24	58	20	59
2	Churriana	24	53	22	51
3	Almuñecar	24	52	20	49
4	Vandalia	24	52	25	49
5	Gabia	24	76	52	43
6	Atlético	24	37	26	42
7	Cullar Vega	24	36	43	36
8	Ciudad Baza	24	43	39	34
9	Juventud	24	48	39	33
10	Colomera	24	44	57	29
11	Puerto	24	36	44	27
12	Atl. Zubia	24	34	61	25
13	CD Dúrcal	24	32	51	23
14	Águilas	24	35	41	22
15	CD Iznalloz	24	38	65	22
16	Purullena	24	21	39	20
17	Huetor Tajar	24	33	51	19
18	Albolote CF	24	25	58	18

TEMPORADA 2018/2019

PRIMERA ANDALUZA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Cubillas FC	34	78	25	81
2	Vandalia	34	93	51	68
3	Churriana	34	78	39	66
4	Águilas	34	58	37	60
5	Campotejar	34	61	46	57
6	Salar CF	34	49	44	56
7	Gabia	33	66	52	50
8	Sierra	34	50	50	49
9	Atl. Zubia	33	48	50	43
10	CD Iznalloz	34	59	67	43
11	Puerto	34	58	65	42
12	CD Dúrcal	34	57	77	38
13	Pinos Puente	34	44	75	37
14	Purullena	33	52	87	34
15	Huetor Tajar	34	56	73	32
16	Estrellas	34	47	61	30
17	Atletico	33	36	59	30
18	Íllora	34	29	61	27

TEMPORADA 2017/2018

PRIMERA ANDALUZA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Celtic	34	96	34	80
2	Cubillas FC	33	80	31	70
3	Salar CF	34	71	39	70
4	Campotejar	32	64	35	62
5	Vandalia	34	75	51	55
6	Huetor Tajar	33	71	46	54
7	CD Dúrcal	34	56	57	48
8	Íllora	34	58	59	46
9	Gabia	33	57	69	44
10	Puerto	32	64	57	42
11	Atletismo	33	58	59	41
12	Águilas	33	61	66	41
13	Purullena	33	68	70	39
14	Chauchina	32	51	81	37
15	Cd Abes	26	55	73	27
16	Atl. Zubia	33	42	79	23
17	Herradura	30	31	82	20
18	Valderrubio	33	32	102	18

TEMPORADA 2016/2017

PRIMERA ANDALUZA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Churriana	34	85	30	81
2	Vandalia	34	76	34	74
3	Ciudad Santa	34	99	44	69
4	Campotejar	34	74	40	68
5	Cubillas FC	33	59	27	65
6	Celtic	34	73	50	59
7	Huetor Tajar	34	61	46	58
8	Gabia	34	65	70	46
9	Águilas	34	68	66	45
10	Herradura	34	54	60	45
11	Purullena	34	69	67	42
12	Cd Abes	34	97	107	41
13	Atl. Zubia	32	62	78	39
14	Albolote CF	34	56	74	38
15	Atletismo	33	58	67	38
16	Sierra	34	52	82	28
17	Otura CF	34	34	92	21
18	Alfacar UD	34	21	129	0

TEMPORADA 2015/2016

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CF Motril	34	83	28	75
2	Huetor Vega	34	78	24	73
3	Cd Oriente	34	67	43	61
4	Arenas	33	69	38	60
5	UD Pavía	34	54	37	57
6	Cullar Vega	34	60	55	57
7	Adra	33	54	47	55
8	Universidad	33	71	43	52
9	Cañada	33	68	66	50
10	Purullena	34	54	56	46
11	Alfacar UD	34	50	55	44
12	Vandalia	34	41	58	40
13	Berja	34	50	68	39
14	Churriana	34	39	51	39
15	Ciudad	33	47	65	34
16	Baza	34	38	68	29
17	Los Molinos	34	44	83	27
18	Celtic	33	32	114	8

TEMPORADA 2014/2015

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Comarca	34	85	36	78
2	Arenas	34	67	24	76
3	Adra	34	69	43	67
4	Huetor Vega	34	56	38	59
5	UD Pavía	34	53	41	56
6	Universidad	34	57	45	50
7	Alfacar UD	34	52	47	50
8	Almuñecar	34	51	65	45
9	Churriana	34	54	61	43
10	Vandalia	34	56	55	42
11	Cullar Vega	34	31	33	42
12	Cd Oriente	34	47	44	41
13	Celtic	34	59	71	41
14	Baza	34	31	50	41
15	Cañada	34	50	61	40
16	CD Mojácar	34	40	64	34
17	CD Huercal	34	46	69	32
18	Atl. Zubia	34	36	93	22

TEMPORADA 2013/2014

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pvo. Ejido	34	91	37	76
2	Guadix CF	34	71	30	71
3	Baza	34	57	38	63
4	Huétor Vega	34	68	50	56
5	UD Pavía	34	80	51	56
6	Atl. Zubia	34	59	50	52
7	Universidad	34	57	43	51
8	Vandalia	34	53	51	47
9	Cd Oriente	34	44	58	45
10	Arenas	34	45	49	42
11	Cullar Vega	34	61	75	41
12	CD Mojácar	34	54	64	39
13	Ciudad	34	54	55	38
14	Churriana	34	40	51	37
15	Alfacar UD	34	42	62	36
16	Águilas	34	43	78	33
17	CD Vera	34	50	82	31
18	Comarca	34	35	80	22

TEMPORADA 2011/2012

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Recreativo	33	67	23	73
2	Guadix CF	33	62	43	63
3	Español	34	58	32	62
4	CD Huercal	34	80	49	59
5	CD Vera	35	53	42	55
6	Atarfe	34	74	59	52
7	Los Molinos	33	45	41	50
8	Parador	34	45	45	50
9	Águilas	34	51	52	47
10	Atl. Zubia	33	42	53	47
11	Cullar Vega	33	49	51	44
12	UD Pavía	34	54	62	44
13	Berja	33	49	50	43
14	Baza	34	41	59	39
15	Adra	33	42	59	37
16	Atlético	34	51	58	34
17	Celtic	33	37	62	32
18	Vandalia	34	36	61	28
19	Atlético	33	42	77	26

TEMPORADA 2010/2011

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Arenas	33	57	26	68
2	Los Molinos	32	71	32	62
3	Atlético	32	69	45	56
4	Español	32	74	51	56
5	Guadix CF	32	55	29	55
6	Parador	32	50	43	54
7	Recreativo	32	67	33	53
8	Cullar Vega	32	52	41	53
9	Atarfe	32	48	30	51
10	Berja	32	51	48	46
11	UD Pavía	32	44	43	44
12	Atl. Zubia	32	50	65	40
13	Vandalia	32	30	39	37
14	CD Vera	32	32	65	31
15	Huétor Vega	32	29	65	21
16	Íllora	32	33	94	17
17	Marinos	32	25	86	12
18	Isidro	1	0	2	0

TEMPORADA 2009/2010

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Maracena	34	73	28	75
2	Isidro	34	87	54	69
3	Guadix CF	34	63	31	66
4	Atarfe	34	64	35	62
5	Español	34	61	37	57
6	Recreativo	34	65	52	54
7	Atl. Zubia	34	59	49	53
8	Cullar Vega	34	60	52	49
9	Marinos	34	57	78	44
10	UD Pavía	34	61	68	43
11	Vandalia	34	41	41	42
12	Berja	34	48	52	42
13	Huétor Vega	34	41	52	40
14	Las Norias	34	53	82	38
15	Churriana	34	42	64	37
16	Imperio	34	44	71	33
17	Cañada	34	58	78	29
18	Gabia	34	52	105	25

TEMPORADA 2008/2009

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Carboneras	32	77	29	75
2	Español	32	71	38	60
3	Atarfe	32	50	26	58
4	Huétor	32	45	31	58
5	Vandalia	32	52	37	50
6	Guadix CF	32	50	50	47
7	Cullar Vega	32	44	49	46
8	Las Norias	32	40	50	43
9	Recreativo	32	32	39	41
10	Maracena	32	43	52	40
11	Atl. Zubia	32	47	46	38
12	Churriana	32	52	52	37
13	Isidro	32	35	41	37
14	Hermandad	32	33	57	34
15	Gabia	32	34	60	34
16	Parador	32	29	52	32
17	Villa Albox	32	33	58	26

TEMPORADA 2007/2008

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CD Santa Fe	32	76	31	75
2	Imperio	32	49	24	66
3	Atarfe	32	62	36	65
4	Parador	32	44	29	58
5	Atl. Zubia	32	43	28	52
6	CD Huercal	32	38	33	51
7	Churriana	32	51	51	45
8	Las Norias	32	36	45	41
9	Cullar Vega	32	31	38	40
10	Recreativo	32	36	43	39
11	Vandalia	32	31	39	36
12	Villa Albox	32	36	41	34
13	Sierra	32	43	52	34
14	Gabia	32	26	43	33
15	Español	32	44	56	31
16	Maracena	32	25	47	29
17	Almuñecar	32	28	63	24

TEMPORADA 2006/2007

PRIMERA ANDALUZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Granada 74	30	51	16	64
2	CD Santa Fe	30	44	26	55
3	Atarfe	30	43	32	50
4	Atl. Zubia	30	45	35	47
5	Ciudad	30	45	37	44
6	Vandalia	30	38	30	44
7	Granada 74	30	28	24	42
8	Churriana	30	31	34	41
9	Almuñecar	30	34	40	40
10	Cuevas CF	30	33	43	38
11	Gabia	30	30	36	37
12	Las Norias	30	41	51	37
13	Guadix CF	30	29	36	35
14	Cd Oriente	30	28	49	30
15	Motril CF B	30	32	52	28
16	Velez Rubio	30	26	37	27

TEMPORADA 2005/2006

2ª ANDALUZA GRANADA
Equipo		PJ	GF	GC	Puntos
1	Atl. Zubia	30	67	28	66
2	Granada	30	52	24	64
3	Motril CF B	30	67	34	63
4	Cullar Vega	30	50	32	56
5	CD Iznalloz	30	46	22	55
6	Recreativo	30	46	32	48
7	Huétor	30	52	43	45
8	Chauchina	30	44	47	41
9	Salobreña	30	38	45	39
10	Maracena	30	38	56	30
11	Águilas	30	48	76	30
12	Vandalia	30	41	62	29
13	Celtic	30	42	61	28
14	U.D.E. Chana	30	46	59	27
15	Alfacar UD	30	36	63	24
16	Huétor Vega	30	27	56	18

TEMPORADA 2004/2005

2ª ANDALUZA GRANADA
Equipo		PJ	GF	GC	Puntos
1	Sierra	29	50	31	59
2	Almuñecar	29	52	34	55
3	U.D.E. Chana	29	73	37	54
4	Atl. Zubia	29	43	27	50
5	Huétor	29	51	44	50
6	Vandalia	29	47	40	48
7	Motril CF B	29	43	41	43
8	Alfacar UD	29	36	44	39
9	Maracena	29	52	48	38
10	Huétor Vega	29	43	47	36
11	Villanueva	29	47	51	33
12	Cullar Vega	29	36	41	33
13	Salobreña	29	43	64	33
14	Haza Grande	29	39	71	27
15	Ogijares	29	32	53	22
16	Universal	15	15	29	10

Competiciones que juega

Grupo 2

Primera Andaluza Grupo 2

Pos	Equipos		Pts
1		Alfacar UD	0
2		Atlético Monachil	0
3		CD Dúrcal	0
4		CD Santa Fe	0
5		Celtic Pulianas	0
6		Cf Villanueva Mesia	0
7		Ciudad de Baza	0
8		Cubillas FC	0
9		Cullar Vega	0
10		Gabia	0
11		Guadix CF	0
12		Puerto de Motril	0
13		Purullena CF	0
14		Salar CF	0
15		UD Maracena B	0
16		Vandalia	0

	Playoff Ascenso : Alfacar UD, Atlético Monachil, CD Dúrcal, CD Santa Fe
	Descenso : Salar CF, UD Maracena B, Vandalia

RIVALES EN Primera Andaluza

USO DE MEMORIA

7,433,408 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6157
Total Execution Time	0.6169

CADENA URL

/historico/Vandalia

GET DATOS

$_GET['/historico/Vandalia']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0135	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 = 'Vandalia' 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.0125	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=2659 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=2659 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2659 AND type_rel = 2
0.0131	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 = '2659' ORDER BY l.year DESC,cat.coefficient DESC
0.0131	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 = '2659' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '2659' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 73625 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=2659 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73625,67320) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 73625 AND teamId = 2659
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2659
0.0128	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 = 73625 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '2659' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2659' and rp.type = 4
0.0127	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 = '2659' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141	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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 2659 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.0135	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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 2659 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 2659 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 2659 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 68700 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.0130	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 = 64156 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.0130	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 = 58972 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 61681 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 51257 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 44627 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 39695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 34595 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 16715 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4080 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2572 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1467 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 858 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 325 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 118 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2965 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 2964 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Vandalia

Vandalia

Selecciona un equipo

Competiciones que juega

Primera Andaluza Grupo 2

RIVALES EN Primera Andaluza