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

Centro - 1ª Fase

Torneo Regional Federal Amateur 2024 G 1

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Rioja	6	8	3	15
2	Defensores	6	8	3	12
3	Andes	6	3	5	6
4	Defensores	6	2	10	3
5	Barrio	6	13	7	10
6	Américo	6	11	10	10
7	Martín	6	6	6	9
8	Facundo	6	9	16	6
9	Andino	4	7	0	8
10	Deportivo	4	3	1	8
11	Federación	4	1	10	0
12	Lorenzo Alem	4	11	0	12
13	Ferrocarril	4	3	5	6
14	Atlético	4	1	10	0
15	Villa Cubas	6	12	7	13
16	Coronel Daza	6	11	6	12
17	Sportivo	6	6	11	6
18	Martín	6	7	12	4
19	Lorenzo	6	11	4	14
20	Boulevard	6	10	3	13
21	River Unido	6	7	14	4
22	Racing Belen	6	5	12	3
23	Alumni Villa	6	9	5	12
24	Sarmiento	6	9	5	12
25	Unión	6	6	8	7
26	Almafuerte	6	4	10	4
27	Deportivo	6	6	3	10
28	Deportivo	5	6	2	9
29	Sportivo	5	3	4	5
30	Bernardino	6	2	8	5
31	Atlético	6	12	3	12
32	Universitari	6	13	6	9
33	Unión	6	3	9	7
34	Vélez Oliva	6	6	16	3
35	General	4	3	1	6
36	Deportivo	4	3	3	4
37	Tiro Federal	4	2	4	3
38	Lautaro	4	9	3	10
39	Belgrano	4	6	8	6
40	Cultural	4	2	6	1
41	Julio	6	10	3	13
42	Gutierrez	6	11	7	8
43	Talleres	6	7	9	7
44	Vecinos	6	3	12	5
45	Atlético	6	10	5	13
46	Toro	6	12	8	13
47	Deportivo	6	10	9	7
48	Villa Plomo	6	3	13	1
49	Tintina	4	5	3	7
50	Platense	3	3	4	4
51	Ensenada	3	3	4	3
52	Unión	6	8	2	11
53	Vélez	6	10	6	10
54	Mayo Termas	6	7	11	7
55	Atlético	6	5	11	5
56	Sarmiento	6	20	1	16
57	Comercio	6	6	4	13
58	Jose	6	2	12	4
59	Fida Arenal	6	0	11	1
60	Sportivo	4	7	2	12
61	Independient	4	8	7	4
62	Instituto	4	3	9	1

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Estudiantes	6	10	3	16
2	Unión	6	17	4	13
3	Talleres	6	5	13	6
4	Unión	6	4	16	0
5	Sarmiento	6	26	3	16
6	Barrio Adela	6	7	10	10
7	Deportivo	6	8	21	4
8	Villa	6	4	11	3
9	Vélez	6	12	2	14
10	Independient	6	9	4	10
11	Mayo Termas	6	3	10	4
12	Talleres	6	6	14	4
13	Antonio	4	5	2	7
14	Jorge	4	4	3	7
15	Mamerto	4	1	5	2
16	Atlético	6	11	3	14
17	Lorenzo Alem	6	11	6	11
18	Deportivo	6	7	12	6
19	Villa Cubas	6	7	15	2
20	Martín	6	16	8	13
21	Instituto	6	11	12	7
22	Independient	6	8	9	7
23	Atlético	6	7	13	5
24	Andino	6	11	2	16
25	Barrio	6	9	5	13
26	Andes	6	6	11	3
27	Atlético	6	4	12	3
28	Deportivo	6	6	3	12
29	Unión	6	5	5	7
30	Unión	6	7	8	6
31	Vélez Oliva	6	4	6	5
32	Sportivo	5	6	2	10
33	Sarmiento	5	8	4	9
34	Argentino	6	7	6	7
35	Julio	6	3	12	6
36	Deportivo	4	8	3	9
37	Sportivo	4	4	3	7
38	Sportivo	4	0	6	1
39	CSyB Atenas	5	9	3	13
40	Camioneros	6	7	5	9
41	Atlético	5	9	6	8
42	Cultural	6	4	15	0
43	Alumni Villa	4	6	1	12
44	Deportivo	4	5	4	4
45	Alem Villa.	4	1	7	1
46	General	4	10	4	12
47	Atlético	4	6	8	3
48	Acción	4	5	9	3

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Unión	6	13	2	14
2	Sarmiento	6	14	6	13
3	Unión	6	7	12	6
4	Martín	6	1	15	1
5	Deportivo	4	10	3	9
6	Racing	4	3	6	6
7	Atlético	4	5	9	3
8	Lorenzo Alem	6	11	1	16
9	Dep. Bañado	6	8	6	11
10	Coronel Daza	6	4	7	4
11	Defensores	6	4	13	3
12	Andino	6	15	4	13
13	Américo	6	19	8	9
14	Unión	6	8	10	9
15	Andes	6	3	23	1
16	Francisco	4	8	6	7
17	Atlético	4	8	8	6
18	Barrio	4	4	6	4
19	General	4	9	5	9
20	Deportivo	4	8	5	9
21	Independient	4	3	10	0
22	Atlético	6	8	1	14
23	Deportivo	6	5	2	8
24	Avellaneda	6	2	4	6
25	Julio	6	3	11	4
26	Unión	4	8	5	7
27	Escuela	4	4	3	7
28	Argentino	4	4	8	2
29	Sarmiento	6	7	2	11
30	Atlético	6	9	6	10
31	Deportivo	6	10	6	8
32	Defensores	6	5	17	4
33	Acción	6	22	3	16
34	Argentino	6	6	2	10
35	Olimpo	6	5	17	6
36	Villa Plomo	6	6	17	3
37	Toro	6	11	9	12
38	Sportivo	6	6	4	11
39	Juventud	6	6	5	8
40	CSyB Atenas	6	4	9	2

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Talleres	5	12	6	10
2	Altos Hornos	5	11	6	9
3	Atletico	5	7	14	4
4	Atlético	5	5	9	3
5	Merced Salta	5	6	4	7
6	Gimnasia	5	8	10	7
7	Villa	5	8	8	6
8	Juventud	5	5	5	5
9	Sportivo	5	7	7	8
10	Atlético	5	8	5	7
11	Deportivo	5	9	9	7
12	Deportivo	5	6	9	4

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Sportivo	6	13	7	13
2	Unión	6	15	7	10
3	Independient	6	9	10	8
4	Costanera	6	6	19	2
5	Vélez	6	14	3	14
6	Atlético	6	7	11	8
7	Talleres	6	10	13	5
8	Tintina	6	8	12	5
9	Lorenzo Alem	4	7	2	10
10	Instituto	4	6	7	4
11	Unión	4	8	12	3
12	Martín	4	7	4	8
13	Atlético	4	8	6	5
14	Dep. Bañado	4	5	10	2
15	Lorenzo	4	4	2	7
16	Tiro Federal	3	3	1	6
17	Peñarol	3	1	5	1
18	Martín	6	8	5	10
19	Andes	6	13	8	9
20	Buenaventura	6	9	11	6
21	Federación	6	5	11	4
22	Andino	6	14	7	14
23	Américo	5	11	9	7
24	Rioja	6	7	11	4
25	Barrio	5	5	10	2
26	Argentino	6	13	2	14
27	Sportivo	6	15	11	10
28	Deportivo	6	6	6	9
29	Independient	6	7	22	0
30	Belgrano	6	12	7	11
31	CSyB Atenas	6	11	10	9
32	Sportivo	6	10	10	7
33	Atlético	6	7	13	5
34	Racing	6	13	2	16
35	Atlético	6	8	6	9
36	Julio	6	5	10	4
37	Julio	6	3	11	4
38	Atlético	6	11	4	11
39	Sarmiento	6	7	6	10
40	Uniiversitar	6	7	8	9
41	Newbery	6	6	13	4
42	General	6	13	5	10
43	Unión	6	16	13	10
44	Juventud	6	11	10	10
45	Defensores	6	11	23	4

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Vélez	8	17	6	16
2	Unión	8	14	8	12
3	Atlético	8	14	14	11
4	Belgrano	8	9	14	9
5	Sportivo	8	11	23	7
6	Central	10	16	9	18
7	Independient	10	18	14	18
8	Sportivo	10	10	8	18
9	Sarmiento	10	14	8	16
10	Tintina	10	17	14	12
11	Deportivo	10	6	28	0
12	Club	8	21	2	22
13	Instituto	8	12	18	9
14	Comercio	8	8	10	7
15	Atlético	8	8	12	7
16	Dep. Bañado	8	7	14	7
17	Deportivo	8	15	3	13
18	Defensores	8	11	6	13
19	Defensores	8	10	8	11
20	Luis Belén	8	7	11	11
21	Merced	8	7	22	5
22	Andino	10	18	11	19
23	Atlético	10	16	12	17
24	Américo	10	10	10	13
25	Barrio	10	10	17	12
26	Juventud	10	14	16	11
27	Defensores	10	13	15	9
28	Sarmiento	8	10	7	13
29	Acción	8	9	4	12
30	Martín	8	9	12	10
31	Atlético	8	8	9	8
32	Social	8	8	12	7
33	CSyB Atenas	10	14	10	17
34	Atlético	10	13	8	16
35	Juventud	10	12	10	16
36	Unión	10	13	10	13
37	Deportivo	10	9	15	10
38	Alumni Villa	10	9	17	10
39	Deportivo	10	18	11	20
40	Alm. Brown.	10	15	8	20
41	Deportivo	10	16	11	15
42	Lorenzo	10	17	13	15
43	Deportivo	10	19	17	13
44	River Plate	10	10	35	1
45	General	6	9	5	13
46	Tiro Federal	6	5	3	10
47	Julio	6	7	9	9
48	Argentino	6	5	9	2

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Club	18	30	10	44
2	Vélez	18	24	11	32
3	Atlético	18	23	18	27
4	Sarmiento	18	18	17	25
5	Central	18	19	24	22
6	Comercio	18	16	25	21
7	Instituto	18	17	21	20
8	Unión	18	21	26	20
9	Defensores	18	22	30	20
10	Andino	18	15	23	17
11	Racing	18	27	10	37
12	Sarmiento	18	22	13	34
13	CSyB Atenas	18	17	14	24
14	Tiro Federal	18	17	16	24
15	Alm. Brown.	18	16	17	23
16	Alumni Villa	18	19	22	23
17	Atlético	18	22	21	22
18	Juventud	18	15	27	22
19	Argentino	18	18	23	19
20	Banda Norte	18	11	21	18

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Racing	8	20	8	16
2	Sol de Mayo	8	20	17	14
3	Cruz	8	14	17	10
4	Independient	8	16	25	9
5	CAI	8	16	19	8

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Germinal	20	36	12	42
2	Huracán	20	36	18	37
3	Boxing Club	20	25	14	34
4	Cruz	20	26	23	33
5	Racing	20	29	19	32
6	Sol de Mayo	20	29	28	30
7	Mayo Pampa	20	20	22	28
8	Independient	20	24	32	25
9	Deportivo	20	26	38	21
10	Belgrano	20	14	35	11
11	Atlético	20	20	44	10
12	Petrolero	0	0	0	0

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Central	21	42	23	36
2	Central	22	37	23	35
3	Famaillá	21	38	41	30
4	Atlético	20	25	22	29
5	General	20	25	24	29
6	Concepción	22	25	40	25
7	Gimnasia	21	28	30	24
8	Ñuñorco	21	21	38	19
9	Patronato	21	32	11	48
10	Guaraní	21	27	24	35
11	Chaco Ever	21	26	28	28
12	Crucero	21	26	26	25
13	Colegiales	21	23	27	25
14	América	21	20	29	24
15	Gualeguaychu	21	16	18	22
16	Textil	21	22	29	21
17	Atenas	22	32	21	44
18	Dep. Maipú	22	27	14	38
19	Martín	21	31	22	30
20	Guaymallén	21	25	27	30
21	Estudiantes	23	27	30	29
22	Argentino	21	27	27	27
23	Trinidad	21	22	32	21
24	Juventud	21	15	33	16
25	Douglas Haig	21	37	29	38
26	Sportivo	22	32	22	35
27	Defensores	22	25	23	34
28	La Emilia	21	33	29	33
29	Julio	21	22	23	31
30	Tiro Federal	22	25	31	25
31	Sportivo	22	21	27	23
32	Gimnasia	21	18	29	19
33	Linqueño	22	44	20	51
34	Alvarado	22	32	22	37
35	Grupo	21	39	33	36
36	Racing	21	37	29	30
37	Defensores	21	25	32	23
38	Sporting	21	19	40	20
39	Tres	21	28	36	19
40	CD Coreano	21	25	37	19
41	Deportivo	21	42	28	40
42	CA Liniers	21	29	21	38
43	Bella Vista	21	36	29	38
44	Dep. Roca	21	25	23	29
45	Independient	21	33	34	29
46	Racing	21	32	36	24
47	Cruz	21	41	46	22
48	Atlético	21	17	38	15

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Cipolletti	13	25	10	27
2	Deportivo	14	23	17	22
3	Independient	14	23	17	20
4	Dep. Roca	14	17	20	18
5	Cruz	13	18	18	16
6	Huracán	14	17	20	16
7	Racing	14	18	28	15
8	Alianza	14	17	28	12
9	Alvarado	14	19	13	22
10	Cadetes	14	18	17	21
11	Sporting	14	18	19	20
12	Bella Vista	14	21	17	19
13	Grupo	14	23	19	18
14	Villa Parque	14	16	20	18
15	CD Coreano	14	13	18	13
16	Racing	14	13	18	12
17	Dep. Maipú	14	17	12	24
18	Trinidad	14	21	16	21
19	Estudiantes	14	14	12	20
20	Sportivo	14	17	17	20
21	Guaymallén	14	16	14	19
22	General	14	14	14	19
23	Centenario	14	11	14	17
24	Juventud	14	10	21	13
25	Linqueño	14	25	17	24
26	Libertad	14	18	12	22
27	La Emilia	14	15	14	21
28	Gualeguaychu	14	19	20	18
29	Patronato	14	15	20	18
30	Gimnasia	13	13	13	17
31	Atlético	14	12	17	14
32	Sportivo	13	13	17	10
33	Central	13	21	11	25
34	Atlético	14	18	14	25
35	Julio	13	21	13	22
36	Sportivo	14	12	12	20
37	Independient	13	18	17	18
38	Concepción	13	14	14	17
39	Gimnasia	14	22	30	11
40	Ñuñorco	14	6	21	8
41	Textil	14	14	10	23
42	Chaco Ever	13	15	9	21
43	Crucero	13	14	9	21
44	Boca Unidos	14	14	15	20
45	América	14	10	11	18
46	Candelaria	14	9	13	16
47	Guaraní	14	15	20	12
48	Sarm.	14	9	13	11

Equipos de esta liga

USO DE MEMORIA

9,472,432 bytes

BENCHMARKS

Loading Time Base Classes	0.0026
Controller Execution Time ( Home / Category )	0.5000
Total Execution Time	0.5027

CADENA URL

/torneo_federal_b2024/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (25)

0.0126	SELECT type FROM routes WHERE alias = 'torneo_federal_b2024'
0.0255	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0126	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1814 ORDER BY order_id ASC
0.0133	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 = 74425 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1814 AND group_code = 1 and tables = 1 AND year <= 2024 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* `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 = 74425 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 70016 AND t.round = 6 ORDER BY team.conference ASC,t.position 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* `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 = 65999 AND t.round = 6 ORDER BY team.conference ASC,t.position 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* `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 = 60918 AND t.round = 6 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 = 53813 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 49513 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 39145 AND t.round = 18 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* `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 = 20286 AND t.round = 10 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 = 15581 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables2008` 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 = 27963 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2007` 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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:38:44' 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-27 17:38:44' 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-27 17:38:44' 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=3 AND last_update > '2024-04-27 17:38:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' 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.0126	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 = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 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.0126	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 = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128	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 = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157	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 = 74425 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC