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

CD Praviano

Entrenador: Lucho Varela

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UD Llanera	31	95	22	78
2	Sporting	31	58	13	67
3	UC Ceares	31	47	24	61
4	L´Entregu	31	49	29	61
5	Lealtad	30	46	23	56
6	CD Praviano	30	31	19	53
7	CD Tuilla	31	50	40	45
8	Urraca CF	31	30	31	42
9	Caudal	31	31	31	39
10	CD Colunga	30	32	35	38
11	Llanes	31	34	50	33
12	Lenense	31	28	44	33
13	Avilés	31	28	41	32
14	Real	31	39	59	30
15	Condal	31	24	48	30
16	Luarca CF	31	36	65	25
17	Gijón	31	29	60	24
18	Barcia CF	30	20	73	9

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Covadonga	30	53	21	65
2	Sporting	30	56	21	64
3	L´Entregu	30	42	28	60
4	UD Llanera	30	49	26	55
5	CD Praviano	30	40	23	53
6	Caudal	30	41	21	50
7	Lealtad	30	31	27	43
8	Llanes	30	36	40	40
9	Real	30	28	44	36
10	CD Colunga	30	35	39	36
11	CD Tuilla	30	39	52	36
12	UC Ceares	30	35	44	34
13	Luarca CF	30	21	32	30
14	Condal	30	20	42	25
15	Avilés	30	25	52	23
16	Valdesoto	30	22	61	14

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	75	39	75
2	Sporting	38	71	25	74
3	Lealtad	38	55	27	71
4	Llanes	38	50	36	64
5	Caudal	38	55	37	64
6	CD Colunga	38	51	32	61
7	L´Entregu	38	48	39	57
8	CD Praviano	38	51	44	56
9	CD Tuilla	38	53	59	53
10	Covadonga	38	48	44	51
11	Luarca CF	38	36	52	49
12	Real	38	43	44	48
13	Gijón	38	43	52	47
14	Urraca CF	38	31	35	47
15	Martín	38	44	48	47
16	Lenense	38	39	48	46
17	TSK Roces	38	40	62	36
18	Navarro	38	29	55	33
19	Langreo	38	36	80	26
20	Mosconia	38	30	70	24

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UC Ceares	20	29	16	44
2	Real Avilés	20	33	13	40
3	UD Llanera	20	38	28	38
4	Caudal	20	36	18	38
5	Gijón	20	34	27	27
6	Lenense	20	24	27	25
7	CD Praviano	20	23	28	24
8	Navarro	20	18	26	22
9	Mosconia	20	15	28	20
10	Vallobin CD	20	14	32	17
11	Avilés	20	12	33	12
12	L´Entregu	18	32	13	40
13	Martín	18	31	21	33
14	Llanes	18	29	16	32
15	CD Tuilla	18	25	19	27
16	Real	18	19	25	23
17	Urraca CF	18	9	12	22
18	Condal	18	13	19	22
19	CD Colunga	18	11	17	20
20	Club Siero	18	12	23	15
21	Valdesoto	18	10	26	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	28	44	12	62
2	UD Llanera	28	48	26	59
3	Covadonga	28	65	33	57
4	Caudal	28	54	21	56
5	CD Tuilla	28	42	25	55
6	Llanes	28	47	30	48
7	Urraca CF	28	34	25	43
8	Gijón	28	42	36	39
9	L´Entregu	28	26	36	34
10	Condal	28	29	37	32
11	CD Praviano	28	37	42	32
12	Mosconia	28	29	33	31
13	Navarro	28	26	35	31
14	Lenense	28	28	48	29
15	UC Ceares	28	28	37	27
16	Real Avilés	28	34	50	25
17	Vallobin CD	28	19	32	25
18	Martín	28	26	49	24
19	CD Colunga	28	25	53	23
20	Club Siero	28	25	48	20

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	72	16	90
2	Marino	38	77	22	90
3	Caudal	38	72	29	75
4	Covadonga	38	80	42	73
5	UD Llanera	38	65	42	70
6	Llanes	38	52	38	65
7	CD Tuilla	38	67	47	64
8	L´Entregu	38	42	36	57
9	Mosconia	38	51	42	55
10	CD Praviano	38	43	49	51
11	Condal	38	40	48	48
12	CD Colunga	38	38	48	44
13	UC Ceares	38	35	51	44
14	Real Avilés	38	32	65	37
15	Martín	38	35	53	36
16	Club Siero	38	35	60	36
17	Gijón	38	38	64	35
18	Madalena	38	37	70	34
19	Universidad	38	30	61	30
20	Claudio	38	23	81	17

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	73	19	82
2	Langreo	38	89	23	78
3	Marino	38	70	21	76
4	Llanes	38	65	48	75
5	Covadonga	38	83	46	72
6	UC Ceares	38	46	30	60
7	CD Tuilla	38	60	41	59
8	CD Praviano	38	45	37	58
9	L´Entregu	38	53	50	53
10	Martín	38	41	50	51
11	Mosconia	38	39	57	50
12	Gijón	38	52	55	47
13	Condal	38	39	67	44
14	CD Colunga	38	44	60	42
15	UD Llanera	38	48	65	39
16	Club Siero	38	34	70	36
17	Real Avilés	38	35	64	32
18	Valdesoto	38	27	55	30
19	Atlético	38	22	68	28
20	TSK Roces	38	29	68	24

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	112	18	92
2	Real Avilés	38	90	34	85
3	Langreo	38	78	26	84
4	CD Tuilla	38	61	35	84
5	Real Oviedo	38	78	32	75
6	Marino	38	61	36	75
7	Covadonga	38	69	50	63
8	Condal	38	65	50	62
9	UC Ceares	38	47	63	49
10	Llanes	38	53	44	48
11	CD Colunga	38	51	59	48
12	Mosconia	38	38	84	35
13	UD Llanera	38	38	61	35
14	CD Praviano	38	46	78	35
15	L´Entregu	38	27	66	33
16	Club Siero	38	36	83	33
17	Atlético	38	42	78	31
18	Tineo	38	42	71	31
19	Lenense	38	50	84	30
20	Urraca CF	38	32	64	27

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	86	12	98
2	Langreo	38	96	25	90
3	Real Avilés	38	77	18	89
4	Marino	38	55	23	68
5	CD Tuilla	38	66	39	67
6	CD Colunga	38	60	54	66
7	Real Oviedo	38	63	42	62
8	Condal	38	50	47	60
9	Llanes	38	54	47	57
10	UC Ceares	38	42	60	45
11	Covadonga	38	35	51	45
12	Atlético	38	33	55	41
13	Mosconia	38	36	57	40
14	CD Praviano	38	39	65	40
15	Tineo	38	40	63	39
16	Club Siero	38	37	63	38
17	Urraca CF	38	34	47	36
18	Gijón	38	34	68	31
19	Astur	38	34	92	24
20	TSK Roces	38	19	62	22

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Condal	38	67	20	86
2	Caudal	38	68	18	84
3	Real Oviedo	38	82	34	78
4	CD Tuilla	38	67	31	77
5	Covadonga	38	63	39	70
6	UC Ceares	38	51	41	63
7	Llanes	38	61	51	61
8	CD Praviano	38	47	46	51
9	Urraca CF	38	50	47	50
10	Atlético	38	45	49	49
11	Mosconia	38	37	45	47
12	Real Avilés	38	46	53	46
13	Astur	38	39	52	46
14	Gijón	38	42	50	46
15	TSK Roces	38	37	43	45
16	Andés	38	44	60	43
17	L´Entregu	38	34	54	38
18	Lenense	38	38	72	30
19	Universidad	38	30	78	23
20	Cudillero	38	10	75	0

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	62	27	76
2	Langreo	38	62	28	76
3	UC Ceares	38	54	31	74
4	CD Praviano	38	57	36	72
5	Covadonga	38	70	35	71
6	CD Tuilla	38	67	38	64
7	Universidad	38	52	30	64
8	Cudillero	38	59	51	63
9	L´Entregu	38	48	39	59
10	Condal	38	47	34	55
11	Real Avilés	38	51	55	49
12	Real Oviedo	38	46	53	48
13	Urraca CF	38	55	54	46
14	Atlético	38	49	55	46
15	Lenense	38	29	54	38
16	Gijón	38	21	50	36
17	Andés	38	32	77	34
18	Candás CF	38	35	53	34
19	Luarca CF	38	23	66	28
20	Real Tapia	38	23	76	20

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Tuilla	38	70	35	81
2	Universidad	38	59	28	75
3	Covadonga	38	58	30	72
4	Langreo	38	54	22	71
5	Real Oviedo	38	51	47	61
6	Lealtad	38	48	42	54
7	L´Entregu	38	42	39	54
8	Condal	38	49	41	54
9	Cudillero	38	46	40	53
10	Luarca CF	38	42	43	51
11	CD Praviano	38	37	50	50
12	UC Ceares	38	43	48	48
13	Urraca CF	38	55	57	45
14	Atlético	38	42	48	43
15	Real Tapia	38	34	43	43
16	Gijón	38	35	42	43
17	Candás CF	38	37	56	42
18	Llanes	38	36	45	42
19	Navia CF	38	35	73	28
20	Navarro	38	26	70	18

TEMPORADA 2011/2012

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	CD Praviano	38	61	35	75
2	Atlético	38	58	25	71
3	L´Entregu	38	71	45	70
4	Urraca CF	38	83	58	69
5	Real Tapia	38	58	43	66
6	Club Siero	38	69	45	62
7	Lenense	38	51	55	56
8	Tineo	38	58	51	53
9	TSK Roces	38	54	46	52
10	Universidad	38	57	55	51
11	Valdesoto	38	51	46	50
12	U.Comercial	38	60	54	49
13	Real Avilés	38	57	58	48
14	La Caridad	38	43	52	48
15	Andés	38	44	61	48
16	Campomanes	38	54	66	42
17	Narcea	38	35	52	42
18	Ribadesella	38	52	71	41
19	Deportiva	38	37	75	30
20	San Martín	38	28	88	25

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marino	38	79	30	84
2	Universidad	38	73	31	79
3	Langreo	38	67	30	77
4	CD Tuilla	38	83	51	75
5	Candás CF	38	60	38	69
6	Condal	38	57	42	61
7	Navia CF	38	60	49	60
8	Real Oviedo	38	77	53	58
9	Navarro	38	44	54	55
10	Real Avilés	38	40	38	55
11	Cudillero	38	39	54	43
12	Lealtad	38	40	49	41
13	Luarca CF	38	38	53	41
14	Llanes	38	54	72	41
15	UC Ceares	38	39	56	39
16	Nalón	38	60	82	38
17	Gijón	38	34	50	37
18	Andés	38	35	68	37
19	Ribadesella	38	36	76	32
20	CD Praviano	38	33	72	21

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	73	27	83
2	Marino	38	73	36	80
3	Universidad	38	81	38	76
4	Llanes	38	68	38	70
5	Langreo	38	59	35	66
6	Ribadesella	38	63	44	65
7	CD Tuilla	38	74	56	64
8	Candás CF	38	49	32	59
9	Real Avilés	38	48	41	58
10	Lealtad	38	51	45	57
11	Navarro	38	49	57	45
12	Condal	38	36	59	44
13	UC Ceares	38	39	59	44
14	Cudillero	38	42	63	40
15	Gijón Ind.	38	37	65	39
16	CD Praviano	38	31	51	38
17	Luarca CF	38	31	53	36
18	Colloto	38	34	60	35
19	Covadonga	38	35	61	33
20	Astur	38	30	83	21

TEMPORADA 2008/2009

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	CD Praviano	38	64	24	83
2	Colloto	38	63	39	73
3	Luarca CF	38	70	43	69
4	Tineo	38	54	29	67
5	Atlético	38	45	46	66
6	Racing Sama	38	57	43	62
7	Real Tapia	38	59	52	54
8	L´Entregu	38	57	53	53
9	San Martín	38	51	47	53
10	La Caridad	38	53	50	53
11	Narcea	38	61	51	52
12	Andés	38	39	37	52
13	U.Comercial	38	50	62	50
14	Universidad	38	59	65	45
15	Urraca CF	38	44	57	45
16	Valdesoto	38	61	66	44
17	Santiago	38	42	65	44
18	Atlético	38	38	84	33
19	Club Hispano	38	38	64	32
20	CD Salas	38	35	63	27

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	58	27	83
2	Lealtad	38	70	34	80
3	Langreo	38	61	30	74
4	Sporting	38	70	37	71
5	CD Tuilla	38	61	42	71
6	Real Avilés	38	52	34	61
7	Ribadesella	38	57	39	59
8	Cudillero	38	50	41	49
9	UC Ceares	38	48	58	48
10	Club Siero	38	43	41	47
11	Condal	38	50	51	46
12	Navarro	38	32	40	42
13	Llanes	38	37	52	42
14	Astur	38	49	70	40
15	Club Hispano	38	41	64	40
16	Covadonga	38	48	58	39
17	Gijón Ind.	38	42	67	38
18	CD Praviano	38	39	56	37
19	Mosconia	38	44	65	35
20	San Martín	38	41	87	29

TEMPORADA 1997/1998

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	75	36	82
2	Universidad	38	64	41	70
3	Club Siero	38	58	32	67
4	San Martín	38	50	33	64
5	Navia CF	38	56	37	63
6	Pumarín CF	38	40	30	61
7	Narcea	38	46	41	60
8	Marino	38	44	39	53
9	CD Tuilla	38	47	42	50
10	Andés	38	45	48	49
11	Candás CF	38	39	45	48
12	Ribadesella	38	43	55	47
13	Deportiva	38	39	52	45
14	Gijón	38	51	53	45
15	Navarro	38	39	51	43
16	Colloto	38	40	57	43
17	Real	38	32	38	41
18	CD Praviano	38	25	40	40
19	Club Hispano	38	33	60	32
20	CD Turón	38	24	60	23

TEMPORADA 1995/1996

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	38	63	39	78
2	Real Oviedo	38	89	36	75
3	Marino	38	67	31	75
4	Caudal	38	66	39	65
5	Mosconia	38	43	29	64
6	Universidad	38	48	52	60
7	Gijón	38	45	38	60
8	Lealtad	38	63	53	58
9	Navia CF	38	52	33	57
10	Ribadesella	38	65	57	56
11	San Martín	38	42	42	53
12	Club Siero	38	45	41	53
13	Navarro	38	46	54	44
14	CD Turón	38	34	51	44
15	Club Hispano	38	48	61	42
16	Pumarín CF	38	44	55	41
17	Colloto	38	40	66	40
18	Deportiva	38	43	62	36
19	Valdesoto	38	30	77	30
20	CD Praviano	38	21	78	15

TEMPORADA 1994/1995

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	77	23	57
2	Club Siero	38	79	39	53
3	Lealtad	38	77	39	52
4	Real	38	53	34	44
5	CD Turón	38	57	41	44
6	Martin	38	32	37	41
7	Club Hispano	38	53	52	40
8	Pumarín CF	38	42	40	40
9	Universidad	38	61	49	39
10	Marino	38	47	40	38
11	Navia CF	38	37	36	38
12	CD Praviano	38	42	60	36
13	Gijón	38	59	63	34
14	Ribadesella	38	47	58	32
15	Deportiva	38	33	53	32
16	Navarro	38	42	54	32
17	CD Tuilla	38	41	63	31
18	Candás CF	38	40	61	29
19	Lenense	38	40	63	29
20	Santiago	38	27	81	19

Competiciones que juega

Tercera Federación Grupo 2

Pos	Equipos		Pts
1		UD Llanera	78
2		Sporting Atlético	67
3		UC Ceares	61
4		L´Entregu CF	61
5		Lealtad Villaviciosa	56
6		CD Praviano	53
7		CD Tuilla	45
8		Urraca CF	42
9		Caudal Deportivo	39
10		CD Colunga	38
11		Llanes	33
12		SD Lenense Proinastur	33
13		Avilés Stadium	32
14		Real Titánico	30
15		Condal	30
16		Luarca CF	25
17		UD Gijón Industrial	24
18		Barcia CF	9

	Ascenso : UD Llanera
	Playoff Ascenso : Sporting Atlético, UC Ceares, L´Entregu CF, Lealtad Villaviciosa
	Descenso : Luarca CF, UD Gijón Industrial, Barcia CF

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,324,120 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1977
Total Execution Time	0.1989

CADENA URL

/historico/Praviano

GET DATOS

$_GET['/historico/Praviano']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0035	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Praviano' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2013 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0080	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2013 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2013 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72261
0.0029	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2013' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '2013' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=2013 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72568,72261,71489,67320) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72261 AND teamId = 2013
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 2013
0.0044	SELECT count(id) as num_players from rel_players WHERE league_id = 72568 AND teamId = 2013
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2013
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 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 = 72261 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0039	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 2013 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 2013 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 2013 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2013 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67976 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.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 = 62386 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.0025	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 = 58580 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.0027	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 = 50270 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 44390 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060	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 = 39026 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 33352 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 3912 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 2552 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 1943 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 1453 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 1113 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 834 AND t.round = 38 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 = 287 AND t.round = 38 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* `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 = 87 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1998` 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 = 21983 AND t.round = 38 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* `tables1996` 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 = 21944 AND t.round = 38 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* `tables1995` 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 = 21923 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Praviano

CD Praviano

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 2

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.