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

UC La Estrella

Temporada 2023/2024

TEMPORADA 2023/2024

1ª REGIONAL EXTREMADURA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Extremadura	22	52	13	50
2	Estrella	22	35	14	43
3	Sport Club.	22	37	27	35
4	Santa Marta	22	31	28	33
5	Gran Maestre	22	29	32	30
6	CP Oliva	22	36	38	29
7	Aceuchal	22	18	26	26
8	EMD Solana	22	25	25	26
9	Usagre	22	27	41	25
10	CD Zafra	22	18	25	23
11	Ribereña	22	18	39	20
12	Segureña A	22	30	48	18

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Llerenense	30	52	22	64
2	CD Azuaga	30	58	29	62
3	Moralo	30	52	24	55
4	Olivenza	30	46	33	53
5	Jerez	30	39	25	49
6	Arroyo	30	30	31	46
7	Trujillo	30	28	28	44
8	Villafranca	30	34	33	43
9	Calamonte	30	38	33	42
10	Fuente	30	23	28	39
11	Pueblonuevo	30	36	41	32
12	Montehermoso	30	31	53	31
13	Álvaro	30	27	54	27
14	Miajadas	30	23	41	26
15	Plasencia	30	31	43	24
16	Estrella	30	30	60	21

TEMPORADA 2021/2022

1ª REGIONAL EXTREMADURA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Fuente	22	39	15	48
2	Estrella	22	42	22	48
3	CD Zafra	22	32	19	41
4	Gran Maestre	22	37	15	39
5	Serván	22	40	29	38
6	Usagre	22	36	29	35
7	CP Oliva	22	22	16	34
8	EMD Solana	22	33	43	22
9	Santa Marta	22	32	48	20
10	Sport Club.	22	27	49	16
11	Monesterio	22	29	46	15
12	Atlético	22	27	65	7

TEMPORADA 2020/2021

1ª REGIONAL EXTREMADURA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	CD Gévora	4	9	7	8
2	Hernán	4	8	4	7
3	CF Jaraíz	4	8	5	7
4	Estrella	4	6	11	4
5	Valdelacalza	4	8	12	1

TEMPORADA 2019/2020

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	25	74	17	61
2	Villafranca	25	67	20	59
3	Campanario	25	59	26	57
4	CD Zafra	25	56	26	51
5	Gimnástico	25	62	40	48
6	Santa Amalia	25	81	29	43
7	Ilipense-Zal	25	35	39	35
8	Castuera	25	38	37	32
9	Usagre	25	30	44	32
10	Olympic	25	44	52	29
11	Hernán	25	33	42	27
12	Gran Maestre	25	35	61	25
13	Ribereña	25	39	65	23
14	Frexnense	25	26	69	20
15	CD Berlanga	25	29	83	15
16	Nueva Ciudad	25	30	88	12

TEMPORADA 2018/2019

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Fuente	30	69	32	70
2	Campanario	30	63	30	64
3	CD Zafra	30	63	28	63
4	Estrella	30	66	38	61
5	Villafranca	30	64	31	60
6	Guareña	30	46	50	46
7	Álvaro	30	67	55	44
8	CD Berlanga	30	54	59	36
9	Gran Maestre	30	51	45	35
10	Gimnástico	30	43	58	35
11	Ilipense-Zal	30	38	59	34
12	Atlético	30	50	73	32
13	Frexnense	30	23	46	28
14	Fornacense	30	35	63	28
15	Ribereña	30	34	69	25
16	Emérita	30	28	58	22

TEMPORADA 2017/2018

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Llerenense	30	75	27	64
2	Villafranca	30	71	29	58
3	Frexnense	30	52	33	57
4	Estrella	30	63	38	56
5	Fuente	30	66	37	55
6	Serván	30	53	38	51
7	Campanario	30	46	33	49
8	CD Berlanga	30	63	52	42
9	Ribereña	30	44	48	42
10	Guareña	30	46	55	40
11	Santa Marta	30	49	62	38
12	Atlético	30	42	55	35
13	Ilipense-Zal	30	48	70	34
14	Monesterio	30	44	84	24
15	Usagre	30	37	73	22
16	CD Quintana	30	23	88	10

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Cacereño	38	81	16	92
2	CD Badajoz	38	90	17	85
3	Jerez	38	57	26	79
4	CD Azuaga	38	83	42	74
5	CD Coria	38	62	29	72
6	Benito	38	62	26	68
7	Calamonte	38	70	39	62
8	Plasencia	38	59	56	59
9	Moralo	38	57	58	52
10	Olivenza	38	44	54	47
11	UD Montijo	38	41	59	43
12	Amanecer	38	52	58	43
13	Extremadura	38	49	55	40
14	CP Valdivia	38	34	63	39
15	Arroyo	38	31	64	37
16	Santa Amalia	38	34	82	36
17	Pueblonuevo	38	34	64	35
18	Fuente	38	42	69	34
19	Diter Zafra	38	34	95	24
20	Estrella	38	34	78	22

TEMPORADA 2015/2016

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	30	66	37	60
2	Castuera	30	64	29	59
3	Ilipense-Zal	30	59	43	56
4	CD Quintana	30	50	27	56
5	Ribereña	30	55	40	54
6	Olympic	30	52	43	46
7	Hernán	30	43	28	46
8	CD Berlanga	30	57	50	46
9	Campanario	30	39	38	42
10	Llerenense	30	47	36	42
11	Villafranca	30	44	47	36
12	Fornacense	30	41	57	33
13	Talarrubias	30	42	49	32
14	Usagre	30	36	55	30
15	CP Rena	30	45	100	21
16	Sp Herrera	30	13	74	13

TEMPORADA 2014/2015

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	30	76	27	66
2	Villafranca	30	56	28	60
3	Fornacense	30	59	38	58
4	Olympic	30	59	39	55
5	Ilipense-Zal	30	53	33	53
6	Llerenense	30	62	42	48
7	Monesterio	30	44	42	41
8	CP Rena	30	54	53	41
9	Belenense	30	38	40	40
10	Ribereña	30	54	53	37
11	Campanario	30	32	42	36
12	Talarrubias	30	40	53	34
13	Guareña	30	30	56	28
14	Sp Herrera	30	45	67	27
15	Metelinense	30	26	56	26
16	Gimnástico	30	24	83	16

TEMPORADA 2013/2014

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CP Valdivia	30	65	22	75
2	Estrella	30	68	32	65
3	Llerenense	30	61	38	60
4	Aceuchal	30	62	30	60
5	Fornacense	30	75	51	51
6	Villafranca	30	65	37	50
7	Sp Herrera	30	62	44	45
8	Campanario	30	49	45	39
9	Monesterio	30	37	45	37
10	Olympic	30	47	54	36
11	CP Rena	30	53	79	33
12	Talarrubias	30	49	66	31
13	Gimnástico	30	34	59	28
14	CD Berlanga	30	42	76	24
15	Guareña	30	29	66	20
16	Orellana	30	22	76	12

TEMPORADA 2012/2013

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aceuchal	28	63	30	60
2	Llanos	30	72	31	58
3	Cd Azuaga	27	64	42	57
4	Estrella	30	60	53	55
5	CP Oliva	29	56	31	54
6	Villafranca	28	58	41	49
7	Llerenense	28	62	48	49
8	CP Cheles	28	37	37	37
9	CD Berlanga	30	55	63	37
10	Campillo Cf	29	42	59	33
11	Calzadilla	29	29	44	31
12	Ribereña	29	48	57	29
13	Burguillos	29	32	52	28
14	Monesterio	28	35	56	27
15	Frexnense	30	32	61	23
16	Francisco	28	37	77	17

TEMPORADA 2011/2012

PREFERENTE EXTREMADURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cd Guadiana	1	3	0	3
2	Burguillos	1	3	1	3
3	Puebla	1	3	1	3
4	Valverdeño	1	3	1	3
5	Aceuchal	1	2	0	3
6	Ud Montijo	1	2	0	3
7	Calamonte	1	2	1	3
8	Santa Marta	1	1	0	3
9	CP Cheles	1	1	2	0
10	Albuera	1	0	1	0
11	Gran Maestre	1	1	3	0
12	CP Oliva	1	1	3	0
13	Francisco	1	1	3	0
14	EMD Solana	1	0	2	0
15	UD Talavera	1	0	2	0
16	Estrella	1	0	3	0

TEMPORADA 2010/2011

PREFERENTE EXTREMADURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pueblonuevo	38	74	26	86
2	Villafranca	38	77	39	79
3	Puebla	38	58	29	71
4	CP Oliva	38	63	37	69
5	Fuente	38	68	52	67
6	Montijo	38	53	47	59
7	Racing	38	73	60	57
8	Calamonte	38	47	50	53
9	Estrella	38	51	51	51
10	Emérita	38	55	57	50
11	Nueva Ciudad	38	52	58	49
12	Monesterio	38	55	54	47
13	Burguillos	38	58	69	47
14	CD Azuaga	38	67	63	46
15	UD Talavera	38	39	52	46
16	Albuera-Faes	38	47	59	44
17	Guadiana	38	48	65	41
18	Gran Maestre	38	53	76	36
19	Francisco	38	43	82	28
20	Jorge	38	41	96	24

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	CD Badajoz	38	109	19	101
2	Jerez	38	76	14	89
3	Extremadura	38	77	26	79
4	Arroyo	38	72	43	74
5	Mérida UD	38	55	28	72
6	Villanueva	38	71	50	67
7	Ciudad	38	54	49	57
8	Benito	38	48	50	53
9	Sanvicenteñ	38	47	48	51
10	Imperio	38	59	56	47
11	Olivenza	38	33	45	47
12	Miajadas	38	28	42	44
13	Deportivo	38	54	68	43
14	Moralo	38	40	52	43
15	Valdelacalza	38	35	54	40
16	CD Coria	38	50	76	34
17	Santa Marta	38	43	69	31
18	Montehermoso	38	31	79	30
19	Estrella	38	27	84	27
20	Villafranca	38	30	87	23

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Cerro Reyes	38	88	27	92
2	Cacereño	38	90	26	91
3	Villanovense	38	64	26	74
4	Benito	38	47	29	65
5	CD Badajoz	38	54	38	59
6	Jerez	38	42	35	54
7	Moralo	38	44	48	51
8	Valdelacalza	38	38	52	50
9	Olivenza	38	42	45	49
10	Imperio	38	41	48	48
11	Estrella	38	46	46	47
12	Villanueva	38	37	55	46
13	Deportivo	38	41	49	45
14	Sanvicenteñ	38	39	68	43
15	Miajadas	38	38	53	42
16	Santa Marta	38	43	63	42
17	Ciudad	38	34	53	41
18	Diter Zafra	38	40	57	39
19	Plasencia	38	50	66	35
20	CP Valdivia	38	30	64	28

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	38	70	18	82
2	Cerro Reyes	38	78	33	78
3	Villanovense	38	73	35	74
4	Jerez	38	58	38	70
5	Plasencia	38	58	33	68
6	Diter Zafra	38	51	27	63
7	Villanueva	38	44	34	59
8	CD Badajoz	38	54	39	58
9	Cacereño	38	48	45	55
10	Moralo	38	41	55	48
11	Imperio	38	54	46	47
12	Estrella	38	36	47	43
13	Olivenza	38	32	64	42
14	CP Valdivia	38	45	59	42
15	Miajadas	38	31	46	39
16	Valdelacalza	38	42	64	39
17	Sanvicenteñ	38	34	75	38
18	Pueblonuevo	38	33	51	38
19	Santa Amalia	38	39	68	36
20	Villafranca	38	35	79	27

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Jerez	38	47	16	82
2	Benito	38	77	25	82
3	Imperio	38	67	28	81
4	Cacereño	38	71	31	75
5	Diter Zafra	38	57	21	73
6	Villanueva	38	60	24	67
7	CD Badajoz	38	50	34	58
8	Miajadas	38	62	64	57
9	Extremadura	38	44	39	56
10	Villafranca	38	51	49	55
11	Estrella	38	45	49	48
12	Moralo	38	42	43	47
13	Plasencia	38	48	44	45
14	Santa Amalia	38	46	58	43
15	Sanvicenteñ	38	40	60	43
16	Olivenza	38	30	47	41
17	CD Coria	38	46	63	38
18	Castuera	38	30	67	28
19	Monesterio	38	19	71	20
20	Moraleja	38	38	137	12

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	40	75	35	90
2	Cerro Reyes	40	93	28	88
3	Benito	40	86	32	82
4	Villanueva	40	67	35	81
5	Miajadas	40	68	64	65
6	Jerez	40	61	50	62
7	Imperio	40	57	49	61
8	Plasencia	40	57	55	59
9	Cacereño	40	54	50	57
10	Estrella	40	42	51	57
11	Santa Amalia	40	44	52	51
12	Extremadura	40	56	69	47
13	CD Coria	40	57	83	46
14	Villafranca	40	46	60	45
15	Moralo	40	38	54	45
16	Olivenza	40	43	62	44
17	Monesterio	40	38	58	40
18	Amanecer	40	39	56	39
19	Alburquerque	40	46	65	39
20	Santa Marta	40	34	67	37
21	CP Valdivia	40	38	64	31

Competiciones que juega

Grupo 4

RIVALES EN 1ª Regional Extr.

USO DE MEMORIA

7,202,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.6485
Total Execution Time	0.6496

CADENA URL

/historico/Uc-Estrella-Senior

GET DATOS

$_GET['/historico/Uc-Estrella-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0169	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 = 'Uc-Estrella-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.0129	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=10239 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=10239 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=10239 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10239 AND type_rel = 2
0.0151	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 = '10239' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0153	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 = '10239' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138	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 = 73533 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=10239 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0137	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 (75917,67988,67320) 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.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 67988 AND teamId = 10239
0.0142	SELECT count(id) as num_players from rel_players WHERE league_id = 75917 AND teamId = 10239
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10239
0.0137	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 = '10239' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10239' and rp.type = 4
0.0135	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 = '10239' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 75917 WHERE rp.league_id = 75917 AND rp.teamId = 10239 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.0153	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 = 75917 WHERE rp.league_id = 75917 AND rp.teamId = 10239 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 75917 WHERE rp.league_id = 75917 AND rp.teamId = 10239 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 = 10239 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67988 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 = 63719 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.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* `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 = 59501 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.0128	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 = 62270 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 51308 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.0135	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 = 44630 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 39346 AND t.round = 30 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* `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 = 33364 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 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 = 16719 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* `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 = 4101 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 2690 AND t.round = 30 ORDER BY team.conference 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* `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 = 2077 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 2052 AND t.round = 1 ORDER BY team.conference 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* `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 = 1223 AND t.round = 38 ORDER BY team.conference 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* `tables2010` 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 = 814 AND t.round = 38 ORDER BY team.conference 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* `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 = 144 AND t.round = 38 ORDER BY team.conference 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* `tables2008` 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 = 21 AND t.round = 38 ORDER BY team.conference 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* `tables2007` 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 = 99 AND t.round = 38 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* `tables2006` 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 = 22126 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

UC La Estrella

UC La Estrella

Selecciona un equipo

Competiciones que juega

RIVALES EN 1ª Regional Extr.