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

Tenerife - G2

Eliminatoria

Preferente Canarias 2024 G 2

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Miguel	28	68	28	67
2	Tenerife C	28	63	22	64
3	AU Güímar	28	58	21	61
4	CD Laguna	28	57	32	53
5	CD Águilas	28	50	34	46
6	Las Zocas	28	42	32	43
7	I'Gara	28	39	42	41
8	Lorenzo	28	45	41	37
9	CD Marino B	28	47	44	35
10	Bahía	28	45	48	33
11	Juventud	28	43	60	28
12	Guargacho	28	35	59	28
13	Atlético	28	37	66	18
14	Chincanayro	28	24	82	17
15	Furia Arona	28	31	73	13

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	CD Buzanada	36	138	24	96
2	AU Güímar	36	101	25	90
3	Tenerife C	36	109	37	79
4	CD Laguna	36	101	28	79
5	Miguel	36	81	58	69
6	I'Gara	36	68	45	59
7	CD Águilas	36	69	56	58
8	CD Marino B	36	80	60	57
9	Las Zocas	36	68	48	55
10	Furia Arona	36	54	56	47
11	Bahía	36	52	57	44
12	Chincanayro	36	58	89	41
13	Atlético	36	54	81	40
14	Lorenzo	36	41	58	35
15	Fañabé	36	44	78	34
16	CD Candela	36	40	76	32
17	Andrés	36	33	78	30
18	Real Unión	36	21	106	15
19	CD Ofra	36	19	171	6

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Estrella	28	69	19	66
2	Universitari	28	58	13	66
3	Breñamen	28	56	26	56
4	El Cotillo	28	51	22	54
5	Doramas	28	51	32	53
6	UD Guía	28	44	40	42
7	UD Teror	28	41	38	37
8	Lomo Blanco	28	40	43	32
9	Tarajalejo	28	35	61	32
10	Vecindario	28	37	46	31
11	Valleseco	28	24	39	30
12	UD Barrial	28	29	52	28
13	Costa Ayala	28	31	48	26
14	Unión	28	29	58	21
15	Longueras	28	30	88	9

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Union Yaiza	18	49	14	41
2	Pedro	17	34	18	33
3	Costa Ayala	17	32	19	29
4	Tahiche	18	36	30	29
5	Estrella	17	29	21	28
6	CD Becerril	17	28	23	26
7	Longueras	17	30	36	25
8	Bartolomé	17	29	23	24
9	Doramas	17	21	27	21
10	Valleseco	17	21	27	17
11	Unión	17	28	29	16
12	Antonio	17	16	29	14
13	Tablero	17	14	37	12
14	Isidro	17	12	46	10

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Atletico	25	55	10	59
2	Tenerife C	23	52	17	54
3	Las Zocas	25	50	23	49
4	UD Icodense	25	49	30	46
5	CD Águilas	24	61	29	45
6	Lorenzo	24	43	32	43
7	CD Marino B	25	45	35	41
8	Miguel	25	39	38	38
9	Cruz Santa	25	26	27	36
10	Orotava	25	50	37	34
11	Granadilla	25	30	46	30
12	Unión	25	26	31	29
13	CD Sauzal	25	35	53	28
14	Puerto Cruz	24	29	40	27
15	Santos Reyes	24	20	55	20
16	CD Guancha	25	20	46	19
17	AD Añaza	25	16	57	15
18	Atlético	25	14	54	11

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Vera	34	67	35	75
2	Atletico	34	72	24	71
3	Cruz Santa	34	57	29	66
4	Lorenzo	34	59	43	58
5	Atlético	34	62	60	54
6	UD Icodense	34	57	54	52
7	AD Añaza	34	61	58	51
8	Puerto Cruz	34	63	43	50
9	Orotava	34	66	47	49
10	Unión	34	69	55	49
11	Granadilla	34	52	49	47
12	CD Águilas	34	55	54	47
13	CD Guancha	34	46	50	44
14	CD Marino B	34	52	58	42
15	La Florida	34	39	46	31
16	I'Gara	34	52	92	28
17	Arguijón	34	30	89	21
18	Valle	34	25	98	17

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Atlético	34	67	22	75
2	UD Icodense	34	77	46	66
3	Atletico	34	54	32	61
4	Lorenzo	34	64	47	61
5	Cruz Santa	34	55	39	59
6	Puerto Cruz	34	55	35	57
7	Orotava	34	45	37	49
8	La Florida	34	43	47	49
9	CD Marino B	34	55	52	47
10	CD Águilas	34	44	50	46
11	Valle	34	51	58	45
12	CD Guancha	34	50	48	42
13	Granadilla	34	42	44	42
14	Unión	34	54	68	42
15	Portezuelo	34	42	55	38
16	Juventud	34	36	70	25
17	Charco Pino	34	40	73	24
18	Santiago	34	35	86	16

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	AU Güímar	34	85	40	76
2	UD Icodense	34	72	39	70
3	Orotava	34	61	31	68
4	Cruz Santa	34	51	34	61
5	Granadilla	34	58	48	54
6	Juventud	34	50	45	54
7	Raqui Isidro	34	55	45	52
8	Charco Pino	34	57	49	50
9	Atlético	34	51	51	49
10	CD Águilas	34	45	51	43
11	Puerto Cruz	34	62	60	42
12	Lorenzo	34	48	55	41
13	Portezuelo	34	43	48	40
14	Valle	34	36	52	40
15	Zamorano	34	47	52	38
16	CD Laguna	34	40	65	28
17	Isora CF	34	46	99	24
18	Andrés	34	30	73	14

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	CD Buzanada	36	75	33	78
2	Atlético	36	87	46	72
3	Lorenzo	36	69	42	72
4	Charco Pino	36	76	39	70
5	CD Laguna	36	69	31	67
6	Ángeles	36	91	52	62
7	UD Gomera	36	68	50	55
8	CD Águilas	36	55	47	54
9	UD Icodense	36	63	55	53
10	Orotava	36	60	52	53
11	Raqui Isidro	36	60	60	47
12	Andrés	36	50	45	47
13	Juventud	36	53	61	46
14	Zamorano	36	50	52	45
15	Valeriana	36	43	60	43
16	Atletico	36	47	61	42
17	Atlético	36	38	108	20
18	I'Gara	36	32	126	17
19	Guargacho	36	41	107	15

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	CD Buzanada	36	62	27	71
2	Raqui Isidro	36	75	49	71
3	Cruz Santa	36	55	38	65
4	UD Gomera	36	40	25	59
5	Charco Pino	36	48	41	55
6	Lorenzo	36	73	65	54
7	Atlético	36	44	39	52
8	Orotava	36	49	48	48
9	Águilas	36	46	49	48
10	AU Güímar	36	72	66	47
11	Atlético	36	64	56	46
12	Andrés	36	51	55	46
13	I'Gara	36	49	51	45
14	UD Icodense	36	53	67	45
15	Realejos	36	40	48	42
16	Valle Guerra	36	42	60	40
17	UD Hidalgo	36	50	63	35
18	Arguijón	36	35	59	30
19	Valle	36	37	79	29

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Realejos B	34	73	39	69
2	Andrés	34	46	28	69
3	Valle Guerra	34	58	37	60
4	CD Laguna	34	48	23	59
5	Santa	34	50	40	59
6	Atlético	34	52	34	56
7	Ud Orotava	34	46	42	51
8	CD Buzanada	34	49	51	46
9	Atlético	34	50	61	41
10	Llanos	33	35	42	39
11	Charco Pino	34	33	39	38
12	Atlético	34	46	52	37
13	Fuencaliente	34	45	54	37
14	Arguijón	34	38	61	37
15	UD Icodense	34	46	70	36
16	Valle	34	38	49	35
17	Andrés	33	39	57	33
18	Zona Norte	34	52	65	31

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Realejos	34	72	38	69
2	Andrés	34	46	28	69
3	CD Laguna	34	48	23	59
4	Santa	33	50	40	58
5	Valle Guerra	33	55	37	57
6	Atlético	33	52	35	55
7	Ud Orotava	34	45	41	51
8	CD Buzanada	34	49	51	46
9	Atlético	34	51	61	41
10	Atlético	33	45	48	37
11	Charco Pino	34	32	41	37
12	Arguijón	33	38	58	37
13	Llanos	32	33	41	36
14	UD Icodense	34	46	70	36
15	Valle	33	37	47	35
16	Ud Ibarra	33	39	56	35
17	Fuencaliente	33	42	53	34
18	UD Norte	34	51	63	31

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Raqui Isidro	34	62	39	70
2	UD Gomera	34	75	35	69
3	Lauburu	34	72	37	68
4	Orotava	34	62	32	67
5	Santa	34	44	37	51
6	At. Paso	34	49	44	51
7	UD Icodense	34	51	49	50
8	Andrés	34	45	44	50
9	Llanos	34	46	43	47
10	Valle	34	39	37	46
11	Zona Norte	34	55	70	42
12	Fuencaliente	34	49	51	39
13	Realejos	34	34	41	38
14	Valle Guerra	34	43	54	37
15	Arguijón	34	32	51	37
16	Victoria	34	41	57	35
17	Tegueste	34	43	55	33
18	Ud Médano	34	25	91	17

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Atletico	34	68	28	72
2	Andrés	34	55	33	66
3	Charco Pino	34	70	38	61
4	Orotava	34	51	32	60
5	Ud Médano	34	60	55	55
6	Andrés	34	54	36	52
7	Valle Guerra	34	46	40	50
8	Tenerife C	34	54	43	48
9	Ibarra	34	41	47	48
10	UD Icodense	34	49	45	45
11	Tegueste	34	43	46	43
12	At. Paso	34	45	53	43
13	Fuencaliente	34	43	56	40
14	Norte	34	41	54	37
15	Llanos	34	33	66	36
16	Puerto Cruz	34	34	59	29
17	Unión	34	26	54	25
18	Miguel	34	32	60	24

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Charco Pino	30	56	23	66
2	Andrés	31	64	29	60
3	Vera	31	55	33	59
4	Tenerife C	31	39	18	56
5	Andrés	31	53	35	56
6	Raqui Isidro	30	64	35	55
7	Atletico	32	53	38	55
8	Ibarra	31	40	35	45
9	Norte	30	40	37	45
10	I'Gara	30	38	44	37
11	Breña Alta	30	30	35	35
12	UD Icodense	31	34	47	35
13	Real Unión	31	37	56	34
14	Atlético	30	42	63	27
15	Águilas	32	30	61	27
16	Orotava	30	30	55	26
17	Unión	31	30	60	26
18	La Palma	30	24	53	20
19	Puerto Cruz	5	9	11	9
20	Atlético	1	1	1	1

Equipos de esta liga

USO DE MEMORIA

6,899,984 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.5119
Total Execution Time	0.5140

CADENA URL

/canarias2024/grupo2/historico

GET DATOS

$_GET['/canarias2024/grupo2/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0252	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'canarias' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80 AND type_rel = 3
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 80 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 (1227759,1055368,1019795,1016738,992278) ORDER BY n.cover_points DESC, update_date DESC
0.0126	SELECT id,name,alias,stepParent FROM categories WHERE parentId=80 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 = 73544 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 80 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 73544 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.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* `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 = 68790 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.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 = 64495 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.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* `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 = 59644 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.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* `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 = 51278 AND t.round = 25 ORDER BY team.conference ASC,t.position 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* `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 = 44766 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* `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 = 39650 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* `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 = 34596 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* `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 = 16711 AND t.round = 38 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 = 4084 AND t.round = 38 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 = 2687 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* `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 = 1995 AND t.round = 34 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* `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 = 1472 AND t.round = 34 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* `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 = 1137 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* `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 = 313 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:03: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-27 14:03: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-27 14:03: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-27 14:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 73544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73544 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 = 73544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73544 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 = 73544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73544 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136	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 = 73544 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


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