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 2024

2023/2024

Grupo 3

Segunda División B Futsal 2024 G 3

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Club Manresa	27	176	72	66
2	Sporting	27	134	72	64
3	Futsal	27	126	80	53
4	Industrias	27	122	84	49
5	Picassent	27	102	73	49
6	Cerdanyola	27	132	87	47
7	Barceloneta	27	85	68	45
8	Hospitalet	27	113	91	43
9	Corts	27	106	87	43
10	Natacio	27	117	94	41
11	Escola	27	110	101	39
12	Canet FS	27	70	107	26
13	Montsant	27	85	128	24
14	Almonacid	27	104	146	18
15	Valencia FS	27	51	120	16
16	Calvia Palma	27	44	255	0

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Ibiza	29	128	95	56
2	Cerdanyola	30	125	93	56
3	Hospitalet	30	110	81	50
4	Club Manresa	29	123	109	50
5	Futsal	30	93	84	47
6	Natacio	29	112	96	45
7	Barceloneta	29	85	76	44
8	Escola	30	118	122	42
9	Canet FS	29	101	107	40
10	Nueva Elda	29	106	93	38
11	Industrias	29	113	94	38
12	Calvia Palma	29	101	108	38
13	Picassent	29	102	115	37
14	Penya	29	88	89	36
15	Ripollet	30	73	129	22
16	Irefrank	20	16	103	4

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Futsal	30	141	81	67
2	Sala	30	139	81	64
3	Industrias	30	131	85	64
4	Club Manresa	30	152	105	59
5	Barceloneta	30	111	78	56
6	Ibiza	30	154	114	51
7	Cerdanyola	30	148	103	49
8	Hospitalet	30	130	110	46
9	Escola	30	116	129	44
10	Natacio	30	113	133	39
11	Picassent	30	92	110	38
12	Ripollet	30	96	110	36
13	Ye Faky	30	105	129	32
14	Segorbe	30	106	133	30
15	Muro FS	30	109	187	18
16	Escorial	30	56	211	4

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Lauburu	14	65	37	34
2	Otxartabe	14	73	44	34
3	Juv. Circulo	14	64	50	25
4	Zierbena	14	49	52	19
5	CD Gora	14	48	50	19
6	Laskorain	14	33	42	12
7	Kukuyaga	14	26	53	12
8	Castro	14	26	56	7

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Hospitalet	23	124	69	53
2	Futsal	23	107	69	52
3	Club Manresa	23	116	77	43
4	Barceloneta	23	85	69	41
5	Sala	23	89	81	40
6	Cerdanyola	23	98	88	36
7	Calvia Palma	23	83	91	36
8	Natacio	23	86	84	33
9	Escola	23	78	81	32
10	Lamsauto	23	89	107	30
11	Salou FS	23	77	94	29
12	Unión Santa	23	86	107	27
13	Mar Denia A	23	86	110	25
14	Ripollet B	23	84	101	22
15	Palleja FS	23	85	110	19
16	Industrias	23	82	117	14

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	C.C.R.	30	161	81	81
2	Club Manresa	30	185	111	66
3	Escola	30	126	93	59
4	Futsal	30	121	83	58
5	Palleja FS	30	163	125	53
6	Hospitalet	30	140	111	49
7	Natacio	30	139	133	44
8	Unión Santa	30	125	132	40
9	Salou FS	30	128	119	39
10	Industrias	30	86	105	37
11	Cerdanyola	30	97	108	36
12	Barceloneta	30	100	119	36
13	Lamsauto	30	125	174	36
14	Canet A	30	96	126	35
15	Segorbe	30	83	138	18
16	Isur Ciutat	30	30	147	5

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Club Manresa	30	185	95	71
2	C.C.R.	29	133	78	67
3	Palleja FS	30	161	102	59
4	Escola	30	138	87	58
5	Hospitalet	30	160	127	57
6	Catgas	30	120	89	57
7	Unión Santa	30	122	107	49
8	Salou FS	29	123	131	43
9	Cerdanyola	30	92	102	38
10	Natacio	30	153	167	38
11	Futsal	30	103	106	37
12	Barceloneta	30	101	114	37
13	Canet A	30	89	125	26
14	Olimpic	30	87	134	23
15	Dénia	30	61	155	15
16	FS Linyola	30	89	198	5

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Bisontes	30	129	69	77
2	C.C.R.	30	140	76	76
3	Unión-Bosco	30	134	94	63
4	Unión Santa	30	124	88	55
5	L'olleria	30	131	91	53
6	Escola	30	111	104	52
7	Cerdanyola	30	112	99	42
8	Hospitalet	30	131	128	42
9	Club Manresa	30	107	121	36
10	Natacio	30	110	135	35
11	Salou FS	30	101	138	33
12	Olimpic	30	87	117	31
13	Barceloneta	29	90	121	27
14	Sala	30	86	127	27
15	Ripollet	30	102	129	24
16	Peña	29	91	149	18

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	C.C.R.	34	159	81	79
2	Unión Santa	34	147	90	70
3	Escola	34	157	113	68
4	Playas	34	117	85	60
5	Unión-Bosco	34	138	121	56
6	Club Manresa	34	146	131	55
7	Hospitalet	34	150	138	48
8	Sala	34	120	122	46
9	Barceloneta	33	123	133	44
10	Ripollet	34	107	137	44
11	Salou FS	34	133	136	42
12	Palleja FS	34	142	160	42
13	Peña	33	123	141	41
14	Olimpic	34	104	139	40
15	Riera Nivell	34	108	121	40
16	Penya	34	109	146	34
17	Esparreguera	34	113	151	28
18	Montcada	34	94	145	22

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Escola	30	142	91	66
2	Palleja FS	30	133	107	57
3	Riera Nivell	30	140	100	56
4	Garcia FS B	30	120	94	53
5	Ripollet	30	153	136	51
6	F.s.c.e.Bar	30	136	119	50
7	Club Manresa	30	133	115	46
8	Olimpic	30	119	114	46
9	Playas Salou	30	126	132	42
10	Unión-Bosco	30	93	107	42
11	Montcada	30	125	129	37
12	Sala	30	102	118	36
13	Hospitalet	30	118	131	34
14	Esparreguera	30	94	118	29
15	Cover Premia	30	141	179	28
16	Natacio	30	68	153	6

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Hospitalet	1	10	0	3
2	Escola	1	8	0	3
3	Montcada	1	5	2	3
4	Fsce Casa F.	1	4	1	3
5	Vilassar	1	6	4	3
6	Unión Santa	1	6	4	3
7	Sala	1	3	1	3
8	Rapid Santa	1	2	2	1
9	Sant Andreu	1	2	2	1
10	Esparreguera	1	4	6	0
11	Petromiralle	1	4	6	0
12	Union Palmas	1	1	3	0
13	Cover Premia	1	2	5	0
14	Sicoris Club	1	1	4	0
15	Santa	1	0	8	0
16	Centelles	1	0	10	0

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Dominicos	30	127	55	76
2	Sporting	30	177	78	73
3	Cover Premia	30	139	110	64
4	Peñíscola	30	142	88	61
5	Sicoris Club	30	118	74	60
6	Club Manresa	30	127	91	51
7	Escola	30	106	87	46
8	Fsce Casa F.	30	137	121	41
9	Vilassar	30	112	103	40
10	Centelles	30	120	113	40
11	Union Palmas	30	96	112	37
12	Rapid Santa	30	93	112	34
13	Salou FS	30	100	133	32
14	Asoc. Amigos	30	98	157	25
15	Gava Futsal	30	80	158	12
16	Pastilla	30	0	180	0

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	UDRB	26	141	62	66
2	El Escorial	26	142	100	57
3	Leganes	26	132	84	54
4	Pilaristas-f	26	132	116	44
5	Escuela Caja	26	102	91	44
6	Cd Albense	26	91	95	39
7	Univ.	26	123	113	37
8	Sport Sala.	26	107	119	31
9	Simancas FS	26	110	136	31
10	Loeches FS	26	103	119	30
11	Distrito	26	109	128	28
12	Atco.	26	79	106	26
13	Collado	26	88	139	25
14	AD Arlequin	26	101	152	13

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Burgos CFS	30	169	128	63
2	UDRB	30	151	99	61
3	Albense	30	132	100	56
4	Univ.	30	139	127	54
5	Loeches	30	124	111	52
6	Sport Sala.	30	143	122	51
7	Atco.	30	114	114	46
8	Admon.	30	116	125	46
9	Sala Arganda	30	128	139	37
10	Collado	30	109	134	35
11	Simancas FS	30	129	134	34
12	Pilaristas-f	30	132	143	34
13	Humanes FS	30	131	144	34
14	Juventud	30	143	159	34
15	Colmenarejo	30	126	161	26
16	Sercom	30	113	159	23

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	El Escorial	32	186	108	70
2	Burgos CFS	32	174	126	64
3	CD Valverde	32	169	113	59
4	UDRB	32	149	99	59
5	Loeches	32	135	108	59
6	Uni.	32	167	147	54
7	Ciudad	32	143	130	53
8	Simancas FS	32	123	120	50
9	Pilaristas	32	151	154	49
10	Sala Arganda	32	130	140	42
11	Collado	32	137	159	40
12	Cd Albense	32	105	121	39
13	Admon.	32	128	166	39
14	Humanes FS	32	153	170	36
15	Unión Tres	32	111	159	36
16	Palacios	32	109	125	30
17	Tancitaro	32	104	229	2

Equipos de esta liga

USO DE MEMORIA

6,697,544 bytes

BENCHMARKS

Loading Time Base Classes	0.0025
Controller Execution Time ( Home / Category )	0.4412
Total Execution Time	0.4437

CADENA URL

/segunda_division_b_futsal2024/grupo3/historico

GET DATOS

$_GET['/segunda_division_b_futsal2024/grupo3/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0218	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_b_futsal' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110 AND type_rel = 3
0.0110	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 110 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0112	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 (1015780,872854,838700,758569,754510) ORDER BY n.cover_points DESC, update_date DESC
0.0111	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 = 74083 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 110 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0117	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* `tables2024` 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 = 74083 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 68839 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.0118	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 = 63774 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.0119	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 = 58894 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.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* `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 = 51026 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.0126	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 = 44514 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 40226 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 35140 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 16953 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 4611 AND t.round = 30 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 = 2203 AND t.round = 1 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* `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 = 1792 AND t.round = 30 ORDER BY team.conference 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* `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 = 1225 AND t.round = 30 ORDER BY team.conference 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* `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 = 927 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116	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 = 739 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 09:15:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 09:15:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 09:15:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 09:15:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_b_futsal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107	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 events2024 e ON e.player_id = p.id AND e.league_id = 74083 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74083 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.0106	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 events2024 e ON e.player_id = p.id AND e.league_id = 74083 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74083 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0107	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 events2024 e ON e.player_id = p.id AND e.league_id = 74083 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74083 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` 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 = 74083 AND t.round = 29 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