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

Villargordo CF

Temporada 2023/2024

TEMPORADA 2023/2024

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Villares	22	44	25	49
2	Valdepeñas	22	49	26	44
3	Tuccitana	22	50	30	41
4	Alcalá	22	37	20	38
5	Guardia	22	37	31	34
6	Real Jaén	22	47	33	32
7	Fuensanta	22	37	39	31
8	Huelma CP	22	29	31	30
9	Villargordo	22	32	45	24
10	Castillo	22	33	47	22
11	Jódar CF	22	23	41	16
12	CD Jimena	22	17	67	6

TEMPORADA 2022/2023

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Hispania	20	50	24	49
2	Guardia	20	54	25	46
3	Villares	20	36	34	31
4	CD Jimena	20	36	32	31
5	Real Jaén	20	30	22	28
6	Martos	20	32	28	26
7	Huelma CP	20	28	32	23
8	Veteranos	20	32	33	21
9	UD Cambil	20	32	56	16
10	Villargordo	20	37	54	15
11	Castillo	20	27	54	15

TEMPORADA 2021/2022

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Torredonjime	24	87	19	60
2	Guardia	24	58	25	55
3	CD Hispania	24	48	19	51
4	Atlético	24	42	21	44
5	Atlético	24	53	33	43
6	Club	23	37	34	39
7	AD Lopera	23	48	37	35
8	Villargordo	24	38	39	35
9	UD Cambil	24	51	78	22
10	Castillo	24	35	55	20
11	CD Utica	23	33	60	16
12	Martos	23	17	75	8
13	Veteranos	24	22	74	6

TEMPORADA 2020/2021

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Alcalá	10	26	8	27
2	UD Cambil	10	20	16	14
3	AD Lopera	10	16	19	13
4	Villargordo	10	14	13	12
5	Veteranos	10	17	27	11
6	Atlético	10	10	20	7

TEMPORADA 2019/2020

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fuensanta	18	47	15	43
2	Valdepeñas	18	43	22	39
3	Alcalá	18	41	17	35
4	CD Utica	18	42	23	33
5	AD Lopera	18	28	28	30
6	Club	18	30	30	28
7	Villargordo	18	22	26	25
8	Tuccitana	18	24	29	23
9	Adebal	18	30	25	21
10	UD Cambil	18	32	43	19
11	Club Dvo.	18	26	57	7
12	Atlético	18	15	65	2

TEMPORADA 2018/2019

2ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Inter Jaén	20	35	11	42
2	Mancha Real	20	44	21	41
3	Villares	20	37	20	38
4	Fuensanta	20	46	37	33
5	Valdepeñas	20	31	26	33
6	Alcalá	20	31	28	27
7	Club	20	28	30	22
8	CD Utica	20	21	29	22
9	Villargordo	20	14	33	19
10	AD Lopera	20	21	33	17
11	Atlético	20	23	63	13

TEMPORADA 2017/2018

PRIMERA ANDALUZA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Begíjar CF	32	58	32	65
2	Baeza CF	32	68	42	62
3	Úbeda Viva	32	72	28	61
4	CD Hispania	33	59	41	56
5	Guardia	32	70	41	56
6	Villanueva	32	51	54	52
7	Huelma CP	32	57	50	51
8	Iliturgi	33	54	46	50
9	Santisteban	32	41	51	43
10	CD Vilches	32	46	51	42
11	Arquillos	32	50	52	40
12	Arroyo	32	41	57	39
13	Recreativo	33	51	57	38
14	Urgavona CF	32	55	63	36
15	Quesada CD	32	51	73	33
16	Villargordo	33	37	81	24
17	Castellar	32	38	65	22
18	C.D.	4	1	16	0

TEMPORADA 2016/2017

PRIMERA ANDALUZA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Navas CD	34	102	54	68
2	Úbeda Viva	33	69	46	61
3	Guardia	34	77	52	59
4	Real Jaén	34	64	47	57
5	Urgavona CF	34	73	57	57
6	CD Hispania	34	52	44	54
7	Baeza CF	34	62	54	53
8	Arroyo	34	60	48	52
9	Begíjar CF	34	59	63	48
10	Guarroman	34	57	50	47
11	CD Vilches	34	54	58	45
12	Arquillos	34	45	55	45
13	Huelma CP	34	65	87	42
14	Villargordo	34	50	62	39
15	C.D.	34	50	64	38
16	Villanueva	34	57	77	37
17	Carolinense	34	52	73	36
18	Fuensanta	33	40	97	16

TEMPORADA 2015/2016

3ª ANDALUZA JAÉN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Villargordo	22	62	10	53
2	C.D.	21	67	21	49
3	Fuensanta	22	64	18	43
4	Mancha Real	22	43	25	42
5	Recreativo	21	35	20	32
6	UD Cambil	22	46	37	29
7	Valdepeñas	22	38	46	28
8	CD Utica	22	38	45	28
9	Escañolense	22	41	48	22
10	Castillo	22	32	58	16
11	Jódar CF	21	30	42	13
12	Mureño CF	21	16	142	6

TEMPORADA 2014/2015

3ª ANDALUZA JAÉN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Hispania	24	69	20	58
2	AD Lopera	24	67	31	52
3	Escañolense	24	52	22	50
4	Huelma CP	23	63	31	48
5	Alcalá	24	62	34	44
6	Martos CD	24	48	37	38
7	Villargordo	24	56	45	36
8	Atlético	24	54	43	35
9	Valdepeñas	24	34	49	32
10	Iliturgi CF	23	31	58	17
11	UD Cambil	24	25	71	13
12	Mancha Real	24	27	54	12
13	Mureño CF	24	21	114	7
14	Veteranos	0	0	0	0

TEMPORADA 2013/2014

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Úbeda Viva	30	82	38	70
2	Mengibar	30	75	30	68
3	Tuccitana	30	58	38	55
4	Bailen	30	56	38	52
5	Baeza CF	30	53	39	51
6	Vilches	30	66	54	48
7	Torreperogil	30	52	50	46
8	Guardia	30	56	62	41
9	C.D. Navas.	30	53	48	40
10	Puertas	30	49	65	38
11	Carolinense	30	40	41	37
12	Jódar CF	30	50	79	36
13	Villargordo	30	43	55	34
14	CD Tugia	30	46	69	28
15	Escañolense	30	31	57	24
16	Iliturgi CF	30	30	77	11

TEMPORADA 2012/2013

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Atletico	30	58	27	61
2	Club	30	62	37	58
3	Baeza CF	30	55	34	54
4	Recreativo	30	52	36	52
5	Carolinense	30	40	31	47
6	Vilches	30	44	43	42
7	Escañolense	30	43	43	42
8	Jódar CF	30	53	54	42
9	Guardia	30	46	46	41
10	Villargordo	30	41	44	39
11	Puertas	30	46	47	38
12	Santomera	30	47	42	37
13	Alcalá	30	42	56	33
14	Atlético	30	32	43	26
15	Guarroman	30	41	79	25
16	C.D. Rus	30	32	72	24

TEMPORADA 2011/2012

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Villares	30	74	23	71
2	Torredonjime	30	68	34	65
3	Iliturgi CF	30	64	34	55
4	Santo Tome	30	53	37	47
5	Guardia	30	53	47	46
6	Jódar CF	30	58	59	45
7	Atletico	30	50	58	41
8	Villargordo	30	49	67	40
9	CD Vilches	30	54	55	36
10	Navas CD	30	42	54	36
11	Bailen Rtvo.	30	31	41	34
12	Guarroman	30	44	60	34
13	Mancha Real	30	38	54	33
14	Huelma CP	30	45	67	33
15	ValdepeÃ±a	30	46	62	29
16	Beas Segura	30	44	61	26

TEMPORADA 2009/2010

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Villacarrill	30	67	27	67
2	Carolinense	30	65	24	65
3	Villares	30	75	26	64
4	Racing Jaén	30	60	35	63
5	Villanueva	30	49	36	53
6	C.D. Útica	30	63	39	52
7	Valdepeñas	30	65	50	47
8	Santomera	30	68	59	44
9	Castillo	30	60	64	42
10	Guarroman	30	44	40	40
11	Guardia	30	33	31	35
12	Huelma CP	30	43	71	34
13	Villargordo	30	27	65	26
14	Mancha Real	30	34	70	22
15	Veteranos	30	22	72	14
16	C.D.	30	38	104	12

TEMPORADA 2008/2009

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Bailén	30	73	23	75
2	Úbeda Viva	30	87	28	73
3	Villares	30	82	37	63
4	Racing Jaén	30	53	37	53
5	C.D. Útica	30	61	51	47
6	F.s.Valdepe�	30	61	50	46
7	Villanueva	30	45	52	42
8	CD Tugia	30	35	40	37
9	Mancha Real	30	56	61	36
10	Castillo	30	45	52	36
11	Atlético	30	32	40	34
12	Villargordo	30	41	55	34
13	C.D.	30	46	68	34
14	Guardia	30	39	61	28
15	Jódar CF	30	24	85	20
16	C.D. Rus	30	18	58	16

TEMPORADA 2007/2008

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Betis	30	73	40	61
2	Vilches	29	66	37	59
3	P.Jienense	30	59	25	56
4	Úbeda Viva	30	52	31	52
5	Villares	30	70	46	51
6	Bailén	30	50	31	51
7	Atlético	30	44	25	47
8	C.D. Útica	30	54	48	46
9	Villargordo	30	43	41	43
10	F.s.Valdepe�	30	45	56	37
11	Castillo	30	40	72	35
12	C.D. Rus	30	33	41	33
13	Orcera CF	29	37	61	29
14	Quesada C.D.	29	41	73	29
15	Linares	29	27	60	15
16	Beas Segura	26	23	70	13

TEMPORADA 2006/2007

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Puertas	32	68	22	73
2	Martos CD	32	61	22	73
3	Alcalá	32	73	24	71
4	P.Jienense	32	51	27	63
5	Vilches	32	54	39	55
6	F.s.Valdepe�	32	52	51	49
7	Betis	32	40	39	43
8	Bailén	32	40	50	43
9	Villares	32	37	38	42
10	Atlético	32	36	35	40
11	Villargordo	32	41	43	40
12	C.D. Rus	32	28	36	40
13	Guardia	32	54	53	39
14	Villanueva	32	32	55	29
15	Begíjar CF	32	34	79	25
16	Urgavona CF	32	27	52	23
17	UD Cazorla	32	24	87	13

TEMPORADA 2005/2006

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Baeza CF	34	70	24	76
2	Mengibar	34	80	42	68
3	Linares	34	58	38	67
4	Martos CD	34	68	41	64
5	Alcalá	34	74	46	62
6	Puertas	34	67	40	56
7	F.s.Valdepe�	34	61	42	53
8	Guardia	34	55	44	51
9	C.D. Rus	34	44	33	49
10	Villares	34	57	60	44
11	UD Cazorla	34	52	63	43
12	Vilches	34	44	63	37
13	Villargordo	34	45	77	37
14	Atlético	34	39	48	36
15	Huelma CP	34	37	49	36
16	C.D. Útica	34	55	82	32
17	Castillo	34	37	83	24
18	Mogon CF	34	33	101	14

TEMPORADA 2004/2005

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Real Jaén	26	60	26	54
2	CD Tugia	26	63	36	54
3	Baeza CF	26	53	28	50
4	Guardia	26	51	33	46
5	Puertas	26	48	35	46
6	Linares	26	53	36	37
7	C.D. Rus	26	41	34	36
8	Villares	26	49	52	36
9	Vilches	26	60	54	35
10	Villargordo	26	33	50	31
11	Castillo	26	40	67	28
12	Mogon CF	26	36	63	25
13	Veteranos	26	45	64	22
14	Jódar CF	26	25	79	9

TEMPORADA 2003/2004

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Bailén	34	104	26	89
2	Jódar	34	92	25	87
3	Iliturgi CF	34	92	27	76
4	Urgavona CF	34	45	47	50
5	Alcalá	34	47	54	49
6	F.s.Valdepe�	34	52	45	47
7	Atlético	34	46	47	47
8	Torredonjime	34	60	74	45
9	Vilches	34	58	67	43
10	Linares	34	47	47	41
11	Puertas	34	60	75	41
12	Club	34	46	67	40
13	Real Jaén	34	47	53	39
14	C.D. Rus	34	33	47	39
15	Atletico	34	42	67	39
16	Villargordo	34	40	59	37
17	C.D. Útica	34	42	81	28
18	Mengibar	34	38	83	24

Competiciones que juega

Grupo 1

2ª Andaluza Jaén Grupo 1

Pos	Equipos		Pts
1		Los Villares CF	49
2		Valdepeñas de Jaén CF	44
3		CD Tuccitana	41
4		CD Alcalá Enjoy	38
5		UD La Guardia	34
6		Real Jaén B	32
7		Fuensanta CF	31
8		Huelma CP	30
9		Villargordo CF	24
10		Castillo de Locubin	22
11		Jódar CF	16
12		CD Jimena	6

	Playoff Ascenso : Los Villares CF, Valdepeñas de Jaén CF, CD Tuccitana, CD Alcalá Enjoy

RIVALES EN 2ª Andaluza Jaén

USO DE MEMORIA

6,969,752 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5939
Total Execution Time	0.5951

CADENA URL

/historico/Villargordo-Cf-Senior

GET DATOS

$_GET['/historico/Villargordo-Cf-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0141	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 = 'Villargordo-Cf-Senior' 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.0127	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=8609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=8609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0277	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 = 73686
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8609 AND type_rel = 2
0.0130	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 = '8609' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '8609' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 73686 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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=8609 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 (73686) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73686 AND teamId = 8609
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 = 73686 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = 73686 WHERE rp.league_id = 73686 AND rp.teamId = 8609 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.0126	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 = 73686 WHERE rp.league_id = 73686 AND rp.teamId = 8609 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 = 73686 WHERE rp.league_id = 73686 AND rp.teamId = 8609 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 8609 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73686 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.0159	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 = 69263 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.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 = 64175 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 59449 AND t.round = 10 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* `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 = 51357 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.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* `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 = 44920 AND t.round = 22 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 = 39570 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* `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 = 34150 AND t.round = 34 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* `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 = 16849 AND t.round = 22 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* `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 = 4114 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 2579 AND t.round = 30 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* `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 = 2578 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 1833 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* `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 = 2951 AND t.round = 30 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* `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 = 2950 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* `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 = 2949 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* `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 = 2948 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* `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 = 2947 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* `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 = 2946 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 2945 AND t.round = 34 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

Villargordo CF

Villargordo CF

Selecciona un equipo

Competiciones que juega

2ª Andaluza Jaén Grupo 1

RIVALES EN 2ª Andaluza Jaén