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

Resultados de Fútbol

Agrotikos Asteras

Temporada 2022/2023

TEMPORADA 2022/2023

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kampaniakos	28	50	19	59
2	Kavala	28	55	23	55
3	Poseidon	28	40	29	53
4	Doxa Dramas	28	52	32	49
5	Apollon	28	49	32	47
6	Panthrakikos	28	44	36	47
7	Nestos	28	38	34	41
8	Aris Avato	28	29	35	41
9	Thermaikos	28	26	26	40
10	Pandramaikos	28	43	35	37
11	Byron Kavala	28	36	37	32
12	Agrotikos	28	26	41	30
13	Orfeas	28	31	49	30
14	Antheias-Ari	28	17	52	13
15	Alexandroupo	28	12	68	4

TEMPORADA 2021/2022

TERCERA GRECIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Panachaiki	6	11	5	15
2	Proodeftiki	6	8	3	10
3	Agrotikos	6	9	6	10
4	Kozani FC	6	5	4	9
5	Ilioupoli	6	8	7	7
6	PAO Rouf	6	7	9	7
7	Iraklis	6	4	18	1

TEMPORADA 2020/2021

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Poseidon	14	27	6	38
2	Keravnos	14	23	15	26
3	Thermaikos	14	24	18	25
4	Agrotikos	14	23	21	25
5	Makedonikos	14	27	10	24
6	Anagennisi	14	23	15	22
7	Anagennisi	14	20	12	22
8	Alexandros	14	20	18	21
9	Edessaikos	14	16	19	21
10	Niki	14	15	16	20
11	Kallikrateia	14	15	20	15
12	Aetos	14	21	27	14
13	Ethnikos	14	17	26	11
14	Koufalion	14	8	22	8
15	PAOK	14	11	45	4

TEMPORADA 2019/2020

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Almopos	25	59	10	61
2	Makedonikos	25	33	8	47
3	Poseidon	25	44	26	46
4	Anagennisi	25	34	19	45
5	Thermaikos	25	40	21	43
6	Edessaikos	25	35	15	42
7	Keravnos	24	34	28	39
8	Alexandros	26	25	20	39
9	Agrotikos	23	31	17	37
10	Kallikrateia	24	33	19	35
11	Niki	24	26	19	33
12	Florina	25	27	41	29
13	Astrapi	25	15	58	13
14	Seirína	22	4	70	3
15	Palaiochori	25	3	72	3

TEMPORADA 2018/2019

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Elpis	26	51	15	57
2	Triglia	26	39	19	55
3	Niki	26	31	11	53
4	Palaiochori	26	45	27	52
5	Edessaikos	26	45	14	45
6	Almopos	26	37	18	42
7	Anagennisi	26	31	25	37
8	Makedonikos	26	32	30	36
9	Agrotikos	26	25	29	34
10	Koufalion	26	20	39	22
11	Olympiakos	26	13	33	22
12	Meliteas	26	28	66	18
13	Ermis	26	21	53	13
14	Langadas	26	14	53	13

TEMPORADA 2017/2018

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Iraklis	28	63	17	65
2	Palaiochori	28	49	19	61
3	Makedonikos	28	32	22	47
4	Almopos	28	32	22	42
5	Edessaikos	28	30	28	41
6	Agrotikos	28	36	39	40
7	Pierikos	28	25	29	40
8	Langadas	28	46	33	39
9	Kardias	28	38	33	39
10	Naoussa	28	30	29	39
11	Kilkisiakos	28	31	32	37
12	AE Karitsa	28	28	39	28
13	Alexandros	28	22	47	25
14	Philippos	28	17	57	18
15	Kampaniakos	28	22	55	16

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 4
Equipo		PJ	GF	GC	Puntos
1	Agrotikos	10	16	7	22
2	Tyrnavos	10	12	8	17
3	Anagennisi	10	12	11	17
4	Aiginiakos	10	12	6	14
5	Zakynthos	10	14	10	14
6	Pierikos	10	0	24	1

TEMPORADA 2013/2014

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Agrotikos	30	47	16	72
2	Panserraikos	30	57	21	67
3	Aris	30	41	35	50
4	Iraklis	30	39	27	48
5	Byzantio	30	25	22	46
6	Ethnikos	30	31	32	46
7	Evros Soufli	30	39	35	45
8	Kilkisiakos	30	39	23	44
9	Nestos	30	51	38	44
10	Orfeas	30	39	26	44
11	Digenis	30	57	56	39
12	Doxa	30	27	32	34
13	Ethnikos	30	31	45	30
14	Moudania	30	37	59	30
15	Makedonikos	30	25	48	25
16	PAO Kosmio	30	14	84	3

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

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panaitolikos	34	47	19	75
2	Giannina	34	55	17	74
3	OFI	34	42	20	69
4	Trikala	34	42	23	60
5	Levadiakos	34	48	33	60
6	Doxa Dramas	34	49	30	53
7	Diagoras	34	36	36	52
8	Panthrakikos	34	36	38	47
9	Veria NPS	34	37	42	44
10	Pierikos	34	36	43	41
11	Ethnikos	34	27	38	38
12	Agrotikos	34	31	43	37
13	Ionikos	34	26	45	37
14	Thrasyvoulos	34	33	36	36
15	Ilioupoli	34	29	50	36
16	Ethnikos	34	30	45	35
17	Anagennisi	34	22	41	33
18	Athens	34	27	54	19

TEMPORADA 2009/2010

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiakos	34	73	36	68
2	Kerkyra	34	45	25	63
3	OFI	34	44	35	62
4	Ethnikos	34	43	30	53
5	Panserraikos	34	36	35	52
6	Pierikos	34	41	31	50
7	Panaitolikos	34	43	36	50
8	Diagoras	34	43	42	48
9	Ilioupoli	34	33	35	46
10	Agrotikos	34	36	31	45
11	Ethnikos	34	39	37	45
12	Anagennisi	34	29	28	44
13	Thrasyvoulos	34	42	42	41
14	Doxa Dramas	34	37	49	40
15	Ionikos	34	32	45	39
16	Rodos	34	31	46	34
17	Kalamata FC	34	21	49	28
18	Aigaleo	34	19	55	21

TEMPORADA 2008/2009

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Atromitos	34	54	30	74
2	Giannina	34	70	36	69
3	Kavala	34	56	28	65
4	Ionikos	34	43	37	55
5	Kerkyra	34	45	40	51
6	Ilysiakos	34	42	40	46
7	Agrotikos	34	39	39	45
8	Diagoras	34	46	38	44
9	Kalamata FC	34	33	43	43
10	Pierikos	34	33	43	42
11	Ethnikos	34	42	40	41
12	Olympiakos	34	32	36	41
13	Apollon	34	34	45	41
14	Ethnikos	34	42	41	40
15	Anagennisi	34	30	43	39
16	Veria NPS	34	27	36	38
17	Athens	34	25	43	34
18	Kastoria	34	28	63	18

TEMPORADA 2007/2008

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Panserraikos	34	48	20	67
2	Thrasyvoulos	34	44	27	61
3	Panthrakikos	34	44	31	60
4	Giannina	34	54	38	57
5	Ionikos	34	37	28	54
6	Athens	34	40	35	52
7	Kerkyra	34	39	33	50
8	Agrotikos	34	44	47	47
9	Ethnikos	34	32	36	45
10	Ilysiakos	34	31	38	43
11	Kalamata FC	34	30	33	42
12	Ethnikos	34	32	37	41
13	Pierikos	34	28	33	41
14	Olympiakos	34	33	38	39
15	Aigaleo	34	28	34	39
16	Kastoria	34	26	41	39
17	Chaidari	34	30	31	38
18	Agios	34	22	62	14

TEMPORADA 2006/2007

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Asteras	34	56	25	69
2	Levadiakos	34	49	33	68
3	Veria NPS	34	46	26	59
4	Kastoria	34	55	40	57
5	Giannina	34	49	34	53
6	Ethnikos	34	35	33	49
7	Athens	34	45	42	47
8	Thrasyvoulos	34	37	48	47
9	Agrotikos	34	36	38	44
10	Kalamata FC	34	36	40	43
11	Panthrakikos	34	40	44	42
12	Ilysiakos	34	44	49	42
13	Chaidari	34	37	44	42
14	Ethnikos	34	29	38	41
15	Panserraikos	34	41	46	39
16	Proodeftiki	34	20	38	36
17	Messiniakos	34	34	50	34
18	Niki Volos	34	23	44	32

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

TEMPORADA 2004/2005

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Veria NPS	32	65	28	69
2	Giannina	32	56	29	65
3	Kavala	32	49	36	56
4	Anagennisi	32	50	34	54
5	Lamia	31	44	44	50
6	Enosi Thraki	32	35	35	49
7	Doxa Dramas	32	37	34	48
8	AEP Kozani	31	38	39	47
9	Panaitolikos	32	38	32	45
10	Agrotikos	32	47	42	45
11	Thermaikos	32	35	33	44
12	Anagennisi	32	36	35	43
13	Eordaikos	32	22	35	39
14	Pavlos Melas	31	33	46	36
15	Pandramaikos	31	18	45	25
16	Apollon	32	21	48	23
17	Iltex Lykoi	32	28	57	20

Competiciones que juega

Tercera Grecia Grupo 1

Pos	Equipos		Pts
1		Kampaniakos Chalastra	59
2		Kavala	55
3		Poseidon Nea Michaniona	53
4		Doxa Dramas	49
5		Apollon Paralimniou	47
6		Panthrakikos	47
7		Nestos Chrisoupolis	41
8		Aris Avato	41
9		Thermaikos Thermis	40
10		Pandramaikos	37
11		Byron Kavala	32
12		Agrotikos Asteras	30
13		Orfeas Xanthi	30
14		Antheias-Aristinou	13
15		Alexandroupolis FC	4

	Playoff Ascenso : Kampaniakos Chalastra
	Descenso : Pandramaikos, Byron Kavala, Agrotikos Asteras, Orfeas Xanthi, Antheias-Aristinou, Alexandroupolis FC

RIVALES EN Tercera Grecia

USO DE MEMORIA

6,998,656 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6557
Total Execution Time	0.6569

CADENA URL

/historico/Agrotikos-Asteras

GET DATOS

$_GET['/historico/Agrotikos-Asteras']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0272	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 = 70495
0.0130	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20597 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 344 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129	SELECT /53 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 (1098455,1051323,606708,277509,105444) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '20597' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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 = '20597' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 70495 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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=20597 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0130	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 (70495,64113) 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.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 70495 AND teamId = 20597
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 64113 AND teamId = 20597
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 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 = 70495 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '20597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20597' and rp.type = 4
0.0137	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 = '20597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 events2023 e ON e.player_id = p.id AND e.league_id = 70495 WHERE rp.league_id = 70495 AND rp.teamId = 20597 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.0137	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 events2023 e ON e.player_id = p.id AND e.league_id = 70495 WHERE rp.league_id = 70495 AND rp.teamId = 20597 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 events2023 e ON e.player_id = p.id AND e.league_id = 70495 WHERE rp.league_id = 70495 AND rp.teamId = 20597 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 20597 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138	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 = 70495 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.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* `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 = 65484 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.0134	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 = 67312 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.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* `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 = 59058 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 51442 AND t.round = 27 ORDER BY team.conference ASC,t.position 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* `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 = 45474 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* `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 = 40661 AND t.round = 30 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* `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.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* `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.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* `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.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* `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 = 13424 AND t.round = 10 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* `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 = 12262 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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.0135	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* `tables2011` 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 = 13405 AND t.round = 34 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* `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 = 13404 AND t.round = 34 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* `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 = 13403 AND t.round = 34 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* `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 = 13402 AND t.round = 34 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* `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 = 13401 AND t.round = 34 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* `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
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* `tables2005` 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 = 24855 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Agrotikos Asteras

Agrotikos Asteras

Selecciona un equipo

Competiciones que juega

Tercera Grecia Grupo 1

RIVALES EN Tercera Grecia