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

3ª Andaluza Cádiz 2024 G 1

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Tesorillo	21	52	22	49
2	Medina	21	53	23	49
3	Jimena	21	49	25	38
4	Barrios	21	52	30	38
5	CD Benalup	22	47	34	38
6	Castellar	22	63	41	35
7	CD Rivera	21	52	50	30
8	Rock Puente	22	41	52	26
9	Facinas	22	38	70	18
10	Atlético	21	22	44	16
11	Bahia	21	24	59	12
12	Rayo Alcalá	21	23	66	11

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Sanluqueño	34	121	23	86
2	Olvera	34	97	23	80
3	Tarifa UD	34	88	37	75
4	Veteranos	34	94	54	73
5	Jose Obrero	34	91	45	68
6	Puerto	34	76	47	57
7	Espera C.F.	34	80	63	53
8	Trebujena	34	77	75	51
9	Alcalá	34	64	68	49
10	Ud Bornense	34	64	53	48
11	San Benito	34	75	72	43
12	Unión	34	82	99	40
13	Facinas	34	61	76	35
14	Bahia	34	72	95	32
15	Tiempo Libre	34	34	92	24
16	Prado	34	60	106	19
17	Atlético	34	57	129	11
18	Federico	34	24	160	4

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Jose	20	54	20	47
2	Athletic	20	53	21	43
3	San Benito	19	55	33	43
4	Veteranos	20	62	39	38
5	Facinas	20	52	46	34
6	Union	19	36	41	26
7	Unión	20	36	41	26
8	Trebujena	20	37	45	21
9	Sherry	20	24	39	16
10	Bahia	20	25	56	13
11	Federico	20	18	71	7
12	Rock Puente	0	0	0	0

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Ciudad Cadiz	14	32	10	30
2	Puerto	14	32	15	26
3	Nextstars	13	24	15	25
4	Ubrique	13	30	15	23
5	Union	12	17	22	15
6	Trebujena	13	19	40	11
7	Rock Puente	13	14	38	10
8	Bahia	14	13	26	8

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Linense	16	40	16	33
2	Castellar	17	35	25	33
3	CD Benalup	16	18	8	30
4	Federico	16	31	17	29
5	Aficion	16	31	19	29
6	Ud Bornense	17	31	19	28
7	Facinas	17	34	33	23
8	Tiempo Libre	17	33	30	19
9	Alcalat	16	17	28	13
10	Novo	16	9	39	7
11	Alma África	16	14	59	7

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Xerez	24	61	22	51
2	CD Rivera	24	58	37	49
3	Algaida UD	23	58	26	48
4	Federico	23	64	33	44
5	Amigos Cruz	23	49	25	44
6	Portuense	23	49	30	44
7	Cañorrera	24	34	43	34
8	Ud Bornense	23	37	33	30
9	Tiempo Libre	24	35	45	26
10	Estrella	24	33	71	21
11	Aficion	23	24	48	18
12	Futbol Sanix	19	14	48	11
13	Alma África	23	24	79	5

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Estrella	19	49	16	44
2	Aficion	20	55	34	41
3	Juventud	18	36	20	38
4	Jose	18	38	27	37
5	Portuense	19	39	29	35
6	Ud Bornense	17	30	27	24
7	Cañorrera	18	27	34	22
8	Amigos Cruz	19	29	26	19
9	Rayo	18	27	47	16
10	Rota B	20	26	49	10
11	Arcos B	0	0	0	0
12	Xerez Club.	0	0	0	0
13	Federico	12	7	54	0

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Alcalá	17	50	19	35
2	Medina	17	29	19	32
3	Facinas	17	37	29	30
4	Divina	17	45	28	29
5	Alma África	17	35	24	29
6	Xerez	17	33	31	28
7	Ud Bornense	17	20	30	21
8	Juventud	17	40	33	15
9	Federico	17	17	48	12
10	Español	9	6	51	0

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Fernando	28	73	35	57
2	C.D. Salle	29	83	37	55
3	Tarifa UD	29	63	46	53
4	Vejer	29	48	35	51
5	Sanluqueña	28	63	52	51
6	Federico	29	56	41	49
7	Ubrique UD	29	55	35	48
8	Rayo	29	39	35	47
9	Prado	28	56	73	33
10	Unión	28	36	63	31
11	Pueblo Nuevo	29	48	59	31
12	Cañorrera	29	42	61	30
13	Atletico	27	44	66	29
14	San Benito	25	34	59	28
15	C.D. Union.	29	36	58	24
16	Puerto Real	15	15	36	13
17	Novo Gazul.	0	0	0	0

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Xerez	28	126	12	77
2	Guadiaro	28	65	25	63
3	Florida	28	55	49	52
4	Torno 2009	28	65	41	51
5	Ubrique UD	28	63	41	49
6	Sanluqueña	28	56	51	48
7	Fernando	28	56	49	41
8	Vejer	28	48	46	38
9	Tarifa UD	28	44	48	38
10	San Benito	28	50	60	33
11	Prado	28	39	61	28
12	Federico	28	35	60	28
13	Atletico	28	37	71	25
14	Espera C.F.	28	41	69	23
15	Español	28	17	114	4
16	Puerto	0	0	0	0

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Xerez	26	95	18	73
2	Guadiaro	27	74	34	50
3	Cañorrera	27	47	33	49
4	Fernando	26	67	24	49
5	Ubrique Ind.	25	62	27	48
6	Puertollano	26	38	19	47
7	Torno 2009	25	54	37	40
8	Chiclana	26	48	44	40
9	Ciudad	26	48	45	40
10	Ud Bornense	26	59	50	39
11	Union	25	49	55	35
12	Novo Gazul.	25	28	50	28
13	Xerez	25	22	54	24
14	Atlético	25	43	59	24
15	Cádiz 1812	25	37	52	23
16	Federico	27	27	82	20
17	El Bosque	25	23	68	17
18	Juventud	27	36	106	14
19	Portuense	0	0	0	0

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Puerto	18	55	17	46
2	Esperanza	18	33	14	40
3	Florida Dst.	18	39	27	36
4	Prado	18	30	24	29
5	Atletico	18	27	25	26
6	Alcalá	18	23	37	23
7	El Bosque	18	22	28	18
8	Cañorrera	18	24	43	16
9	Atlético	18	25	38	14
10	Juventud	18	27	52	8

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Benito	26	50	28	53
2	Pueblo Nuevo	26	60	40	46
3	Bernardo	26	59	31	45
4	Entrechuelos	26	50	47	42
5	Liberación	26	55	39	41
6	Federico	26	59	41	40
7	Atlético	26	43	50	38
8	Espera C.F.	26	43	36	34
9	Puerto	26	53	72	34
10	El Bosque	26	39	45	31
11	Alcalá	26	37	48	31
12	Juventud	26	43	53	30
13	Olvera	26	29	68	24
14	Prado	26	36	58	19

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Alcalá	28	90	25	63
2	Balona	28	67	23	60
3	Portuense	28	64	20	60
4	Sanluqueña	28	63	38	60
5	Jose Obrero	28	65	36	56
6	Sindicales	28	39	53	43
7	Federico	28	46	45	42
8	Juventud	28	48	57	37
9	Novo	28	47	62	34
10	Torno 2009	28	49	53	32
11	Atlético	28	37	50	29
12	Pueblo Nuevo	28	40	61	26
13	El Bosque	28	37	67	21
14	Alcalá	28	33	80	16
15	Algodonales	28	29	84	16

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	CD Rivera	27	71	34	61
2	Tiempo Libre	28	48	23	59
3	Puerto	27	84	56	55
4	Estella Cd	27	60	35	51
5	Cortijillos	28	60	37	50
6	Puerto Real	28	63	39	48
7	Cádiz	27	71	48	46
8	Alcalá	28	46	45	40
9	Torno 2009	27	44	40	36
10	Olvera	27	45	44	36
11	Athletic	28	38	55	28
12	Sindicales	28	41	73	24
13	Juventud	27	34	82	20
14	Arcos CF	28	28	88	12
15	Pastores	21	31	65	11

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	El Colorado	16	31	15	30
2	Conil B	16	30	21	29
3	Español	16	29	21	27
4	Sidonia Bpie	16	28	21	25
5	Alcalá	16	22	20	24
6	Cortijillos	16	22	28	19
7	Jimena	16	23	31	17
8	Cádiz	16	15	24	17
9	Sindicales	16	15	34	12

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Paterna CF	30	80	42	64
2	Benito	30	69	39	62
3	Recreativo	29	79	37	59
4	Saladillo	29	68	39	58
5	Atletico	30	66	34	57
6	Tesorillo	29	60	50	51
7	Benalup	29	54	41	49
8	Torno 2009	30	61	51	46
9	Español	29	63	44	42
10	Jimena	30	46	65	32
11	Alcalá	30	38	57	30
12	S.Isidro	29	40	63	29
13	Sidonia Bpie	29	30	52	24
14	Rayo Piñera	22	23	40	23
15	Olvera	29	31	87	14
16	Puerto	30	17	84	14

Equipos de esta liga

USO DE MEMORIA

6,460,360 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.5405
Total Execution Time	0.5428

CADENA URL

/tercera_andaluza_cadiz2024/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0125	SELECT type FROM routes WHERE alias = 'tercera_andaluza_cadiz2024'
0.0253	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_andaluza_cadiz' 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.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=420 AND type_rel = 3
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 420 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	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 (685788,641934,638815,68963,68433) ORDER BY n.cover_points DESC, update_date DESC
0.0125	SELECT id,name,alias,stepParent FROM categories WHERE parentId=420 ORDER BY order_id ASC
0.0126	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 = 73744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 420 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 73744 AND t.round = 22 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* `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 = 68941 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.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* `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 = 64465 AND t.round = 22 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 = 60373 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.0127	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 = 51516 AND t.round = 18 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* `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 = 45635 AND t.round = 26 ORDER BY team.conference 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* `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 = 39903 AND t.round = 26 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* `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 = 34315 AND t.round = 18 ORDER BY team.conference 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* `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 = 16926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 4112 AND t.round = 30 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* `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 = 2996 AND t.round = 38 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* `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 = 2995 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 2994 AND t.round = 26 ORDER BY team.conference 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* `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 = 2993 AND t.round = 30 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* `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 = 2992 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 2991 AND t.round = 18 ORDER BY team.conference 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* `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 = 2990 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:12:42' 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-28 13:12:42' 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-28 13:12:42' 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-28 13:12:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 73744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73744 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 = 73744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73744 AND (e.action = 4 or e.action = 5) 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 = 73744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73744 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139	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 = 73744 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC