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

AE Larisa

Entrenador: Sotiris Antoniou

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA GRECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Levadiakos	5	11	3	41
2	AE Larisa	6	13	12	31
3	Niki Volos	5	6	6	24
4	Makedonikos	5	8	11	21
5	Athens	5	6	12	18
6	Athens	5	11	3	34
7	Chania	5	10	11	28
8	Ionikos	5	9	4	27
9	Ilioupoli	5	7	12	25
10	Kalamata FC	4	0	7	19

TEMPORADA 2022/2023

SEGUNDA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panserraikos	28	43	13	64
2	AE Larisa	28	50	19	58
3	Niki Volos	28	41	20	52
4	Iraklis	28	53	22	50
5	PAOK B	28	51	33	49
6	Almopos	28	23	17	36
7	Anagennisi	28	34	21	35
8	Makedonikos	28	28	30	33
9	Panathinaiko	28	39	41	33
10	Diagoras	28	38	42	33
11	Apollon	28	21	37	32
12	Veria NPS	28	28	32	31
13	Iraklis	28	17	42	26
14	Thesprotos	28	26	49	17
15	Apollon	28	8	82	4

TEMPORADA 2021/2022

SEGUNDA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Veria NPS	32	61	23	75
2	AE Larisa	32	42	15	67
3	Xanthi	32	43	25	53
4	Niki Volos	32	38	20	52
5	Anagennisi	32	47	34	51
6	Olympiacos	32	40	31	51
7	Iraklis	32	51	29	48
8	PAOK B	32	41	32	44
9	Almopos	32	40	39	39
10	Apollon	32	34	38	37
11	Apollon	32	27	42	35
12	Thesprotos	32	34	43	34
13	Panserraikos	32	31	39	33
14	Pierikos	32	36	49	32
15	Kavala	32	25	71	31
16	Olympiakos	32	34	49	29
17	Trikala	32	17	62	21

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

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	57	16	67
2	PAOK	30	52	19	61
3	Panathinaiko	30	45	19	57
4	AEK Athens	30	54	23	53
5	Panionios	30	35	23	52
6	Xanthi	30	34	25	48
7	Platanias	30	34	38	42
8	Atromitos	30	29	38	39
9	Giannina	30	30	37	36
10	Kerkyra	30	22	43	32
11	Panaitolikos	30	29	40	31
12	Asteras	30	34	49	28
13	AE Larisa	30	23	42	28
14	Levadiakos	30	27	49	26
15	Iraklis	30	28	39	26
16	Veria NPS	30	23	56	22

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 5
Equipo		PJ	GF	GC	Puntos
1	Apollon	10	16	10	20
2	Iraklis	10	10	5	19
3	AEK Athens	10	14	9	18
4	AE Larisa	10	10	11	13
5	Olympiakos	10	8	12	10
6	Panachaiki	10	12	23	5

TEMPORADA 2013/2014

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AE Larisa	30	87	15	73
2	Oikonomos	30	59	25	61
3	Kampaniakos	30	50	34	55
4	AEP Kozani	30	52	32	54
5	Ethnikos	30	48	24	52
6	Pyrsos	30	42	31	52
7	Thesprotos	30	42	27	51
8	Kastoria	30	48	38	51
9	Doxa	30	40	30	49
10	Odysseas	30	38	42	44
11	Doxa	30	43	40	37
12	Agios Thomas	30	42	51	30
13	Kastor	30	30	45	24
14	Keravnos	30	36	67	23
15	Olympos	30	18	84	17
16	Tilikratis	30	0	90	0

TEMPORADA 2012/2013

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Apollon	40	50	29	75
2	Ergotelis	40	42	25	74
3	Panaitolikos	40	55	23	73
4	Olympiakos	40	49	23	73
5	Kalloni	40	48	22	73
6	Iraklis	40	49	25	71
7	Niki Volos	40	44	23	68
8	Panserraikos	40	40	29	68
9	AE Larisa	40	42	25	63
10	Doxa Dramas	40	35	27	60
11	Iraklis	40	42	37	55
12	Kavala	40	35	36	53
13	Athens	40	42	44	50
14	Panachaiki	40	32	40	42
15	Ethnikos	40	27	35	41
16	Pierikos	40	33	61	39
17	Fokikos	40	28	51	37
18	Anagennisi	40	35	68	34
19	Vyzas Megara	40	22	49	32
20	Thrasyvoulos	40	23	48	31
21	Anagennisi	40	24	77	15

TEMPORADA 2011/2012

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panthrakikos	34	49	16	73
2	Veria NPS	34	56	19	72
3	Athens	34	58	32	64
4	Panachaiki	34	55	33	61
5	Platanias	34	41	20	60
6	Kalloni	34	46	29	57
7	Panserraikos	34	39	22	57
8	Pierikos	34	41	30	55
9	Anagennisi	34	42	46	44
10	AE Larisa	34	38	29	43
11	Iraklis	34	29	23	42
12	Thrasyvoulos	34	37	40	42
13	Anagennisi	34	29	44	39
14	Fokikos	34	27	38	35
15	Agrotikos	34	24	41	34
16	Vyzas Megara	34	24	42	34
17	Ethnikos	33	11	62	13
18	Diagoras	33	3	83	3

TEMPORADA 2010/2011

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	65	18	73
2	Panathinaiko	30	47	26	60
3	AEK Athens	30	46	37	50
4	PAOK	30	32	29	48
5	Olympiakos	30	40	28	47
6	Aris	30	29	29	45
7	Kavala	30	29	27	40
8	Ergotelis	30	32	38	39
9	Xanthi	30	29	35	36
10	Iraklis	30	22	28	35
11	Panionios	30	25	35	35
12	Atromitos	30	30	34	34
13	Kerkyra	30	30	40	33
14	Asteras	30	21	29	31
15	AE Larisa	30	29	47	25
16	Panserraikos	30	22	48	24

TEMPORADA 2009/2010

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panathinaiko	30	54	17	70
2	Olympiacos	30	47	18	64
3	PAOK	30	41	16	62
4	AEK Athens	30	43	31	53
5	Aris	30	35	28	46
6	Kavala	30	31	32	39
7	Atromitos	30	34	36	38
8	Panionios	30	34	35	37
9	Iraklis	30	39	41	37
10	AE Larisa	30	31	42	37
11	Ergotelis	30	37	41	36
12	Asteras	30	29	36	36
13	Xanthi	30	27	36	35
14	Levadiakos	30	31	44	34
15	Giannina	30	27	46	28
16	Panthrakikos	30	21	62	12

TEMPORADA 2008/2009

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	50	14	71
2	PAOK	30	39	16	63
3	Panathinaiko	30	51	18	61
4	AEK Athens	30	40	24	55
5	AE Larisa	30	36	26	49
6	Aris	30	30	31	47
7	Xanthi	30	25	21	38
8	Panionios	30	40	40	37
9	Ergotelis	30	31	39	36
10	Iraklis	30	22	38	33
11	Panthrakikos	30	23	37	33
12	Asteras	30	33	31	33
13	Levadiakos	30	28	36	32
14	OFI	30	30	50	24
15	Panserraikos	30	19	45	24
16	Thrasyvoulos	30	22	53	14

Competiciones que juega

Grupo 1

Segunda Grecia Grupo 3

Pos	Equipos		Pts
1		Levadiakos	41
2		Athens Kallithea	34
3		AE Larisa	31
4		Chania	28
5		Ionikos Nikea	27
6		Ilioupoli	25
7		Niki Volos	24
8		Makedonikos Neapolis	21
9		Kalamata FC	19
10		AEK Athens B	18

	Ascenso : Levadiakos

RIVALES EN Copa Griega

RIVALES EN Segunda Grecia

USO DE MEMORIA

6,997,624 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1077
Total Execution Time	0.1091

CADENA URL

/historico/Larissa-Fc

GET DATOS

$_GET['/historico/Larissa-Fc']

POST DATOS

No hay datos POST existentes

CONSULTAS (28)

0.0042	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 = 73941
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4799 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4799 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 (41287,17741,127761,164529,181358) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '4799' 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 = 73551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 73941 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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 = 4799 AND l.year <= 2024 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* `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 = 73941 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* `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 = 75674 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* `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 = 69284 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 65350 AND t.round = 34 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* `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.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 = 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.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* `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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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* `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 = 33417 AND t.round = 30 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* `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.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* `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* `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 = 13425 AND t.round = 10 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 = 12263 AND t.round = 30 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* `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 = 2780 AND t.round = 42 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* `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 = 13406 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* `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 868 AND t.round = 30 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* `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 = 395 AND t.round = 30 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 = 75674 ORDER BY nameShow LIMIT 100

AE Larisa

AE Larisa

Selecciona un equipo

Competiciones que juega

Segunda Grecia Grupo 3

RIVALES EN Copa Griega

RIVALES EN Segunda Grecia