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 Naval

Entrenador: Oscar Gea

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UM Escobedo	32	55	28	64
2	CD Laredo	32	47	18	61
3	SD Torina	32	45	37	58
4	Atlético	32	52	37	54
5	Tropezón	32	46	36	52
6	CF Vimenor	32	38	32	51
7	CD Bezana	32	45	41	50
8	Castro	32	37	39	48
9	CD Guarnizo	32	32	27	45
10	Siete Villas	32	49	43	42
11	Colindres	32	35	39	42
12	Revilla	32	38	48	41
13	CD Naval	32	36	34	41
14	Sámano	32	39	41	40
15	Atlético	32	33	61	31
16	UC Cartes	32	29	46	30
17	SD Solares	32	28	48	30
18	Velarde CF	32	29	58	19

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cayón	30	59	26	59
2	CF Vimenor	30	52	36	57
3	Tropezón	30	46	23	52
4	UM Escobedo	30	50	34	52
5	Atlético	30	53	34	52
6	SD Torina	30	34	20	49
7	CD Naval	30	26	27	43
8	Siete Villas	30	34	37	41
9	Sámano	30	39	43	40
10	Revilla	30	37	44	33
11	CD Guarnizo	30	27	35	31
12	UC Cartes	30	26	46	31
13	Castro	30	33	43	30
14	SD Solares	30	34	49	28
15	SD Gama	30	30	58	26
16	Textil	30	26	51	24

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	30	69	17	65
2	CF Vimenor	30	49	27	57
3	UM Escobedo	30	53	27	54
4	CD Naval	30	41	26	48
5	SD Torina	30	34	25	46
6	Sámano	30	35	33	46
7	Atlético	30	38	35	44
8	CD Guarnizo	30	36	30	42
9	Siete Villas	30	41	41	41
10	UC Cartes	30	31	37	37
11	Castro	30	34	43	37
12	Textil	30	24	38	32
13	Noja	30	32	57	27
14	Barreda	30	26	47	25
15	Colindres	30	26	58	21
16	Selaya	30	20	48	19

TEMPORADA 2020/2021

PREFERENTE CANTABRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Naval	16	51	7	43
2	Atlético	16	35	15	34
3	Velarde CF	16	30	16	27
4	Arenas	16	21	20	26
5	FC Miengo	16	21	21	21
6	CD Los Rios	16	24	27	21
7	Santillana	16	26	29	19
8	EMF Meruelo	16	11	36	5
9	Atco. Deva	16	5	53	4

TEMPORADA 2019/2020

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Revilla	25	51	17	53
2	Castro	25	48	21	51
3	Rinconeda	25	46	21	51
4	FC Miengo	24	39	26	46
5	Nueva	25	55	39	40
6	Atlético	24	38	29	39
7	Noja	25	32	30	36
8	Colindres	25	31	25	35
9	Velarde CF	25	39	35	35
10	CD Naval	25	34	39	33
11	SD Gama	25	28	31	30
12	Villaescusa	25	27	38	29
13	Valle	25	33	50	28
14	EMF Meruelo	25	31	45	27
15	Santillana	25	30	34	24
16	Atco. Deva	25	28	45	22
17	CD Ramales	25	19	58	17
18	CD Los Rios	25	23	49	15

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UM Escobedo	38	80	29	86
2	CD Laredo	38	71	26	80
3	Tropezón	38	73	34	76
4	Cayón	38	66	26	74
5	Rayo	38	62	24	68
6	CD Bezana	38	60	50	65
7	Sámano	38	54	46	58
8	CF Vimenor	38	51	56	54
9	SD Torina	38	55	60	53
10	Textil	38	49	43	51
11	Ribamontán	38	36	38	50
12	Barreda	38	48	59	47
13	Siete Villas	38	41	51	43
14	Atlético	38	43	47	42
15	SD Solares	38	33	44	42
16	CD Guarnizo	38	41	54	40
17	Revilla	38	48	83	38
18	Velarde CF	38	35	67	36
19	CD Naval	38	36	95	23
20	Rinconeda	38	37	87	19

TEMPORADA 2017/2018

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Revilla	34	62	27	72
2	SD Torina	34	55	27	72
3	Rinconeda	34	61	40	65
4	Ribamontán	34	49	30	61
5	CD Naval	34	51	41	53
6	Valle	34	55	56	45
7	Ayrón Club	34	46	48	45
8	Colindres	34	42	38	42
9	UC Cartes	34	57	50	42
10	SD Gama	34	48	51	41
11	CD Los Rios	34	56	68	40
12	Cayón B	34	53	72	40
13	EMF Meruelo	33	42	50	39
14	CD Monte	34	42	68	38
15	Nueva	34	54	57	37
16	Santoña CF	33	32	52	37
17	Vimenor B	34	28	43	35
18	Internaciona	34	46	61	33

TEMPORADA 2016/2017

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Santillana	34	73	22	82
2	Sámano	34	71	33	77
3	SD Solares	34	57	30	67
4	Valle	34	68	52	58
5	CD Naval	34	54	42	58
6	Vimenor B	34	52	44	52
7	SD Torina	34	58	63	49
8	Nueva	34	54	56	48
9	Rinconeda	34	80	69	46
10	CD Los Rios	34	66	65	43
11	Santoña CF	34	49	56	40
12	SD Gama	34	41	56	37
13	Internaciona	34	42	77	35
14	Cayón B	34	54	65	34
15	CD Monte	34	44	68	34
16	Arenas	34	47	69	33
17	Noja	34	35	60	31
18	Atlético	34	47	65	30

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Laredo	38	74	29	88
2	Gimnástica	38	86	28	87
3	Rayo	38	90	35	86
4	Cayón	38	65	26	79
5	Deportivo	38	60	49	61
6	Castro	38	46	34	57
7	CF Vimenor	38	54	46	55
8	UM Escobedo	38	56	52	50
9	Tropezón	38	51	44	50
10	Textil	38	62	58	46
11	CD Guarnizo	38	44	55	43
12	Colindres	38	45	68	43
13	Siete Villas	38	44	57	42
14	Revilla	38	34	47	41
15	CD Bezana	38	36	59	40
16	Atlético	38	38	60	39
17	Selaya	38	41	60	39
18	CD Naval	38	29	60	36
19	SD Gama	38	34	82	34
20	Sámano	38	32	72	30

TEMPORADA 2014/2015

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	CD Guarnizo	34	63	23	85
2	Sámano	34	69	39	68
3	CD Naval	34	49	28	60
4	Santillana	34	55	39	59
5	Velarde CF	34	61	45	58
6	Barquereño	33	64	40	56
7	EMF Meruelo	34	50	29	56
8	Reocin	32	63	47	50
9	Ribamontán	34	47	53	49
10	Noja	34	40	50	40
11	Rinconeda	33	45	57	38
12	Nueva	34	38	61	35
13	SD Solares	34	27	36	34
14	CD Los Rios	34	52	67	34
15	CD Pontejos	34	29	52	34
16	Minerva Fc	34	35	67	32
17	SD Torina	34	41	65	28
18	Martín	34	36	66	27

TEMPORADA 2011/2012

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	SD Gama	34	57	31	67
2	Santoña CF	34	56	31	66
3	Santillana	33	57	37	61
4	Textil	33	47	27	58
5	EMF Meruelo	34	45	39	56
6	Sámano	33	60	46	54
7	Gimnástica	34	59	37	52
8	Selaya	34	50	39	48
9	SD Torina	34	49	53	47
10	Colindres	34	35	36	44
11	Revilla	34	40	50	44
12	Velarde CF	34	53	69	38
13	Reocin	34	48	58	37
14	Solares	33	40	66	36
15	CD Comillas	33	46	56	35
16	Ayrón Club	33	39	51	33
17	Atco. Deva	32	38	74	33
18	CD Naval	34	38	57	25

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Velarde CF	38	73	29	89
2	Barreda	38	51	14	78
3	Tropezón	38	50	25	73
4	Reocin	38	80	38	70
5	CD Bezana	38	62	39	69
6	Castro	38	58	56	61
7	Ribamontán	38	66	39	60
8	CD Laredo	38	63	47	58
9	Deportivo	38	40	38	51
10	UM Escobedo	38	53	57	49
11	CD Pontejos	38	42	52	46
12	CF Vimenor	38	40	48	46
13	Cayón	38	33	45	46
14	Textil	38	45	59	45
15	Atco. Deva	38	42	44	44
16	Atlético	38	42	51	43
17	Minerva Fc	38	41	63	39
18	Toranzo CD	38	36	73	35
19	Revilla	38	40	73	30
20	CD Naval	38	29	96	17

TEMPORADA 2000/2001

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Noja	36	71	20	83
2	CD Laredo	36	73	46	70
3	CD Bezana	36	58	25	69
4	Textil	36	51	28	68
5	Cayón	36	48	31	64
6	Atco. Deva	36	56	37	63
7	Velarde CF	36	38	24	51
8	Ribamontán	36	38	46	47
9	UM Escobedo	36	40	47	45
10	Ayrón Club	36	46	54	45
11	Barreda	36	41	46	45
12	CD Guarnizo	36	39	47	43
13	Revilla	36	32	51	41
14	Deportivo	36	49	63	40
15	CD Naval	36	44	52	40
16	Atlético	36	40	67	39
17	Castro	36	48	63	38
18	Santoña CF	36	34	51	37
19	Villaescusa	36	32	80	17

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Noja	38	82	18	87
2	Tropezón	38	66	20	75
3	FC Miengo	38	58	29	72
4	Rayo	38	58	25	71
5	Atco. Deva	38	51	36	61
6	Santoña CF	38	49	49	57
7	Barreda	38	46	53	55
8	UM Escobedo	38	53	51	54
9	CD Bezana	38	51	46	53
10	CD Guarnizo	38	53	60	47
11	CD Laredo	38	35	56	46
12	Revilla	38	36	41	45
13	CD Naval	38	33	56	45
14	Velarde CF	38	49	48	45
15	Textil	38	37	45	44
16	Ribamontán	38	42	46	43
17	Cayón	38	51	49	43
18	CD Comillas	38	37	67	39
19	Marina	38	33	82	30
20	Ampuero FC	38	35	78	25

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	64	15	91
2	UM Escobedo	38	67	30	77
3	Ribamontán	38	51	26	71
4	CD Bezana	38	50	31	70
5	Santoña CF	38	52	42	68
6	Cayón	38	33	40	57
7	Barreda	38	55	46	54
8	Textil	38	33	32	51
9	CD Naval	38	32	33	49
10	Revilla	38	31	40	48
11	CD Laredo	38	36	40	45
12	CD Guarnizo	38	42	48	45
13	Velarde CF	38	32	47	44
14	CD Comillas	38	43	55	43
15	Castro	38	44	49	42
16	Unión Club	38	38	66	41
17	FC Miengo	38	34	36	40
18	Villaescusa	38	31	42	39
19	Ayrón Club	38	32	48	37
20	CD Pontejos	38	37	71	26

TEMPORADA 1997/1998

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tropezón	38	63	25	80
2	Noja	38	51	22	67
3	UM Escobedo	38	50	32	66
4	Castro	38	55	37	64
5	Cayón	38	51	46	62
6	Santoña CF	38	47	35	57
7	CD Guarnizo	38	31	31	57
8	Ribamontán	38	39	28	56
9	Barreda	38	45	45	54
10	CD Bezana	38	45	33	52
11	Unión Club	38	39	37	52
12	Velarde CF	38	36	47	49
13	CD Laredo	38	38	40	47
14	CD Comillas	38	33	49	44
15	CD Naval	38	36	46	42
16	Revilla	38	37	50	40
17	Villaescusa	38	27	57	40
18	Atco. Deva	38	23	38	38
19	CF Vimenor	38	29	43	35
20	Reocin	38	29	63	26

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tropezón	38	58	24	81
2	Rayo	38	81	36	72
3	CD Bezana	38	48	28	66
4	Velarde CF	38	68	41	65
5	Ribamontán	38	53	44	61
6	CD Comillas	38	57	45	60
7	Noja	38	54	28	57
8	Barreda	38	60	51	53
9	CD Naval	38	50	44	52
10	Castro	38	40	40	50
11	Cayón	38	52	54	49
12	CD Laredo	38	45	39	49
13	Revilla	38	33	50	44
14	Santoña CF	38	40	61	44
15	UM Escobedo	38	37	51	44
16	CD Guarnizo	38	38	54	39
17	Unión Club	38	43	61	38
18	Ayrón Club	38	30	51	38
19	Textil	38	33	64	31
20	Atlético	38	20	74	23

TEMPORADA 1994/1995

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	87	24	57
2	CD Bezana	38	46	22	49
3	UM Escobedo	38	71	42	48
4	Tropezón	38	50	28	47
5	CD Comillas	38	50	36	47
6	CD Laredo	38	56	41	45
7	Noja	38	40	23	45
8	Ribamontán	38	36	39	41
9	Gimnástica	38	40	34	40
10	Castro	38	42	41	38
11	Unión Club	38	35	44	38
12	CD Guarnizo	38	37	48	35
13	Cayón	38	36	41	34
14	Marina	38	25	29	34
15	Velarde CF	38	39	45	33
16	Colindres	38	32	61	29
17	Santoña CF	38	25	53	28
18	CD Pontejos	38	29	50	28
19	Barreda	38	21	68	23
20	CD Naval	38	27	55	21

TEMPORADA 1993/1994

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Noja	38	84	16	61
2	Rayo	38	97	23	59
3	CD Laredo	38	57	27	53
4	Castro	38	56	28	51
5	UM Escobedo	38	62	35	51
6	Tropezón	38	49	28	50
7	Cayón	38	51	42	42
8	Barreda	38	40	39	40
9	Unión Club	38	36	28	38
10	CD Pontejos	38	43	46	37
11	Ribamontán	38	39	41	36
12	Colindres	38	47	44	36
13	CD Comillas	38	45	51	36
14	Marina	38	42	45	34
15	Velarde CF	38	46	56	28
16	CD Bezana	38	42	71	28
17	CD Naval	38	27	49	27
18	CD Ramales	38	20	65	26
19	SD Torina	38	22	88	14
20	SD Gama	38	22	105	13

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UM Escobedo	38	68	19	60
2	Deportivo	38	68	28	55
3	CD Laredo	38	59	27	47
4	Noja	38	52	31	47
5	Marina	38	34	19	46
6	CD Comillas	38	56	36	45
7	Tropezón	38	39	38	44
8	Cayón	38	44	30	42
9	Colindres	38	41	35	41
10	Castro	38	32	28	39
11	CD Pontejos	38	41	46	38
12	Unión Club	38	28	28	36
13	SD Torina	38	45	47	35
14	Ribamontán	38	35	55	30
15	CD Ramales	38	32	53	29
16	CD Naval	38	31	52	28
17	Barreda	38	31	57	27
18	Santoña CF	38	24	47	27
19	Textil	38	27	65	26
20	Selaya	38	20	66	18

Competiciones que juega

Tercera Federación Grupo 3

Pos	Equipos		Pts
1		UM Escobedo	64
2		CD Laredo	61
3		SD Torina	58
4		Atlético Albericia	54
5		Tropezón	52
6		CF Vimenor	51
7		CD Bezana	50
8		Castro	48
9		CD Guarnizo	45
10		Siete Villas	42
11		CD Colindres	42
12		Revilla	41
13		CD Naval	41
14		Sámano	40
15		Atlético Mineros	31
16		UC Cartes	30
17		SD Solares	30
18		Velarde CF	19

	Ascenso : UM Escobedo
	Playoff Ascenso : CD Laredo, SD Torina, Atlético Albericia, Tropezón
	Descenso : UC Cartes, SD Solares, Velarde CF

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,122,080 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5957
Total Execution Time	0.5969

CADENA URL

/historico/Nava-Cd

GET DATOS

$_GET['/historico/Nava-Cd']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0122	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 = 'Nava-Cd' 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.0107	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=25036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=25036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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=25036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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=25036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0220	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 = 72262
0.0114	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 = 72575
0.0115	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 = '25036' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0117	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 = '25036' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72575 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72262 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116	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=25036 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0108	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 (72575,72262,71432,69379) 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.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 72262 AND teamId = 25036
0.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 72575 AND teamId = 25036
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 69379 AND teamId = 25036
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 25036
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 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 = 72262 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0123	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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 25036 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.0124	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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 25036 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 25036 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125	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 = 25036 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72262 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 67977 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.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* `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 = 62387 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.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* `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 = 58850 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.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* `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 = 51274 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.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* `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 = 44391 AND t.round = 38 ORDER BY team.conference 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* `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 = 39193 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 33972 AND t.round = 34 ORDER BY team.conference 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* `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 = 15444 AND t.round = 38 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* `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 = 4097 AND t.round = 34 ORDER BY team.conference 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* `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 = 1454 AND t.round = 34 ORDER BY team.conference 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* `tables2003` 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 = 22064 AND t.round = 38 ORDER BY team.conference 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* `tables2001` 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 = 22032 AND t.round = 38 ORDER BY team.conference 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* `tables2000` 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 = 22016 AND t.round = 38 ORDER BY team.conference 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* `tables1999` 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 = 22000 AND t.round = 38 ORDER BY team.conference 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* `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 = 21984 AND t.round = 38 ORDER BY team.conference 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* `tables1997` 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 = 21966 AND t.round = 38 ORDER BY team.conference 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* `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 = 21924 AND t.round = 38 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* `tables1994` 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 = 21903 AND t.round = 38 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* `tables1993` 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 = 21882 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Naval

CD Naval

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 3

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.