4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Giouchtas
TEMPORADA 2023/2024
SEGUNDA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 PAOK B PAOK B 6 12 9 27
2 Iraklis Thessaloniki Iraklis 6 6 3 27
3 Anagennisi Karditsas Anagennisi 6 2 5 20
4 Kampaniakos Chalastra Kampaniakos 6 7 7 19
5 Kozani FC Kozani FC 6 7 8 19
6 Aiolikos Aiolikos 6 3 5 15
7 Diagoras Diagoras 7 7 4 27
8 Egaleo Egaleo 6 6 3 22
9 Panachaiki Panachaiki 6 7 9 21
10 Panathinaikos B Panathinaiko 7 4 3 20
11 Giouchtas Giouchtas 6 5 10 17
12 Olympiacos Piraeus B Olympiacos 6 9 9 16
TEMPORADA 2022/2023
TERCERA GRECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Aiolikos Aiolikos 8 10 10 13
2 Kampaniakos Chalastra Kampaniakos 8 10 8 12
3 Kozani FC Kozani FC 8 8 8 12
4 Giouchtas Giouchtas 8 8 9 9
5 Tilikratis Tilikratis 8 7 8 9
TEMPORADA 2021/2022
TERCERA GRECIA GRUPO 7
Equipo PJ GF GC Puntos
1 PAO Rouf PAO Rouf 18 36 16 43
2 Panionios Panionios 18 33 12 40
3 Poros Poros 18 32 20 30
4 Agios Nikolaos Agios 18 29 22 30
5 Giouchtas Giouchtas 18 20 16 27
6 Almyros Gaziou Almyros 18 29 17 26
7 Atsalenios Atsalenios 18 28 24 26
8 Aris Soudas Aris Soudas 18 13 26 10
9 Anagennisi Ierapetra Anagennisi 18 13 55 10
10 AE Neapolis AE Neapolis 18 10 35 9
TEMPORADA 2020/2021
TERCERA GRECIA GRUPO 10
Equipo PJ GF GC Puntos
1 Irodotos Irodotos 15 30 9 36
2 Agios Nikolaos Agios 15 31 12 34
3 Atsalenios Atsalenios 15 25 15 31
4 Almyros Gaziou Almyros 15 35 14 28
5 AEEK INKA AEEK INKA 15 30 14 28
6 Giouchtas Giouchtas 15 22 12 27
7 Aris Soudas Aris Soudas 15 23 17 24
8 Poros Poros 15 17 19 23
9 Anagennisi Ierapetra Anagennisi 15 33 29 22
10 AE Neapolis AE Neapolis 15 16 18 22
11 Rethymniakos Rethymniakos 15 21 20 21
12 Damastas Damastas 15 20 20 18
13 Asteras Rethymno Asteras 15 19 29 15
14 Palaiochora Palaiochora 14 6 39 6
15 Platanias Platanias 15 8 29 5
16 Aris Rethymnou Aris 14 1 41 0
TEMPORADA 2019/2020
TERCERA GRECIA GRUPO 9
Equipo PJ GF GC Puntos
1 Episkopi Episkopi 3 3 3 42
2 Giouchtas Giouchtas 3 4 4 35
3 Irodotos Irodotos 3 5 4 30
4 Panakrotiriakos Panakrotiria 3 2 3 26
TEMPORADA 2018/2019
TERCERA GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 OF Ierapetra Ierapetra 24 43 14 50
2 Ionikos Nikea Ionikos 24 32 11 47
3 Ethnikos Piraeus Ethnikos 24 32 17 44
4 Episkopi Episkopi 24 43 23 42
5 Giouchtas Giouchtas 24 31 19 40
6 AEEK INKA AEEK INKA 24 30 23 35
7 Atsalenios Atsalenios 24 25 18 34
8 Keratsini Keratsini 24 27 30 33
9 Proodeftiki FC Proodeftiki 24 17 21 29
10 Ampelakiako Salamis Ampelakiako 24 18 27 25
11 Palaiochora Palaiochora 24 23 45 20
12 Atromitos Pireo Atromitos 24 19 50 11
13 AE Neapolis AE Neapolis 24 14 56 10
TEMPORADA 2014/2015
TERCERA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Chania Chania 26 37 19 54
2 Kifisia Kifisia 26 35 19 46
3 Atromitos Piraeus Atromitos 26 58 38 43
4 Ionikos Nikea Ionikos 25 39 24 43
5 Kyanos Asteras Vari Kyanos 26 27 33 34
6 Glyfada Glyfada 26 26 33 34
7 Triglia Rafinas Triglia 26 37 31 33
8 Ethnikos Piraeus Ethnikos 25 21 21 33
9 Kroussonas Kroussonas 26 33 37 32
10 Ilysiakos AO Ilysiakos 26 32 44 30
11 Irodotos Irodotos 26 34 25 29
12 Giouchtas Giouchtas 26 34 32 29
13 Nea Lonia Nea Lonia 26 28 38 27
14 Anagennisi Ierapetra Anagennisi 26 13 60 7
TEMPORADA 2013/2014
TERCERA GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Ionikos Nikea Ionikos 4 6 1 10
2 Panelefsiniakos Panelefsinia 4 7 2 8
3 Trachones Trachones 4 4 1 8
4 Giouchtas Giouchtas 4 6 4 7
5 Nea Lonia Nea Lonia 4 5 3 7
6 Atromitos Piraeus Atromitos 3 5 5 6
7 Pefki Pefki 4 5 4 5
8 Chania Chania 4 3 2 5
9 Mykonos Mykonos 4 4 7 5
10 Doxa Vyrona Doxa Vyrona 4 2 2 4
11 Proodeftiki FC Proodeftiki 4 5 6 4
12 Atsalenios Atsalenios 4 3 5 4
13 Rouvas Rouvas 3 1 3 2
14 Olympiakos Lavrio Olympiakos 4 2 7 1
15 Ethnikos Asteras Ethnikos 4 1 7 0

  USO DE MEMORIA  
5,577,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5023
Total Execution Time  0.5040
  CADENA URL  
/historico/Giouchtas
  GET DATOS  
$_GET['/historico/Giouchtas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0255  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 = 75675
0.0131  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 = 73942
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63258 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2166 AND type_rel = 3
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 = '63258' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 73942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=63258 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75675,73551,71637) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75675 AND teamId = 63258
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 71637 AND teamId = 63258
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 63258
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 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 = 75675 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '63258' 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 = '63258' 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 = '63258' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 63258 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 events2024 e ON e.player_id = p.id AND e.league_id = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 63258 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 events2024 e ON e.player_id = p.id AND e.league_id = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 63258 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 = 63258 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73942 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.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 `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 = 75675 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 `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 = 70499 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.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 `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 = 71637 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.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 `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 = 65490 AND t.round = 18 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 `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 = 59066 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.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 `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 = 51448 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 55507 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 45477 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 12488 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 12266 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC