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

Kifisia

Entrenador: Konstantinos Bratsos

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
SEGUNDA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kifisia Kifisia 28 62 16 66
2 Athens Kallithea Athens 28 54 21 65
3 Apollon Smyrnis Apollon 28 37 20 56
4 Chania Chania 28 38 18 51
5 OF Ierapetra Ierapetra 28 39 25 48
6 Kalamata FC Kalamata FC 28 34 17 47
7 Ilioupoli Ilioupoli 28 36 32 41
8 Panachaiki Panachaiki 28 32 29 39
9 Olympiacos Piraeus B Olympiacos 28 39 36 34
10 Egaleo Egaleo 28 27 31 34
11 AEK Athens B Athens 28 30 35 29
12 Proodeftiki FC Proodeftiki 28 23 37 29
13 Episkopi Episkopi 28 17 53 16
14 PAO Rouf PAO Rouf 28 25 60 12
15 Irodotos Irodotos 28 6 69 0
TEMPORADA 2021/2022
SEGUNDA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Levadiakos Levadiakos 32 68 19 72
2 Athens Kallithea Athens 32 46 19 65
3 Kalamata FC Kalamata FC 32 51 20 61
4 Chania Chania 32 46 25 55
5 AEK Athens B Athens 32 38 27 52
6 Kifisia Kifisia 32 37 31 50
7 Episkopi Episkopi 32 27 25 48
8 Egaleo Egaleo 32 31 31 46
9 Ergotelis Ergotelis 32 23 32 40
10 Irodotos Irodotos 32 29 42 37
11 OF Ierapetra Ierapetra 32 43 49 37
12 Diagoras Diagoras 32 22 36 36
13 Asteras Vlachioti Asteras 32 32 38 35
14 Panathinaikos B Panathinaiko 32 30 40 34
15 Karaiskakis Karaiskakis 32 24 50 29
16 Rodos Rodos 32 27 48 18
17 Zakynthos Zakynthos 32 19 61 12
TEMPORADA 2017/2018
TERCERA GRECIA GRUPO 8
Equipo PJ GF GC Puntos
1 Irodotos Irodotos 20 30 12 44
2 Egaleo Egaleo 20 31 22 36
3 OF Ierapetra Ierapetra 20 23 14 30
4 Ilysiakos AO Ilysiakos 20 23 17 27
5 Atsalenios Atsalenios 20 16 19 27
6 Agios Ierotheos Agios 20 24 23 26
7 Palaiochora Palaiochora 20 16 19 26
8 Fostiras Fostiras 20 16 18 22
9 Kifisia Kifisia 20 23 33 21
10 AE Mylopotamos Mylopotamos 20 19 27 19
11 Ermis Zoniana Ermis 20 18 35 18
TEMPORADA 2016/2017
TERCERA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Ergotelis Ergotelis 28 50 21 64
2 Ionikos Nikea Ionikos 28 55 18 63
3 Agios Ierotheos Agios 28 40 23 54
4 Ethnikos Piraeus Ethnikos 28 34 33 40
5 Atsalenios Atsalenios 28 37 43 40
6 Proodeftiki FC Proodeftiki 28 31 27 39
7 Ermis Zoniana Ermis 28 25 33 34
8 Panthiraikos AO Panthiraikos 28 28 32 32
9 Triglia Rafinas Triglia 28 35 42 32
10 Rodos Rodos 28 29 41 31
11 Kifisia Kifisia 28 30 36 30
12 Thyella D Rafina Thyella 28 29 36 29
13 Ialysos Ialysos 28 29 41 29
14 Ilysiakos AO Ilysiakos 28 24 35 27
15 AEEK INKA AEEK INKA 28 24 39 27
TEMPORADA 2015/2016
TERCERA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 OFI OFI 30 53 11 68
2 Fostiras Fostiras 30 42 22 63
3 Triglia Rafinas Triglia 30 44 25 57
4 Ethnikos Piraeus Ethnikos 30 44 29 56
5 Ialysos Ialysos 30 41 31 55
6 Ermis Zoniana Ermis 30 45 37 50
7 Ionikos Nikea Ionikos 30 36 23 49
8 Ilysiakos AO Ilysiakos 30 37 28 46
9 Kifisia Kifisia 30 38 32 46
10 Kyanos Asteras Vari Kyanos 30 33 30 41
11 Kroussonas Kroussonas 30 28 43 32
12 Atromitos Piraeus Atromitos 30 26 42 32
13 Episkopi Episkopi 30 29 41 29
14 Iraklio Iraklio 30 41 55 26
15 Glyfada Glyfada 30 19 57 10
16 Trachones Trachones 30 16 66 9
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 6
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 28 80 14 75
2 Kifisia Kifisia 28 59 31 54
3 Irodotos Irodotos 28 40 33 45
4 Triglia Rafinas Triglia 28 42 26 44
5 Kyanos Asteras Vari Kyanos 28 39 29 42
6 Ilysiakos AO Ilysiakos 28 39 42 42
7 Kroussonas Kroussonas 28 42 48 40
8 Aigaleo FC Athens Aigaleo 28 26 25 39
9 Ermis Zoniana Ermis 28 34 32 38
10 Mandraikos Mandraikos 28 31 38 38
11 Thyella D Rafina Thyella 28 27 27 35
12 Ifaistos Peristeri Ifaistos 28 33 55 30
13 Peramaikos Peramaikos 28 25 48 28
14 Pannaxiakos Pannaxiakos 28 22 49 17
15 Agios Nikolaos Agios 28 24 66 13

  USO DE MEMORIA  
5,892,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1320
Total Execution Time  0.1332
  CADENA URL  
/historico/Kifisia
  GET DATOS  
$_GET['/historico/Kifisia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0036  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 = 'Kifisia' 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.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=63270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=63270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=63270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=63270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=63270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72170
0.0028  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 = 73551
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63270 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17 AND type_rel = 3
0.0051  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 17 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1312351,1301600,1301278,1301232,1293682) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '63270' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '63270' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '63270' 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.0025  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=63270 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (75537,73551,71432,69285) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 75537 AND teamId = 63270
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69285 AND teamId = 63270
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 63270
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 63270
0.0021  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 = '63270' 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 = '63270' and rp.type = 4
0.0027  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 = '63270' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 75537 WHERE rp.league_id = 75537 AND rp.teamId = 63270 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.0037  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 = 75537 WHERE rp.league_id = 75537 AND rp.teamId = 63270 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75537 WHERE rp.league_id = 75537 AND rp.teamId = 63270 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 63270 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72170 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 `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.0026  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 = 69285 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.0028  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 = 65351 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.0026  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 = 40667 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 36077 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15929 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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.0029  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 = 12267 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC