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

Utrera B

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN HONOR SENIOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlético	30	40	26	56
2	UD Tomares	30	48	27	55
3	Club Atl. C.	30	42	22	55
4	Chiclana CF	30	41	25	51
5	Montilla	30	46	31	47
6	Castilleja	30	37	31	47
7	Lebrijana	30	47	32	45
8	Los Barrios	30	44	33	44
9	Fernando	30	30	30	43
10	Almodóvar	30	49	54	42
11	UD Algaida	30	29	35	38
12	Viso UP	30	37	40	35
13	CD Rota	30	29	40	32
14	Pinzón CD	30	34	58	30
15	Utrera B	30	31	59	25
16	Villafranco	30	26	67	12

TEMPORADA 2022/2023

PRIMERA ANDALUZA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Utrera B	34	64	24	77
2	José	34	62	24	68
3	Ventippo	34	60	37	64
4	Mairena	33	49	30	63
5	CD Alcalá	33	53	30	60
6	Estrella	34	60	46	57
7	CD Demo	33	46	45	55
8	Torreblanca	34	59	46	54
9	PD Rociera	34	55	32	53
10	UD Morón	33	55	40	52
11	Puebla CF	34	51	46	42
12	Montequinto	34	44	58	42
13	Rinconada	33	37	42	41
14	Mosqueo	34	39	51	37
15	Atlético	34	41	64	37
16	Pilas	33	53	77	33
17	Camas	34	30	111	9
18	Pablo Pino.	28	19	74	8

TEMPORADA 2021/2022

PRIMERA ANDALUZA GRUPO 19
Equipo		PJ	GF	GC	Puntos
1	Villafranco	28	47	27	55
2	Ventippo	28	51	23	55
3	Rinconada	28	49	27	53
4	UD Morón	28	54	27	53
5	Mairena	28	43	17	52
6	José	28	42	28	47
7	Utrera B	28	35	47	39
8	Mosqueo	28	34	37	37
9	Pablo Pino.	28	29	54	31

TEMPORADA 2020/2021

2ª ANDALUZA SEVILLA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Pablo Pino.	28	52	32	50
2	Utrera B	26	51	32	49
3	Diablos	28	48	32	48
4	Andalucia	28	52	41	48
5	Tinte Utrera	26	44	36	41
6	Montequinto	28	39	40	40
7	Nervión	27	44	36	39
8	Montellano	26	16	25	31
9	Puebla	26	44	46	29
10	Arahal	25	30	39	27

TEMPORADA 2019/2020

2ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Club Atl. C.	25	59	31	58
2	CD Demo	25	64	28	57
3	Nervión	25	53	27	52
4	CDF Herrera	25	49	26	45
5	Montequinto	25	34	32	41
6	Utrera B	25	45	34	40
7	Montellano	25	30	33	39
8	Badolatosa	25	40	34	38
9	Pablo Pino.	25	39	28	37
10	Roque	25	43	43	36
11	Diablos	25	37	36	33
12	Arahal	25	37	39	33
13	Tinte Utrera	25	41	62	29
14	Marcos	25	34	49	23
15	Ecija CF	25	21	44	20
16	El Rubio	25	22	45	19
17	Andalucia	25	23	49	17
18	Triana CF	25	25	56	17

TEMPORADA 2018/2019

2ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ventippo	34	72	31	79
2	Hermanas	34	68	30	72
3	CDF Herrera	34	77	50	65
4	Utrera B	34	59	43	61
5	Nervión	34	62	40	50
6	Badolatosa	34	73	65	50
7	Ecija CF	34	54	47	50
8	El Rubio	34	55	55	48
9	Andalucia	34	60	59	45
10	Pablo Pino.	34	57	56	45
11	Tinte Utrera	34	56	67	45
12	Montellano	34	49	46	44
13	Diablos	34	41	41	44
14	Triana CF	34	38	49	41
15	Ciudad	34	42	62	41
16	Marchena	34	46	81	29
17	Calavera	34	39	67	27
18	UD Morón B	34	37	96	25

TEMPORADA 2017/2018

2ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Paradas	34	73	35	72
2	Osuna Bote.	34	59	34	68
3	Camas	34	82	47	66
4	Ecija CF	34	64	52	61
5	La Barrera	34	43	35	54
6	El Rubio	34	47	40	52
7	Utrera B	34	66	53	49
8	Nervión	34	51	51	48
9	Marchena	34	44	53	48
10	Ciudad	34	56	60	43
11	CDF Herrera	34	44	57	41
12	Triana CF	34	49	66	41
13	Campana	34	50	56	40
14	Arahal	34	42	48	39
15	Espartinas	34	53	61	39
16	La Roda	34	48	58	39
17	La Jara	34	45	81	32
18	Puebla	34	43	72	26

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 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UD Morón	25	99	20	64
2	Ecija CF	26	67	21	59
3	La Roda	26	59	33	54
4	Tinte Utrera	26	62	53	46
5	Puebla	26	61	43	44
6	C.D. Fuentes	25	55	47	42
7	Estepa	26	53	37	42
8	Utrera B	26	59	43	39
9	Racing	24	40	58	29
10	Marcos	26	42	63	29
11	U.D.	26	33	79	28
12	Lantejuela	26	34	59	21
13	Aguadulce	26	21	72	8
14	Pruna CD	26	22	79	8

TEMPORADA 2014/2015

4ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	El Rubio	28	68	28	61
2	C.D.	28	55	25	57
3	UD Morón	28	67	32	56
4	Puebla	28	65	32	55
5	Tinte Utrera	28	55	36	53
6	Estepa	28	63	30	52
7	Utrera B	28	44	38	47
8	La Roda	28	55	33	44
9	C.D. Fuentes	28	52	45	42
10	Aguadulce	28	29	31	35
11	Lantejuela	28	32	55	27
12	Luisiana	28	32	60	24
13	Cantarrana	28	32	79	22
14	Barrera C.F.	28	31	76	10
15	Marcos	28	21	101	8

TEMPORADA 2011/2012

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Corrales	26	61	26	60
2	Atlético	26	54	29	54
3	El Rubio	26	55	34	48
4	Gilena C.F.	26	59	31	45
5	Lantejuela	26	40	36	43
6	Utrera B	26	72	52	42
7	La Jara	26	45	35	37
8	UD Morón	26	49	45	36
9	Poli	26	29	30	29
10	Atletico	26	33	52	29
11	Mairena	26	41	50	28
12	Tinte Utrera	26	37	59	26
13	Villanueva	26	39	65	25
14	U.D.	26	30	100	6

Competiciones que juega

Grupo 1

División Honor Senior Grupo 1

Pos	Equipos		Pts
1		Atlético Onubense	56
2		UD Tomares	55
3		Club Atl. Central	55
4		Chiclana CF	51
5		Montilla	47
6		Castilleja	47
7		Lebrijana	45
8		Los Barrios	44
9		San Fernando CD B	43
10		Almodóvar del Río	42
11		UD Algaida	38
12		Viso UP	35
13		CD Rota	32
14		Pinzón CD	30
15		Utrera B	25
16		Villafranco	12

	Ascenso : Atlético Onubense, UD Tomares, Club Atl. Central
	Descenso : CD Rota, Pinzón CD, Utrera B, Villafranco

RIVALES EN División Honor S.

USO DE MEMORIA

6,148,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.6284
Total Execution Time	0.6296

CADENA URL

/historico/Cd-Utrera-B

GET DATOS

$_GET['/historico/Cd-Utrera-B']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0154	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-Utrera-B' 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.0146	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=19236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=19236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0298	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 = 73495
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19236 AND type_rel = 2
0.0165	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 = '19236' ORDER BY l.year DESC,cat.coefficient DESC
0.0162	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 = '19236' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0162	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 = '19236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0169	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=19236 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (73495,71789) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 71789 AND teamId = 19236
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 73495 AND teamId = 19236
0.0148	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 = '19236' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19236' and rp.type = 4
0.0147	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 = '19236' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0207	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 = 73495 WHERE rp.league_id = 73495 AND rp.teamId = 19236 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.0212	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 = 73495 WHERE rp.league_id = 73495 AND rp.teamId = 19236 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0198	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 = 73495 WHERE rp.league_id = 73495 AND rp.teamId = 19236 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168	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 = 19236 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0168	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 = 68705 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.0160	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 = 64031 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.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* `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 = 67387 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.0160	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 = 59510 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.0162	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 = 61885 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.0164	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 = 51360 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.0164	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 = 44924 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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 = 39684 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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.0166	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 = 16911 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 4125 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 3010 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Utrera B

Utrera B

Selecciona un equipo

Competiciones que juega

División Honor Senior Grupo 1

RIVALES EN División Honor S.