4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Asteras Tripolis

Asteras Tripolis

Entrenador: Milan Rastavac

Temporada 2023/2024
TEMPORADA 2023/2024
SUPER LEAGUE GRIEGA GRUPO 3
Equipo PJ GF GC Puntos
1 OFI OFI 32 35 48 35
2 Asteras Tripolis Asteras 32 39 55 35
3 Panserraikos FC Panserraikos 32 35 53 35
4 Atromitos Atromitos 32 36 52 34
5 Panaitolikos Panaitolikos 32 34 48 33
6 Volos New Football Volos 32 35 57 32
7 Kifisia Kifisia 32 38 66 28
8 PAS Giannina Giannina 32 32 61 22
TEMPORADA 2022/2023
SUPER LEAGUE GRIEGA GRUPO 3
Equipo PJ GF GC Puntos
1 OFI OFI 33 37 41 41
2 Atromitos Atromitos 33 34 36 38
3 PAS Giannina Giannina 33 33 50 34
4 Asteras Tripolis Asteras 33 23 36 31
5 Panaitolikos Panaitolikos 33 32 53 30
6 Lamia Lamia 33 23 53 29
7 Ionikos Nikea Ionikos 33 24 51 27
8 Levadiakos Levadiakos 33 25 48 26
TEMPORADA 2021/2022
SUPER LEAGUE GRIEGA GRUPO 3
Equipo PJ GF GC Puntos
1 Ionikos Nikea Ionikos 33 44 42 45
2 OFI OFI 33 40 45 44
3 Asteras Tripolis Asteras 33 33 37 41
4 Volos New Football Volos 33 47 48 40
5 Panaitolikos Panaitolikos 33 32 48 37
6 Atromitos Atromitos 33 33 52 33
7 Lamia Lamia 33 24 44 26
8 Apollon Smyrnis Apollon 33 16 57 22
TEMPORADA 2020/2021
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 26 64 13 67
2 Aris Thessaloniki Aris 26 34 16 51
3 AEK Athens AEK Athens 26 41 29 48
4 PAOK PAOK 26 49 26 47
5 Panathinaikos Panathinaiko 26 30 19 45
6 Asteras Tripolis Asteras 26 27 25 42
7 Volos New Football Volos 26 26 32 33
8 PAS Giannina Giannina 26 23 26 31
9 Apollon Smyrnis Apollon 26 26 35 28
10 Atromitos Atromitos 26 24 35 28
11 Lamia Lamia 26 14 38 23
12 Panaitolikos Panaitolikos 26 13 32 20
13 OFI OFI 26 22 43 19
14 AE Larisa AE Larisa 26 18 42 16
TEMPORADA 2019/2020
SUPER LEAGUE GRIEGA GRUPO 3
Equipo PJ GF GC Puntos
1 Asteras Tripolis Asteras 7 11 5 43
2 Atromitos Atromitos 7 10 7 42
3 AE Larisa AE Larisa 7 4 9 36
4 Lamia Lamia 7 4 3 35
5 Volos New Football Volos 7 4 12 31
6 Panaitolikos Panaitolikos 7 10 6 29
7 Xanthi Xanthi 7 4 6 24
8 Panionios Panionios 7 4 3 23
TEMPORADA 2018/2019
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 PAOK PAOK 30 66 14 80
2 Olympiacos Piraeus Olympiacos 30 71 17 75
3 AEK Athens AEK Athens 30 50 19 57
4 Atromitos Atromitos 30 41 28 52
5 Aris Thessaloniki Aris 30 46 33 49
6 Panionios Panionios 30 27 45 38
7 Lamia Lamia 30 28 37 37
8 Panathinaikos Panathinaiko 30 38 30 36
9 Panaitolikos Panaitolikos 30 34 48 36
10 AE Larisa AE Larisa 30 26 34 34
11 Asteras Tripolis Asteras 30 25 30 33
12 Xanthi Xanthi 30 22 34 32
13 OFI OFI 30 30 42 32
14 PAS Giannina Giannina 30 19 38 27
15 Levadiakos Levadiakos 30 15 45 21
16 Apollon Smyrnis Apollon 30 11 55 10
TEMPORADA 2017/2018
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 50 12 70
2 PAOK PAOK 30 59 19 64
3 Olympiacos Piraeus Olympiacos 30 63 28 57
4 Atromitos Atromitos 30 43 21 56
5 Asteras Tripolis Asteras 30 39 24 45
6 Xanthi Xanthi 30 31 30 45
7 Panionios Panionios 30 32 31 40
8 Panaitolikos Panaitolikos 30 31 40 35
9 PAS Giannina Giannina 30 31 34 34
10 Levadiakos Levadiakos 30 23 34 34
11 Panathinaikos Panathinaiko 30 30 30 32
12 AE Larisa AE Larisa 30 22 41 31
13 Lamia Lamia 30 20 34 30
14 Apollon Smyrnis Apollon 30 23 36 29
15 Kerkyra Kerkyra 30 19 51 22
16 Platanias Platanias 30 14 65 10
TEMPORADA 2016/2017
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 57 16 67
2 PAOK PAOK 30 52 19 61
3 Panathinaikos Panathinaiko 30 45 19 57
4 AEK Athens AEK Athens 30 54 23 53
5 Panionios Panionios 30 35 23 52
6 Xanthi Xanthi 30 34 25 48
7 Platanias Platanias 30 34 38 42
8 Atromitos Atromitos 30 29 38 39
9 PAS Giannina Giannina 30 30 37 36
10 Kerkyra Kerkyra 30 22 43 32
11 Panaitolikos Panaitolikos 30 29 40 31
12 Asteras Tripolis Asteras 30 34 49 28
13 AE Larisa AE Larisa 30 23 42 28
14 Levadiakos Levadiakos 30 27 49 26
15 Iraklis Thessaloniki Iraklis 30 28 39 26
16 Veria NPS Veria NPS 30 23 56 22
TEMPORADA 2015/2016
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 81 16 85
2 AEK Athens AEK Athens 30 43 21 57
3 Panathinaikos Panathinaiko 30 52 26 55
4 PAOK PAOK 30 45 32 48
5 Panionios Panionios 30 33 27 44
6 PAS Giannina Giannina 30 36 40 42
7 Atromitos Atromitos 30 26 31 42
8 Asteras Tripolis Asteras 30 31 30 41
9 Platanias Platanias 30 32 30 39
10 Levadiakos Levadiakos 30 27 36 37
11 Iraklis Thessaloniki Iraklis 30 24 32 35
12 Panaitolikos Panaitolikos 30 30 46 35
13 Xanthi Xanthi 30 27 32 33
14 Veria NPS Veria NPS 30 19 33 27
15 Panthrakikos Panthrakikos 30 18 58 17
16 Kalloni Kalloni 30 19 53 16
TEMPORADA 2014/2015
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 6 9 2 15
2 Asteras Tripolis Asteras 6 2 4 10
3 Atromitos Atromitos 6 4 4 8
4 PAOK PAOK 6 1 6 4
TEMPORADA 2013/2014
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 6 7 5 11
2 PAOK PAOK 6 8 4 10
3 Atromitos Atromitos 6 6 9 7
4 Asteras Tripolis Asteras 6 5 8 7
TEMPORADA 2012/2013
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 PAOK PAOK 6 7 7 13
2 Atromitos Atromitos 6 8 5 11
3 Asteras Tripolis Asteras 6 6 7 9
4 PAS Giannina Giannina 6 6 8 7

  USO DE MEMORIA  
6,013,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0837
Total Execution Time  0.0849
  CADENA URL  
/historico/Asteras-Tripolis
  GET DATOS  
$_GET['/historico/Asteras-Tripolis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
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 = '294' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 294 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75537 AND t.round = 6 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 = 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.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 = 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.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 `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 = 61824 AND t.round = 10 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 `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.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 = 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.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 `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.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 `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.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 `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 = 15431 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 `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 = 3825 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 `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 = 14092 AND t.round = 6 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 `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 = 2517 AND t.round = 34 ORDER BY team.conference 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 `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 = 10446 AND t.round = 6 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 `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 = 2040 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 `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 = 10445 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC