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

Lamia

Entrenador: Leonidas Vokolos

Temporada 2023/2024

TEMPORADA 2023/2024

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	34	77	33	75
2	PAOK	33	79	32	71
3	Panathinaiko	34	79	31	71
4	Olympiacos	33	74	32	70
5	Aris	34	46	40	52
6	Lamia	34	41	72	35

TEMPORADA 2022/2023

SUPER LEAGUE GRIEGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	OFI	33	37	41	41
2	Atromitos	33	34	36	38
3	Giannina	33	33	50	34
4	Asteras	33	23	36	31
5	Panaitolikos	33	32	53	30
6	Lamia	33	23	53	29
7	Ionikos	33	24	51	27
8	Levadiakos	33	25	48	26

TEMPORADA 2021/2022

SUPER LEAGUE GRIEGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ionikos	33	44	42	45
2	OFI	33	40	45	44
3	Asteras	33	33	37	41
4	Volos	33	47	48	40
5	Panaitolikos	33	32	48	37
6	Atromitos	33	33	52	33
7	Lamia	33	24	44	26
8	Apollon	33	16	57	22

TEMPORADA 2020/2021

SUPER LEAGUE GRIEGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Volos	33	34	37	43
2	Atromitos	33	30	40	37
3	Giannina	33	27	36	35
4	Lamia	33	21	42	35
5	Apollon	33	29	40	34
6	OFI	33	30	47	32
7	Panaitolikos	33	20	44	28
8	AE Larisa	33	25	47	27

TEMPORADA 2019/2020

SUPER LEAGUE GRIEGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Asteras	7	11	5	43
2	Atromitos	7	10	7	42
3	AE Larisa	7	4	9	36
4	Lamia	7	4	3	35
5	Volos	7	4	12	31
6	Panaitolikos	7	10	6	29
7	Xanthi	7	4	6	24
8	Panionios	7	4	3	23

TEMPORADA 2018/2019

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	PAOK	30	66	14	80
2	Olympiacos	30	71	17	75
3	AEK Athens	30	50	19	57
4	Atromitos	30	41	28	52
5	Aris	30	46	33	49
6	Panionios	30	27	45	38
7	Lamia	30	28	37	37
8	Panathinaiko	30	38	30	36
9	Panaitolikos	30	34	48	36
10	AE Larisa	30	26	34	34
11	Asteras	30	25	30	33
12	Xanthi	30	22	34	32
13	OFI	30	30	42	32
14	Giannina	30	19	38	27
15	Levadiakos	30	15	45	21
16	Apollon	30	11	55	10

TEMPORADA 2017/2018

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	30	50	12	70
2	PAOK	30	59	19	64
3	Olympiacos	30	63	28	57
4	Atromitos	30	43	21	56
5	Asteras	30	39	24	45
6	Xanthi	30	31	30	45
7	Panionios	30	32	31	40
8	Panaitolikos	30	31	40	35
9	Giannina	30	31	34	34
10	Levadiakos	30	23	34	34
11	Panathinaiko	30	30	30	32
12	AE Larisa	30	22	41	31
13	Lamia	30	20	34	30
14	Apollon	30	23	36	29
15	Kerkyra	30	19	51	22
16	Platanias	30	14	65	10

TEMPORADA 2016/2017

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Apollon	34	61	14	83
2	Lamia	34	55	11	80
3	Aris	34	58	17	77
4	OFI	34	68	20	72
5	Trikala	34	65	19	71
6	Agrotikos	34	49	35	52
7	Sparti	34	38	42	45
8	Panserraikos	34	38	44	44
9	Panegialios	34	33	28	44
10	Aiginiakos	34	44	52	41
11	Chania	34	29	38	40
12	Anagennisi	34	26	38	39
13	Acharnaikos	34	38	51	36
14	Chania	34	37	60	35
15	Athens	34	42	49	33
16	Panelefsinia	34	21	56	28
17	Kalloni	34	21	75	7
18	Panthrakikos	34	7	81	0

TEMPORADA 2015/2016

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	AE Larisa	34	49	15	78
2	Kerkyra	34	57	24	75
3	Trikala	34	53	22	67
4	Apollon	34	46	19	61
5	Lamia	34	41	24	59
6	Chania	34	29	19	51
7	Athens	34	41	31	49
8	Acharnaikos	34	30	29	45
9	Anagennisi	34	30	34	45
10	Panserraikos	34	39	43	43
11	Agrotikos	34	27	24	43
12	Chania	34	34	37	41
13	Panegialios	34	34	40	41
14	Panelefsinia	34	34	53	35
15	Zakynthos	34	31	32	34
16	Panachaiki	34	26	47	28
17	Olympiakos	33	16	69	10
18	Ergotelis	33	18	73	7

TEMPORADA 2014/2015

FOOTBALL LEAGUE GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Iraklis	24	34	8	57
2	AE Larisa	24	27	11	45
3	Olympiakos	24	33	21	45
4	Lamia	24	24	17	43
5	Zakynthos	24	26	27	39
6	Anagennisi	24	26	27	32
7	Aiginiakos	24	23	19	30
8	Pierikos	24	19	29	30
9	Agrotikos	24	23	27	29
10	Tyrnavos	24	16	24	29
11	Apollon	24	19	23	26
12	Ethnikos	24	11	30	15
13	Fokikos	24	12	30	12

TEMPORADA 2013/2014

TERCERA GRECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lamia	28	60	25	66
2	Achilleas	28	48	20	62
3	Kymi	28	32	17	53
4	Makrochori	28	40	33	46
5	Lefkadia	28	30	23	45
6	Dotieas	28	41	27	44
7	Rigas	28	40	27	44
8	Trikala	28	30	20	44
9	Machitis	28	42	31	39
10	Naoussa	28	41	37	38
11	Chalkis	28	38	33	37
12	Achilleas	28	29	57	25
13	Karditsa	28	28	44	23
14	Ambeloniakos	28	28	56	17
15	Pyrgetos	28	6	83	0

TEMPORADA 2008/2009

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Doxa Dramas	34	68	22	76
2	Panaitolikos	34	56	14	70
3	Eordaikos	33	46	17	65
4	Makedonikos	34	47	25	56
5	Neon	34	44	25	55
6	Zakynthos	34	39	27	54
7	Niki Volos	34	32	26	49
8	Anagennisi	34	35	36	48
9	Odysseas	34	35	30	47
10	Ethnikos	34	33	35	47
11	Pyrsos	34	37	28	46
12	Fokikos	33	38	34	46
13	Thermaikos	32	48	41	45
14	Preveza	34	26	23	44
15	Lamia	34	34	34	42
16	Ethnikos	34	25	68	21
17	Anagennisi	34	15	78	17
18	Enosi Thraki	34	3	98	0

TEMPORADA 2007/2008

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kavala	32	49	18	72
2	Anagennisi	31	43	19	60
3	Paone	32	42	23	59
4	Olympiakos	31	36	32	53
5	Thermaikos	32	42	31	52
6	Enosi Thraki	32	27	26	47
7	Preveza	32	39	28	45
8	Ethnikos	32	35	27	45
9	Anagennisi	32	46	39	45
10	Niki Volos	32	37	33	44
11	Eordaikos	32	26	29	43
12	Anagennisi	32	39	36	41
13	Lamia	32	30	32	40
14	Polykastro	32	26	41	31
15	Prosotsani	31	25	36	30
16	AE Giannina	31	30	42	24
17	Doxa Dramas	32	6	86	6

TEMPORADA 2006/2007

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pierikos	32	64	23	75
2	Olympiakos	32	56	17	73
3	Lamia	31	46	34	62
4	Thermaikos	31	46	21	61
5	Kavala	32	35	31	47
6	Anagennisi	32	35	34	45
7	Doxa Dramas	32	23	23	41
8	Polykastro	32	24	31	40
9	Enosi Thraki	32	34	29	39
10	AE Giannina	32	30	31	39
11	Ethnikos	32	32	41	39
12	Paone	31	31	35	37
13	Anagennisi	32	31	38	37
14	Trikala	31	30	40	36
15	Gravia	32	31	39	31
16	Nafpaktiakos	32	23	51	24
17	Gratini	32	18	71	17

TEMPORADA 2005/2006

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Agrotikos	30	63	18	70
2	Panthrakikos	30	44	21	66
3	Giannina	29	52	13	65
4	Pierikos	30	42	30	46
5	AE Giannina	30	31	22	44
6	Doxa Dramas	30	41	36	43
7	Kavala	29	24	33	40
8	Anagennisi	30	31	33	38
9	Enosi Thraki	30	33	37	38
10	Thermaikos	30	32	41	34
11	Anagennisi	30	20	34	33
12	Trikala	30	32	42	30
13	Lamia	30	26	37	30
14	Polykastro	29	24	40	29
15	AEP Kozani	30	33	52	28
16	Eordaikos	29	20	59	16

Competiciones que juega

Grupo 1

Super League Griega Grupo 2

Pos	Equipos		Pts
1		AEK Athens	75
2		PAOK	71
3		Panathinaikos	71
4		Olympiacos Piraeus	70
5		Aris Thessaloniki	52
6		Lamia	35

	Previa de Champions : AEK Athens
	: PAOK, Panathinaikos

RIVALES EN Copa Griega

RIVALES EN Super League Gri.

USO DE MEMORIA

6,672,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1442
Total Execution Time	0.1454

CADENA URL

/historico/Lamia

GET DATOS

$_GET['/historico/Lamia']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0034	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 = 'Lamia' 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.0020	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=20599 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=20599 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=20599 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=20599 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=20599 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20599 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 20599 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 (267008,283085,291295,496507,650532) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '20599' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '20599' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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=20599 AND l.year in (2023,2024,2025) 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 (75536,73551,71432) 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.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 75536 AND teamId = 20599
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 20599
0.0044	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20599
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75536 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025	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 = '20599' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20599' and rp.type = 4
0.0019	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 = '20599' 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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 20599 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.0027	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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 20599 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 20599 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 20599 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75536 AND t.round = 8 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* `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 = 67777 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.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* `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 = 71245 AND t.round = 7 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* `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 = 63207 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.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 = 66929 AND t.round = 7 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 = 58673 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.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* `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 = 61825 AND t.round = 7 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* `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 = 49866 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* `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 = 55621 AND t.round = 7 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* `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 = 44207 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* `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 = 38720 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* `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 = 35326 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* `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 = 15462 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* `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 = 4429 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* `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 = 12264 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* `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 = 24846 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* `tables2008` 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 = 24849 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* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24851 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* `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24853 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Lamia

Lamia

Selecciona un equipo

Competiciones que juega

Super League Griega Grupo 2

RIVALES EN Copa Griega

RIVALES EN Super League Gri.