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

« Temporada Anterior

Temporada 2024

2023/2024

Grupo H

Serie D 2024 G 8

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Team	33	50	22	71
2	Martina	33	50	22	65
3	Nardò	33	50	24	62
4	Fidelis	33	56	31	58
5	Virtus	33	43	31	52
6	Matera	33	44	36	52
7	Paganese	33	40	40	45
8	Palmese	33	46	51	44
9	Gelbison	33	40	35	43
10	Rotonda	33	36	35	42
11	Manfredonia	33	30	37	42
12	Gravina	33	49	44	40
13	Città	33	35	55	38
14	Angri	33	34	52	36
15	Gallipoli	33	26	48	32
16	Barletta	33	30	44	30
17	USD Bitonto	33	21	43	30
18	Santa Maria	33	22	52	25

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Brindisi	34	59	27	69
2	Cavese 1919	34	66	35	69
3	Nardò	34	51	26	65
4	Barletta	34	42	29	64
5	Virtus	34	46	32	57
6	Team	34	51	37	56
7	Matera	34	53	46	50
8	Martina	34	40	43	45
9	Città	34	43	43	44
10	USD Bitonto	34	45	51	43
11	Afragolese	34	41	45	39
12	Gladiator	34	42	55	37
13	Nocerina	34	40	51	36
14	Gravina	34	29	41	36
15	Molfetta	34	40	50	32
16	Francavilla	34	38	51	30
17	Lavello	34	31	68	26
18	Puteolana	34	32	59	19

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Audace	38	83	27	88
2	Francavilla	38	62	44	71
3	USD Bitonto	38	56	40	65
4	Città	38	63	50	62
5	Nocerina	38	55	48	58
6	Gravina	38	51	49	56
7	Casertana	38	56	52	55
8	Sorrento	38	41	50	52
9	Nola 1925	38	50	58	51
10	Brindisi	38	42	55	49
11	Molfetta	38	48	45	48
12	Team	38	48	45	47
13	Mariglianese	38	43	46	47
14	Virtus	38	37	49	47
15	Lavello	38	49	56	45
16	Nardò	38	59	67	45
17	Rotonda	38	39	46	42
18	Giorgio	38	30	44	41
19	Bisceglie	38	32	47	39
20	Virtus	38	36	62	30

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Taranto	34	50	23	69
2	Picerno	34	58	34	68
3	Fidelis	34	40	18	61
4	USD Bitonto	34	51	42	55
5	Virtus	34	49	39	55
6	Lavello	34	55	40	54
7	Audace	34	62	39	52
8	Nardò	34	45	39	49
9	Team	34	49	42	47
10	Molfetta	34	54	60	42
11	Sorrento	34	41	54	41
12	Gravina	34	33	40	35
13	Città	34	38	50	35
14	Brindisi	34	27	45	35
15	Francavilla	34	34	48	34
16	Real Agro A.	34	40	57	34
17	Portici	34	50	73	34
18	Puteolana	34	23	56	26

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	USD Bitonto	26	45	10	55
2	Calcio	26	33	16	54
3	Sorrento	26	38	21	50
4	Audace	26	45	27	49
5	Virtus	26	34	28	42
6	Taranto	26	32	21	40
7	Città	26	35	31	35
8	Gravina	26	36	32	34
9	Gelbison	26	20	22	34
10	Gladiator	26	25	27	33
11	Team	26	31	29	32
12	Brindisi	26	23	35	31
13	Fidelis	26	31	41	29
14	Grumentum	26	27	39	27
15	Nocerina	26	30	45	27
16	Francavilla	26	24	35	25
17	Nardò	26	24	35	25
18	Agropoli	26	14	53	14

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Picerno	34	67	24	81
2	Audace	34	68	28	75
3	Taranto	34	65	28	71
4	USD Bitonto	34	54	31	59
5	Savoia 1908	34	40	27	59
6	Fidelis	34	37	26	56
7	Città	34	58	50	50
8	Gravina	34	48	43	48
9	Team	34	43	49	47
10	Sorrento	34	47	50	43
11	Francavilla	34	30	35	43
12	Nardò	34	30	39	37
13	Gelbison	34	37	49	37
14	Sarnese	34	32	50	36
15	Nola 1925	34	36	55	36
16	Gragnano	34	30	43	33
17	Pomigliano	34	17	59	19
18	Granata 1924	34	21	74	14

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Potenza	34	81	28	81
2	Cavese 1919	34	68	31	76
3	Team	34	56	38	69
4	Taranto	34	62	38	68
5	Audace	34	60	38	62
6	Picerno	34	49	37	53
7	Gravina	34	58	42	52
8	Nardò	34	48	36	52
9	Gragnano	34	34	40	42
10	Sarnese	34	49	54	40
11	Turris	34	35	46	40
12	Francavilla	34	59	70	39
13	Pomigliano	34	41	46	37
14	San Severo	34	35	48	33
15	Nerostellati	34	26	50	33
16	Real Agro A.	34	31	56	30
17	Manfredonia	34	41	85	19
18	Sporting	34	35	85	14

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Bisceglie	34	67	31	74
2	Trastevere	34	60	32	73
3	Nocerina	34	62	31	64
4	Gravina	34	45	23	61
5	Nardò	34	49	35	60
6	Gelbison	34	50	44	47
7	Picerno	34	42	37	47
8	Herculaneum	34	36	34	46
9	Potenza	34	43	44	45
10	Manfredonia	34	50	53	44
11	Francavilla	34	34	38	43
12	Anzio	34	41	49	41
13	San Severo	34	42	45	40
14	C.S. Vultur	34	37	44	38
15	Madrepietra	34	43	57	37
16	Agropoli	34	38	70	26
17	Cynthia	34	31	59	22
18	Polisportiva	34	37	81	20

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Virtus	34	45	26	66
2	Taranto	34	61	34	63
3	Francavilla	34	61	35	61
4	Nardò	34	49	26	60
5	Fondi	34	75	52	52
6	Manfredonia	34	45	49	50
7	Pomigliano	34	47	46	47
8	Bisceglie	34	42	44	47
9	Progreditur	34	40	38	45
10	Torrecuso	34	57	50	44
11	San Severo	34	58	59	44
12	Isola Liri	34	42	45	44
13	Potenza	34	43	58	44
14	Turris	34	40	50	43
15	Serpentara	34	44	50	41
16	Picerno	34	43	60	30
17	Aprilia	34	37	63	28
18	Gallipoli	34	25	69	21

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Fidelis	34	64	39	74
2	Taranto	34	53	24	69
3	Potenza SC	34	59	46	67
4	Cavese 1919	34	72	44	62
5	Bisceglie	34	57	33	62
6	Brindisi	34	64	44	60
7	Gelbison	34	43	41	49
8	Manfredonia	34	44	45	44
9	Sarnese	34	51	57	44
10	Gallipoli	34	42	52	44
11	Monopoli	34	48	39	43
12	Francavilla	34	42	43	39
13	San Severo	34	45	53	39
14	Pomigliano	34	35	50	38
15	Arzanese	34	40	50	33
16	Scafatese	34	30	52	29
17	Puteolana	34	22	64	24
18	Grottaglie	34	28	63	23

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Matera	32	48	22	64
2	Taranto	32	56	37	62
3	Turris	32	45	26	58
4	Monopoli	32	48	32	57
5	Progreditur	32	60	34	56
6	Brindisi	32	51	35	54
7	Francavilla	32	48	40	49
8	Bisceglie	32	46	39	44
9	Gelbison	32	36	42	42
10	San Severo	32	31	46	39
11	Manfredonia	32	36	48	38
12	Mariano	32	39	54	37
13	Nola 1925	32	28	41	33
14	Puteolana	32	26	35	30
15	Real	32	29	42	29
16	Gladiator	32	23	53	27
17	Grottaglie	32	30	54	26
18	Nardò	0	0	0	0

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Ischia	34	74	19	86
2	Matera	34	68	38	70
3	Gladiator	34	58	26	69
4	Monopoli	34	60	30	65
5	Calcio	34	53	34	58
6	Bisceglie	34	57	41	56
7	Taranto	34	50	46	50
8	Brindisi	34	45	44	44
9	Campania	34	34	35	44
10	Francavilla	34	49	53	44
11	Battipaglies	34	44	47	43
12	Pomigliano	34	33	38	43
13	Puteolana	34	39	44	42
14	Nardò	34	34	38	41
15	Sant Antonio	34	38	43	37
16	Grottaglie	34	35	68	29
17	Fortis Trani	34	16	75	12
18	Potenza SC	34	17	85	9

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Martina	34	61	23	72
2	Sarnese	34	69	29	71
3	Ischia	34	65	38	66
4	Casertana	34	64	34	65
5	Brindisi	34	58	42	59
6	Turris	34	63	41	57
7	Francavilla	34	48	39	56
8	Campania	34	31	26	52
9	Virtus	34	40	31	45
10	Nardò	34	30	43	43
11	Fortis Trani	34	46	51	41
12	Internapoli	34	31	46	37
13	Irsinese	34	40	51	36
14	Grottaglie	34	35	52	35
15	Real Nocera	34	32	56	27
16	Viribus	34	29	61	27
17	Angelo	34	30	61	23
18	Gaeta	34	23	71	23

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Ebolitana	34	63	18	83
2	Forza	34	63	24	80
3	Casertana	34	58	26	67
4	Sambiase	34	45	31	59
5	Nissa	34	42	27	56
6	Turris	34	66	46	54
7	ACR Messina	35	39	46	50
8	Valle	34	51	42	49
9	HinterReggio	34	39	36	48
10	Sapri Calcio	34	51	47	44
11	Noto	34	39	43	43
12	Cittanova	35	31	36	43
13	Real Nocera	34	39	43	42
14	Acireale	34	35	40	40
15	Modica	34	30	45	38
16	Marsala	34	30	49	32
17	Rossanese	34	26	51	31
18	Mazara 1946	34	46	63	30
19	Nola 1925	34	18	98	9

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Turris	68	119	90	117
2	Francavilla	68	80	85	82
3	ASD Pianura	34	62	33	69
4	Virtus	34	56	28	65
5	Forza	34	61	45	62
6	Sant Antonio	34	53	38	57
7	Pomigliano	34	41	36	55
8	Casertana	34	38	32	52
9	Matera	34	43	44	46
10	Grottaglie	34	47	44	44
11	Ostuni Sport	34	38	51	41
12	Angri	34	37	53	40
13	Omnia	35	36	50	36
14	Bacoli	34	36	51	33
15	Ischia	34	27	47	32
16	Pisticci	35	28	49	32
17	Città	34	23	49	23

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Brindisi	34	61	28	70
2	ASD Pianura	34	71	39	60
3	Nocerina	33	51	40	60
4	Pomigliano	34	56	41	56
5	Ischia	34	43	29	55
6	Turris 1944	34	40	37	54
7	Matera	34	42	33	47
8	Virtus	34	35	39	47
9	Città	34	41	36	46
10	Francavilla	33	36	33	45
11	Bacoli	34	43	41	45
12	Angri	33	33	41	42
13	Sant Antonio	34	34	44	42
14	Omnia	33	33	47	37
15	Grottaglie	34	31	41	36
16	Sporting	34	27	52	32
17	Gelbison	34	35	56	24
18	US Venafro	34	25	60	20

JUGADORES DESTACADOS

Nombre	Goles	Equipo
Mateus	17	FBC
A. Croce	15	GEL
R. Palermo	15	MAR
N. Loiodice	15	ASD
Domenico Santoro	11	FBC
L. Fernández	10	ROT
E. Tedesco	9	USB
I. Battista	9	ASF
S. D'anna	9	NAR
M. Rajković	8	VIR

Equipos de esta liga

USO DE MEMORIA

7,398,624 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1563
Total Execution Time	0.1582

CADENA URL

/serie_d2024/grupo8/historico

GET DATOS

$_GET['/serie_d2024/grupo8/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0018	SELECT type FROM routes WHERE alias = 'serie_d2024'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d' AND (l.group_code = 8 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=8 DESC LIMIT 1
0.0018	SELECT id,name,alias,stepParent FROM categories WHERE parentId=222 ORDER BY order_id ASC
0.0019	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 = 73986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 8 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 73986 AND t.round = 33 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* `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 = 68754 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* `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 = 64282 AND t.round = 38 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* `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 = 58833 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.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* `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 = 51163 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 = 44803 AND t.round = 34 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 = 39601 AND t.round = 34 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 = 33456 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* `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 = 15656 AND t.round = 34 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* `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 = 4821 AND t.round = 34 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 = 24686 AND t.round = 34 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* `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 = 2094 AND t.round = 34 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* `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 = 1698 AND t.round = 34 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* `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 = 24703 AND t.round = 36 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* `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 = 24716 AND t.round = 36 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 = 24735 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-30 11:09:26' 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-30 11:09:26' 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=4 AND last_update > '2024-04-30 11:09:26' 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-30 11:09:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0166	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 = 73986 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73986 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.0261	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 = 73986 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73986 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033	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 = 73986 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73986 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048	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 = 73986 AND t.round = 33 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
A. D'Auria	2	SMC
Sante Russo	2	FIA
A. Dieng	2	MAR
M. De Gol	2	FBC
Luigi Gianfreda	2	USB
Murilo Gomes	1	USB
Ciro Cipolletta	1	MAT
Lucio Brunetti	1	SSM
M. Gennari	1	NAR
N. Strambelli	1	FIA

Nombre	Amarillas	Equipo
G. Rizzo	13	MAR
Ciro Cipolletta	13	MAT
Murilo Gomes	12	USB
Samuele Manfredi	11	ASF
T. Kosovan	10	GEL
Luigi Gianfreda	10	USB
M. Fissore	10	SSM
M. Picascia	10	ACC
B. Addae	10	NAR
G. Chironi	9	SMC