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

CD Apedem A

Temporada 2021/2022

TEMPORADA 2021/2022

4ª ANDALUZA CÓRDOBA CADETE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rambla	26	94	27	66
2	Palma	26	93	47	62
3	CD Apedem A	26	111	28	61
4	Paco Pradas	25	110	43	59
5	Rute Calidad	26	112	46	59
6	Ochavillo	26	92	77	40
7	Lorenzo	26	56	58	36
8	Bosco	26	67	52	35
9	Granadal	26	41	57	31
10	Priego B	25	69	87	26
11	Villarrubia	26	66	68	22
12	Alzahar	26	40	77	14
13	Carlota	26	34	137	11
14	Lucecor D	26	11	192	4

TEMPORADA 2020/2021

1ª ANDALUZA CADETE GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Algeciras	10	22	9	24
2	Roque	8	18	10	17
3	Nuevo Molino	10	23	17	17
4	Utrera	8	12	11	13
5	Sierra Cadiz	10	17	18	13
6	Atlético	10	22	24	9
7	Caminantes	8	10	13	8
8	CD Apedem A	8	17	22	7
9	Califas	8	11	28	3

TEMPORADA 2019/2020

2ª ANDALUZA CÓRDOBA CADETE
Equipo		PJ	GF	GC	Puntos
1	CD Apedem A	22	86	18	55
2	Bosco	23	66	19	54
3	Pozoblanco	22	74	24	50
4	Atlético	22	85	27	49
5	Juanin Diego	23	63	31	47
6	A.D.	22	61	24	40
7	Futbol Base	23	54	43	37
8	Salerm	23	52	40	33
9	Carlota	22	45	51	31
10	C.D. Stadium	22	53	52	29
11	Villa	23	44	54	25
12	Figueroa CD	20	33	44	19
13	Deportivo	21	52	66	19
14	Alcazar CD	23	24	95	10
15	Baenense	23	16	169	3
16	Rambla	16	13	64	1

TEMPORADA 2018/2019

2ª ANDALUZA CÓRDOBA CADETE
Equipo		PJ	GF	GC	Puntos
1	Califas	30	115	19	75
2	Deportivo	30	104	30	72
3	A.D.	30	104	32	72
4	Juanin Diego	30	107	24	69
5	Atlético	30	109	25	64
6	Bosco	30	91	39	62
7	CD Apedem A	30	70	57	45
8	Futbol Base	30	72	56	41
9	C.D. Stadium	30	79	105	39
10	Villa	30	56	75	33
11	Carlota	30	67	81	32
12	Alcazar CD	30	41	100	28
13	Fundacion	30	37	89	23
14	Palma	30	52	152	21
15	Atlético	30	48	123	15
16	Salvador	30	15	160	7

TEMPORADA 2017/2018

2ª ANDALUZA CÓRDOBA CADETE
Equipo		PJ	GF	GC	Puntos
1	Pozoblanco	30	109	21	81
2	Juanin Diego	30	116	38	70
3	Palma	30	109	34	69
4	A.D.	30	99	31	60
5	CD Apedem A	30	92	48	57
6	Califas	30	75	45	50
7	Bosco	30	59	65	49
8	Carlota	30	53	51	48
9	Futbol Base	30	60	50	44
10	Salvador	30	48	42	37
11	Alcazar CD	30	40	45	36
12	Fundacion	30	49	74	36
13	Palomera	30	39	86	23
14	Colonia	30	35	134	18
15	Baenense	30	50	136	13
16	Montalbeño	30	23	156	0

TEMPORADA 2016/2017

2ª ANDALUZA CÓRDOBA CADETE
Equipo		PJ	GF	GC	Puntos
1	Salerm	30	147	25	80
2	Futbol Base	30	85	35	67
3	Pozoblanco	30	91	42	63
4	Salvador	30	107	33	61
5	Bosco	30	67	50	57
6	CD Apedem A	30	67	53	46
7	Carlota	30	77	69	46
8	Palma	30	59	59	46
9	Califas	30	66	56	44
10	Montalbeño	30	67	77	42
11	A.D.	30	73	92	30
12	Palomera	30	53	98	29
13	Colonia	30	51	100	24
14	Sporting	30	46	104	18
15	Villafranca	30	45	129	17
16	Atletico	30	34	113	12

TEMPORADA 2015/2016

2ª ANDALUZA CÓRDOBA CADETE
Equipo		PJ	GF	GC	Puntos
1	Córdoba	30	126	28	77
2	Deportivo	30	86	23	75
3	CD Apedem A	30	69	31	70
4	Futbol Base	30	112	55	63
5	Pozoblanco	30	80	43	62
6	Lucena	30	109	57	57
7	Califas	30	77	46	55
8	Salerm	30	68	74	36
9	Palma	30	51	65	36
10	Bosco	30	42	71	33
11	Salvador	30	45	88	31
12	Montalbeño	30	44	87	29
13	Sporting	30	52	105	23
14	Palomera	30	36	98	17
15	Atlético	30	34	86	16
16	Parque Cruz	30	42	116	12

TEMPORADA 2014/2015

1ª ANDALUZA CADETE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sevilla	28	129	11	77
2	Córdoba	30	77	23	70
3	Real Betis	30	86	26	61
4	Recreativo	30	66	45	56
5	Cádiz	29	63	35	52
6	Séneca	30	51	53	50
7	Altair	30	58	50	46
8	Bosco	29	44	37	45
9	CDAD	30	48	54	43
10	Atlético	29	39	51	32
11	CD Apedem A	30	34	75	32
12	Utrera	30	45	60	31
13	Huelva	30	31	84	30
14	Taraguilla	29	33	78	22
15	Coria CF	30	28	75	17
16	Salesianos	30	24	99	8

TEMPORADA 2013/2014

1ª ANDALUZA CADETE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Betis	30	105	13	83
2	Cádiz	30	82	31	75
3	Sevilla	29	89	19	69
4	Córdoba	30	72	37	59
5	Recreativo	30	71	33	58
6	Taraguilla	30	65	58	45
7	Altair	30	52	56	42
8	Séneca	29	48	38	39
9	Coria CF	30	42	47	37
10	Utrera	30	48	61	35
11	CD Apedem A	30	41	62	35
12	Atlético	30	34	75	31
13	Xerez Cd	29	40	61	27
14	Fernando	29	24	88	19
15	Roque Lepe	30	26	99	15
16	Deportivo	30	28	89	11

TEMPORADA 2012/2013

1ª ANDALUZA CADETE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sevilla	30	98	13	78
2	Real Betis	30	115	25	74
3	Altair	30	84	37	65
4	Xerez Cd	30	72	43	54
5	Taraguilla	30	57	40	52
6	Cádiz	30	66	43	50
7	Séneca	30	49	60	45
8	Recreativo	30	60	56	43
9	Cdad.	30	62	54	42
10	Utrera	30	44	51	36
11	Atco.	30	49	58	33
12	CD Apedem A	30	37	66	33
13	Huelva	30	29	59	31
14	Chiclana	30	45	68	30
15	Salerm	30	22	96	9
16	Olímpica	30	15	135	4

Competiciones que juega

Grupo 3

RIVALES EN 4ª Andaluza Córd.

RIVALES EN 2ª Andaluza Córd.

USO DE MEMORIA

5,856,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	1.6267
Total Execution Time	1.6286

CADENA URL

/historico/Apedem-Cadete

GET DATOS

$_GET['/historico/Apedem-Cadete']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0110	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 = 'Apedem-Cadete' 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.0120	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 = 'Apedem-Cadete' 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.0106	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=25361 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124	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 = 66040
0.0134	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 = 66117
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25361 AND type_rel = 2
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=759 AND type_rel = 3
0.0124	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 = '25361' ORDER BY l.year DESC,cat.coefficient DESC
0.0115	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 = '25361' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0109	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 = '25361' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 66117 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	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 = 66040 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109	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=25361 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (66117,66040,62004) 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.0105	SELECT count(id) as num_players from rel_players_base WHERE league_id = 62004 AND teamId = 25361
0.0105	SELECT count(id) as num_players from rel_players_base WHERE league_id = 66040 AND teamId = 25361
0.0105	SELECT count(id) as num_players from rel_players_base WHERE league_id = 66117 AND teamId = 25361
0.0106	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 66040 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107	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 = '25361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25361' and rp.type = 4
0.0106	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 = '25361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0108	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 = 25361 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0113	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_base` 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 = 66040 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.0112	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_base` 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 = 66117 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.0108	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_base` 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 = 59846 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.0108	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_base` 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 = 60453 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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_base` 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 = 62004 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.0114	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_base` 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 = 52410 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.0116	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_base` 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 = 45915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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_base` 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 = 40490 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* `tables2017_base` 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 = 34341 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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_base` 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 = 17366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 4308 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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_base` 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 = 2817 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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_base` 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 = 2660 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

CD Apedem A

CD Apedem A

Selecciona un equipo

Competiciones que juega

RIVALES EN 4ª Andaluza Córd.

RIVALES EN 2ª Andaluza Córd.