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

Bergantiños FC

Entrenador: Jose Manuel Martínez Paz

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	31	45	17	67
2	Celta Gran.	31	46	28	57
3	Arosa	30	34	20	50
4	Ourense UD	31	40	34	48
5	At. Arteixo	31	45	33	47
6	SD Sarriana	31	40	29	47
7	Silva SD	31	35	30	43
8	Alondras CF	30	35	31	42
9	Viveiro	31	37	40	40
10	CD Lugo B	31	30	31	40
11	Somozas	31	38	38	39
12	Estradense	31	27	30	39
13	Barbadás	31	30	34	37
14	Betanzos CF	31	33	31	36
15	Rápido	31	31	38	36
16	UD Paiosaco	31	28	39	35
17	Pontevedra	31	25	56	24
18	CSD Arzua	31	22	62	15

TEMPORADA 2022/2023

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arenteiro	34	44	19	73
2	Real Avilés	34	45	30	59
3	Real	34	49	41	56
4	Compostela	34	42	27	54
5	Zamora	34	38	33	54
6	Guijuelo	34	35	29	54
7	Real Oviedo	34	44	42	51
8	Gimnástica	34	32	31	51
9	Marino	34	33	34	49
10	Rayo	34	41	41	48
11	Coruxo	34	36	29	46
12	Langreo	34	36	38	45
13	Ourense CF	34	36	36	43
14	Palencia	34	25	32	41
15	CD Laredo	34	20	31	35
16	Burgos CF B	34	29	54	27
17	CD Lugo B	34	30	47	26
18	Bergantiños	34	33	54	22

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	34	66	35	65
2	Unión	34	54	39	61
3	Navalcarnero	34	41	32	57
4	Coruxo	34	46	32	52
5	Palencia	34	51	41	52
6	Bergantiños	34	36	37	49
7	Leganés B	34	44	34	48
8	Compostela	34	47	38	47
9	Real Avilés	34	43	37	47
10	Arenteiro	34	35	35	45
11	Langreo	34	40	41	44
12	Marino	34	38	38	43
13	Gimnástica	34	37	42	42
14	Móstoles	34	37	44	41
15	Salamanca	34	26	29	41
16	UD Llanera	34	39	55	40
17	Arosa	34	32	48	39
18	UC Ceares	34	23	78	18

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	22	37	16	48
2	CD Lugo B	22	34	17	42
3	Somozas	22	41	21	41
4	Villalbés	22	34	26	40
5	Deportivo	22	41	27	32
6	Silva SD	22	21	20	30
7	CSD Arzua	22	32	23	29
8	Viveiro	22	25	39	28
9	Estudiantil	22	27	45	20
10	As Pontes	22	18	40	19
11	SD Fisterra	22	22	35	17
12	UD Paiosaco	22	16	39	12
13	Arenteiro	22	33	13	47
14	Arosa	22	27	14	41
15	Alondras CF	22	31	15	37
16	Estradense	22	35	34	31
17	Choco	22	28	22	31
18	Rápido	22	25	25	31
19	Barco	22	26	27	30
20	Ourense CF	22	33	29	28
21	Ribadumia	22	24	36	26
22	Ourense UD	22	25	32	25
23	UD Atios	22	18	32	20
24	Pontellas	22	12	38	9

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	27	50	15	61
2	Ourense CF	27	50	21	60
3	Arosa	27	42	31	47
4	Barco	27	40	40	47
5	Choco	27	40	28	43
6	CSD Arzua	27	40	39	41
7	Deportivo	27	38	28	40
8	Ourense UD	27	32	36	40
9	Arenteiro	27	29	31	35
10	Estradense	27	33	32	35
11	CD Lugo B	27	51	33	35
12	Silva SD	27	24	25	35
13	Bergantiños	27	27	31	34
14	Villalbés	27	30	30	34
15	Somozas	27	31	43	32
16	Alondras CF	27	32	45	32
17	As Pontes	27	39	44	28
18	Rápido	27	36	54	23
19	Pontellas	27	22	56	20
20	UD Paiosaco	27	23	47	17

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	80	35	78
2	Bergantiños	38	58	42	74
3	Compostela	38	80	47	68
4	Alondras CF	38	47	36	65
5	Barco	38	58	43	64
6	Ourense CF	38	51	24	64
7	Choco	38	59	47	59
8	Ourense UD	38	45	39	59
9	Arosa	38	57	44	57
10	CD Lugo B	38	55	53	52
11	Villalbés	38	47	48	52
12	Silva SD	38	52	56	48
13	Arenteiro	38	41	53	47
14	Somozas	38	45	52	46
15	UD Paiosaco	38	46	59	45
16	Céltiga FC	38	36	66	41
17	Laracha	38	42	49	40
18	Ribadumia	38	41	65	38
19	Boiro	38	34	79	31
20	Porriño	38	37	74	27

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	38	78	34	86
2	Bergantiños	38	77	29	80
3	Villalbés	38	60	30	71
4	Alondras CF	38	61	34	69
5	Arosa	38	65	34	67
6	Somozas	38	63	42	63
7	Barco	38	63	44	63
8	Choco	38	50	44	59
9	Ourense CF	38	48	36	58
10	Boiro	38	52	53	58
11	Silva SD	38	45	46	55
12	Ribadumia	38	44	55	47
13	Céltiga FC	38	32	57	44
14	Arenteiro	38	39	61	42
15	Laracha	38	35	44	41
16	Cultural	38	48	82	34
17	Noia	38	42	72	32
18	Barbadás	38	29	61	32
19	Negreira	38	31	63	31
20	Villalonga	38	28	69	27

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	79	31	81
2	Rápido	38	51	24	72
3	CCD Cerceda	38	65	36	71
4	Bergantiños	38	52	31	68
5	Villalbés	38	51	35	67
6	Arosa	38	51	38	64
7	Compostela	38	61	47	62
8	Villalonga	38	55	40	59
9	Silva SD	38	52	50	57
10	Choco	38	55	50	52
11	Barbadás	38	45	48	50
12	Negreira	38	51	48	49
13	Barco	38	50	55	49
14	Alondras CF	38	50	45	48
15	Ribadumia	38	41	52	48
16	Céltiga FC	38	42	45	47
17	CD Castro	38	47	72	37
18	As Pontes	38	32	67	28
19	Dubra	38	36	83	21
20	Club Ordenes	38	24	93	9

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Boiro	38	71	33	77
2	CCD Cerceda	38	64	40	72
3	Deportivo	38	74	46	67
4	Choco	38	57	40	63
5	Villalbés	38	51	43	58
6	Barco	38	55	54	57
7	Alondras CF	38	44	41	56
8	Rápido	38	51	46	55
9	Arosa	38	55	48	54
10	As Pontes	38	49	54	49
11	Ribadumia	38	54	51	48
12	Negreira	38	47	48	48
13	Silva SD	38	53	56	48
14	Barbadás	38	47	58	45
15	Club Ordenes	38	33	45	45
16	Bergantiños	38	38	43	43
17	Galicia	38	48	63	43
18	Ribadeo FC	38	41	68	35
19	Noia	38	28	59	32
20	Verín	38	30	54	31

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	38	65	25	79
2	Deportivo	38	66	32	71
3	CCD Cerceda	38	64	37	64
4	Choco	38	58	39	62
5	Bergantiños	38	46	31	59
6	Ribadeo FC	38	54	64	58
7	Ribadumia	38	56	44	58
8	Alondras CF	38	43	41	56
9	Villalbés	38	49	38	56
10	Rápido	38	48	35	56
11	Arosa	38	51	42	54
12	Barbadás	38	39	40	53
13	Club Ordenes	38	47	48	53
14	As Pontes	38	48	50	52
15	Boiro	38	51	48	51
16	Silva SD	38	44	58	48
17	Sanxenxo	38	48	65	41
18	Cultural	38	41	65	34
19	Laracha	38	28	61	33
20	Bertamiráns	38	26	109	8

TEMPORADA 2013/2014

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ribadeo FC	38	76	37	84
2	Bergantiños	38	65	26	83
3	Silva SD	38	74	41	74
4	Viveiro	38	60	34	72
5	CF Dumbría	38	63	31	67
6	Estudiantil	38	50	37	61
7	Sporting	38	52	41	61
8	Dubra	38	54	48	55
9	Residencia	38	51	52	54
10	Galicia	38	61	57	49
11	Cidade	38	54	50	49
12	SD Chantada	38	43	47	47
13	CD Castro	38	41	44	45
14	Xallas FC	38	44	65	40
15	O Val	38	41	63	39
16	Tirso	38	37	58	38
17	Ud Carral	38	42	72	37
18	Club Lemos	38	49	80	35
19	Narón BP	38	47	78	33
20	Soneira Sd	38	41	84	24

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	98	22	97
2	Celta	38	75	34	77
3	Compostela	38	64	28	73
4	Deportivo	38	76	33	71
5	Pontevedra	38	57	45	63
6	As Pontes	38	56	53	59
7	Club Ordenes	38	45	38	55
8	Rápido	38	39	53	52
9	Alondras CF	38	48	45	52
10	Villalbés	38	45	42	48
11	CCD Cerceda	38	35	44	48
12	Somozas	38	41	45	47
13	Betanzos CF	38	48	61	47
14	Barbadás	38	39	47	47
15	SD Negreira	38	37	56	45
16	CD Dorneda	38	37	55	45
17	Villalonga	38	44	50	45
18	Bergantiños	38	28	63	30
19	Céltiga FC	38	28	71	25
20	Narón BP	38	30	85	20

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	38	49	25	76
2	Alondras CF	38	68	41	73
3	CCD Cerceda	38	47	29	70
4	Pontevedra	38	54	34	70
5	Rácing	38	57	45	67
6	Deportivo	38	56	33	65
7	Rápido	38	52	50	56
8	Racing	38	55	41	55
9	Villalonga	38	45	48	50
10	CD Dorneda	38	39	47	49
11	Somozas	38	50	51	48
12	Club Ordenes	38	40	47	46
13	Bergantiños	38	37	44	45
14	SD Negreira	38	41	52	44
15	Betanzos CF	38	43	53	42
16	As Pontes	38	47	53	41
17	Estradense	38	37	51	41
18	Cultural	38	40	58	40
19	Lalín	38	30	53	39
20	Sanxenxo	38	33	65	28

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CCD Cerceda	36	58	17	83
2	Racing	36	79	29	73
3	CD Ourense	36	71	31	67
4	Rácing	36	39	25	63
5	Somozas	36	49	32	60
6	Alondras CF	36	47	38	55
7	Club Ordenes	36	42	44	55
8	SD Negreira	36	41	35	51
9	Villalonga	36	42	45	49
10	Rápido	36	43	51	44
11	As Pontes	36	41	53	44
12	Estradense	36	37	41	44
13	Mesón Bento	36	36	48	40
14	Bergantiños	36	33	45	40
15	Cultural	36	40	55	39
16	Pontevedra	36	30	46	37
17	Xallas FC	36	30	52	35
18	Narón BP	36	33	56	31
19	Portonovo	36	23	71	22

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	36	65	33	82
2	CCD Cerceda	36	52	29	70
3	CD Ourense	36	70	34	68
4	Coruxo	36	54	32	64
5	Narón BP	36	49	45	59
6	Alondras CF	35	48	38	53
7	Club Ordenes	36	46	43	53
8	Negreira	36	41	37	51
9	Rácing	36	36	37	48
10	Xallas FC	36	44	48	46
11	Rápido	35	37	35	46
12	Villalonga	36	36	39	44
13	Cultural	36	34	50	44
14	Bergantiños	36	30	49	42
15	Pontevedra	36	44	47	40
16	Somozas	36	40	56	39
17	Lalín	36	38	51	38
18	Céltiga FC	36	37	45	36
19	Verín	36	26	79	15
20	Ciudad	0	0	0	0

TEMPORADA 2008/2009

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rácing	38	77	20	88
2	Bergantiños	38	69	31	82
3	Betanzos CF	38	72	27	73
4	CD Foz	38	50	41	62
5	Flavia	38	50	46	60
6	Santiago	38	50	50	56
7	CD Castro	38	55	38	54
8	Laracha	38	53	52	53
9	As Pontes	38	49	49	52
10	Boiro	38	44	45	52
11	Dubra	38	37	49	49
12	Viveiro	38	42	48	47
13	Sporting	38	44	48	44
14	Noia	38	49	61	44
15	CD Dorneda	38	43	56	42
16	Club Lemos	38	36	49	42
17	SD Chantada	38	46	69	42
18	Calo	38	45	69	35
19	Vizoño	38	37	71	34
20	Outeiro	38	33	62	29

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	70	36	72
2	Coruxo	38	61	34	72
3	Negreira	38	55	34	68
4	Villalonga	38	57	37	67
5	Club Ordenes	38	63	51	66
6	CCD Cerceda	38	58	47	63
7	Xallas FC	38	56	46	63
8	Portonovo	38	48	39	58
9	Alondras CF	38	52	39	56
10	Narón BP	38	52	46	55
11	Ourense	38	50	52	53
12	Rápido	38	51	44	49
13	Céltiga FC	38	52	58	48
14	Lalín	38	48	79	38
15	Betanzos CF	38	43	52	37
16	Arosa	38	49	73	37
17	Club Lemos	38	38	64	37
18	Bergantiños	38	35	53	36
19	Laracha	38	24	50	31
20	Cruceiro	38	47	75	31

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	74	20	93
2	CD Lugo	38	79	28	86
3	Laracha	38	61	26	74
4	Alondras CF	38	59	33	69
5	Coruxo	38	64	32	67
6	CCD Cerceda	38	50	39	64
7	Arosa	38	53	54	59
8	Narón BP	38	54	51	55
9	Céltiga FC	38	52	54	55
10	Xallas FC	38	46	42	55
11	Bergantiños	38	49	45	53
12	Portonovo	38	37	40	50
13	Villalonga	38	39	44	47
14	Lalín	38	37	43	47
15	Rápido	38	43	42	44
16	Betanzos CF	38	38	54	41
17	Club Lemos	38	39	62	34
18	Viveiro	38	32	75	23
19	O Val	38	31	79	22
20	Caselas	38	21	95	13

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rápido	38	53	26	74
2	Negreira	38	52	24	72
3	CD Lugo	38	58	30	71
4	Coruxo	38	47	26	68
5	Laracha	38	48	25	65
6	CCD Cerceda	38	71	45	64
7	Lalín	38	51	36	63
8	Deportivo	38	54	36	56
9	Narón BP	38	48	47	51
10	Betanzos CF	38	47	52	50
11	Viveiro	38	50	51	49
12	Bergantiños	38	46	54	47
13	Alondras CF	38	46	74	45
14	Portonovo	38	32	48	43
15	Arosa	38	32	39	43
16	Villalonga	38	40	60	39
17	O Val	38	30	60	38
18	Porriño	38	36	53	35
19	CD Grove	38	42	69	34
20	Verín	38	31	59	33

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CCD Cerceda	38	65	31	76
2	At. Arteixo	38	70	35	73
3	Deportivo	38	65	37	71
4	Verín	38	56	37	68
5	Lalín	38	49	34	65
6	CD Lugo	38	60	41	64
7	Compostela	38	39	37	57
8	Porriño	38	48	40	56
9	Coruxo	38	44	50	50
10	Bergantiños	38	47	48	48
11	Negreira	38	34	42	47
12	Betanzos CF	38	41	43	46
13	CD Grove	38	53	56	45
14	Rápido	38	43	47	44
15	Portonovo	38	34	48	44
16	Arosa	38	41	56	41
17	Narón BP	38	44	68	37
18	Ponte	38	42	72	36
19	SP Guardes	38	34	59	35
20	Xove Lago	38	33	61	30

Competiciones que juega

Tercera Federación Grupo 1

Pos	Equipos		Pts
1		Bergantiños FC	67
2		Celta C – Gran Peña	57
3		Arosa	50
4		Ourense UD	48
5		At. Arteixo	47
6		SD Sarriana	47
7		Silva SD	43
8		Alondras CF	42
9		Viveiro	40
10		CD Lugo B	40
11		Somozas	39
12		CD Estradense	39
13		Barbadás	37
14		Betanzos CF	36
15		Rápido de Bouzas	36
16		UD Paiosaco	35
17		Pontevedra B	24
18		CSD Arzua	15

	Ascenso : Bergantiños FC
	Playoff Ascenso : Celta C – Gran Peña, Arosa, Ourense UD, At. Arteixo
	Descenso : UD Paiosaco, Pontevedra B, CSD Arzua

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,264,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.6415
Total Execution Time	0.6438

CADENA URL

/historico/Bergantinos

GET DATOS

$_GET['/historico/Bergantinos']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=479 AND type_rel = 2
0.0133	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 479 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0140	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 (93042,225942,263458,427710,428153) ORDER BY n.cover_points DESC, update_date DESC
0.0138	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 = '479' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134	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=479 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129	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 (72729,72260,69379,67965,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.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 67965 AND teamId = 479
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 72260 AND teamId = 479
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 72729 AND teamId = 479
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 69379 AND teamId = 479
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 479
0.0142	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 = '479' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '479' and rp.type = 4
0.0129	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 = '479' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 479 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.0163	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 479 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 479 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0187	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 = 479 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0263	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 = 67965 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 62380 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 58579 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.0140	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 = 50269 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.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* `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 = 44389 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 39025 AND t.round = 38 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 = 33351 AND t.round = 38 ORDER BY team.conference 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* `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 = 15442 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 = 3911 AND t.round = 38 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* `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 = 2587 AND t.round = 38 ORDER BY team.conference 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* `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 = 1970 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* `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 = 1398 AND t.round = 38 ORDER BY team.conference 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* `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 = 1118 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 833 AND t.round = 38 ORDER BY team.conference 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* `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 = 286 AND t.round = 38 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* `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 = 86 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* `tables2006` 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 = 21002 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* `tables2005` 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 = 21001 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Bergantiños FC

Bergantiños FC

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 1

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.