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

Pontellas

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA GALICIA GRUPO 5
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2022/2023

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Barbadás	38	66	29	81
2	Pontevedra	38	44	19	74
3	Juvenil	38	64	42	61
4	Céltiga FC	38	64	44	59
5	UD Atios	38	50	38	57
6	Ribadumia	38	50	51	56
7	Porriño	38	58	57	55
8	Antela FC	38	48	53	53
9	Portonovo	38	63	55	53
10	Villalonga	38	53	52	52
11	Valladares	38	50	55	52
12	Cambados	38	50	57	50
13	At. Arnoia	38	51	47	50
14	Cultural	38	55	51	50
15	Umia	38	50	52	49
16	CD Beluso	38	52	54	49
17	Verín	38	37	40	44
18	Pontellas	38	36	56	38
19	Racing	38	39	87	27
20	Moraña	38	29	70	27

TEMPORADA 2021/2022

PREFERENTE GALICIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	10	20	6	29
2	Celta Gran.	10	14	11	23
3	Pontevedra	10	23	19	20
4	Portonovo	10	17	13	20
5	Barbadás	10	14	15	20
6	Umia	10	19	14	17
7	Cultural	10	16	17	15
8	Villalonga	10	9	15	12
9	Pontellas	10	12	23	8
10	Verín	10	10	21	8

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

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pontellas	38	85	44	82
2	Estradense	38	67	28	81
3	UD Atios	38	74	46	71
4	Barbadás	37	52	37	69
5	Cambados	38	70	49	61
6	CD Moaña	38	70	45	60
7	Sanxenxo	38	64	46	57
8	CD Beluso	38	54	58	56
9	Villalonga	38	48	47	55
10	Juvenil	38	60	64	53
11	Mondariz CF	38	57	61	52
12	Cultural	37	62	53	50
13	Valladares	38	58	52	48
14	CD Velle	38	40	56	47
15	Marcón	38	33	57	45
16	Alertanavia	38	47	57	44
17	SD Bande	38	58	73	43
18	Amanecer	38	44	66	41
19	Antela FC	38	45	92	23
20	USD O Grove	38	31	88	21

TEMPORADA 2017/2018

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	38	70	29	79
2	Porriño	38	77	37	79
3	UD Atios	38	80	35	76
4	Estradense	38	74	36	71
5	CD Moaña	38	71	40	66
6	SD Bande	38	60	44	66
7	Sanxenxo	38	80	56	62
8	USD O Grove	38	63	58	60
9	CD Beluso	38	73	64	56
10	Pontellas	38	73	63	52
11	Valladares	38	55	71	51
12	Mondariz CF	38	50	65	48
13	Alertanavia	38	53	60	46
14	Marcón	38	45	78	46
15	Caselas	38	57	67	45
16	Campo	38	46	59	45
17	Gondomar Cf	38	63	89	38
18	Erizana	38	57	77	34
19	Nogueira	38	31	67	28
20	Ribeiro FC	38	26	109	14

TEMPORADA 2016/2017

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cultural	38	87	42	83
2	Ourense CF	38	67	33	77
3	Arenteiro	38	67	37	76
4	CD Moaña	38	61	32	72
5	Estradense	38	65	39	67
6	Pontellas	38	68	55	57
7	Valladares	38	61	70	57
8	Nogueira	38	53	52	55
9	Porriño	38	59	55	53
10	Gondomar Cf	38	67	64	52
11	Alertanavia	38	58	59	47
12	Sanxenxo	38	55	59	47
13	USD O Grove	38	59	66	47
14	UD Atios	38	69	73	46
15	Erizana	38	72	70	45
16	Mondariz CF	38	46	55	44
17	Caselas	38	55	82	38
18	Portonovo	38	48	79	32
19	Poligono	38	34	79	27
20	Verín	38	36	86	27

TEMPORADA 2015/2016

PRIMERA GALICIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Erizana	34	84	44	76
2	Pontellas	34	75	35	69
3	CD Moaña	33	68	28	68
4	UVCD Candean	34	49	32	61
5	Juvenil	33	55	42	57
6	Amanecer	34	51	43	55
7	Celta Gran.	34	54	51	53
8	SP Guardes	34	55	41	51
9	Martín	34	44	42	51
10	Esteban	34	36	49	43
11	Campo	33	41	48	42
12	Umia	34	39	59	40
13	Pontevedra	34	47	46	39
14	CD Beluso	32	43	46	37
15	Unión Dena	33	38	67	30
16	Caldas CF	34	40	71	29
17	Rápido	34	39	76	28
18	Nigrán Cf	34	38	76	24

TEMPORADA 2014/2015

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Barco	38	74	41	77
2	Verín	38	67	32	75
3	Portonovo	38	77	48	72
4	Estradense	38	58	35	67
5	Porriño	38	68	48	66
6	Villalonga	38	50	39	60
7	Lalín	38	63	46	57
8	Gondomar Cf	38	62	52	56
9	Valladares	38	56	53	55
10	Mondariz CF	38	58	60	55
11	UD Atios	38	51	46	54
12	Arenteiro	38	51	54	51
13	Céltiga FC	38	49	55	49
14	Marcón	38	52	56	48
15	Alertanavia	38	63	73	47
16	Erizana	38	59	69	46
17	Nogueira	38	39	64	40
18	Pontellas	38	35	66	27
19	Rápido	38	43	87	26
20	Pontevedra	38	32	83	17

TEMPORADA 2013/2014

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ribadumia	38	75	46	69
2	Club	38	64	43	68
3	Villalonga	38	70	38	65
4	Valladares	38	68	45	62
5	Lalín	38	64	57	59
6	Pontellas	38	53	42	59
7	Gondomar Cf	38	51	41	57
8	Pontevedra	38	65	64	56
9	Estradense	38	54	54	55
10	Barco	38	48	48	54
11	Portonovo	38	63	43	54
12	Porriño	38	51	49	52
13	Céltiga FC	38	50	47	51
14	Mondariz CF	38	49	56	50
15	Ourense	38	50	56	49
16	Rápido	38	49	63	49
17	UD Atios	38	47	49	46
18	Caselas	38	40	67	33
19	USD O Grove	38	37	75	31
20	Melias	38	39	104	24

TEMPORADA 2012/2013

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cultural	38	75	44	73
2	Arosa	38	79	37	72
3	Choco	38	68	33	72
4	Sanxenxo	38	56	35	70
5	Portonovo	38	57	41	70
6	Gondomar Cf	38	80	50	66
7	Ribadumia	38	73	46	64
8	Valladares	38	49	37	59
9	UD Atios	38	60	52	59
10	CD Lalín	38	59	52	52
11	Pontellas	38	49	61	51
12	Barco	38	56	62	49
13	Pontevedra	38	51	57	48
14	USD O Grove	38	55	71	48
15	Estradense	38	47	54	47
16	Mondariz CF	38	43	54	42
17	Arenteiro	38	40	62	39
18	Verín	38	44	67	33
19	Marín CF	38	25	76	24
20	Ourense CF	38	28	103	12

TEMPORADA 2011/2012

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Barbadás	38	86	38	84
2	Céltiga FC	38	81	41	80
3	Choco	38	75	36	79
4	Pontellas	38	59	32	70
5	Ribadumia	38	61	45	68
6	Arosa	38	60	43	67
7	Barco	38	56	53	56
8	UD Atios	38	58	50	55
9	Mondariz CF	38	44	49	55
10	Marín CF	38	50	49	51
11	Portonovo	38	50	52	51
12	Verín	38	54	58	48
13	Alerta	38	56	66	47
14	Cruceiro	38	49	57	44
15	Pontevedra	38	42	56	42
16	Sporting	38	37	53	39
17	Celta Gran.	38	50	71	39
18	Tomiño	38	43	57	36
19	Nigrán Cf	38	36	93	21
20	Ourense	38	34	82	20

TEMPORADA 2010/2011

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lalín	38	76	45	75
2	Sanxenxo	38	70	40	72
3	Barbadás	38	53	44	64
4	Verín	38	50	38	63
5	Nigrán Cf	38	65	46	62
6	Céltiga FC	38	51	44	62
7	Pontellas	38	59	37	61
8	Cruceiro	38	49	41	56
9	Choco	38	49	45	54
10	Arosa	38	58	50	53
11	Celta Gran.	38	55	49	53
12	Marín CF	38	50	47	53
13	Ourense	38	47	50	52
14	Ribadumia	38	57	47	51
15	UD Atios	38	48	43	51
16	Porriño	38	42	41	51
17	Rápido	38	38	55	49
18	Cambados	38	48	54	46
19	Arenteiro	38	30	78	21
20	A Peroxa CF	38	21	122	3

TEMPORADA 2009/2010

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Portonovo	38	63	34	74
2	Estradense	38	77	35	72
3	Choco	38	51	25	70
4	Arosa	38	59	48	64
5	Porriño	38	68	38	61
6	Sanxenxo	38	53	36	61
7	Rápido	38	58	42	61
8	Pontellas	38	52	40	59
9	Barbadás	37	62	49	57
10	Ribadumia	38	67	61	51
11	Celta Gran.	38	58	57	51
12	Cruceiro	38	39	44	51
13	Cambados	38	54	63	49
14	Arenteiro	38	46	66	49
15	Sporting	38	49	56	47
16	Marín CF	37	47	56	45
17	Caselas	38	43	66	35
18	Tomiño	38	36	67	33
19	Nogueira	37	39	74	27
20	Covadonga	37	32	96	25

TEMPORADA 2008/2009

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cultural	38	64	38	72
2	Barbadás	38	61	41	70
3	Estradense	38	72	48	65
4	Cruceiro	38	66	42	65
5	Porriño	38	60	47	65
6	Ribadumia	38	58	66	56
7	Arenteiro	38	60	50	54
8	Choco	38	48	38	53
9	Pontellas	38	53	45	53
10	Caselas	38	56	53	53
11	Sanxenxo	38	53	59	51
12	Sporting	38	46	45	49
13	Marín CF	38	56	70	47
14	Tomiño	38	56	54	46
15	Salvatierra	38	41	45	46
16	Ourense	38	47	65	46
17	Barco	38	49	71	37
18	CD Grove	38	42	58	36
19	Ponte	38	46	67	34
20	Melias	38	43	75	34

Competiciones que juega

RIVALES EN Primera Galicia

USO DE MEMORIA

7,055,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1206
Total Execution Time	0.1218

CADENA URL

/historico/Pontellas

GET DATOS

$_GET['/historico/Pontellas']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1994 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1994 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (698965,728119,744436,822157,831531) ORDER BY n.cover_points DESC, update_date DESC
0.0021	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 = '1994' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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=1994 AND l.year in (2023,2024,2025) 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 (73637,68757) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 68757 AND teamId = 1994
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73637 AND teamId = 1994
0.0022	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 = '1994' 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 = '1994' and rp.type = 4
0.0020	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 = '1994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029	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 = 73637 WHERE rp.league_id = 73637 AND rp.teamId = 1994 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 = 73637 WHERE rp.league_id = 73637 AND rp.teamId = 1994 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 73637 WHERE rp.league_id = 73637 AND rp.teamId = 1994 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 1994 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0018	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 = 73637 AND t.round = 31 ORDER BY team.conference ASC,t.position 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* `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 = 68757 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.0021	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 = 64091 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 67010 AND t.round = 10 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 = 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.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* `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.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* `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 = 44619 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* `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 = 39343 AND t.round = 38 ORDER BY team.conference 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* `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 = 34034 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* `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 = 16769 AND t.round = 34 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* `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 = 4050 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* `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 = 2588 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* `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 = 1976 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* `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 = 1452 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* `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 = 1147 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 846 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 = 307 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Pontellas

Pontellas

Selecciona un equipo

Competiciones que juega

RIVALES EN Primera Galicia