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

Farense

Entrenador: José Mota

Temporada 2020/2021

TEMPORADA 2020/2021

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	34	65	20	85
2	Porto	34	74	29	80
3	Benfica	34	69	27	76
4	Sporting	34	53	33	64
5	Paços	34	40	41	53
6	Santa Clara	34	44	36	46
7	Vitória	34	37	44	43
8	Moreirense	34	37	43	43
9	Famalicão	34	40	48	40
10	Belenenses	34	25	35	40
11	Gil Vicente	34	33	42	39
12	Tondela	34	36	57	36
13	Boavista	34	39	49	36
14	Portimonense	34	34	41	35
15	Marítimo	34	27	47	35
16	Rio Ave	34	25	40	34
17	Farense	34	31	48	31
18	Nacional	34	30	59	25

TEMPORADA 2019/2020

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Nacional	24	36	16	50
2	Farense	24	35	22	48
3	Feirense	24	27	18	42
4	Estoril	24	35	26	39
5	Mafra	24	33	24	39
6	Varzim	24	32	31	37
7	Académica	24	34	26	35
8	Academico	24	21	24	34
9	Leixões	24	23	22	33
10	Oliveirense	24	36	31	32
11	SC Covilha	24	29	27	32
12	Chaves	24	26	26	32
13	Porto II	24	35	36	29
14	Penafiel	24	23	24	28
15	Benfica II	24	31	35	28
16	Vilafranquen	24	27	45	24
17	Cova Piedade	24	20	42	17
18	Casa Pia AC	24	19	47	11

TEMPORADA 2018/2019

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Paços	34	50	21	74
2	Famalicão	34	57	34	69
3	Estoril	34	49	42	54
4	Benfica II	34	47	42	52
5	Académica	34	36	37	51
6	SC Covilha	34	42	37	49
7	Penafiel	34	49	48	45
8	Leixões	34	35	36	45
9	Porto II	34	41	42	44
10	Farense	34	39	35	43
11	Academico	34	49	54	43
12	Oliveirense	34	44	49	43
13	Cova Piedade	34	25	42	42
14	Mafra	34	40	44	41
15	Varzim	34	25	37	41
16	Arouca	34	40	45	40
17	Sporting	34	38	45	37
18	Vitória	34	41	57	31

TEMPORADA 2017/2018

CAMPEONATO DE PORTUGAL GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Farense	30	66	12	81
2	Oriental	30	40	19	63
3	Olhanense	30	42	30	58
4	Casa Pia AC	30	50	31	53
5	Pinhalnovens	30	43	29	46
6	Louletano	30	43	39	44
7	Armacenenses	30	31	29	44
8	Moura	30	41	38	41
9	Olímpico	30	40	44	37
10	Ideal	30	29	38	35
11	Estrela	30	32	54	32
12	Operário	30	35	46	30
13	Almancilense	30	33	50	28
14	Castrense	30	32	47	26
15	Lusitano	30	24	49	25
16	Moncarapache	30	27	53	23

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 2015/2016

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Porto II	46	84	52	86
2	Chaves	46	60	39	81
3	Feirense	46	54	38	78
4	Portimonense	46	57	45	78
5	Freamunde	46	52	36	74
6	Famalicão	46	64	51	72
7	Olhanense	46	42	39	69
8	Desportivo	46	58	48	67
9	Varzim	46	51	48	65
10	Sporting	46	61	59	65
11	Gil Vicente	46	58	56	62
12	Penafiel	46	49	46	61
13	Vitória	46	60	67	60
14	SC Covilha	46	45	48	58
15	Santa Clara	46	49	52	57
16	Sporting	46	47	54	57
17	Academico	46	46	60	56
18	Benfica II	46	58	64	55
19	Leixões	46	45	56	55
20	Mafra	46	37	40	54
21	Farense	46	49	55	54
22	Atlético	46	49	56	51
23	Oriental	46	47	67	41
24	Oliveirense	46	42	88	29

TEMPORADA 2014/2015

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Tondela	46	67	51	81
2	SC Covilha	46	78	46	80
3	União	46	69	39	80
4	Chaves	46	68	45	80
5	Sporting	46	66	57	78
6	Benfica II	46	81	60	77
7	Feirense	46	61	51	75
8	Freamunde	46	48	32	71
9	Vitória	46	71	57	65
10	Beira	46	52	48	63
11	Academico	46	55	56	62
12	Farense	46	51	54	62
13	Porto II	46	66	64	61
14	Portimonense	46	56	62	60
15	Oriental	46	47	59	58
16	Olhanense	46	51	56	55
17	Oliveirense	46	50	67	55
18	Desportivo	46	52	58	53
19	Santa Clara	46	33	42	51
20	Sporting	46	48	62	51
21	Leixões	46	53	67	50
22	Atlético	46	56	70	47
23	Marítimo	46	37	67	41
24	Trofense	46	35	81	36

TEMPORADA 2013/2014

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Moreirense	42	65	25	79
2	Porto II	42	59	42	77
3	Penafiel	42	47	24	73
4	Desportivo	42	46	35	71
5	Benfica II	42	77	56	70
6	Sporting	42	61	50	70
7	Portimonense	42	58	48	67
8	Chaves	42	58	56	67
9	Tondela	42	41	38	59
10	Farense	42	45	44	57
11	Academico	42	43	43	54
12	Beira	42	45	48	54
13	União	42	50	46	52
14	Feirense	42	41	46	50
15	Santa Clara	42	38	46	48
16	SC Covilha	42	34	50	48
17	Leixões	42	42	57	47
18	Oliveirense	42	56	76	47
19	Trofense	42	36	61	47
20	Sporting	42	47	60	44
21	Marítimo	42	39	57	43
22	Atlético	42	34	54	40

TEMPORADA 2012/2013

CAMPEONATO DE PORTUGAL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Farense	30	38	21	65
2	Mafra	30	57	28	64
3	Torreense	30	39	31	52
4	Sertanense	30	44	31	51
5	Oriental	30	55	34	49
6	Dezembro	30	29	25	47
7	União	30	36	31	46
8	Fatima	30	36	31	43
9	Casa Pia AC	30	30	24	40
10	Pinhalnovens	30	34	38	38
11	Louletano	30	25	35	35
12	Quarteirense	30	26	34	34
13	CF Benfica	30	36	55	31
14	Carregado	30	34	51	24
15	Oeiras	30	24	45	21
16	Ribeira	30	27	56	17

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 2002/2003

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Rio Ave	34	49	36	63
2	FC Alverca	34	47	24	60
3	Estrela	34	42	32	57
4	Naval	34	40	25	55
5	Portimonense	34	50	40	51
6	Chaves	34	44	41	47
7	Desportivo	34	41	38	47
8	Ovarense	34	49	48	46
9	FC Maia	34	51	51	46
10	Salgueiros	34	39	47	46
11	SC Covilha	34	37	33	45
12	Farense	34	32	32	44
13	FC Marco	34	46	49	43
14	Penafiel	34	38	40	41
15	União	34	31	38	40
16	Leça FC	34	35	42	39
17	Felgueiras	34	34	50	39
18	Uniao Lamas	34	21	60	19

TEMPORADA 2001/2002

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	34	74	25	75
2	Boavista	34	53	20	70
3	Porto	34	66	34	68
4	Benfica	34	66	37	63
5	Belenenses	34	54	44	57
6	Marítimo	34	48	35	56
7	União	34	52	35	55
8	Paços	34	41	44	46
9	Vitória	34	35	41	42
10	Sporting	34	43	43	42
11	Beira	34	48	56	39
12	Gil Vicente	34	42	56	38
13	Vitória	34	40	46	38
14	Santa Clara	34	32	46	37
15	Varzim	34	27	55	32
16	Salgueiros	34	29	71	30
17	Farense	34	29	63	28
18	FC Alverca	34	39	67	27

TEMPORADA 2000/2001

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Boavista	34	63	22	77
2	Porto	34	73	27	76
3	Sporting CP	34	56	37	62
4	Sporting	34	58	48	57
5	União	34	46	41	56
6	Benfica	34	54	44	54
7	Belenenses	34	43	36	52
8	Beira	34	45	49	49
9	Paços	34	47	39	48
10	Salgueiros	34	41	55	43
11	Marítimo	34	34	37	43
12	FC Alverca	34	45	52	43
13	Farense	34	37	47	39
14	Gil Vicente	34	34	41	37
15	Vitória	34	41	49	36
16	Campomaioren	34	29	58	32
17	Desportivo	34	31	68	22
18	Estrela	34	30	57	19

TEMPORADA 1999/2000

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	34	57	22	77
2	Porto	34	66	26	73
3	Benfica	34	58	33	69
4	Boavista	34	40	31	55
5	Gil Vicente	34	48	34	53
6	Marítimo	34	42	36	50
7	Vitória	34	48	43	48
8	Estrela	34	40	35	45
9	Sporting	34	44	45	43
10	União	34	31	35	42
11	FC Alverca	34	39	48	41
12	Belenenses	34	36	38	40
13	Campomaioren	34	31	51	36
14	Farense	34	35	60	35
15	Salgueiros	34	30	49	34
16	Vitória	34	25	49	33
17	Rio Ave	34	34	54	33
18	Santa Clara	34	35	50	31

TEMPORADA 1998/1999

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	85	26	79
2	Boavista	34	57	29	71
3	Benfica	34	71	29	65
4	Sporting CP	34	64	32	63
5	Vitória	34	37	38	53
6	União	34	36	29	52
7	Vitória	34	53	41	50
8	Estrela	34	33	40	45
9	Sporting	34	38	50	42
10	Marítimo	34	44	45	41
11	Farense	34	39	54	39
12	Salgueiros	34	45	55	38
13	Campomaioren	34	41	51	37
14	FC Alverca	34	36	50	35
15	Rio Ave	34	26	47	35
16	Beira	34	36	53	33
17	Chaves	34	39	70	25
18	Académica	34	30	71	21

TEMPORADA 1997/1998

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	75	38	77
2	Benfica	34	62	29	68
3	Vitória	34	42	25	59
4	Sporting CP	34	45	33	56
5	Marítimo	34	44	35	56
6	Boavista	34	54	31	55
7	Estrela	34	42	41	50
8	Salgueiros	34	48	44	49
9	Rio Ave	34	43	43	46
10	Sporting	34	48	49	45
11	Campomaioren	34	53	58	40
12	Leça FC	34	29	52	38
13	Vitória	34	38	43	37
14	Farense	34	41	50	37
15	Académica	34	27	41	36
16	Chaves	34	31	55	35
17	Varzim	34	26	51	29
18	Belenenses	34	22	52	24

TEMPORADA 1996/1997

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	80	24	85
2	Sporting CP	34	55	19	72
3	Benfica	34	49	30	58
4	Sporting	34	39	40	55
5	Vitória	34	51	46	53
6	Salgueiros	34	49	48	52
7	Boavista	34	62	39	49
8	Marítimo	34	39	38	47
9	Estrela	34	39	38	47
10	Chaves	34	39	45	46
11	Farense	34	34	34	42
12	Vitória	34	38	42	40
13	Belenenses	34	37	50	40
14	Leça FC	34	33	42	36
15	Rio Ave	34	35	42	35
16	Espinho	34	27	56	33
17	União	34	25	53	30
18	Gil Vicente	34	29	74	19

TEMPORADA 1995/1996

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	84	20	84
2	Benfica	34	58	27	73
3	Sporting CP	34	69	27	67
4	Boavista	34	58	28	65
5	Vitória	34	55	39	62
6	Belenenses	34	53	33	51
7	União	34	38	50	47
8	Sporting	34	44	47	45
9	Marítimo	34	39	53	43
10	Salgueiros	34	39	49	36
11	Gil Vicente	34	31	49	36
12	Farense	34	36	45	36
13	Estrela	34	35	50	35
14	Leça FC	34	29	55	34
15	Chaves	34	38	56	34
16	Felgueiras	34	29	47	33
17	Campomaioren	34	32	69	33
18	Tirsense	34	30	53	31

TEMPORADA 1994/1995

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	73	15	62
2	Sporting CP	34	59	21	55
3	Benfica	34	60	30	47
4	Vitória	34	54	43	42
5	Farense	34	44	38	37
6	União	34	41	44	36
7	Tirsense	34	35	34	34
8	Marítimo	34	40	45	34
9	Boavista	34	40	49	32
10	Sporting	34	34	42	32
11	Salgueiros	34	43	50	29
12	Belenenses	34	30	39	27
13	Gil Vicente	34	30	40	27
14	Estrela	34	27	39	27
15	Chaves	34	33	49	27
16	União	34	30	54	24
17	Beira	34	33	54	21
18	Vitória	34	25	45	19

TEMPORADA 1993/1994

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	34	73	25	54
2	Porto	34	56	15	52
3	Sporting CP	34	71	29	51
4	Boavista	34	46	31	38
5	Marítimo	34	45	40	38
6	Vitória	34	56	42	34
7	Vitória	34	30	31	33
8	Farense	34	44	46	33
9	Estrela	34	39	36	33
10	Gil Vicente	34	27	47	31
11	Salgueiros	34	48	56	31
12	União	34	36	42	31
13	Belenenses	34	39	51	30
14	Beira	34	28	38	29
15	Sporting	34	33	43	28
16	Paços	34	31	49	26
17	Famalicão	34	26	72	22
18	Estoril	34	22	57	18

Competiciones que juega

Grupo 3

Liga Portuguesa

Pos	Equipos		Pts
1		Sporting CP	85
2		Porto	80
3		Benfica	76
4		Sporting Braga	64
5		Paços de Ferreira	53
6		CD Santa Clara	46
7		Vitória Guimarães	43
8		Moreirense	43
9		Famalicão	40
10		Belenenses SAD	40
11		Gil Vicente	39
12		Tondela	36
13		Boavista	36
14		Portimonense	35
15		Marítimo	35
16		Rio Ave	34
17		Farense	31
18		Nacional	25

	Champions League : Sporting CP, Porto
	Previa de Champions : Benfica
	Europa League : Sporting Braga
	Conference League : Paços de Ferreira, CD Santa Clara
	Playoff Descenso : Rio Ave
	Descenso : Farense, Nacional

RIVALES EN Liga Portuguesa

RIVALES EN Taça de Portugal

USO DE MEMORIA

8,067,320 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1926
Total Execution Time	0.1940

CADENA URL

/historico/Farense/2021

GET DATOS

$_GET['/historico/Farense/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

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 = 'Farense' AND l.year = 2021 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=1030 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=1030 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=1030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 57339
0.0026	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 = 58721
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1030 AND type_rel = 2
0.0034	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1030 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (35241,58360,354143,397521,673149) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '1030' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '1030' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 57339 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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 = 58721 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0056	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=1030 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (63795,63295,62812,62807,57339) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 57339 AND teamId = 1030
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 62812 AND teamId = 1030
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 63795 AND teamId = 1030
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 63295 AND teamId = 1030
0.0196	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 1030
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 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 = 57339 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0046	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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 1030 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.0041	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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 1030 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 1030 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 1030 AND l.year <= 2021 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* `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 = 49946 AND t.round = 24 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* `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 = 43587 AND t.round = 34 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* `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 = 39615 AND t.round = 30 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* `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.0039	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 = 3858 AND t.round = 46 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* `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 = 2504 AND t.round = 42 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* `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 = 2170 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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.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* `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 612 AND t.round = 34 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* `tables2002` 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 = 215 AND t.round = 34 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* `tables2001` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 216 AND t.round = 34 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* `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 217 AND t.round = 34 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* `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 218 AND t.round = 34 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* `tables1998` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 219 AND t.round = 34 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* `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 220 AND t.round = 34 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* `tables1996` 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 = 221 AND t.round = 34 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* `tables1995` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 222 AND t.round = 34 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* `tables1994` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 5761 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 57339 ORDER BY nameShow LIMIT 100

Farense

Farense

Selecciona un equipo

Competiciones que juega

Liga Portuguesa

RIVALES EN Liga Portuguesa

RIVALES EN Taça de Portugal