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

UD Dos Hermanas

Temporada 2023/2024

TEMPORADA 2023/2024

2ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Osuna Bote.	27	89	30	66
2	CD Pedrera	27	57	28	58
3	Tomares	27	60	43	50
4	Bellavista	28	48	38	49
5	CDF Herrera	27	49	35	43
6	Hermanas	28	46	40	42
7	Espartinas	27	43	37	42
8	Puebla	27	55	49	37
9	Olivarense	26	33	39	33
10	Sam-Cam	27	49	52	32
11	JD Bormujos	28	44	55	31
12	Colegio	26	35	44	29
13	Tinte Utrera	26	40	49	28
14	UD Loreto	27	38	60	26
15	Andalucia	27	29	89	12
16	Ecija CF	17	16	43	7

TEMPORADA 2022/2023

3ª ANDALUZA SEVILLA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hermanas	30	97	26	74
2	Tinte Utrera	30	89	34	72
3	Fuente	30	89	38	64
4	Atlético	30	62	32	60
5	Atl.	30	70	50	57
6	Montellano	30	63	39	53
7	Cuervo	30	55	43	52
8	Ibarburu CF	30	49	44	47
9	Cabecense B	30	60	55	41
10	CD Cantely	30	54	54	40
11	Cantera	30	61	72	35
12	Lebrijana	30	44	61	29
13	Trobal	30	31	84	23
14	Palacios	30	33	63	20
15	Union	30	39	83	6
16	Pinzon 09	30	15	133	0

TEMPORADA 2021/2022

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Palmar	25	77	24	65
2	Hermanas	26	102	12	63
3	Cabecense B	26	66	21	58
4	Hermanas	25	66	23	57
5	Fuente	25	79	34	53
6	Cuervo	26	39	39	35
7	Atlético	24	27	35	32
8	Peña	26	39	45	30
9	Lebrijana	26	42	45	29
10	Hermanas	24	21	72	23
11	Tabladilla	26	32	67	20
12	CD Cantely	26	36	60	19
13	Trobal	25	15	74	18
14	Pinzon 09	24	9	99	4

TEMPORADA 2020/2021

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UD Loreto	26	70	32	59
2	Atl.	25	64	21	58
3	Atlético	26	51	37	50
4	Valencina	24	39	27	49
5	Lebrijana	26	37	37	39
6	Benacazón	24	45	36	38
7	Huévar C.F.	25	43	40	38
8	Mairena	25	49	41	37
9	Gelves C.D	25	38	49	26
10	Almensilla	26	31	42	25
11	Hermanas	25	34	46	25
12	Cantarrana	19	28	38	23
13	Cuervo	25	36	66	19
14	Martin C.D.	25	28	81	7

TEMPORADA 2019/2020

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Marchena	25	51	18	59
2	JD Bormujos	25	59	36	51
3	Marismillas	25	69	46	47
4	Colegio	25	64	34	46
5	Bellavista	25	47	27	44
6	Lebrijana	25	49	41	44
7	Ciudad	25	36	30	40
8	Cantarrana	25	49	42	39
9	Hermanas	25	39	45	36
10	Atl.	25	45	55	36
11	Ciudad	24	48	52	34
12	Huévar C.F.	25	50	50	30
13	Atlético	25	43	51	26
14	Palmar	24	29	41	26
15	Benacazón	25	29	46	20
16	Martin C.D.	24	29	57	17
17	Cuervo	25	28	57	17
18	Pilas	24	37	73	8

TEMPORADA 2018/2019

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Arahal	33	82	23	79
2	Roque	34	86	32	79
3	Montequinto	33	85	30	70
4	Juan Cala	33	68	44	62
5	Atlético	34	58	53	57
6	Atl.	33	88	64	55
7	La Motilla	34	71	59	55
8	Mairena	33	63	64	51
9	Lebrijana	33	43	38	50
10	Palmar	33	62	67	46
11	C.D. Rabesa	34	70	82	46
12	Bellavista	34	49	43	45
13	José	34	55	68	38
14	Hermanas	34	54	66	30
15	Almensilla	34	64	82	30
16	Pilas	34	31	66	27
17	Cantarrana	31	38	86	26
18	Marismillas	34	34	134	10

TEMPORADA 2017/2018

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tinte Utrera	29	88	46	62
2	Montellano	29	64	22	59
3	Huévar C.F.	29	79	44	54
4	Mairena	29	74	58	50
5	Montequinto	28	61	39	49
6	Atlético	28	46	31	48
7	Santiponce	28	48	45	45
8	La Motilla	27	51	47	40
9	Pilas	27	45	47	36
10	Colegio	28	39	39	35
11	Gelves C.D	29	52	64	35
12	Lebrijana	29	49	63	35
13	Palomares	27	44	72	26
14	C.D. Rabesa	28	42	82	19
15	Hermanas	29	35	93	16
16	Palmar	10	7	32	1

TEMPORADA 2016/2017

3ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Camas	30	99	12	81
2	Utrera B	31	73	28	72
3	UD Loreto	30	78	34	67
4	Palmar	30	69	44	57
5	Cantarrana	30	63	50	52
6	Atlético	31	57	59	45
7	Mairena	29	76	61	43
8	Tinte Utrera	29	67	68	40
9	Mosquito CD	30	55	52	38
10	Hermanas	31	52	67	38
11	Lebrijana	31	38	71	36
12	Almensilla	30	47	59	35
13	Eminencia	31	43	68	26
14	Palomares	29	38	68	22
15	Racing	25	31	77	19
16	Gelves C.D	31	46	103	19
17	Cuervo	8	8	19	7

TEMPORADA 2015/2016

4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	U.B.	31	106	37	70
2	Motilla	31	92	39	69
3	Ibarburu CF	31	87	55	61
4	Cd Coronil	31	87	61	59
5	Palmar	31	65	35	58
6	Hermanas	31	98	58	57
7	Rociera	31	79	55	52
8	Tinte Utrera	32	85	89	47
9	Tabladilla	32	66	84	44
10	AD Mosqueo	31	76	63	43
11	UD Cuervo	31	74	65	41
12	Cantera	31	69	66	40
13	Palacios	31	47	69	33
14	Vistazul	31	58	108	22
15	Racing	32	44	115	19
16	Atlético	19	19	42	15
17	Estrella	31	49	160	10

TEMPORADA 2014/2015

4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Torreblanca	30	84	25	72
2	Mosquito	30	140	42	70
3	Doctor	30	82	54	62
4	AD Mosqueo	30	73	42	61
5	Palmar	30	76	32	59
6	Motilla	30	100	63	56
7	Hermanas	30	66	70	42
8	Montequinto	30	61	60	38
9	Atlético	30	72	77	37
10	Palacios	30	59	67	37
11	Eminencia	30	65	79	36
12	UD Cuervo	30	52	84	32
13	Arquero	30	50	114	29
14	Tabladilla	30	42	75	28
15	Cantera	30	57	93	23
16	Triana C.F.	30	25	127	5

TEMPORADA 2013/2014

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Santiponce	30	72	20	70
2	Eminencia	30	80	31	66
3	Gelves C.D	30	69	48	57
4	C.D.	30	63	39	51
5	Almensilla	30	54	45	51
6	Aznalcollar	30	66	41	51
7	Mairena	30	60	41	49
8	Centro	30	61	60	44
9	Pilas	30	42	50	44
10	Bellavista	30	51	44	40
11	Carrión	30	36	45	35
12	Aznalcazar,	30	48	70	30
13	Umbrete	30	40	67	29
14	Hermanas	30	39	81	20
15	Martin	30	36	72	20
16	Buhaira	30	34	97	15

TEMPORADA 2012/2013

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Antonio	30	89	33	74
2	Mairena	30	96	32	66
3	San Gines	30	69	39	66
4	Atlético	30	92	41	60
5	Padre Pío	29	71	41	55
6	Pilas	30	56	47	51
7	Atlético	30	49	56	47
8	Umbrete	29	66	59	46
9	Bellavista	30	56	52	43
10	Nueva	30	44	36	39
11	Claret C.F.	30	51	72	35
12	Buhaira	30	55	78	35
13	Mures CF	30	30	69	22
14	Olivarense	30	46	92	21
15	Espartinas	30	35	95	16
16	Hermanas	30	23	86	7

TEMPORADA 2011/2012

3ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Palacios	27	77	25	72
2	Viso UP	28	69	37	60
3	Jeronimo	27	72	37	54
4	Santiponce	27	47	37	48
5	Eminencia	27	65	52	43
6	Palomares	28	64	68	43
7	Sevilla Este	27	57	42	42
8	Círculo	27	58	54	37
9	Aznalcazar,	27	43	66	33
10	Hermanas	21	39	37	28
11	Triana Bpie	26	31	54	25
12	Pilas	27	42	65	21
13	Escritor	28	37	67	19
14	Mures CF	27	31	64	19
15	Esperanza	22	22	49	18

TEMPORADA 2010/2011

3ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	JD Bormujos	32	91	47	70
2	Montequinto	32	65	34	70
3	San Gines	32	51	28	68
4	Antonio	32	85	37	62
5	Hermanas	32	88	59	58
6	Pinzón CD	32	65	59	51
7	Tinte Utrera	32	73	48	50
8	Almensilla	32	55	60	49
9	Buhaira	32	59	60	42
10	Espartinas	32	69	90	42
11	Círculo	32	57	64	40
12	Trobal	32	50	70	40
13	Mota Cuervo	32	48	60	36
14	Bellavista	32	58	65	34
15	Mairena	32	58	81	28
16	Pilas	32	39	70	27
17	Olivarense	32	24	103	8

Competiciones que juega

Grupo 1

2ª Andaluza Sevilla Grupo 1

Pos	Equipos		Pts
1		Osuna Bote Club	66
2		CD Pedrera	58
3		UD Tomares B	50
4		UD Bellavista	49
5		CDF Herrera	43
6		UD Dos Hermanas	42
7		Espartinas CF	42
8		Puebla Cazalla CF	37
9		Olivarense	33
10		Sam-Cam Dos Hermanas	32
11		JD Bormujos	31
12		Colegio Claret	29
13		El Tinte de Utrera	28
14		UD Loreto	26
15		Andalucia Este CF	12
16		Ecija CF	7

	Ascenso : Osuna Bote Club
	Playoff Ascenso : CD Pedrera, UD Tomares B
	Descenso : El Tinte de Utrera, UD Loreto, Andalucia Este CF, Ecija CF

RIVALES EN 2ª Andaluza Sevi.

USO DE MEMORIA

6,459,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.5454
Total Execution Time	0.5466

CADENA URL

/historico/Ud-Dos-Hermanas-Senior

GET DATOS

$_GET['/historico/Ud-Dos-Hermanas-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0144	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 = 'Ud-Dos-Hermanas-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.0126	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=62691 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=62691 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62691 AND type_rel = 2
0.0134	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 = '62691' ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '62691' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154	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 = '62691' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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=62691 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (73638,69281) 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 = 73638 AND teamId = 62691
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 69281 AND teamId = 62691
0.0126	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 = '62691' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62691' and rp.type = 4
0.0126	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 = '62691' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73638 WHERE rp.league_id = 73638 AND rp.teamId = 62691 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 = 73638 WHERE rp.league_id = 73638 AND rp.teamId = 62691 AND (e.action = 4 or e.action = 5) 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 = 73638 WHERE rp.league_id = 73638 AND rp.teamId = 62691 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 62691 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* `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 = 73638 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.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 = 69281 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 = 64475 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.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* `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 = 60376 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.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* `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 = 51520 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 45328 AND t.round = 34 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* `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 = 39835 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 34585 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 35347 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 17060 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 4284 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 3017 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 3016 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 = 3001 AND t.round = 30 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* `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 = 3005 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

UD Dos Hermanas

UD Dos Hermanas

Selecciona un equipo

Competiciones que juega

2ª Andaluza Sevilla Grupo 1

RIVALES EN 2ª Andaluza Sevi.