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

Resultados de Fútbol

La Unión CF

Temporada 2023/2024

TEMPORADA 2023/2024

1ª REGIONAL BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unión	24	60	28	52
2	S´Horta	23	48	27	45
3	Atlètic	23	60	53	40
4	Porto Cristo	24	53	35	39
5	Arta	24	34	25	36
6	Pollença	24	47	39	36
7	Baleares	24	44	37	35
8	Ce Campanet	24	37	46	34
9	Binissalem	23	28	29	33
10	CD Génova	24	36	39	29
11	CE Escolar	23	26	39	28
12	S'arraco	24	25	51	26
13	Vilafranca	23	32	35	24
14	Col. Pedro	24	33	46	24
15	Athlàtic	23	33	52	20
16	Sporting	24	39	54	16

TEMPORADA 2022/2023

1ª REGIONAL BALEARES GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Santa	30	73	20	77
2	Andratx B	30	78	28	67
3	Athetic Club	30	59	40	54
4	CE Escolar	30	63	43	53
5	Consell	30	54	34	52
6	Unión	30	57	41	52
7	Unió	30	50	39	43
8	Athlàtic	30	50	46	42
9	Baleares	30	49	41	40
10	Margaritense	30	52	56	37
11	Port Soller	30	35	46	36
12	Picafort	30	41	58	36
13	Pilares	30	43	64	31
14	Binissalem	30	36	73	28
15	San Roque	30	37	65	18
16	Taujá	30	18	101	3

TEMPORADA 2021/2022

1ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Algaida	38	89	33	80
2	UD Arenal	38	63	24	76
3	S´Horta	37	80	41	72
4	Portol	38	75	35	69
5	Atletico	37	55	34	65
6	Indep. Camp	38	86	52	62
7	Espanya	38	54	39	62
8	Cala Millor	38	72	56	61
9	Pollença	38	64	70	58
10	Unión	38	56	48	54
11	Platges	38	65	70	51
12	Athlàtic	38	60	68	50
13	Montaura	38	54	69	49
14	Santa María	38	39	57	45
15	Ce Campanet	38	55	74	45
16	CE Escolar	38	42	68	40
17	A-Llubi	38	44	74	37
18	Constancia	38	48	89	33
19	Picafort	38	36	77	28
20	Porto Cristo	38	39	98	24

TEMPORADA 2020/2021

PREFERENTE BALEARES GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rotlet	18	25	9	38
2	Murense	18	25	11	37
3	Sineu	18	36	21	29
4	Serverense	18	30	23	29
5	UD Alaró	18	23	29	22
6	Alqueria	18	20	28	22
7	CE Xilvar	18	26	26	21
8	Cala Millor	18	18	33	20
9	Atletico	18	19	25	18
10	Unión	18	18	35	13

TEMPORADA 2019/2020

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cardassar	28	56	17	64
2	Campos	28	48	27	50
3	CD Génova	28	65	47	45
4	Serverense	28	47	37	42
5	Rotlet	28	39	33	41
6	Sant Jordi	28	42	40	41
7	UD Alaró	28	36	37	41
8	Porreres	28	41	32	40
9	Atletico	28	43	39	40
10	Inter	28	36	40	40
11	Sineu	28	47	46	39
12	Son Veri	28	40	41	39
13	Murense	28	42	35	37
14	Cladera	28	37	35	34
15	Cala Millor	28	47	55	33
16	Santa María	28	34	48	33
17	CE Xilvar	28	37	59	32
18	UE Petra	28	34	49	27
19	Unión	28	29	47	24
20	A-Llubi	28	24	60	19

TEMPORADA 2018/2019

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Andratx	38	89	30	86
2	Collerense	38	74	34	77
3	Rotlet	38	67	37	74
4	Campos	38	57	41	58
5	Sineu	38	63	63	58
6	Atletico	38	70	61	57
7	Son Veri	38	61	57	57
8	UD Alaró	38	57	54	57
9	Cala Millor	38	63	61	55
10	Inter	38	45	47	50
11	UE Petra	38	51	53	49
12	A-Llubi	38	58	67	48
13	CD Génova	38	68	83	48
14	CE Xilvar	38	52	59	45
15	Unión	38	57	71	44
16	Recreativo	38	59	68	43
17	Sant Jordi	38	52	68	42
18	Serverense	38	62	71	41
19	Port Soller	38	35	71	32
20	Son Sardina	38	48	92	29

TEMPORADA 2017/2018

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Soller	38	86	32	79
2	Murense	38	66	43	72
3	Sant Jordi	38	63	44	68
4	Andratx	38	79	54	64
5	Rotlet	38	68	45	62
6	Unión	38	64	49	61
7	Port Soller	38	51	50	60
8	Recreativo	38	58	48	59
9	Atletico	38	47	35	59
10	Inter	38	55	53	52
11	Sineu	38	55	49	52
12	CE Xilvar	38	52	55	52
13	CD Génova	38	66	64	51
14	UD Alaró	38	46	48	50
15	A-Llubi	38	44	51	47
16	Son Veri	38	62	65	47
17	Campos	38	32	39	47
18	Indep. Camp	38	37	85	23
19	Cardassar	38	38	98	23
20	Llosetense	38	42	104	21

TEMPORADA 2016/2017

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manacor	38	70	27	77
2	UE Petra	38	60	40	67
3	Unión	38	59	40	66
4	Santanyi	38	48	37	64
5	CE Xilvar	38	58	44	62
6	Serverense	38	62	47	59
7	Sineu	38	56	49	56
8	A-Llubi	38	47	43	54
9	Recreativo	38	48	52	52
10	Atletico	38	45	39	52
11	Murense	38	51	64	51
12	Cardassar	38	45	51	48
13	Port Soller	38	47	47	46
14	CD Génova	38	65	78	44
15	UD Alaró	38	40	58	43
16	Andratx	38	48	47	43
17	Soller	38	44	63	43
18	Indep. Camp	38	45	80	42
19	Platges	38	39	55	40
20	Ce Campanet	38	48	64	39

TEMPORADA 2015/2016

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Felanitx	38	69	41	74
2	Serverense	38	68	45	70
3	Cladera	38	64	41	67
4	Santanyi	37	58	34	67
5	Sineu	38	51	38	65
6	Andratx	37	64	38	63
7	CD Génova	38	68	64	58
8	Cardassar	38	53	51	57
9	Murense	38	59	61	55
10	Manacor	38	71	58	55
11	Unión	38	52	39	52
12	UE Petra	38	56	77	51
13	Ce Campanet	37	46	53	47
14	Recreativo	38	61	70	43
15	Atletico	38	45	62	40
16	A-Llubi	37	40	59	38
17	UD Arenal	38	28	50	37
18	Port Soller	37	49	72	36
19	Santa	32	37	52	32
20	Espanya	37	46	80	28

TEMPORADA 2014/2015

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Santa	38	81	39	83
2	Rotlet	38	85	40	82
3	Cardassar	38	78	36	76
4	Esporles	38	60	33	73
5	Santanyi	38	68	46	63
6	Andratx	38	61	43	63
7	Ce Campanet	38	57	49	63
8	Santa	38	60	50	62
9	Recreativo	38	65	63	56
10	CD Génova	38	61	53	55
11	UE Petra	38	52	49	52
12	Serverense	38	59	71	44
13	Murense	38	49	69	42
14	CD España	38	47	70	40
15	Felanitx	38	54	73	37
16	Port Soller	38	41	73	37
17	S´Horta	38	48	66	36
18	Unión	38	50	79	36
19	Indep. Camp	38	42	76	33
20	CE Escolar	38	48	88	30

TEMPORADA 2013/2014

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Soller	38	92	39	85
2	Santa	38	81	31	82
3	UD Alaró	38	50	30	67
4	Cardassar	38	64	53	64
5	Indep. Camp	38	77	47	62
6	Cladera	38	67	61	60
7	Esporles	38	44	36	59
8	Andratx	38	62	44	59
9	Ce Campanet	38	65	55	58
10	Serverense	38	74	64	53
11	CD Génova	38	59	58	52
12	CD España	38	56	62	51
13	S´Horta	38	71	81	51
14	Port Soller	38	48	67	47
15	CE Escolar	38	57	64	46
16	Unión	38	57	75	44
17	Murense	38	38	66	35
18	UD Arenal	38	44	74	31
19	Binissalem	38	40	86	28
20	Son Ferrer	38	37	90	27

TEMPORADA 2012/2013

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rotlet	38	74	45	71
2	Platges	38	65	30	68
3	Atletico	38	71	55	68
4	Santa	38	63	46	61
5	Independient	38	59	57	60
6	Cd Génova	38	60	46	58
7	Serverense	38	67	58	55
8	Unión	38	63	53	53
9	Cd S´horta	38	53	68	52
10	UD Alaró	38	54	63	51
11	Ce Campanet	38	57	62	50
12	UD Arenal	38	57	58	49
13	CE Escolar	38	49	49	48
14	Cd Murense	38	58	72	48
15	Cardassar	38	52	66	48
16	Ce Esporles	38	67	66	47
17	Tesa	38	65	79	44
18	CE Xilvar	38	43	61	43
19	Sporting	38	57	78	38
20	Pollença	38	42	64	35

TEMPORADA 2011/2012

PREFERENTE BALEARES
Equipo		PJ	GF	GC	Puntos
1	Soller	38	99	46	86
2	Andratx	37	98	38	79
3	CD Génova	38	81	59	68
4	S´Horta	38	68	47	67
5	Serverense	37	71	54	66
6	Xilvar	38	69	50	63
7	Cd Escolar	38	73	52	61
8	Cardassar	38	65	56	59
9	Murense	38	54	61	57
10	Unión	37	54	47	55
11	Ce Campanet	38	77	79	54
12	Independient	37	66	65	51
13	Santa	38	52	54	50
14	Sporting	38	53	56	46
15	Alaró	38	55	66	45
16	Esporles	37	54	82	38
17	Tesa	37	60	86	34
18	UD Arenal	38	36	70	33
19	Pollença	38	46	106	27
20	Arta	38	35	92	22

TEMPORADA 2010/2011

PREFERENTE BALEARES
Equipo		PJ	GF	GC	Puntos
1	Son Ferrer	38	66	36	76
2	CD España	38	94	49	73
3	Andratx	38	73	44	71
4	Platges	38	67	42	65
5	Unión	38	55	39	64
6	S´Horta	38	66	52	60
7	Murense	38	59	55	59
8	Independient	38	66	64	58
9	Sporting	38	54	52	57
10	Cardassar	38	54	61	55
11	Alaró	38	51	56	52
12	Esporles	38	62	53	51
13	Serverense	38	79	86	49
14	Cd Escolar	38	61	68	48
15	CD Génova	38	64	72	48
16	Soller	38	56	71	45
17	Pollensa	38	45	68	41
18	Arta	38	52	67	39
19	S´arraco	38	40	82	29
20	Calvià	38	42	89	21

TEMPORADA 2008/2009

PREFERENTE BALEARES
Equipo		PJ	GF	GC	Puntos
1	Esporles	38	81	39	75
2	Llosetense	38	69	35	74
3	Collerense	38	73	49	68
4	Indep. Camp	38	70	48	66
5	S´Horta	38	61	48	63
6	Margaritense	38	61	42	62
7	Soller	38	73	58	62
8	Penya	38	56	34	61
9	Platges	38	68	47	58
10	Murense	38	56	60	52
11	Serverense	38	47	46	51
12	Génova	38	63	74	47
13	Calvià	38	56	75	45
14	Xilvar	38	51	74	44
15	Cardassar	38	56	69	43
16	Felanitx	38	40	67	43
17	Tesa	38	63	90	40
18	Poblense B	38	59	72	38
19	Unión	38	50	76	34
20	Atl. Rafal	38	41	91	22

Competiciones que juega

Grupo 1

1ª Regional Baleares Grupo 1

Pos	Equipos		Pts
1		La Unión CF	52
2		S´Horta	45
3		Atlètic Sencelles	40
4		Porto Cristo	39
5		Arta	36
6		CF Pollença	36
7		Baleares Sin Fronteras	35
8		Ce Campanet	34
9		CD Binissalem B	33
10		CD Génova	29
11		CE Escolar	28
12		S'arraco	26
13		Vilafranca	24
14		Col. San Pedro	24
15		Athlàtic Huialfàs	20
16		Sporting Sant Marçal	16

	Ascenso : La Unión CF, S´Horta, Atlètic Sencelles

RIVALES EN 1ª Regional Bale.

USO DE MEMORIA

7,071,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.6807
Total Execution Time	0.6822

CADENA URL

/historico/La-Union-Cf-Baleares

GET DATOS

$_GET['/historico/La-Union-Cf-Baleares']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0153	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 = 'La-Union-Cf-Baleares' 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=85061 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=85061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0297	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 = 73782
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85061 AND type_rel = 2
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 686 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	SELECT /53 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 (1104898,627067,564570) ORDER BY n.cover_points DESC, update_date DESC
0.0148	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 = '85061' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161	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 = '85061' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 73782 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=85061 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (73782) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 73782 AND teamId = 85061
0.0149	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 = 73782 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157	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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 85061 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.0156	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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 85061 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 85061 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 85061 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73782 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.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* `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 = 69164 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.0153	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 = 63635 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 58942 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.0151	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 = 51180 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.0151	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 = 44632 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 39183 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 33976 AND t.round = 38 ORDER BY team.conference 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* `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 = 16706 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 4075 AND t.round = 38 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* `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 = 2683 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1993 AND t.round = 38 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* `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 = 1471 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1130 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 293 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 73782 ORDER BY nameShow LIMIT 100


	¿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

La Unión CF

La Unión CF

Selecciona un equipo

Competiciones que juega

1ª Regional Baleares Grupo 1

RIVALES EN 1ª Regional Bale.