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

Lusitano GC Évora

Temporada 1965/1966

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

TEMPORADA 1964/1965

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	88	21	43
2	Porto	26	47	27	37
3	Fabril	26	49	29	35
4	Académica	26	58	40	34
5	Sporting CP	26	39	35	32
6	Vitória	26	61	30	32
7	Vitória	26	44	36	29
8	Belenenses	26	39	40	26
9	Leixões	26	50	51	21
10	Sporting	26	36	51	20
11	Varzim	26	39	55	20
12	Lusitano	26	30	51	20
13	Seixal FC	26	16	84	8
14	Torreense	26	18	64	7

TEMPORADA 1963/1964

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	103	26	46
2	Porto	26	51	20	40
3	Sporting CP	26	49	26	34
4	Vitória	26	62	42	34
5	Fabril	26	46	33	30
6	Belenenses	26	46	36	30
7	Vitória	26	46	41	29
8	Leixões	26	34	44	25
9	Académica	26	43	48	25
10	Varzim	26	37	57	20
11	Lusitano	26	22	51	14
12	Seixal FC	26	28	66	14
13	Olhanense	26	20	57	12
14	Barreirense	26	22	62	11

TEMPORADA 1962/1963

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	81	25	48
2	Porto	26	61	24	42
3	Sporting CP	26	71	31	38
4	Belenenses	26	47	30	36
5	Leixões	26	34	33	30
6	Vitória	26	47	43	27
7	Lusitano	26	33	41	23
8	Olhanense	26	29	38	21
9	Vitória	26	33	39	20
10	Académica	26	49	50	19
11	Barreirense	26	20	56	18
12	Fabril	26	37	40	18
13	Atlético	26	33	65	17
14	Feirense	26	21	81	7

TEMPORADA 1961/1962

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	66	17	43
2	Porto	26	57	16	41
3	Benfica	26	69	38	36
4	Fabril	26	44	34	33
5	Belenenses	26	51	35	31
6	Atlético	26	41	42	26
7	Leixões	26	47	55	23
8	Olhanense	26	33	41	22
9	Vitória	26	44	47	22
10	Académica	26	44	54	22
11	Beira	26	43	61	21
12	Lusitano	26	31	42	20
13	SC Covilha	26	30	48	17
14	Salgueiros	26	17	87	7

TEMPORADA 1960/1961

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	92	21	46
2	Sporting CP	26	61	19	42
3	Porto	26	51	28	33
4	Vitória	26	48	44	30
5	Belenenses	26	45	37	28
6	Fabril	26	38	28	26
7	Académica	26	31	29	26
8	Leixões	26	41	44	23
9	SC Covilha	26	27	55	21
10	Atlético	26	35	57	21
11	Lusitano	26	29	51	21
12	Salgueiros	26	34	64	20
13	Sporting	26	41	62	19
14	Barreirense	26	26	60	8

TEMPORADA 1959/1960

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	75	27	45
2	Sporting CP	26	82	21	43
3	Belenenses	26	58	25	36
4	Porto	26	48	36	30
5	Fabril	26	36	39	25
6	Académica	26	40	41	25
7	Vitória	26	47	43	23
8	Leixões	26	48	56	23
9	SC Covilha	26	32	49	22
10	Lusitano	26	32	55	21
11	Atlético	26	34	46	21
12	Sporting	26	25	39	20
13	Vitória	26	26	52	18
14	Boavista	26	27	81	12

TEMPORADA 1958/1959

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	26	81	22	41
2	Benfica	26	78	20	41
3	Belenenses	26	65	27	38
4	Sporting CP	26	50	28	31
5	Vitória	26	59	55	29
6	Vitória	26	53	64	27
7	Sporting	26	48	51	24
8	SC Covilha	26	43	65	22
9	Lusitano	26	40	49	21
10	Académica	26	45	46	21
11	Fabril	26	34	55	21
12	Barreirense	26	39	62	17
13	Caldas	26	33	76	16
14	Torreense	26	23	71	15

TEMPORADA 1957/1958

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	79	21	43
2	Porto	26	64	25	43
3	Benfica	26	59	23	36
4	Belenenses	26	54	42	28
5	Sporting	26	51	52	25
6	Lusitano	26	37	36	24
7	Barreirense	26	42	52	24
8	Torreense	26	30	46	24
9	Académica	26	45	40	24
10	Caldas	26	30	46	23
11	Vitória	26	37	59	22
12	Fabril	26	40	59	19
13	Salgueiros	26	45	65	16
14	Oriental	26	21	68	13

TEMPORADA 1956/1957

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	75	25	41
2	Porto	26	86	23	40
3	Belenenses	26	74	50	33
4	Sporting CP	26	62	28	31
5	Lusitano	26	57	51	30
6	Académica	26	45	33	28
7	Torreense	26	44	50	24
8	Oriental	26	27	44	23
9	Fabril	26	35	69	21
10	Vitória	26	40	59	20
11	Barreirense	26	39	62	20
12	Caldas	26	32	63	19
13	SC Covilha	26	33	62	18
14	Atlético	26	32	62	16

TEMPORADA 1955/1956

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	26	77	20	43
2	Benfica	26	76	31	43
3	Belenenses	26	67	25	37
4	Sporting CP	26	54	27	36
5	SC Covilha	26	52	44	29
6	Barreirense	26	40	60	23
7	Torreense	26	32	42	22
8	Lusitano	26	38	55	21
9	Vitória	26	57	64	20
10	Fabril	26	33	58	20
11	Caldas	26	29	50	19
12	Atlético	26	47	62	19
13	Académica	26	36	52	19
14	Sporting	26	36	84	13

TEMPORADA 1954/1955

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	26	61	20	39
2	Belenenses	26	63	28	39
3	Sporting CP	26	73	27	37
4	Porto	26	51	34	30
5	Sporting	26	52	42	29
6	Académica	26	53	52	25
7	Fabril	26	45	51	25
8	Vitória	26	37	52	22
9	Atlético	26	42	52	22
10	Lusitano	26	40	70	21
11	Barreirense	26	24	38	20
12	SC Covilha	26	32	53	20
13	Boavista	26	33	71	18
14	Vitória	26	33	49	17

TEMPORADA 1953/1954

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	80	25	43
2	Porto	26	83	35	36
3	Benfica	26	62	40	32
4	Belenenses	26	43	39	31
5	Sporting	26	54	36	28
6	Atlético	26	49	43	28
7	SC Covilha	26	43	39	28
8	Vitória	26	44	64	25
9	Barreirense	26	34	47	22
10	Lusitano	26	47	66	21
11	Boavista	26	29	66	19
12	Vitória	26	51	66	18
13	Académica	26	29	50	18
14	Oriental	26	35	67	15

TEMPORADA 1952/1953

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	26	77	22	43
2	Benfica	26	75	27	39
3	Belenenses	26	60	29	36
4	Porto	26	58	35	36
5	Barreirense	26	44	40	28
6	Vitória	26	40	33	27
7	Lusitano	26	31	44	25
8	Vitória	26	28	54	20
9	Boavista	26	35	54	20
10	SC Covilha	26	38	54	20
11	Académica	26	39	57	19
12	Atlético	26	33	52	19
13	Sporting	26	37	58	18
14	Estoril	26	28	64	14

Competiciones que juega

Liga Portuguesa

Pos	Equipos		Pts
1		Sporting CP	42
2		Benfica	41
3		Porto	34
4		Vitória Guimarães	33
5		Vitória Setúbal	29
6		Académica	26
7		Os Belenenses	25
8		Varzim	25
9		Fabril Barreiro	24
10		Sporting Braga	21
11		Beira Mar SC	18
12		Leixões	18
13		Lusitano GC Évora	14
14		FC Barreirense	14

	Copa de Europa : Sporting CP
	Copa de Ferias : Benfica, Porto, Vitória Setúbal
	Recopa : Sporting Braga
	Descenso : Lusitano GC Évora, FC Barreirense

RIVALES EN Liga Portuguesa

USO DE MEMORIA

6,174,960 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.9794
Total Execution Time	0.9807

CADENA URL

/historico/Lusitano-Evora

GET DATOS

$_GET['/historico/Lusitano-Evora']

POST DATOS

No hay datos POST existentes

CONSULTAS (66)

0.0132	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 = 'Lusitano-Evora' 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.0270	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 = 'Lusitano-Evora' 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.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0139	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=30909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30909 AND type_rel = 2
0.0135	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 30909 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (311263) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '30909' ORDER BY l.year DESC,cat.coefficient DESC
0.0153	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 = '30909' AND l.year = 1966 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '30909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = '30909' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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=30909 AND l.year in (1965,1966,1967) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (5733) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 5733 AND teamId = 30909
0.0127	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 = '30909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30909' and rp.type = 4
0.0127	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 = '30909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130	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 events1966 e ON e.player_id = p.id AND e.league_id = 5733 WHERE rp.league_id = 5733 AND rp.teamId = 30909 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.0130	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 events1966 e ON e.player_id = p.id AND e.league_id = 5733 WHERE rp.league_id = 5733 AND rp.teamId = 30909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 events1966 e ON e.player_id = p.id AND e.league_id = 5733 WHERE rp.league_id = 5733 AND rp.teamId = 30909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 30909 AND l.year <= 1966 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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
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* `tables1965` 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 = 5732 AND t.round = 26 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* `tables1964` 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 = 5731 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables1963` 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 = 5730 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables1962` 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 = 5729 AND t.round = 26 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* `tables1961` 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 = 5728 AND t.round = 26 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* `tables1960` 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 = 5727 AND t.round = 26 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* `tables1959` 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 = 5726 AND t.round = 26 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* `tables1958` 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 = 5725 AND t.round = 26 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* `tables1957` 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 = 5724 AND t.round = 26 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* `tables1956` 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 = 5723 AND t.round = 26 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* `tables1955` 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 = 5722 AND t.round = 26 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* `tables1954` 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 = 5721 AND t.round = 26 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* `tables1953` 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 = 5720 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Lusitano GC Évora

Lusitano GC Évora

Selecciona un equipo

Competiciones que juega

Liga Portuguesa

RIVALES EN Liga Portuguesa