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

Temporada Regular

Primera División Futsal 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Barça	30	122	63	68
2	Inter FS	30	87	68	58
3	Palma Futsal	30	78	55	58
4	Viña Albali	30	91	81	56
5	Jimbee	30	99	70	55
6	Ribera	30	88	96	45
7	Jaén FS	30	85	73	44
8	ElPozo	30	87	72	43
9	Industrias	30	90	78	42
10	Levante	30	84	91	37
11	Córdoba	30	90	91	36
12	Manzanares	30	82	100	30
13	Osasuna	30	65	98	30
14	Real Betis.	30	67	100	26
15	Sala	30	85	112	24
16	Burela FS	30	62	114	14

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	ElPozo	34	108	79	68
2	Palma Futsal	34	98	67	68
3	Barça	34	109	63	66
4	Jimbee	34	134	93	64
5	Levante	34	113	99	64
6	Inter FS	34	121	84	57
7	Sala	34	108	104	48
8	Viña Albali	34	107	91	47
9	Industrias	34	95	89	47
10	Real Betis.	34	86	101	46
11	Ribera	34	104	105	41
12	Osasuna	34	83	96	40
13	Córdoba	34	80	90	40
14	Jaén FS	34	73	95	38
15	Burela FS	34	102	120	38
16	Peñíscola	34	83	108	34
17	Antequera	34	75	129	22
18	Parrulo	34	80	146	20

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Inter FS	23	96	51	56
2	Barça	23	107	60	54
3	Viña Albali	23	81	61	45
4	ElPozo	23	75	54	44
5	Palma Futsal	23	64	38	43
6	Osasuna	23	83	67	39
7	Levante	23	82	77	34
8	Jaén FS	23	66	70	33
9	Jimbee	23	67	74	27
10	Parrulo	23	68	81	26
11	Peñíscola	23	70	72	26
12	Industrias	23	61	83	25
13	Ribera	23	52	76	19
14	Córdoba	23	51	89	17
15	Sala	23	63	86	15
16	Burela FS	23	40	87	13

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Barça	30	134	65	67
2	ElPozo	30	122	78	62
3	Osasuna	30	104	75	59
4	Inter FS	30	125	66	57
5	Palma Futsal	30	102	70	55
6	Jaén FS	30	94	81	49
7	Ribera	30	108	92	46
8	Levante	30	105	99	45
9	Peñíscola	30	77	79	44
10	Jimbee	30	104	109	40
11	Sala	30	82	117	33
12	Industrias	30	79	98	32
13	Parrulo	30	80	116	27
14	Viña Albali	30	83	136	22
15	Naturpellet	30	59	115	18
16	Antequera	30	67	129	14

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	137	64	71
2	Barça	30	149	66	70
3	ElPozo	30	131	70	68
4	Jaén FS	30	119	69	64
5	Osasuna	30	123	88	62
6	Palma Futsal	30	94	77	46
7	Sala	30	96	110	45
8	Ribera	30	80	91	40
9	Jimbee	30	107	111	39
10	Levante	30	104	111	31
11	Naturpellet	30	94	142	31
12	Industrias	30	90	108	29
13	Peñíscola	30	67	92	26
14	Parrulo	30	80	116	24
15	Santiago	30	84	121	19
16	Gran Canaria	30	66	185	10

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	151	59	75
2	ElPozo	30	148	61	71
3	Barça	30	135	70	70
4	Jaén FS	30	103	72	53
5	Palma Futsal	30	106	72	51
6	Osasuna	30	96	73	51
7	Peñíscola	30	105	94	48
8	Industrias	30	106	104	40
9	Ribera	30	70	85	34
10	Sala	30	94	119	32
11	Santiago	30	89	118	31
12	Levante	30	82	110	30
13	Gran Canaria	30	85	130	30
14	Jimbee	30	80	115	26
15	Burela FS	30	88	132	25
16	Jumilla	30	69	193	9

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	158	57	83
2	Barça	30	157	78	74
3	ElPozo	30	130	81	63
4	Palma Futsal	30	107	80	57
5	Ribera	30	91	75	52
6	Osasuna	30	111	85	48
7	Industrias	30	129	125	44
8	Peñíscola	30	117	116	41
9	Burela FS	30	92	108	40
10	Santiago	30	99	117	31
11	Sala	30	109	125	31
12	Jaén FS	30	86	111	28
13	Levante	30	72	128	23
14	Jumilla	30	85	135	21
15	Elche Sala	30	75	156	17
16	Antequera	30	97	138	17

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	152	60	79
2	Barça	30	149	67	74
3	ElPozo	30	152	71	73
4	Jaén FS	30	113	79	54
5	Palma Futsal	30	122	105	53
6	Osasuna	30	115	98	52
7	Ribera	30	101	91	51
8	Peñíscola	30	116	93	47
9	Burela FS	30	97	100	37
10	Sala	30	105	119	36
11	Industrias	30	140	134	32
12	Santiago	30	80	103	32
13	Jumilla	30	119	135	28
14	Levante	30	75	124	26
15	Uruguay	30	72	205	9
16	Prone Lugo	30	59	183	5

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Inter FS	28	148	58	76
2	ElPozo	28	139	69	68
3	Barça	28	115	46	68
4	Industrias	28	115	98	50
5	Osasuna	28	92	95	44
6	Jumilla	28	90	92	41
7	Ribera	28	74	80	39
8	Santiago	28	76	79	37
9	Burela FS	28	71	77	37
10	Jaén FS	28	59	83	27
11	Palma Futsal	28	87	117	26
12	Peñíscola	28	57	90	25
13	Sala	28	74	108	23
14	Prone Lugo	28	70	108	22
15	Gran Canaria	28	64	131	11

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Barça	26	133	45	67
2	ElPozo	26	117	62	59
3	Inter FS	26	103	50	57
4	Naturpellet	26	103	79	53
5	Sala	26	83	75	47
6	Osasuna	26	91	82	45
7	Santiago	26	85	71	43
8	Ribera	26	88	96	36
9	Industrias	26	110	123	32
10	Palma Futsal	26	64	81	21
11	Prone Lugo	26	75	115	21
12	Burela FS	26	48	87	19
13	Puertollano	26	37	116	11
14	Gran Canaria	26	54	109	8

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	ElPozo	30	153	69	79
2	Barça	30	149	65	74
3	Inter FS	30	123	61	64
4	Naturpellet	30	98	81	49
5	Santiago	30	85	75	47
6	Carnicer	30	101	95	45
7	Osasuna	30	92	100	45
8	Sala	30	95	96	43
9	Puertollano	30	88	98	39
10	Palma Futsal	30	98	108	37
11	Talavera	30	83	112	36
12	Ribera	30	84	106	33
13	Prone Lugo	30	93	125	29
14	Industrias	30	71	106	28
15	Cartagena	30	80	142	24
16	Benicarló	30	41	95	11

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Barça	30	127	63	70
2	ElPozo	30	138	90	65
3	Inter FS	30	111	75	61
4	Santiago	30	133	94	59
5	Palma Futsal	30	107	87	56
6	Benicarló	32	87	80	50
7	Naturpellet	30	104	95	48
8	Osasuna	30	100	96	42
9	Sala	30	93	91	40
10	Carnicer	30	95	101	35
11	Prone Lugo	30	98	105	35
12	Talavera	30	78	96	35
13	Cartagena	30	102	116	34
14	Industrias	32	85	107	30
15	Playas	30	59	108	28
16	Gestesa	30	55	168	3

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	ElPozo	30	143	84	72
2	Inter FS	30	103	68	64
3	Naturpellet	30	112	77	61
4	Santiago	30	120	86	60
5	Barça	30	97	57	57
6	Industrias	30	106	107	43
7	Osasuna	30	94	92	42
8	Carnicer	30	117	124	40
9	Prone Lugo	30	92	113	40
10	Gestesa	30	106	119	38
11	Playas	30	61	84	33
12	Sala	30	93	103	32
13	Cartagena	30	103	120	32
14	Benicarló	30	70	90	23
15	Arcebansa	30	92	122	22
16	Punctum	30	67	130	15

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	ElPozo	28	120	76	65
2	Inter FS	28	107	70	60
3	Barça	28	92	56	53
4	Autos	28	98	89	47
5	Benicarlo	28	72	62	45
6	Millenium	28	93	90	45
7	Naturpellet	28	90	72	43
8	Osasuna	28	91	88	38
9	Prone Lugo	28	80	95	37
10	Cartagena	28	92	95	36
11	Carnicer	28	97	115	29
12	Playas	28	63	93	28
13	Gestesa	28	85	103	27
14	Industrias	28	70	101	24
15	Palma Futsal	28	83	128	21

Equipos de esta liga

USO DE MEMORIA

6,635,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1201
Total Execution Time	0.1220

CADENA URL

/primera_division_futsal2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0019	SELECT type FROM routes WHERE alias = 'primera_division_futsal2022'
0.0047	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_futsal' 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 total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=108 AND type_rel = 3
0.0038	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 108 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028	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 (1289259,1265138,1264025,1263906,1261393) ORDER BY n.cover_points DESC, update_date DESC
0.0022	SELECT id,name,alias,stepParent FROM categories WHERE parentId=108 ORDER BY order_id ASC
0.0024	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 = 63424 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 108 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0030	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 = 63424 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.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* `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 = 58753 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.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 = 50469 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 44361 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 39112 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 33893 AND t.round = 30 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 = 16598 AND t.round = 30 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 = 4455 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 3019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 1935 AND t.round = 26 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* `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 = 1527 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 1159 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 923 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 734 AND t.round = 30 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-19 04:37:19' 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=2 AND last_update > '2024-04-19 04:37:19' 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-19 04:37:19' 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-19 04:37:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_futsal' 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.0020	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 = 63424 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63424 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.0020	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 = 63424 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63424 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020	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 = 63424 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63424 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051	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 = 63424 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


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