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

2021/2022

Cádiz - Subgrupo A

Primera Andaluza 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Balón	18	54	18	47
2	Trebujena	18	25	19	31
3	CD Jédula	18	27	25	30
4	Villamartín	18	27	22	29
5	Recreativo	18	24	24	24
6	Guadiaro	18	27	21	22
7	Bernardo	18	23	29	20
8	Rayo	18	27	43	19
9	Puerto Real	18	13	30	18
10	Ubrique UD	18	23	39	14

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Leones	14	26	19	24
2	Castro	14	24	17	21
3	Bujalance	14	19	21	21
4	Carpio	14	14	14	19
5	Belmezano	14	26	26	18
6	Villa	14	19	28	18
7	Peñarroya	14	14	17	16
8	Atco.	14	19	19	13

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	CD Vera	19	39	8	47
2	Cañada	19	56	19	45
3	UD Pavía	19	38	16	38
4	Roquetas	19	26	17	31
5	Poli	19	29	30	28
6	Cuevas CF	19	32	34	24
7	CD Viator	19	25	33	24
8	Ciudad	19	28	33	22
9	Adra	19	23	30	22
10	CD Huercal	19	25	32	19
11	PD Garrucha	19	29	39	18
12	Cd Oriente	19	22	37	17
13	Las Norias	19	24	46	16
14	Atlético	19	26	48	15

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	UD Pavía	24	47	26	49
2	CD Cantoria	24	59	32	46
3	CD Huercal	23	48	31	43
4	Cañada	24	45	31	38
5	Poli	24	51	42	38
6	Cuevas CF	24	51	38	36
7	Plus Ultra	24	45	41	31
8	Comarca	24	37	42	29
9	PD Garrucha	24	47	55	29
10	Atlético	23	38	46	28
11	CD Viator	24	34	49	26
12	Los Molinos	24	31	57	19
13	Roquetas	22	14	57	11

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	CD Vera	22	44	21	55
2	CD Huercal	21	54	23	45
3	Plus Ultra	22	40	32	41
4	Cuevas CF	21	45	31	35
5	PD Garrucha	22	46	47	34
6	Cañada	22	41	39	33
7	CD Mojácar	22	31	35	27
8	CD Viator	22	26	38	22
9	Atlético	22	29	40	21
10	Comarca	22	22	40	20
11	Comarca	22	36	54	19
12	Las Norias	22	30	44	18

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Navas CD	34	102	54	68
2	Úbeda Viva	33	69	46	61
3	Guardia	34	77	52	59
4	Real Jaén	34	64	47	57
5	Urgavona CF	34	73	57	57
6	CD Hispania	34	52	44	54
7	Baeza CF	34	62	54	53
8	Arroyo	34	60	48	52
9	Begíjar CF	34	59	63	48
10	Guarroman	34	57	50	47
11	CD Vilches	34	54	58	45
12	Arquillos	34	45	55	45
13	Huelma CP	34	65	87	42
14	Villargordo	34	50	62	39
15	C.D.	34	50	64	38
16	Villanueva	34	57	77	37
17	Carolinense	34	52	73	36
18	Fuensanta	33	40	97	16

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Atlético	34	68	30	76
2	Cádiz	34	90	32	71
3	CD Rota	34	71	47	68
4	AD Cartaya	34	64	32	64
5	La Palma CF	34	55	48	55
6	Xerez CD	34	49	41	54
7	Chiclana CF	34	49	40	53
8	Valverdeña	34	51	45	50
9	Chipiona CF	34	45	55	48
10	Isla	34	38	47	48
11	Jerez	34	39	41	47
12	Recreativo	34	52	48	43
13	Grupo	34	44	55	35
14	Algeciras	34	27	42	33
15	Roque Lepe	34	36	57	31
16	Sanluqueño	34	25	54	31
17	Villamartín	34	25	64	23
18	Cortijillos	34	27	77	13

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Roteña	32	58	29	63
2	Jerez	32	41	27	54
3	CD Rota	32	50	41	54
4	Chiclana CF	32	51	37	52
5	Valverdeña	32	47	30	50
6	Sanluqueño	32	57	56	50
7	Grupo	32	52	40	49
8	Balón	32	50	39	49
9	Algaida UD	32	51	52	45
10	Xerez CD	32	40	41	43
11	Roque Lepe	32	42	42	39
12	Cortijillos	32	35	43	39
13	Chipiona CF	32	38	47	39
14	Villamartín	32	45	59	38
15	Mazagon CF	32	49	64	38
16	Chiclana	32	31	57	25
17	Balona	32	37	70	25

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Guadalcacín	32	51	28	69
2	Los Barrios	32	57	24	65
3	CD Rota	32	55	45	51
4	Valverdeña	32	55	47	51
5	Grupo	32	43	39	50
6	Chiclana CF	32	49	35	48
7	Roteña	32	53	58	47
8	Chiclana	32	36	38	46
9	Jerez	32	44	38	43
10	Sanluqueño	32	43	43	41
11	Balón	32	43	45	39
12	Chipiona CF	32	27	32	39
13	UD Algaida	32	43	49	38
14	Mazagon CF	32	41	39	38
15	Puerto Real	32	49	58	33
16	Tesorillo	32	38	71	31
17	Aljaraque	32	36	74	24

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	La Palma Cf	32	57	25	70
2	Olímpica	32	60	32	70
3	Xerez B	32	67	25	67
4	Sanluqueño	32	50	39	50
5	Isla	32	53	44	50
6	Cd Rota	32	45	37	47
7	Puerto Real	32	60	64	47
8	Jerez	32	50	52	42
9	Balón	32	58	60	40
10	Chiclana	32	41	43	40
11	Guadalcacín	32	43	49	40
12	UD Algaida	32	47	64	40
13	Chiclana CF	32	37	38	39
14	Grupo	32	45	59	39
15	Ud Tarifa	32	47	59	37
16	CD Canela	32	40	67	26
17	Almonte	32	40	83	20

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Los Barrios	34	68	25	74
2	Puerto Real	34	70	39	69
3	Xerez B	34	87	42	68
4	Isla	34	57	35	66
5	Balón	34	59	47	62
6	Chiclana CF	34	60	39	61
7	Grupo	34	53	50	47
8	Valverdeña	34	56	57	46
9	Guadalcacín	34	56	56	45
10	Tarifa UD	34	42	51	44
11	Chiclana	34	55	53	43
12	La Palma	34	40	40	42
13	CD Rota	34	45	47	42
14	Almonte	34	49	79	41
15	Roque Lepe	34	34	55	34
16	Roteña	34	48	79	29
17	Chipiona CF	34	30	71	27
18	Pinzón CD	34	36	80	23

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Roque	34	65	25	76
2	Arcos CF	34	69	31	75
3	Xerez B	34	52	16	73
4	Chiclana	34	66	29	71
5	Atlético	34	66	60	50
6	CD Rota	34	44	48	49
7	Barbate	34	46	50	48
8	Valverdeña	34	43	40	47
9	La Palma	34	53	48	46
10	Isla	34	45	45	44
11	Balón	34	46	49	44
12	Pinzón CD	34	44	53	43
13	Roteña	34	50	61	41
14	Roque Lepe	34	33	49	35
15	Gibraleón	34	39	59	35
16	Guadalcacín	34	53	67	34
17	Nueva	34	44	65	28
18	CD San Juan	34	21	84	18

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Conil	34	55	38	70
2	Fernando	34	74	33	66
3	Arcos CF	34	57	20	65
4	Xerez B	34	68	34	63
5	Valverdeña	34	61	39	56
6	Pastores	34	51	37	55
7	Chiclana CF	34	63	46	53
8	Balón	34	55	47	52
9	La Palma	34	55	45	47
10	Isla	34	52	51	47
11	CD Rota	34	42	47	44
12	Roteña	34	50	57	42
13	Roque	34	40	78	38
14	Atlético	34	44	67	36
15	Gibraleón	34	31	58	36
16	Atl.	34	47	57	35
17	Punta Umbria	34	29	60	25
18	Almonte	34	33	93	17

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Algeciras	34	64	30	69
2	Conil	34	64	39	69
3	Arcos CF	34	70	32	67
4	CD Rota	34	55	48	54
5	Punta Umbria	34	40	42	53
6	Roteña	34	59	48	50
7	La Palma	34	49	44	49
8	Xerez B	34	47	45	47
9	Atl.	34	46	48	42
10	Roque Lepe	34	31	42	41
11	Balón	34	36	41	40
12	Isla	34	34	41	39
13	Valverdeña	34	37	55	39
14	Fernando	34	41	49	38
15	Atlético	34	36	50	38
16	Ud Bornense	34	45	60	32
17	Tesorillo	34	39	56	31
18	Chiclana	34	24	47	31

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Atlético	34	75	19	75
2	Chiclana CF	34	57	28	68
3	Tesorillo	34	67	38	66
4	Conil	34	65	43	66
5	Punta Umbria	34	52	32	64
6	La Palma	34	45	38	56
7	Valverdeña	34	37	31	53
8	CD Rota	34	39	44	43
9	Cortegana	34	40	48	43
10	Atlético	34	40	48	42
11	Fernando	34	63	54	40
12	Cortijillos	34	37	55	38
13	Roteña	34	43	61	37
14	Chiclana	34	45	66	37
15	Atlético	34	36	51	36
16	Barbate	34	36	65	31
17	Pastores	34	40	73	28
18	Chipiona CF	34	31	54	26

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	AD Cartaya	30	64	21	69
2	Roque Lepe	30	60	17	64
3	Punta Umbria	30	57	33	63
4	Tesorillo	30	64	38	52
5	Atlético	30	63	41	52
6	La Palma	30	43	37	46
7	Roteña	30	36	28	36
8	Barbate	30	45	41	36
9	Cortijillos	30	39	42	36
10	Conil	30	33	38	36
11	Chiclana	30	24	45	35
12	Algeciras	30	37	55	34
13	Cortegana	30	39	59	33
14	Bollullos	30	29	46	29
15	Ubrique Ind.	30	25	51	26
16	Hinojos	30	25	91	9

Equipos de esta liga

USO DE MEMORIA

6,571,528 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.4789
Total Execution Time	0.4807

CADENA URL

/andaluza2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0106	SELECT type FROM routes WHERE alias = 'andaluza2022'
0.0218	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'andaluza' 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.0108	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5 AND type_rel = 3
0.0111	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 5 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0115	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 (1267671,1255959,1148089,1109642,1107691) ORDER BY n.cover_points DESC, update_date DESC
0.0116	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 = 64021 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 5 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 64021 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.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* `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 = 58855 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.0111	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 = 51254 AND t.round = 19 ORDER BY team.conference ASC,t.position 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* `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 = 44620 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 39324 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 34150 AND t.round = 34 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 = 16712 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 4056 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 2569 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 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 = 1972 AND t.round = 34 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* `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 = 1468 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 1189 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 115 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 07:35:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 07:35:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 07:35:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 07:35:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0120	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'andaluza' 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.0117	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 = 64021 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64021 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.0116	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 = 64021 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64021 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115	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 = 64021 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64021 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154	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 = 64021 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


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