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

« Temporada Anterior

Temporada 2022

Temporada Siguiente »

2021/2022

Preferente C. La Mancha 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Solana	33	77	30	74
2	Atlético	34	50	36	63
3	Manzanares	34	57	27	62
4	Pedroñeras	34	57	37	61
5	Valdepeñas	34	67	48	57
6	AD Campillo	34	53	42	52
7	UD Carrión	34	59	47	49
8	Quintanar	34	48	34	48
9	Criptanense	34	45	34	48
10	Sporting	34	37	48	45
11	Atlético	34	50	41	44
12	Fuente	34	59	58	44
13	EFB La Roda	34	44	47	42
14	Herencia	34	49	53	40
15	C.F.	34	37	53	37
16	Munera	34	52	76	34
17	C.D.	33	31	98	27
18	Almagro CF	34	26	89	16

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Clemente	22	43	15	47
2	Criptanense	22	24	14	40
3	Quintanar	22	35	24	37
4	Atlético	22	36	25	36
5	Jose Obrero	22	33	30	35
6	AD Campillo	22	31	31	31
7	Munera	22	24	27	29
8	Herencia	22	29	33	28
9	Sporting	22	21	38	26
10	Membrilla	22	23	29	25
11	Atlético	22	28	42	20
12	La Gineta	22	24	43	15

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Manzanares	26	47	7	65
2	Huracan	26	43	17	56
3	Clemente	26	48	23	54
4	Quintanar	26	35	21	46
5	La Gineta	26	37	24	42
6	UD Carrión	26	23	21	37
7	Miguelturre�	26	23	23	37
8	Atlético	26	26	23	36
9	AD Campillo	26	32	32	34
10	Jose Obrero	26	31	37	33
11	Criptanense	26	28	39	32
12	Fuente	26	32	41	30
13	Sporting	26	25	29	29
14	C.F.	26	34	44	29
15	Membrilla	26	25	36	29
16	Daimiel	26	20	30	21
17	Atlético	26	18	41	21
18	Cultural	26	23	62	21

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Pedroñeras	34	67	16	80
2	UD Almansa	34	77	27	79
3	Huracan	34	51	20	71
4	La Gineta	34	70	28	68
5	Manzanares	34	58	41	65
6	Miguelturre�	34	49	54	49
7	Clemente	34	51	41	46
8	AD Campillo	34	49	46	45
9	Daimiel	34	36	40	45
10	Fuente	34	51	60	45
11	UD Carrión	34	46	52	44
12	Sporting	34	45	57	40
13	Cultural	34	51	65	39
14	Miguel	34	47	58	38
15	Membrilla	34	29	47	38
16	Hellin CF	34	26	61	25
17	C.D.	34	35	79	23
18	Atletico	34	21	67	19

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Puertollano	34	106	24	84
2	Solana	34	55	19	77
3	La Gineta	34	71	33	74
4	Manzanares	34	61	39	57
5	Huracan	34	82	52	55
6	Atletico	34	65	45	53
7	Clemente	34	49	30	53
8	Miguel	34	54	49	47
9	Cultural	34	49	72	45
10	Fuente	34	50	59	44
11	Daimiel	34	35	44	43
12	UD Carrión	34	50	56	39
13	CD Urda	34	40	54	38
14	Valdepeñas	34	30	55	34
15	C.D.	34	34	71	34
16	Atco. Pedro	34	42	62	33
17	Porzuna CDB	34	30	55	30
18	Atletico	34	30	114	17

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Atlético	34	88	23	82
2	Miguelturre�	34	62	28	72
3	La Gineta	34	67	37	67
4	Solana	34	56	35	63
5	Huracan	34	55	45	53
6	Valdepeñas	34	61	50	51
7	Atletico	34	50	42	49
8	Manzanares	34	46	48	48
9	Atco. Pedro	34	53	51	47
10	Atletico	34	50	49	47
11	Fuente	34	63	68	47
12	C.D.	34	53	47	45
13	Porzuna CDB	34	46	55	44
14	Daimiel	34	34	52	42
15	Munera	34	52	56	40
16	C.D.B.F.	34	31	86	21
17	U.D. Alpera	34	47	92	18
18	Villamalea	34	36	86	16

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Anro-Atco	34	97	26	84
2	UD Carrión	34	71	25	72
3	Solana	34	71	33	65
4	UD Tobarra	34	56	28	64
5	Atletico	34	51	46	53
6	Valdepeñas	34	49	46	50
7	Miguelturre�	34	46	35	49
8	Daimiel	34	56	56	49
9	C.D.B.F.	34	39	45	48
10	Atco. Pedro	34	55	55	47
11	C.D.	34	41	59	45
12	Motilla CF	34	53	54	43
13	U.D. Alpera	34	58	87	40
14	Huracan	34	52	54	39
15	Al-Basit	34	47	56	39
16	Hellin	34	42	55	38
17	U.B.	34	25	91	18
18	EF Zona 5	34	14	72	8

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Jose Obrero	33	79	40	71
2	Munera	33	73	27	70
3	Solana	33	78	38	70
4	Atlético	34	86	35	65
5	U.B.	33	52	40	57
6	UD Tobarra	33	49	34	54
7	Motilla CF	33	54	40	53
8	UD Carrión	33	46	34	51
9	Quintanar	33	50	48	45
10	Miguelturre�	33	39	51	39
11	U.D. Alpera	33	50	61	37
12	C.D.B.F.	33	38	54	35
13	C.F.	33	41	62	35
14	C.D.	33	36	66	35
15	EF Zona 5	33	31	64	35
16	Mota Cuervo	32	28	63	20
17	Piedrabuena	32	27	77	19
18	Tomelloso	18	21	44	12

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Almagro CF	34	60	30	71
2	Daimiel	34	61	34	69
3	Munera	34	55	37	66
4	Jose Obrero	34	70	39	65
5	Solana	34	70	51	57
6	Isso CF	34	58	35	57
7	Quintanar	34	58	41	54
8	Tomelloso	34	60	53	53
9	Mota Cuervo	34	58	47	45
10	Cervantes	34	51	71	42
11	Roda	34	42	55	41
12	Miguelturre�	34	40	49	40
13	Piedrabuena	34	51	49	40
14	UD Tobarra	34	40	55	37
15	Herencia	34	50	61	37
16	Madrigueras	34	39	64	32
17	Criptanense	34	50	68	31
18	Atlético	34	19	93	12

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	La Gineta	34	89	29	86
2	EF Zona 5	34	67	28	76
3	Atlético	34	72	31	74
4	EMD Solana	34	54	33	66
5	Daimiel	34	51	25	64
6	Almagro CF	34	54	43	56
7	Munera	34	49	43	55
8	Tomelloso	34	64	48	53
9	Piedrabuena	34	55	52	49
10	Isso CF	34	45	54	42
11	Madrigueras	34	42	53	41
12	Miguelturre�	34	46	56	40
13	Herencia	34	37	63	40
14	UD Carrión	34	44	54	32
15	Atlético	34	42	54	32
16	Valdepeñas	34	48	52	29
17	Piedrabuena	34	31	100	21
18	Puertollano	34	24	96	10

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Manchego	34	77	33	71
2	Daimiel	34	65	33	64
3	Almagro CF	34	57	31	64
4	Solana	34	62	47	57
5	Pedroñeras	34	46	33	55
6	Piedrabuena	34	58	45	54
7	Mota Cuervo	34	56	47	51
8	Atlético	34	51	51	50
9	Motilla Cf	34	52	60	49
10	EF Zona 5	34	67	47	48
11	Herencia	34	57	61	47
12	Munera	34	44	53	46
13	Ud Carrión	34	42	51	44
14	Miguelturre�	34	42	51	42
15	Villamalea	34	45	63	37
16	Unión	34	52	66	35
17	Efud Albacer	34	27	65	24
18	Deportivo	34	35	98	23

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Atlético	34	75	36	76
2	Puertollano	34	90	39	75
3	Atlético	34	76	28	72
4	Solana	34	71	41	61
5	Jose Obrero	34	71	43	60
6	Daimiel	34	57	24	59
7	Munera	34	55	49	54
8	Almagro CF	34	54	34	53
9	CDE Zona 5	34	54	54	46
10	Villamalea	34	46	43	46
11	Albacer	34	49	42	45
12	Deportivo	34	53	75	43
13	Miguelturre�	34	39	49	41
14	Aldea	34	50	55	38
15	Sporting	34	37	82	27
16	Tomelloso B	34	41	89	26
17	Bolañego	34	22	82	14
18	Manchego	34	30	105	13

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Manzanares	34	67	32	70
2	Solana	34	82	51	69
3	Villarrubia	34	55	33	69
4	Aldea	34	113	49	65
5	Puertollano	34	77	48	61
6	Miguelturre�	34	56	49	52
7	Atlético	34	49	56	51
8	Atlético	34	57	61	49
9	Albacer	34	46	42	47
10	Almagro CF	34	65	56	45
11	Manchego	34	49	62	44
12	Villamalea	34	45	50	41
13	Bolañego	34	40	50	40
14	Deportivo	34	48	54	39
15	Hellín B	34	44	56	38
16	Quintanar	34	39	63	36
17	Atlético	34	39	58	33
18	Pedroñeras	34	19	120	7

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Quintanar	34	66	20	80
2	La Gineta	34	67	28	69
3	Atlético	33	63	31	65
4	Miguelturre�	34	59	37	65
5	Villamalea	34	44	32	58
6	Manzanares	34	57	35	57
7	Almagro CF	34	44	43	45
8	Albacer	34	46	42	44
9	Deportivo	34	50	58	44
10	Almansa B	34	45	55	44
11	Altobuey	33	49	46	41
12	Puertollano	34	49	47	41
13	Bolañego	34	51	53	40
14	Aldea	34	47	52	40
15	Munera	33	40	63	31
16	Atco. Pedro	34	40	66	31
17	El Bonillo	31	28	66	26
18	Atlético	34	18	89	13

JUGADORES DESTACADOS

Nombre	Goles	Equipo
Mauro	23	PED
P. Sobrino	21	MAN
Reyes	19	LSO
J. Vivanco	17	QUI
C. Quiñones	16	ALC
A. Orega	14	FUE
D. Lozano	12	MAN
S. Moratalla	12	CAM
B. Lemmi	12	UDC
A. Espinosa	12	CRI

Equipos de esta liga

USO DE MEMORIA

7,072,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1461
Total Execution Time	0.1482

CADENA URL

/primera_autonomica_castilla_la_mancha2022/grupo1/historico

GET DATOS

$_GET['/primera_autonomica_castilla_la_mancha2022/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0018	SELECT type FROM routes WHERE alias = 'primera_autonomica_castilla_la_mancha2022'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 86 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 63675 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.0021	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 = 58932 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 = 51208 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.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* `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 = 44768 AND t.round = 34 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* `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 = 39693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 34107 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* `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 = 16708 AND t.round = 34 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* `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 = 4077 AND t.round = 34 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 = 2697 AND t.round = 34 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* `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 = 2255 AND t.round = 34 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* `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 = 1479 AND t.round = 34 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 = 1190 AND t.round = 34 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* `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 = 948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 299 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 22:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 22:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 22:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 22:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0116	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0207	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0037	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045	SELECT ,(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 = 63675 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

Nombre	Rojas	Equipo
Santi Vera	4	FUE
L. Sirera	3	CAU
A. Cañizares	3	MAN
M. Sanchez	2	CAU
C. Castro	2	RRB
E. Martinez	2	MUN
R. Crespo	2	QUI
H. Khmaich	2	CAU
J. Estevan	2	CAU
I. Sanchez	2	ALM


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Nombre	Amarillas	Equipo
A. Alvarez	19	CAU
C. Lucio	19	ALM
Santi Vera	18	FUE
Cielo	16	CRI
L. Sirera	16	CAU
A. Cañizares	15	MAN
M. Garcia	13	CDB
I. Muñoz	13	FUE
B. Galindo	13	ATT
A. Moran	13	FUE