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

Fabril Barreiro

Temporada 2023/2024

TEMPORADA 2023/2024

CAMPEONATO DE PORTUGAL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Vitória	26	45	21	53
2	Moncarapache	26	29	17	49
3	Lusitano	26	28	9	46
4	Louletano	26	37	26	41
5	Sintrense	26	29	26	40
6	O Elvas	26	34	27	39
7	Barreirense	26	31	25	39
8	Fabril	26	29	24	34
9	Serpa	26	27	30	34
10	Juventude	26	26	25	32
11	Vasco Gama	26	26	45	30
12	Oriental	26	31	48	29
13	Real Sport.	26	24	46	14
14	Imortal DC	26	19	46	13

TEMPORADA 2022/2023

CAMPEONATO DE PORTUGAL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Atlético	26	43	22	52
2	Lusitano	26	35	22	51
3	Juventude	26	37	16	46
4	Rabo Peixe	26	33	19	45
5	Imortal DC	26	31	22	39
6	Fabril	26	31	26	39
7	Vasco Gama	26	37	33	39
8	Serpa	26	44	36	36
9	Oriental	26	35	36	36
10	Praiense	26	31	32	34
11	Esperança	26	28	38	31
12	Angrense	26	17	46	17
13	Olhanense	26	18	50	17
14	Ferreiras	26	17	39	16

TEMPORADA 2020/2021

CAMPEONATO DE PORTUGAL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Estrela	22	34	12	53
2	Sporting	22	33	7	49
3	Oriental	22	30	20	37
4	Real Sport.	22	32	23	32
5	Fontinhas	22	30	26	32
6	Praiense	22	25	23	32
7	Rabo Peixe	22	17	25	27
8	Ideal	22	26	34	23
9	Belenenses	22	16	26	22
10	Fabril	22	19	31	21
11	Oriental	22	16	27	16
12	Olímpico	22	19	43	16

TEMPORADA 2019/2020

CAMPEONATO DE PORTUGAL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Sport.	25	58	16	57
2	Olhanense	25	57	19	57
3	FC Alverca	25	48	22	53
4	Louletano	23	38	19	50
5	Pinhalnovens	25	43	31	45
6	Sintrense	25	27	17	45
7	Loures	25	35	25	42
8	Oriental	25	30	27	38
9	Dezembro	25	27	28	30
10	Amora FC	25	24	29	28
11	Esperança	24	25	38	27
12	Armacenenses	25	33	48	27
13	Olímpico	25	26	45	21
14	Sacavenense	25	19	38	21
15	Lusitano	25	30	48	20
16	Fabril	25	21	46	19
17	Sintra	25	20	39	16
18	Aljustrelens	24	25	51	15

TEMPORADA 2016/2017

CAMPEONATO DE PORTUGAL GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Farense	18	31	7	39
2	Louletano	18	31	16	38
3	Lusitano	18	31	23	31
4	Moura	18	20	18	27
5	Pinhalnovens	18	21	20	27
6	Aljustrelens	18	26	30	21
7	Almancilense	18	25	29	21
8	Viana	18	24	36	14
9	Armacenenses	18	20	34	14
10	Fabril	18	22	38	14

TEMPORADA 2014/2015

CAMPEONATO DE PORTUGAL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Dezembro	18	28	15	35
2	Casa Pia AC	18	18	11	31
3	Cova Piedade	18	17	15	28
4	União	18	24	22	26
5	Loures	18	22	18	24
6	Sacavenense	18	20	20	24
7	Atlético	18	20	21	23
8	Pinhalnovens	18	14	18	21
9	Sintrense	18	18	27	21
10	Fabril	18	15	29	14

TEMPORADA 2012/2013

III DIVISAO PORTUGAL GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sintrense	22	42	19	40
2	Fabril	22	40	23	40
3	Sacavenense	22	39	22	36
4	Eléctrico	22	31	16	36
5	Barreirense	22	35	33	36
6	Lourinhanens	22	38	29	34
7	Pêro	22	27	27	34
8	Real Sport.	22	31	24	30
9	Amora FC	22	26	34	26
10	União Tires	22	25	27	25
11	Peniche	22	18	48	21
12	Cartaxo	22	13	63	5

TEMPORADA 2011/2012

III DIVISAO PORTUGAL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Farense	22	52	17	56
2	Lagos	22	36	25	37
3	Sesimbra	22	30	25	35
4	Quarteirense	22	27	25	35
5	Messinense	22	28	25	34
6	Aljustrelens	22	33	31	34
7	Fabril	22	36	29	33
8	Lagoa	22	21	19	30
9	União	22	23	22	29
10	Pescadores	22	24	37	23
11	Redondense	22	21	32	19
12	Despertar	22	7	51	4

TEMPORADA 1975/1976

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	30	94	20	50
2	Boavista	30	65	23	48
3	Belenenses	30	45	28	40
4	Porto	30	73	33	39
5	Sporting CP	30	56	30	39
6	Vitória	30	49	32	36
7	Sporting	30	35	43	28
8	Estoril	30	31	45	28
9	Vitória	30	39	42	26
10	Académica	30	32	47	23
11	Atlético	30	25	51	22
12	Leixões	30	30	65	22
13	Beira	30	28	47	21
14	Uniao Tomar	30	32	61	21
15	Farense	30	33	65	19
16	Fabril	30	15	50	18

TEMPORADA 1974/1975

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	30	62	12	49
2	Porto	30	62	30	44
3	Sporting CP	30	59	25	43
4	Boavista	30	58	32	38
5	Vitória	30	64	36	38
6	Belenenses	30	45	37	35
7	Vitória	30	49	35	31
8	Leixões	30	29	42	29
9	Fabril	30	40	42	27
10	Atlético	30	38	69	26
11	Farense	30	38	52	25
12	Uniao Tomar	30	39	59	23
13	Oriental	30	21	51	20
14	Académica	30	33	47	20
15	Olhanense	30	41	70	17
16	Espinho	30	25	64	15

TEMPORADA 1973/1974

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	30	96	21	49
2	Benfica	30	68	23	47
3	Vitória	30	69	21	45
4	Porto	30	43	22	43
5	Belenenses	30	56	34	40
6	Vitória	30	36	34	31
7	Farense	30	35	38	26
8	Fabril	30	33	44	25
9	Boavista	30	35	43	25
10	Académica	30	29	45	23
11	Olhanense	30	35	69	22
12	Oriental	30	35	79	21
13	Beira	30	34	59	21
14	Leixões	30	36	56	21
15	Barreirense	30	19	42	21
16	Montijo CD	30	32	61	20

TEMPORADA 1972/1973

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	30	101	13	58
2	Belenenses	30	53	30	40
3	Vitória	30	65	26	38
4	Porto	30	56	28	37
5	Sporting CP	30	57	31	37
6	Vitória	30	38	38	33
7	Boavista	30	41	47	31
8	Fabril	30	38	37	30
9	Leixões	30	32	45	30
10	Barreirense	30	43	64	25
11	Farense	30	27	53	24
12	Beira	30	27	57	23
13	Montijo CD	30	29	47	23
14	União	30	22	54	17
15	Atlético	30	27	52	17
16	Uniao Tomar	30	35	69	17

TEMPORADA 1971/1972

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	30	81	16	55
2	Vitória	30	62	16	45
3	Sporting CP	30	51	26	43
4	Fabril	30	43	28	37
5	Porto	30	51	32	33
6	Vitória	30	49	47	30
7	Belenenses	30	35	33	29
8	Barreirense	30	34	46	27
9	Farense	30	34	48	25
10	Atlético	30	35	52	25
11	Boavista	30	28	46	24
12	Uniao Tomar	30	25	42	23
13	Beira	30	29	51	23
14	Leixões	30	26	51	21
15	Académica	30	29	38	21
16	Tirsense	30	26	66	19

TEMPORADA 1970/1971

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	62	17	41
2	Sporting CP	26	45	14	38
3	Porto	26	44	21	37
4	Vitória	26	51	16	34
5	Académica	26	38	24	33
6	Boavista	26	18	38	22
7	Belenenses	26	20	27	22
8	Fabril	26	28	37	21
9	Tirsense	26	24	45	20
10	Barreirense	26	21	31	20
11	Farense	26	15	33	20
12	Vitória	26	15	27	19
13	Leixões	26	22	44	19
14	Varzim	26	23	52	18

TEMPORADA 1969/1970

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	61	17	46
2	Benfica	26	58	14	38
3	Vitória	26	58	26	36
4	Barreirense	26	42	33	28
5	Vitória	26	38	36	28
6	Varzim	26	31	26	28
7	Belenenses	26	23	34	23
8	Fabril	26	24	38	23
9	Porto	26	30	37	22
10	Académica	26	42	46	22
11	Leixões	26	33	47	21
12	Boavista	26	35	61	18
13	Sporting	26	25	52	17
14	Uniao Tomar	26	20	53	14

TEMPORADA 1968/1969

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	49	17	39
2	Porto	26	39	23	37
3	Vitória	26	46	17	36
4	Vitória	26	45	20	35
5	Sporting CP	26	35	20	30
6	Académica	26	48	32	30
7	Fabril	26	32	30	27
8	Belenenses	26	31	33	26
9	Varzim	26	32	49	22
10	Uniao Tomar	26	27	47	21
11	Leixões	26	21	30	21
12	Sporting	26	20	47	19
13	Atlético	26	26	49	12
14	Sanjoanense	26	15	52	9

TEMPORADA 1967/1968

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	75	19	41
2	Sporting CP	26	48	24	37
3	Porto	26	60	24	36
4	Académica	26	53	24	35
5	Vitória	26	43	20	34
6	Vitória	26	31	34	27
7	Belenenses	26	38	40	25
8	Leixões	26	29	39	24
9	Sporting	26	29	48	21
10	Sanjoanense	26	22	40	21
11	Fabril	26	28	37	21
12	Varzim	26	27	50	17
13	Tirsense	26	17	53	15
14	Barreirense	26	24	72	10

TEMPORADA 1966/1967

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	64	19	43
2	Académica	26	50	18	40
3	Porto	26	56	22	39
4	Sporting CP	26	36	24	30
5	Vitória	26	27	25	27
6	Vitória	26	35	40	26
7	Leixões	26	23	29	24
8	Fabril	26	27	43	23
9	Sporting	26	33	33	23
10	Varzim	26	29	42	22
11	Belenenses	26	26	34	20
12	Sanjoanense	26	23	39	19
13	Atlético	26	29	55	14
14	Beira	26	23	58	14

TEMPORADA 1965/1966

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	70	21	42
2	Benfica	26	73	30	41
3	Porto	26	41	25	34
4	Vitória	26	58	47	33
5	Vitória	26	51	36	29
6	Académica	26	58	48	26
7	Belenenses	26	28	29	25
8	Varzim	26	40	38	25
9	Fabril	26	37	46	24
10	Sporting	26	39	64	21
11	Beira	26	31	65	18
12	Leixões	26	28	39	18
13	Lusitano	26	27	60	14
14	Barreirense	26	32	65	14

Competiciones que juega

Grupo 4

Campeonato de Portugal Grupo 4

Pos	Equipos		Pts
1		Vitória Setúbal	53
2		Moncarapachense	49
3		Lusitano Évora 1911	46
4		Louletano	41
5		Sintrense	40
6		O Elvas	39
7		FC Barreirense	39
8		Fabril Barreiro	34
9		Serpa	34
10		Juventude Évora	32
11		Vasco da Gama	30
12		Oriental Lisboa	29
13		Real Sport Clube	14
14		Imortal DC	13

	Playoff Ascenso : Vitória Setúbal, Moncarapachense
	Descenso : Juventude Évora, Vasco da Gama, Oriental Lisboa, Real Sport Clube, Imortal DC

RIVALES EN Campeonato de Po.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,124,392 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1313
Total Execution Time	0.1325

CADENA URL

/historico/Fabril-Barreiro

GET DATOS

$_GET['/historico/Fabril-Barreiro']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0038	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 = 'Fabril-Barreiro' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7109 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=7109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=7109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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 = 73487
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7109 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=223 AND type_rel = 3
0.0026	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 = '7109' AND l.year = 2024 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 = '7109' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 73487 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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=7109 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73560,73487) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73487 AND teamId = 7109
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 7109
0.0034	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 = 73487 WHERE rp.league_id = 73487 AND rp.teamId = 7109 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.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 = 73487 WHERE rp.league_id = 73487 AND rp.teamId = 7109 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 = 73487 WHERE rp.league_id = 73487 AND rp.teamId = 7109 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 7109 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73487 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* `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 = 68780 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* `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 = 58704 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 = 50953 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.0020	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 = 34060 AND t.round = 18 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* `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 = 4360 AND t.round = 18 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 = 2173 AND t.round = 18 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* `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 = 2176 AND t.round = 22 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* `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 = 1709 AND t.round = 22 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* `tables1976` 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 = 5743 AND t.round = 30 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* `tables1975` 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 = 5742 AND t.round = 30 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* `tables1974` 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 = 5741 AND t.round = 30 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* `tables1973` 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 = 5740 AND t.round = 30 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* `tables1972` 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 = 5739 AND t.round = 30 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* `tables1971` 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 = 5738 AND t.round = 26 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* `tables1970` 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 = 5737 AND t.round = 26 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* `tables1969` 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 = 5736 AND t.round = 26 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* `tables1968` 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 = 5735 AND t.round = 26 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* `tables1967` 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 = 5734 AND t.round = 26 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* `tables1966` 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 = 5733 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Fabril Barreiro

Fabril Barreiro

Selecciona un equipo

Competiciones que juega

Campeonato de Portugal Grupo 4

RIVALES EN Campeonato de Po.

RIVALES EN Taça de Portugal