4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del EsPa
TEMPORADA 2023/2024
QUINTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ekenäs IF II Ekenäs 0 0 0 0
2 EPS II EPS II 0 0 0 0
3 EsPa EsPa 0 0 0 0
4 FC Espoo FC Espoo 0 0 0 0
5 GrIFK Sub 23 GrIFK 0 0 0 0
6 HooGee HooGee 0 0 0 0
7 Kirkkonummi Kirkkonummi 0 0 0 0
8 LJS LJS 0 0 0 0
9 NuPS NuPS 0 0 0 0
10 PPJ / Ruoholahti Ruoholahti 0 0 0 0
11 ToTe ToTe 0 0 0 0
12 VJS II VJS II 0 0 0 0
TEMPORADA 2022/2023
QUINTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 EBK EBK 22 57 22 51
2 NuPS NuPS 22 56 19 49
3 EsPa EsPa 22 67 33 45
4 GrIFK Sub 23 GrIFK 22 34 21 38
5 Töölön Taisto Töölön 22 45 31 36
6 Ekenäs IF II Ekenäs 22 38 34 35
7 HIFK 2 HIFK 2 22 32 27 34
8 Kirkkonummi Kirkkonummi 22 33 42 28
9 EPS II EPS II 22 28 39 25
10 LJS LJS 22 22 48 23
11 FC Espoo FC Espoo 22 26 57 14
12 Kurvin Vauhti Kurvin 22 17 82 3
13 VJS VJS 22 90 13 55
14 HPS HPS 22 70 10 55
15 MPS / Atletico Malmi Atletico 22 79 37 48
16 FC Kontu FC Kontu 22 68 35 44
17 LPS LPS 22 77 40 41
18 PPJ / Ruoholahti Ruoholahti 22 52 40 36
19 Gnistan - Ogeli Gnistan 22 48 47 29
20 Ponnistajat Ponnistajat 22 48 51 23
21 Finnkurd Finnkurd 22 40 74 22
22 HerTo HerTo 22 28 80 17
23 SaPa SaPa 22 20 91 10
24 ToTe II ToTe II 22 13 115 1
25 JäPS II JäPS II 22 58 19 49
26 MPS MPS 22 62 27 45
27 ToTe ToTe 22 48 23 45
28 PuiU Helsinki PuiU 22 47 25 41
29 Valtti Valtti 22 47 33 36
30 TuPS TuPS 22 48 48 34
31 RiPS RiPS 22 36 36 31
32 PKKU II PKKU II 22 35 52 25
33 HyPS HyPS 22 27 51 24
34 Loviisa Loviisa 22 29 56 18
35 NouLa NouLa 22 31 58 16
36 KoiPS KoiPS 22 27 67 9
TEMPORADA 2021/2022
QUINTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 LePa LePa 2 0 10 0
2 EPS II EPS II 20 63 22 45
3 FC Espoo FC Espoo 21 46 28 44
4 SexyPöxyt SexyPöxyt 19 54 24 41
5 EBK EBK 20 66 38 36
6 Ekenäs IF II Ekenäs 21 39 35 30
7 GrIFK Sub 23 GrIFK 20 30 43 26
8 EsPa EsPa 20 37 54 26
9 SaPa SaPa 20 40 39 24
10 Kirkkonummi Kirkkonummi 20 31 41 24
11 Finnkurd Finnkurd 19 27 64 15
12 BK-46 BK-46 20 20 55 8
13 Atlantis II Atlantis II 22 88 21 56
14 ToTe ToTe 22 53 22 49
15 Valtti Valtti 22 58 29 45
16 FC Kontu FC Kontu 22 61 36 38
17 MPS MPS 22 43 24 37
18 PuiU Helsinki PuiU 22 49 49 30
19 Töölön Taisto Töölön 22 42 53 30
20 Ponnistajat Ponnistajat 22 35 41 28
21 HIFK 2 HIFK 2 22 35 58 25
22 HerTo HerTo 22 33 53 21
23 Viikingit Viikingit 22 21 76 8
24 FC POHU FC POHU 22 31 87 8
25 TiPS TiPS 22 60 16 53
26 HPS HPS 22 68 28 49
27 LPS LPS 22 79 43 45
28 PKKU II PKKU II 22 37 25 39
29 MPS / Atletico Malmi Atletico 22 56 36 38
30 JäPS II JäPS II 22 37 21 37
31 RiPS RiPS 22 41 43 29
32 KoiPS KoiPS 22 41 56 23
33 NouLa NouLa 22 31 65 22
34 TuPS TuPS 22 26 55 21
35 FC Kuusysi FC Kuusysi 22 31 71 11
36 Inter Helsinki Inter 22 34 82 9
TEMPORADA 2020/2021
QUINTA FINLANDIA GRUPO 8
Equipo PJ GF GC Puntos
1 EsPa EsPa 5 16 10 24
2 FC Espoo FC Espoo 5 10 9 24
3 Ekenäs IF II Ekenäs 5 15 8 20
4 Töölön Taisto Töölön 5 9 5 19
5 Espoon Tikka Espoon Tikka 5 8 11 18
6 NuPS NuPS 5 5 20 1
7 KoiPS KoiPS 5 12 6 26
8 SaPa SaPa 5 14 5 25
9 FC Espoo II FC Espoo II 5 7 29 15
10 PuiU Helsinki PuiU 5 13 9 14
11 Viikingit Viikingit 5 10 7 14
12 HIFK 2 HIFK 2 5 8 8 9
13 TuPS TuPS 5 8 6 20
14 Ponnistajat Ponnistajat 5 10 10 19
15 RiPS RiPS 5 4 7 14
16 NJS II NJS II 5 13 8 10
17 FC Kuusysi FC Kuusysi 5 11 7 10
18 Kapina Kapina 5 1 9 0
TEMPORADA 2019/2020
QUINTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 KaPa KaPa 17 50 15 44
2 Atlantis II Atlantis II 17 54 27 36
3 SexyPöxyt SexyPöxyt 17 33 17 34
4 Kirkkonummi Kirkkonummi 17 37 23 34
5 HPS HPS 17 42 29 28
6 EsPa EsPa 17 36 27 28
7 LPS LPS 18 43 38 28
8 CLE CLE 17 29 30 28
9 Töölön Taisto Töölön 17 37 33 25
10 ToTe ToTe 17 29 36 25
11 Finnkurd Finnkurd 17 43 48 24
12 NuPS NuPS 16 35 35 22
13 FC Espoo II FC Espoo II 17 14 25 17
14 Ekenäs IF II Ekenäs 17 26 46 17
15 Espoon Tikka Espoon Tikka 17 39 49 15
16 HerTo HerTo 17 24 38 10
17 BK-46 BK-46 17 16 46 10
18 FC POHU FC POHU 17 19 44 7
TEMPORADA 2016/2017
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Viikingit Viikingit 22 50 28 45
2 Musan Salama Musan Salama 22 44 18 44
3 SalPa SalPa 22 47 31 43
4 BK-46 BK-46 22 46 29 42
5 TPV Tampere TPV Tampere 22 45 40 36
6 Tampere United Tampere 22 43 38 33
7 KaPa KaPa 22 34 20 32
8 FC Jazz FC Jazz 22 37 43 28
9 FC Espoo FC Espoo 22 39 37 25
10 Peimari United Peimari 22 26 43 19
11 NuPS NuPS 22 24 66 14
12 EsPa EsPa 22 28 70 11
TEMPORADA 2015/2016
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Honka FC Honka 22 74 9 58
2 TPV Tampere TPV Tampere 22 47 22 45
3 BK-46 BK-46 22 51 35 41
4 FC Espoo FC Espoo 22 41 38 37
5 Klubi 04 Klubi 04 22 40 32 35
6 Kiffen Kiffen 22 31 31 31
7 SalPa SalPa 22 31 33 25
8 Viikingit Viikingit 22 29 37 23
9 EsPa EsPa 22 21 55 22
10 Åland Åland 22 25 38 21
11 Atlantis Atlantis 22 25 36 20
12 FC Kontu FC Kontu 22 20 69 11
TEMPORADA 2012/2013
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ekenäs IF Ekenäs IF 27 52 25 57
2 Gnistan Gnistan 27 48 29 49
3 GrIFK Grankulla GrIFK 27 50 39 48
4 BK-46 BK-46 27 50 35 45
5 SalPa SalPa 27 41 33 38
6 Klubi 04 Klubi 04 27 27 29 37
7 KaPa KaPa 27 33 36 34
8 Pallohonka Pallohonka 27 32 36 33
9 EsPa EsPa 27 21 58 18
10 LPS LPS 27 23 57 17
TEMPORADA 2011/2012
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 ÅIFK ÅIFK 27 50 25 56
2 BK-46 BK-46 27 55 35 51
3 SalPa SalPa 27 50 34 50
4 Ekenäs IF Ekenäs IF 27 75 34 48
5 Klubi 04 Klubi 04 27 64 36 45
6 GrIFK Grankulla GrIFK 27 64 35 42
7 Pallohonka Pallohonka 27 56 38 42
8 EsPa EsPa 27 46 59 28
9 FC Espoo FC Espoo 27 48 61 23
10 LoPa LoPa 27 14 165 1

  USO DE MEMORIA  
6,089,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5613
Total Execution Time  0.5626
  CADENA URL  
/historico/Espa
  GET DATOS  
$_GET['/historico/Espa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0135  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 = 'Espa' 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.0125  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=12617 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=12617 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12617 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 75427
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12617 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2355 AND type_rel = 3
0.0128  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 = '12617' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '12617' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '12617' 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 = 75427 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=12617 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 (75427,75296) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75427 AND teamId = 12617
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 12617
0.0140  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 = 75427 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '12617' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12617' and rp.type = 4
0.0130  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 = '12617' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 75427 WHERE rp.league_id = 75427 AND rp.teamId = 12617 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.0128  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 = 75427 WHERE rp.league_id = 75427 AND rp.teamId = 12617 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 75427 WHERE rp.league_id = 75427 AND rp.teamId = 12617 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 12617 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143  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 = 75427 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.0157  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 = 70864 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.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 `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 = 66474 AND t.round = 40 ORDER BY team.conference ASC,t.position 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 `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 = 62652 AND t.round = 20 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 = 64668 AND t.round = 5 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 = 57727 AND t.round = 16 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 `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 = 37931 AND t.round = 22 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 `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 = 20335 AND t.round = 22 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 `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 = 2777 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 16303 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 75427 ORDER BY nameShow LIMIT 100