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.

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 Pamplona

Entrenador: Julen Etxebeste

Temporada 2022/2023

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Valle	30	45	18	62
2	Subiza	30	53	31	55
3	CF Ardoi	30	36	26	54
4	Peña Sport	30	44	28	52
5	Itaroa	30	41	33	48
6	Beti Onak	30	43	41	45
7	Cantolagua	30	42	46	44
8	Lagunak	30	40	47	39
9	CD Cortes	30	28	34	38
10	Avance	30	42	41	38
11	Burladés	30	30	34	37
12	CD Pamplona	30	36	32	36
13	Oberena	30	42	48	36
14	Txantrea	30	34	41	35
15	CD Alesves	30	23	53	24
16	Azkoyen	30	27	53	23

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Cirbonero	30	50	12	69
2	Subiza	30	62	24	64
3	Txantrea	30	46	26	55
4	Itaroa	30	58	40	51
5	Cantolagua	30	49	33	50
6	CD Cortes	30	39	24	48
7	Beti Onak	30	37	30	44
8	Avance	30	41	39	40
9	CD Pamplona	30	24	30	38
10	Azkoyen	30	32	51	37
11	Valle	30	38	49	37
12	Burladés	30	35	39	33
13	Murchante	30	29	50	32
14	Beti Kozkor	30	20	41	28
15	Corellano	30	27	52	23
16	Gares	30	20	67	18

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	AD San Juan	20	21	9	35
2	Beti Kozkor	20	23	18	33
3	Valle	20	31	23	32
4	Itaroa	20	29	23	30
5	CD Pamplona	20	28	18	30
6	Burladés	20	22	30	26
7	Beti Onak	20	26	25	24
8	Corellano	20	24	29	24
9	Txantrea	20	23	29	23
10	Subiza	20	25	28	21
11	River Ega	20	23	43	14
12	Peña Sport	20	32	14	47
13	Cirbonero	20	35	21	32
14	CF Ardoi	20	26	15	32
15	Cantolagua	20	28	19	31
16	CD Cortes	20	18	21	28
17	Murchante	20	19	19	24
18	Peña	20	24	33	24
19	Baztan	20	19	27	20
20	Fontellas	20	18	37	20
21	Lourdes	20	18	26	19
22	Bidezarra	20	18	23	19

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Mutilvera	27	57	27	58
2	AD San Juan	27	49	23	55
3	Beti Kozkor	27	42	27	52
4	CD Pamplona	27	36	18	50
5	Itaroa	27	40	26	47
6	Peña Sport	27	44	35	45
7	Cirbonero	27	52	38	44
8	Txantrea	27	45	34	41
9	Burladés	27	31	34	37
10	Valle	27	45	41	35
11	Beti Onak	27	32	38	35
12	CD Cortes	27	27	23	32
13	Corellano	27	29	42	32
14	Murchante	27	27	30	31
15	Lourdes	27	28	37	30
16	CF Ardoi	27	29	39	30
17	Peña	27	39	53	25
18	Subiza	27	34	49	24
19	Baztan	27	30	57	19
20	Fontellas	27	16	61	13

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Osasuna	38	89	20	92
2	Peña Sport	38	99	35	88
3	Mutilvera	38	69	31	81
4	Beti Kozkor	38	58	32	71
5	CD Cortes	38	49	43	62
6	AD San Juan	38	55	36	56
7	Cirbonero	38	49	38	52
8	Txantrea	38	56	64	46
9	Baztan	38	65	77	46
10	Burladés	38	36	47	46
11	Itaroa	38	40	57	44
12	Beti Onak	38	41	65	43
13	CF Ardoi	38	38	48	43
14	Subiza	38	51	63	43
15	Corellano	38	35	64	41
16	Valle	38	45	55	40
17	CD Pamplona	38	44	54	39
18	Avance	38	43	59	37
19	Cantolagua	38	39	61	37
20	CD Alesves	38	39	91	28

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Mutilvera	38	77	25	90
2	AD San Juan	38	52	22	74
3	CD Iruña	38	59	28	73
4	Burladés	38	51	28	65
5	Cirbonero	38	58	39	63
6	CD Pamplona	38	44	41	54
7	Txantrea	38	50	41	53
8	CF Ardoi	38	51	57	51
9	CD Cortes	38	36	39	50
10	Beti Kozkor	38	40	45	49
11	Valle	38	48	48	48
12	Baztan	38	50	68	47
13	Subiza	38	53	57	46
14	Cantolagua	38	41	56	46
15	Itaroa	38	39	47	45
16	Corellano	38	36	53	43
17	Oberena	38	37	56	43
18	Idoya	38	37	61	32
19	River Ega	38	45	67	32
20	Gares	38	28	54	31

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	73	35	82
2	CD Iruña	38	66	32	79
3	Cirbonero	38	65	30	77
4	CD Cortes	38	51	35	64
5	Oberena	38	54	45	63
6	AD San Juan	38	60	42	62
7	Burladés	38	51	50	59
8	Idoya	38	51	47	57
9	Itaroa	38	39	36	52
10	Txantrea	38	63	56	52
11	Subiza	38	65	62	50
12	Cantolagua	38	44	47	49
13	Valle	38	51	49	45
14	River Ega	38	52	77	45
15	CD Pamplona	38	47	52	44
16	Corellano	38	49	56	44
17	CF Ardoi	38	39	46	44
18	Lourdes	38	37	56	40
19	Erriberri	38	27	69	29
20	Valtierrano	38	30	92	14

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Osasuna	38	81	24	84
2	Cirbonero	38	67	32	80
3	AD San Juan	38	65	31	77
4	Mutilvera	38	80	35	76
5	CD Cortes	38	48	30	73
6	CF Ardoi	38	68	40	65
7	Valle	38	55	52	55
8	Burladés	38	47	43	50
9	River Ega	38	48	58	50
10	Subiza	38	57	62	49
11	Txantrea	38	70	66	48
12	CD Pamplona	38	50	49	47
13	Cantolagua	38	40	54	44
14	CD Iruña	38	51	57	44
15	Erriberri	38	23	53	42
16	Itaroa	38	39	52	39
17	Oberena	38	38	66	37
18	Baztan	38	53	97	32
19	Beti Onak	38	42	82	28
20	Mendi	38	34	73	24

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	36	68	29	85
2	AD San Juan	36	49	15	75
3	Osasuna	38	64	31	72
4	Izarra	36	65	31	70
5	Mutilvera	36	62	38	63
6	CD Cortes	36	47	42	57
7	Oberena	36	50	41	56
8	Burladés	36	43	33	56
9	Itaroa	36	49	43	53
10	Txantrea	36	56	52	50
11	Cirbonero	36	42	43	46
12	Valle	36	63	62	45
13	CF Ardoi	36	38	49	41
14	Subiza	36	49	73	38
15	CD Pamplona	36	39	55	37
16	Beti Onak	36	38	57	37
17	Idoya	36	33	68	33
18	Valtierrano	36	31	73	23
19	Corellano	36	25	74	17
20	CD Iruña	2	2	4	0

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Izarra	38	59	16	85
2	AD San Juan	38	57	14	85
3	Mutilvera	38	57	26	75
4	Osasuna	38	76	32	75
5	Txantrea	38	56	36	66
6	Valle	38	60	49	62
7	CD Cortes	38	44	43	52
8	Oberena	38	45	49	50
9	CD Iruña	38	44	48	48
10	Cirbonero	38	47	50	46
11	Itaroa	38	41	44	46
12	Burladés	38	37	41	46
13	CD Pamplona	38	51	57	46
14	Corellano	38	47	57	42
15	Beti Onak	38	50	59	42
16	Valtierrano	38	42	64	42
17	Lagun Artea	38	48	62	41
18	Murchante	38	34	62	36
19	Erriberri	38	31	64	32
20	Artajonés	38	25	78	23

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	88	35	92
2	Izarra	38	104	33	90
3	Tudelano	38	97	26	88
4	Mutilvera	38	71	32	80
5	AD San Juan	38	50	36	66
6	Txantrea	38	54	38	60
7	Murchante	38	61	64	54
8	Cirbonero	38	57	53	53
9	CD Iruña	38	53	53	52
10	CD Pamplona	38	47	65	43
11	Oberena	38	48	61	42
12	Itaroa	38	54	60	41
13	Valle	38	43	60	41
14	Idoya	38	36	61	39
15	Burladés	38	40	48	38
16	Aoiz	38	49	74	38
17	CD Cortes	38	33	63	37
18	Lourdes	38	39	77	33
19	Azkoyen	38	34	65	32
20	Aluvión	38	33	87	21

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Tudelano	38	87	24	90
2	Nivel	38	78	24	83
3	Valle	38	57	45	67
4	Mutilvera	38	60	34	66
5	Txantrea	38	57	35	65
6	CD Iruña	38	52	36	59
7	AD San Juan	38	38	30	56
8	Cirbonero	38	51	46	53
9	Lourdes	38	52	57	53
10	Oberena	38	40	39	52
11	CD Pamplona	38	51	49	49
12	Murchante	38	50	57	45
13	Itaroa	38	45	48	44
14	Aoiz	38	37	49	42
15	Aluvión	38	34	44	41
16	Idoya	38	51	77	41
17	CF Ardoi	38	29	57	38
18	Lagun Artea	38	38	80	37
19	River Ega	38	26	73	27
20	Peña	38	34	63	25

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Tudelano	38	87	29	89
2	Peña Sport	38	87	27	82
3	Cirbonero	38	57	38	71
4	CD Iruña	38	58	35	69
5	Mutilvera	38	69	46	65
6	AD San Juan	38	50	36	58
7	Valle	38	51	43	57
8	Txantrea	38	40	38	52
9	Lourdes	38	67	64	52
10	Oberena	38	62	49	49
11	CD Pamplona	38	33	45	48
12	Aoiz	38	36	39	48
13	Aluvión	38	44	61	44
14	River Ega	38	33	38	41
15	Peña	38	44	61	41
16	Murchante	38	29	50	40
17	Itaroa	38	38	59	39
18	Valtierrano	38	34	91	36
19	Zarramonza	38	28	58	34
20	CD Cortes	38	25	65	23

TEMPORADA 2008/2009

AUTONÓMICA NAVARRA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Pamplona	30	47	19	66
2	Cantolagua	30	53	32	59
3	Jorge	30	63	36	58
4	Amigó	30	60	38	55
5	Burladés	30	41	34	45
6	Lagun Artea	30	42	40	45
7	Cristóbal	30	50	33	44
8	Aurrera	30	35	41	40
9	Amaya	30	40	40	35
10	Gazte	30	36	42	35
11	Subiza	30	44	61	34
12	Avance	30	39	53	33
13	Baztan	30	41	58	33
14	Osasuna	30	44	58	32
15	San Ignacio	30	30	55	28
16	Gares	30	28	53	24

Competiciones que juega

Tercera Federación Grupo 15

Pos	Equipos		Pts
1		CD Valle de Egüés	62
2		Subiza	55
3		CF Ardoi	54
4		Peña Sport	52
5		CD Itaroa Huarte	48
6		Beti Onak	45
7		Cantolagua	44
8		Lagunak	39
9		CD Cortes	38
10		Avance Ezcabarte	38
11		Burladés	37
12		CD Pamplona	36
13		Oberena	36
14		Txantrea	35
15		CD Alesves	24
16		Azkoyen	23

	Ascenso : CD Valle de Egüés
	Playoff Ascenso : Subiza, CF Ardoi, Peña Sport, CD Itaroa Huarte
	Descenso : Azkoyen

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,104,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1796
Total Execution Time	0.1817

CADENA URL

/historico/Pamplona/2023

GET DATOS

$_GET['/historico/Pamplona/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0033	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 = 'Pamplona' AND l.year = 2023 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.0019	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=1909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 67989
0.0027	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 = 68196
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1909 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1909 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028	SELECT /35 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 (345511,822157,831186,861791,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '1909' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '1909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 68196 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 67989 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=1909 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72275,71432,68196) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72275 AND teamId = 1909
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68196 AND teamId = 1909
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1909
0.0021	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1909' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042	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 events2023 e ON e.player_id = p.id AND e.league_id = 67989 WHERE rp.league_id = 67989 AND rp.teamId = 1909 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 67989 WHERE rp.league_id = 67989 AND rp.teamId = 1909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 events2023 e ON e.player_id = p.id AND e.league_id = 67989 WHERE rp.league_id = 67989 AND rp.teamId = 1909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 1909 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67989 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.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* `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 = 62399 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* `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 = 58594 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.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* `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 = 50283 AND t.round = 27 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* `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 = 44403 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* `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 = 39039 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* `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 = 33365 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 15457 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* `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 = 3924 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* `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 = 2564 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* `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 = 1449 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 1135 AND t.round = 38 ORDER BY team.conference 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* `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 = 842 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* `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 = 297 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Pamplona

CD Pamplona

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 15

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.