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.

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 Gerena

Entrenador: Fran Carmona

Temporada 2020/2021

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Xerez	18	26	11	37
2	Xerez CD	18	23	11	35
3	AD Ceuta FC	18	26	17	29
4	Los Barrios	18	18	17	24
5	CD Rota	18	15	21	22
6	Atlético	18	15	20	21
7	Conil	18	19	18	20
8	Cabecense	18	15	23	19
9	Arcos CF	18	10	19	17
10	Lebrijana	18	15	25	16
11	Roque Lepe	20	30	18	45
12	Ciudad	20	35	16	40
13	Salerm	20	28	24	33
14	Córdoba	20	31	25	30
15	Utrera	20	26	26	30
16	Pozoblanco	20	22	23	27
17	Sevilla C	20	17	20	26
18	CD Gerena	20	17	25	22
19	Castilleja	20	25	27	21
20	Coria CF	20	14	28	15
21	La Palma CF	20	14	27	13

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	29	68	28	59
2	Ciudad	29	46	24	55
3	Xerez	29	44	24	55
4	Utrera	29	41	22	52
5	AD Ceuta FC	29	50	22	51
6	Sevilla C	29	34	19	51
7	Atlético	29	42	28	51
8	Salerm	29	48	35	50
9	CD Rota	29	47	49	43
10	Coria CF	29	39	36	42
11	Roque Lepe	29	39	31	40
12	Conil	29	34	37	40
13	Lebrijana	29	33	42	34
14	CD Gerena	29	31	37	33
15	Arcos CF	29	30	40	31
16	Los Barrios	29	25	35	30
17	Xerez CD	29	31	43	29
18	Pozoblanco	29	32	51	26
19	Córdoba	29	30	54	23
20	Écija	29	0	87	0

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Cádiz	42	48	18	83
2	AD Ceuta FC	42	68	42	80
3	Utrera	42	59	29	79
4	Algeciras	42	64	35	77
5	Xerez	42	49	24	77
6	Betis	42	93	40	76
7	Los Barrios	42	64	43	76
8	Córdoba	42	67	39	71
9	Ciudad	42	56	53	58
10	Xerez CD	42	45	42	57
11	Salerm	42	52	49	55
12	Lebrijana	42	47	65	52
13	Coria CF	42	53	52	51
14	CD Gerena	42	43	68	50
15	Sevilla C	42	39	49	50
16	Roque Lepe	42	52	61	49
17	Conil	42	47	55	49
18	Arcos CF	42	45	53	49
19	Écija	42	37	48	48
20	Cabecense	42	39	80	30
21	Atlético	42	45	91	29
22	Guadalcacín	42	21	97	14

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Cádiz	38	49	19	75
2	AD Ceuta FC	38	54	24	74
3	Algeciras	38	55	31	66
4	Sanluqueño	38	51	27	64
5	Lebrijana	38	50	37	59
6	Sevilla C	38	62	48	59
7	CD Gerena	38	50	39	57
8	Salerm	38	47	44	53
9	Cabecense	38	41	45	48
10	Ciudad	38	60	65	47
11	Roque Lepe	38	50	60	45
12	Atlético	38	53	65	45
13	Utrera	38	38	43	45
14	Guadalcacín	38	38	46	45
15	Arcos CF	38	43	57	44
16	Xerez CD	38	50	66	43
17	Los Barrios	38	38	44	43
18	Atlético	38	42	54	41
19	CD Alcalá	38	33	61	41
20	Castilleja	38	41	70	34

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	38	81	35	78
2	Arcos CF	38	76	39	73
3	Écija	38	69	39	71
4	Algeciras	38	66	34	69
5	Roque Lepe	38	68	52	66
6	Sevilla C	38	55	39	58
7	Atlético	38	63	56	57
8	Lebrijana	38	45	48	56
9	AD Ceuta FC	38	45	39	56
10	Utrera	38	49	50	51
11	CD Gerena	38	53	53	49
12	Los Barrios	38	31	44	47
13	Guadalcacín	38	42	57	47
14	Cabecense	38	47	64	43
15	Atlético	38	45	66	43
16	Castilleja	38	44	55	41
17	CD Alcalá	38	37	65	41
18	Atlético	38	38	59	40
19	Coria CF	38	48	66	36
20	Roque	38	37	79	21

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Córdoba	40	90	42	85
2	Sanluqueño	40	71	34	79
3	Fernando	40	69	30	75
4	CD Alcalá	40	59	33	73
5	CD Gerena	40	65	46	61
6	AD Ceuta FC	40	47	43	58
7	Arcos CF	40	44	43	58
8	Sevilla C	40	43	44	55
9	Castilleja	40	49	54	55
10	Los Barrios	40	54	56	55
11	Guadalcacín	40	42	50	54
12	Écija	40	58	54	52
13	Utrera	40	70	76	52
14	Roque	40	46	52	50
15	Lebrijana	40	45	59	49
16	Cabecense	40	49	57	49
17	Coria CF	40	38	39	48
18	San Juan	40	42	53	48
19	Conil	40	41	65	39
20	Roteña	40	43	73	36
21	Lucena	40	19	81	13

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	42	77	28	100
2	Fernando	42	88	28	91
3	CD Gerena	42	89	38	87
4	Sanluqueño	42	74	40	83
5	AD Ceuta FC	42	50	32	72
6	Lebrijana	42	60	66	60
7	Conil	42	51	60	60
8	Écija	42	49	41	58
9	Sevilla C	42	42	45	58
10	Coria CF	42	48	42	57
11	CD Alcalá	42	40	52	57
12	Roque	42	47	49	56
13	San Juan	42	48	49	52
14	Los Barrios	42	45	50	52
15	Guadalcacín	42	39	48	52
16	Cabecense	42	36	54	49
17	Arcos CF	42	46	74	48
18	Mairena	42	42	55	44
19	PD Rociera	42	40	73	40
20	Cádiz	42	45	54	38
21	La Palma CF	42	35	69	36
22	Atlético	42	34	78	33

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	38	70	37	76
2	Roque Lepe	38	60	29	75
3	CD Alcalá	38	78	43	72
4	AD Ceuta FC	38	54	33	69
5	Mairena	38	61	54	61
6	CD Gerena	38	64	40	60
7	Cabecense	38	60	45	58
8	San Juan	38	54	53	56
9	Lebrijana	38	51	49	55
10	Conil	38	41	43	55
11	Cádiz	38	49	46	52
12	Coria CF	38	48	53	51
13	Atlético	38	57	58	50
14	Roque	38	56	54	48
15	Sevilla C	38	43	58	45
16	La Palma CF	38	46	61	44
17	Arcos CF	38	36	53	42
18	Pozoblanco	38	37	68	42
19	Xerez CD	38	41	65	32
20	Ayamonte	38	16	80	0

TEMPORADA 2012/2013

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Gerena	34	89	36	74
2	PD Rociera	34	68	37	66
3	Lebrijana	34	69	33	64
4	Atl.Villanue	34	47	29	59
5	José	34	56	52	58
6	Utrera	34	64	50	57
7	Castilleja	34	53	42	48
8	Ciudad	34	55	49	47
9	La Barrera	34	53	57	46
10	Paradas	34	46	59	45
11	CD Coronil	34	51	49	44
12	Atlético	34	46	47	42
13	Palma	34	31	43	42
14	Lora CF	34	48	51	37
15	Carlota	34	48	83	37
16	Brenes	34	40	75	32
17	Nervión	34	54	83	29
18	Marinaleda	34	26	69	28

TEMPORADA 2011/2012

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cabecense	34	80	31	79
2	San Juan	34	72	28	69
3	Montilla	34	56	40	66
4	Brenes	34	59	45	61
5	CD Gerena	34	83	49	60
6	Utrera	34	57	40	55
7	Barrera	34	47	42	55
8	José	34	56	52	50
9	Carlota	34	42	46	47
10	Paradas	34	58	53	45
11	Castilleja	34	44	47	45
12	Lora CF	34	68	52	43
13	Atlético	34	44	55	43
14	Ciudad	34	48	72	43
15	Peñarroya	34	46	60	38
16	Cerro	34	37	69	28
17	Arahal	34	31	86	19
18	Hermanas	34	31	92	13

TEMPORADA 2010/2011

2ª ANDALUZA SEVILLA
Equipo		PJ	GF	GC	Puntos
1	CD Gerena	36	96	41	78
2	Cabecense	36	81	51	68
3	Lora CF	36	59	38	67
4	Lebrijana	36	71	58	58
5	La Estrella	36	68	58	53
6	Ciudad	36	64	58	51
7	Mosqueo	36	49	55	51
8	Triana CF	36	65	63	50
9	Moron	36	54	49	47
10	Bellavista	36	57	59	46
11	Puebla	36	44	54	46
12	Villaverde	36	51	66	46
13	Nervión	36	50	68	46
14	CD Pedrera	36	62	67	45
15	Camino Viejo	36	62	66	44
16	UD Tomares	36	44	54	40
17	Atlético	36	43	54	35
18	Atlético	36	52	87	34
19	Huévar C.F.	36	66	92	32

Competiciones que juega

Tercera División Grupo 10

Pos	Equipos		Pts
1		San Roque de Lepe	45
2		Ciudad de Lucena	40
3		Xerez Deportivo	37
4		Xerez CD	35
5		Salerm Puente Genil	33
6		Córdoba CF B	30
7		Utrera	30
8		AD Ceuta FC	29
9		CD Pozoblanco	27
10		Sevilla C	26
11		Los Barrios	24
12		CD Rota	22
13		CD Gerena	22
14		Castilleja	21
15		Atlético Antoniano	21
16		Conil	20
17		Cabecense	19
18		Arcos CF	17
19		Lebrijana	16
20		Coria CF	15
21		La Palma CF	13

	Playoff Ascenso : San Roque de Lepe, Ciudad de Lucena, Xerez Deportivo
	Siguiente Ronda : Xerez CD, Salerm Puente Genil, Córdoba CF B
	Playoff Descenso : Utrera, AD Ceuta FC, CD Pozoblanco, Sevilla C, Los Barrios

RIVALES EN Tercera División

RIVALES EN Tercera División.

USO DE MEMORIA

6,863,688 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1408
Total Execution Time	0.1420

CADENA URL

/historico/Cd-Gerena/2021

GET DATOS

$_GET['/historico/Cd-Gerena/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0028	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 = 'Cd-Gerena' AND l.year = 2021 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.0027	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=6119 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=6119 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6119 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=6119 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 58589
0.0024	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 = 61813
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6119 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6119 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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 (2688,6955,23391,25223,25444) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '6119' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '6119' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '6119' 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 = 58589 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 61813 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=6119 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (67509,62807,62394,61813,58589) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 62394 AND teamId = 6119
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 58589 AND teamId = 6119
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 67509 AND teamId = 6119
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 61813 AND teamId = 6119
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 6119
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 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 = 58589 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '6119' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6119' and rp.type = 4
0.0021	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 = '6119' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 events2021 e ON e.player_id = p.id AND e.league_id = 58589 WHERE rp.league_id = 58589 AND rp.teamId = 6119 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.0031	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 events2021 e ON e.player_id = p.id AND e.league_id = 58589 WHERE rp.league_id = 58589 AND rp.teamId = 6119 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events2021 e ON e.player_id = p.id AND e.league_id = 58589 WHERE rp.league_id = 58589 AND rp.teamId = 6119 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 6119 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 58589 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 = 50278 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44398 AND t.round = 42 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* `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 = 39034 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* `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 = 33360 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 3919 AND t.round = 42 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* `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 = 2559 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* `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 = 1974 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* `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 = 1470 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 = 2943 AND t.round = 38 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 = 58589 ORDER BY nameShow LIMIT 100

CD Gerena

CD Gerena

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 10

RIVALES EN Tercera División

RIVALES EN Tercera División.