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

Eliminatoria

Preferente Aragón 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Tamarite	32	109	26	83
2	Sariñena	32	79	22	78
3	Internaciona	32	55	21	67
4	Fraga	32	70	32	64
5	Montecarlo	32	61	47	56
6	Valdefierro	32	60	48	50
7	Sabiñánigo	32	57	42	46
8	Atlético	32	31	30	46
9	Casetas	32	53	42	45
10	Jacetano	32	52	49	42
11	Alcolea CF	32	42	58	41
12	Mequinenza	32	36	58	38
13	Peña	32	42	58	33
14	Lorenzo	32	46	80	24
15	Almunia Juan	32	21	89	19
16	Zaragoza	32	22	67	17
17	Peñas	32	22	89	16

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Biescas	11	27	6	28
2	Lorenzo	12	23	18	22
3	Tardienta	12	22	13	19
4	Peña	12	17	26	15
5	Internaciona	11	18	16	14
6	Mequinenza	12	10	22	13
7	Peñas	12	11	27	8

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Huesca B	24	46	10	59
2	Sabiñánigo	24	52	14	52
3	Santa	24	44	27	50
4	Peñas	24	40	19	46
5	Zuera	24	39	25	44
6	Casetas	24	27	20	36
7	Tardienta	24	26	23	35
8	Villa	24	28	23	33
9	Actur Pablo	24	31	28	32
10	Mallén	24	37	44	28
11	Peña	24	21	26	27
12	Zaragoza	24	22	44	26
13	CD Delicias	24	24	33	24
14	AD Magallon	23	29	40	23
15	Biescas	23	19	29	22
16	Peña	24	22	47	22
17	Lorenzo	24	26	42	20
18	Mequinenza	24	14	53	10

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	CD Cuarte	34	69	28	72
2	Barbastro	34	54	27	71
3	CF Epila	34	52	39	59
4	Santa	34	55	47	59
5	Zuera	34	60	58	50
6	José	34	53	51	47
7	Biescas	34	39	44	47
8	Villa	34	48	49	46
9	Zaragoza	34	49	48	45
10	Mallén	34	37	45	45
11	Peña	34	48	41	43
12	Tardienta	34	43	46	43
13	AD Magallon	34	43	47	43
14	Actur Pablo	34	40	45	43
15	Gallur CD	34	40	52	42
16	Jacetano	34	42	51	41
17	Grañén	34	40	64	29
18	Altorricón	34	35	65	25

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Villanueva	34	69	32	71
2	Casetas	34	47	34	70
3	Lorenzo	34	52	33	65
4	Zaragoza	34	57	40	53
5	Grañén	34	42	46	49
6	Barbastro	34	43	42	47
7	Villa	34	38	40	47
8	Gallur CD	34	47	52	47
9	Montecarlo	34	38	39	44
10	Tardienta	34	44	45	43
11	Mallén	34	47	54	43
12	Biescas	34	42	49	43
13	Peña	34	49	46	41
14	AD Magallon	34	43	43	39
15	Alcolea CF	33	45	56	39
16	Giner	34	34	40	38
17	Peñas	33	42	46	32
18	Gregorio	34	29	71	21

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Caspe	34	56	29	66
2	Fraga	34	62	30	61
3	Atlético	34	47	25	61
4	José	34	53	46	56
5	Actur Pablo	34	45	44	51
6	Mequinenza	34	44	32	50
7	Barbastro	34	47	45	50
8	Peña	34	56	55	50
9	Lorenzo	34	51	64	49
10	Montecarlo	34	53	51	48
11	Peñas	34	44	49	47
12	Villanueva	34	48	41	44
13	Grañén	34	55	52	44
14	Giner	34	47	59	40
15	Benabarre	34	46	55	39
16	Santa Isabel	34	40	55	36
17	Altorricón	34	48	69	36
18	Lalueza	34	31	72	19

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Robres	34	60	27	71
2	Tamarite	34	71	26	67
3	Santa Isabel	34	42	38	57
4	Peñas	34	54	50	52
5	Caspe	34	49	29	52
6	Actur Pablo	34	59	41	49
7	Hernán	34	43	39	47
8	Grañén	34	43	55	47
9	Peña	34	44	52	47
10	Mequinenza	34	37	38	47
11	Altorricón	34	48	53	46
12	Benabarre	34	49	41	46
13	Barbastro	34	35	45	45
14	Giner	34	44	50	45
15	Alcañiz	34	54	57	45
16	Tardienta	34	43	39	41
17	Alcolea CF	34	34	57	33
18	Belver	34	24	96	10

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Fraga	34	77	35	70
2	Atlético	34	65	27	69
3	Altorricón	34	54	31	58
4	Robres	34	56	42	56
5	Montecarlo	34	48	33	55
6	José	34	49	46	54
7	Benabarre	34	51	45	52
8	Mallén	34	44	46	51
9	Villanueva	34	51	45	45
10	Peñas	34	42	42	45
11	Tardienta	34	42	41	44
12	Grañén	34	43	47	43
13	Valdefierro	34	44	47	40
14	Lorenzo	34	43	48	40
15	Tauste CD	34	36	47	40
16	Mequinenza	34	39	53	40
17	Zuera	34	39	58	32
18	Jacetano	34	18	108	7

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	CD Binéfar	34	60	29	68
2	Villa	34	63	27	66
3	Fraga	34	58	32	65
4	Benabarre	34	49	35	64
5	Tardienta	34	52	42	53
6	Tauste CD	34	54	37	52
7	Lorenzo	34	53	45	51
8	Valdefierro	34	36	38	51
9	Robres	34	50	39	48
10	Montecarlo	34	54	48	46
11	Mallén	34	38	45	45
12	Mequinenza	34	54	51	44
13	Grañén	34	50	56	41
14	Actur Pablo	34	43	48	38
15	Salvador	34	41	53	37
16	UD Pueyo	34	38	70	29
17	Pomar	34	29	79	24
18	Santa	34	29	77	22

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Altorricón	34	89	46	78
2	Tamarite	34	53	28	63
3	Fraga	34	67	42	61
4	Benabarre	33	68	44	59
5	Giner	34	50	40	52
6	Cd Caspe	34	49	46	51
7	Lorenzo	34	55	51	50
8	Santa Isabel	34	47	35	47
9	José	34	47	54	46
10	Cf Pomar	34	44	48	45
11	Tardienta	33	60	66	43
12	Salvador	34	61	62	42
13	Alcañiz	34	43	51	41
14	Mequinenza	34	40	62	39
15	Anento	34	50	60	37
16	Cd Zuera	34	30	53	33
17	Alfindén	34	34	73	33
18	Sportin	34	31	57	27

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	SD Borja	34	76	22	84
2	Almunia	34	70	31	74
3	Mallén	34	60	34	71
4	Cella	34	60	40	56
5	Illueca	34	62	39	54
6	Villa	34	61	41	53
7	Brea	34	55	57	52
8	Belchite	34	57	45	50
9	Calamocha	34	35	50	42
10	Gregorio	34	45	65	39
11	Hernán	34	46	53	38
12	CD Utrillas	34	46	57	38
13	Morata CD	34	33	50	38
14	Valdefuentes	34	51	46	37
15	Actur Pablo	34	37	62	36
16	La Muela	34	50	69	32
17	Cd Daroca	34	33	79	26
18	Cd Azuara	34	31	68	21

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Universidad	34	71	32	69
2	Oliver	34	64	36	67
3	Tamarite	34	65	35	64
4	Robres	34	67	30	62
5	Fraga	34	69	36	62
6	Zuera	34	62	41	61
7	SD Borja	34	59	45	59
8	Alcampell	34	65	42	58
9	Casetas	34	50	51	46
10	Lorenzo	34	50	52	45
11	Almudévar	34	57	51	39
12	Alfindén	34	40	51	38
13	Peña	34	53	72	38
14	Jacetano	34	45	51	37
15	Gregorio	34	34	61	37
16	Grañén	34	47	70	36
17	Alcolea CF	34	39	69	29
18	Pedrola	34	13	125	8

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	CD Ebro	34	78	22	84
2	Universidad	34	83	17	81
3	SD Tarazona	34	72	35	72
4	Oliver	34	49	49	57
5	Brea	33	60	50	56
6	José	34	45	41	52
7	Calamocha	34	56	55	51
8	Pedrola	34	53	45	48
9	Teruel B	34	42	52	46
10	Casetas	33	47	52	44
11	Illueca	34	45	56	44
12	Almunia	34	42	50	43
13	Monzalbarba	34	49	59	36
14	Alfindén	34	51	69	35
15	Montecarlo	34	41	57	32
16	Garrapinillo	34	42	64	31
17	Cella	34	38	82	24
18	Santa	34	47	85	21

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Tauste CD	34	70	30	77
2	Mallén	34	55	29	64
3	Fuentes	34	62	36	62
4	SD Tarazona	34	63	38	59
5	Illueca	34	70	49	56
6	Quinto	34	38	34	53
7	Casetas	34	47	45	49
8	Almunia	34	55	44	48
9	Alfindén	34	48	43	48
10	José	34	50	47	47
11	Teruel B	34	57	50	46
12	Cella	34	62	79	45
13	Belchite	34	51	63	44
14	Santa	34	55	61	43
15	Ateca	34	57	65	41
16	Ágreda	34	43	67	26
17	Molinos	34	40	72	25
18	Gregorio	34	33	104	14

JUGADORES DESTACADOS

Nombre	Goles	Equipo
Alexis Espinosa	30	TAM
Roncea	23	SAR
Moria	20	SAR
Diego Muñoz	20	CFV
Unai Jodar	16	FRA
Jhonnier Montaño	16	SIE
Paco Blasco	15	SAB
Albert	15	TAM
Grau	13	TAM
Joel Casals	12	TAM

Equipos de esta liga

USO DE MEMORIA

6,943,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.4660
Total Execution Time	0.4678

CADENA URL

/aragon2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0104	SELECT type FROM routes WHERE alias = 'aragon2022'
0.0213	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'aragon' 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.0105	SELECT id,name,alias,stepParent FROM categories WHERE parentId=85 ORDER BY order_id ASC
0.0106	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 = 63838 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 85 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0111	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 = 63838 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.0108	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 = 59794 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 44662 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 39349 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 33993 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 16720 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 4082 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 2695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 1996 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 1478 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 1141 AND t.round = 34 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 = 861 AND t.round = 34 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 = 298 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 22:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 22:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 22:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 22:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'aragon' 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.0347	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 = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 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.0434	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 = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117	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 = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0121	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 = 63838 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
D. Pueyo	2	CFJ
I. Latre	2	ASJ
D. Castilla	2	FRA
Eloy	2	CDM
J. Cabistan	2	CDM
Elhadji Karamo	1	ALC
J. Mayoral	1	ALC
B. Palacios	1	UDC
Perea	1	CFV
I. Ronaldo	1	UDC


	¿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
S. Nihah	12	SIE
Sergio Poy	12	ALC
Miguel Gutiérrez	12	CFV
Nogueras	12	SAB
A. Sinusia	12	ZAR
M. Diez	11	CFJ
Jhonnier Montaño	11	SIE
Gabriel	11	ZAR
J. Azón	10	CFJ
A. Bruna	10	CDM