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

Primera RFFPA 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Avilés	22	35	16	47
2	Atlético	22	29	12	44
3	Barcia CF	22	34	23	38
4	Tineo	22	25	15	37
5	Andés	22	26	14	37
6	Candás CF	22	28	18	36
7	Claudio	22	27	27	33
8	Real Tapia	22	24	34	27
9	Club	22	31	35	24
10	Podes CF	22	33	39	21
11	Gozón	22	24	44	14
12	Guía Norte	22	23	62	7

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	TSK Roces	10	12	4	21
2	Gozón	10	8	8	13
3	Guía Norte	10	15	12	12
4	Colloto	10	9	13	12
5	Berrón	10	10	14	11
6	Ribadesella	10	7	10	11

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Real	28	55	20	69
2	Avilés	28	28	12	53
3	Valdesoto	28	39	24	51
4	TSK Roces	28	50	26	50
5	Claudio	28	44	28	49
6	Podes CF	28	41	34	49
7	Astur	28	34	21	44
8	Atlético	28	40	31	41
9	Candás CF	28	30	32	36
10	Club	28	43	35	34
11	Unión	28	35	37	34
12	Berrón	28	28	45	34
13	Colloto	28	33	41	33
14	Universidad	28	34	34	32
15	Guía Norte	28	34	41	30
16	Llaranes CF	28	33	48	29
17	Tineo	28	22	36	26
18	Nalón CF	28	28	48	26
19	CD Turón	28	30	53	26
20	Madalena	28	28	63	18

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Urraca CF	38	58	28	74
2	Vallobin CD	38	59	33	74
3	Navarro	38	61	27	73
4	Lenense	38	65	36	72
5	Avilés	38	52	27	71
6	Real	38	43	28	67
7	Tineo	38	63	59	56
8	TSK Roces	38	58	46	54
9	Club	38	59	61	52
10	Atlético	38	41	43	48
11	Astur	38	45	49	47
12	Candás CF	38	47	53	44
13	Colloto	38	47	59	43
14	Valdesoto	38	47	65	43
15	Berrón	38	37	59	42
16	CD Turón	38	45	65	41
17	Nalón CF	38	46	67	41
18	Andés	38	43	57	39
19	Ribadesella	38	39	62	32
20	Ribadedeva	38	33	64	31

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Claudio	38	70	37	78
2	Madalena	38	71	38	74
3	Universidad	38	69	32	71
4	Ribadesella	38	67	56	66
5	Vallobin CD	38	43	27	62
6	Lenense	38	51	42	59
7	Astur	38	46	39	57
8	Club	37	51	56	50
9	Nalón CF	37	45	51	50
10	Urraca CF	38	36	40	49
11	Andés	38	41	46	48
12	Tineo	38	42	44	48
13	Navarro	38	52	51	46
14	Candás CF	38	37	41	46
15	Real	37	44	50	46
16	Ribadedeva	37	48	63	43
17	CD Turón	38	43	69	42
18	Unión	38	48	60	40
19	Rayo	38	50	66	38
20	Manuel Rubio	38	40	86	25

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	58	25	72
2	Gijón	38	65	33	71
3	Martín	38	63	34	70
4	Valdesoto	38	61	31	69
5	Nalón CF	38	67	37	67
6	Rayo	38	46	31	64
7	Claudio	38	58	56	57
8	Ribadesella	38	76	76	55
9	Unión	38	50	51	55
10	Andés	38	57	61	48
11	Navarro	38	44	54	48
12	Astur	38	42	48	47
13	Universidad	38	50	66	47
14	Madalena	38	59	62	45
15	Ribadedeva	38	44	51	44
16	Candás CF	38	42	61	40
17	CD Turón	38	45	69	38
18	Muros	38	45	82	36
19	Luarca CF	38	44	65	33
20	Berrón	38	46	69	33

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	L´Entregu	38	70	30	78
2	UD Llanera	38	69	28	76
3	Lenense	38	54	28	76
4	Andés	38	60	38	73
5	Martín	38	61	34	72
6	Navarro	38	58	27	71
7	Nalón CF	38	63	38	70
8	CD Turón	38	57	49	60
9	Valdesoto	38	54	50	58
10	Unión	38	51	48	50
11	Luarca CF	38	54	60	50
12	Madalena	38	58	62	48
13	Candás CF	38	48	64	46
14	Claudio	38	46	46	45
15	Universidad	38	34	54	45
16	Berrón	38	48	59	41
17	Rayo	38	47	71	41
18	Campomanes	38	35	66	33
19	Real Avilés	38	26	83	17
20	Fresneda	38	36	94	14

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Club Siero	38	69	39	69
2	CD Colunga	38	60	39	69
3	Tineo	38	63	42	68
4	Rayo	38	63	47	67
5	Llano 2000	38	45	23	62
6	Martín	38	59	53	54
7	Valdesoto	38	57	55	53
8	UD Llanera	38	63	61	52
9	Candás CF	38	49	48	51
10	CD Turón	38	50	50	51
11	Campomanes	38	51	56	51
12	Claudio	38	41	42	50
13	Unión	38	35	48	50
14	Madalena	38	52	55	49
15	Luarca CF	38	41	43	48
16	Navarro	38	42	45	48
17	Real Tapia	38	46	58	43
18	Boal CF	38	36	56	38
19	Muros	38	44	62	34
20	CD Raíces	38	36	80	25

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	75	32	77
2	Llanes	38	86	41	76
3	Astur	38	71	38	76
4	Mosconia	38	78	38	70
5	CD Colunga	38	68	44	66
6	Rayo	38	67	50	61
7	Navarro	38	47	35	61
8	Valdesoto	38	59	46	55
9	Atlético	38	56	53	52
10	Llano 2000	38	46	44	52
11	Tineo	38	38	47	51
12	UD Llanera	38	58	56	50
13	Muros	38	56	54	50
14	U.Comercial	38	50	52	49
15	CD Turón	38	68	69	47
16	Boal CF	38	51	59	46
17	Campomanes	38	54	65	45
18	Nalón CF	38	34	54	39
19	Pumarín CF	38	53	65	31
20	Navia CF	38	21	194	3

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Real Avilés	37	69	32	73
2	Lenense	37	69	53	71
3	Andés	37	69	43	70
4	Astur	37	60	32	69
5	Muros	38	83	37	68
6	Pumarín Cf	38	57	36	65
7	Valdesoto	38	53	48	60
8	TSK Roces	38	53	37	59
9	Tineo	38	60	45	59
10	Llano 2000	38	64	41	57
11	Mosconia	38	48	44	55
12	Atlético	38	51	42	51
13	Campomanes	38	53	49	48
14	Unión	38	54	60	48
15	CD Colunga	38	48	64	46
16	CD Turón	38	60	74	45
17	Nalón CF	37	55	63	43
18	Sd Colloto	37	32	49	43
19	Narcea	38	31	106	11
20	La Caridad	38	27	141	11

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	CD Praviano	38	61	35	75
2	Atlético	38	58	25	71
3	L´Entregu	38	71	45	70
4	Urraca CF	38	83	58	69
5	Real Tapia	38	58	43	66
6	Club Siero	38	69	45	62
7	Lenense	38	51	55	56
8	Tineo	38	58	51	53
9	TSK Roces	38	54	46	52
10	Universidad	38	57	55	51
11	Valdesoto	38	51	46	50
12	U.Comercial	38	60	54	49
13	Real Avilés	38	57	58	48
14	La Caridad	38	43	52	48
15	Andés	38	44	61	48
16	Campomanes	38	54	66	42
17	Narcea	38	35	52	42
18	Ribadesella	38	52	71	41
19	Deportiva	38	37	75	30
20	San Martín	38	28	88	25

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Covadonga	38	70	18	91
2	Colloto	38	74	41	73
3	Pumarín CF	38	51	23	70
4	Atlético	38	59	39	66
5	Tineo	38	47	38	66
6	Urraca CF	38	64	62	53
7	Narcea	38	39	51	53
8	Valdesoto	38	52	52	52
9	La Caridad	38	47	48	51
10	Campomanes	38	59	51	50
11	Real Avilés	38	50	49	50
12	L´Entregu	38	50	47	48
13	Club Siero	38	49	62	48
14	Universidad	38	52	68	46
15	U.Comercial	38	43	59	45
16	San Martín	38	57	64	44
17	Deportiva	38	43	64	44
18	Mosconia	38	52	70	42
19	Astur	38	45	62	37
20	UD Llanera	38	37	72	26

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Navia CF	38	71	43	75
2	Oviedo	38	52	29	69
3	Nalón	38	77	56	67
4	Andés	38	53	37	63
5	Valdesoto	38	55	49	62
6	Atlético	38	47	31	58
7	Piloñesa	38	58	55	58
8	Narcea	38	53	52	52
9	U.Comercial	38	61	58	51
10	Tineo	38	52	62	50
11	La Caridad	38	54	61	49
12	San Martín	38	44	49	48
13	Universidad	38	64	70	48
14	Mosconia	38	48	65	47
15	L´Entregu	38	67	62	46
16	Urraca CF	38	48	60	46
17	Atlético	38	53	61	45
18	Santiago	38	46	57	44
19	Real Tapia	38	52	70	36
20	Berrón	38	42	70	31

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	CD Praviano	38	64	24	83
2	Colloto	38	63	39	73
3	Luarca CF	38	70	43	69
4	Tineo	38	54	29	67
5	Atlético	38	45	46	66
6	Racing Sama	38	57	43	62
7	Real Tapia	38	59	52	54
8	L´Entregu	38	57	53	53
9	San Martín	38	51	47	53
10	La Caridad	38	53	50	53
11	Narcea	38	61	51	52
12	Andés	38	39	37	52
13	U.Comercial	38	50	62	50
14	Universidad	38	59	65	45
15	Urraca CF	38	44	57	45
16	Valdesoto	38	61	66	44
17	Santiago	38	42	65	44
18	Atlético	38	38	84	33
19	Club Hispano	38	38	64	32
20	CD Salas	38	35	63	27

JUGADORES DESTACADOS

Nombre	Goles	Equipo
Chus	13	ATL
Aramo	9	AVI
J. Fernandez	8	BAR
C. Díaz	7	GUI
Sergio	7	CLA
A. Felipe	7	AST
A. Antuña	7	AST
Prida	7	TIN
Peláez	7	CAN
Modesto	6	TAP

Equipos de esta liga

USO DE MEMORIA

6,890,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5108
Total Execution Time	0.5127

CADENA URL

/asturias2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (28)

0.0125	SELECT type FROM routes WHERE alias = 'asturias2022'
0.0255	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'asturias' 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.0129	SELECT id,name,alias,stepParent FROM categories WHERE parentId=72 ORDER BY order_id ASC
0.0136	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 = 63715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 72 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 63715 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.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* `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 = 61954 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.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 = 51182 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.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* `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 = 44673 AND t.round = 38 ORDER BY team.conference 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* `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 = 39192 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* `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 = 34175 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* `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 = 16699 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* `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 = 4081 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* `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 = 2589 AND t.round = 38 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 = 1978 AND t.round = 38 ORDER BY team.conference 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* `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 = 1453 AND t.round = 38 ORDER BY team.conference 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* `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 = 1129 AND t.round = 38 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* `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 = 847 AND t.round = 38 ORDER BY team.conference 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* `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 = 287 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 14:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 14:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 14:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 14:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'asturias' 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.0214	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 = 63715 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63715 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.0326	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 = 63715 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63715 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133	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 = 63715 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63715 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136	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 = 63715 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

Nombre	Rojas	Equipo
Borja	2	GOZ
M. Diaz	2	GOZ
E. Durán	2	AST
S. Fernandez	1	TAP
B. Rodriguez	1	GOZ
Dani Cuello	1	BAR
Aitor Suárez	1	CAN
A. Rodríguez	1	TAP
A. González	1	AVI
N. Olaya	1	GUI


	¿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
Dani Cuello	11	BAR
Belar	9	AST
Cordero	9	CLA
J. Fernandez	9	BAR
M. Ndong	8	AVI
Israel	8	ATL
C. Díaz	8	GUI
M. Ameijide	8	BAR
L. Riesco	7	BAR
E. Durán	7	AST