4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Valtti Valtti 2 10 0 6
2 Ponnistus Ponnistus 2 10 2 6
3 HPS HPS 2 6 1 6
4 LPS LPS 1 6 2 3
5 PPJ / Lauttasaari Lauttasaari 2 6 4 3
6 FC Kontu FC Kontu 2 5 3 3
7 MPS / Atletico Malmi Atletico 1 2 0 3
8 Töölön Taisto Töölön 2 1 3 1
9 HIFK 2 HIFK 2 2 1 4 1
10 Finnkurd Finnkurd 2 3 9 0
11 HerTo HerTo 2 0 10 0
12 Loviisa Loviisa 2 1 13 0
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 JPS JPS 18 46 24 37
2 FC Jyvaskyla Blackbird Jyvaskyla 18 56 27 35
3 LehPa LehPa 18 32 13 35
4 Kings Kuopio Kings Kuopio 18 50 37 34
5 KeuPa KeuPa 18 43 34 30
6 PK-37 PK-37 18 40 40 23
7 FC Komeetat FC Komeetat 18 26 39 20
8 NiemU NiemU 18 27 40 18
9 AFC Keltik AFC Keltik 18 28 61 12
10 STPS STPS 18 28 61 11
11 MYPA MYPA 22 91 19 58
12 HaPK HaPK 22 54 27 45
13 Mikkelin Palloilijat II Mikkelin 22 75 47 39
14 Union Plaani Union Plaani 22 45 37 38
15 Mikkelin Kissat Mikkelin 22 60 48 35
16 KJP KJP 21 42 30 34
17 Edustus IPS Edustus IPS 21 51 59 34
18 PeKa PeKa 22 34 30 32
19 Kultsu Kultsu 22 40 49 25
20 LaPa LaPa 22 25 53 17
21 KoPa KoPa 22 23 57 14
22 Jäntevä Kotka Jäntevä 22 17 101 3
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Kuopion Elo Kuopion Elo 20 73 13 55
2 FC Jyvaskyla Blackbird Jyvaskyla 20 52 24 38
3 AC Barca AC Barca 20 46 30 37
4 PK-37 PK-37 20 55 30 33
5 JJK Jyväskylä II Jyväskylä 20 50 44 32
6 LehPa LehPa 20 39 38 32
7 Kings Kuopio Kings Kuopio 20 34 35 31
8 JPS JPS 20 34 36 20
9 SC Riverball Riverball 20 22 51 20
10 KeuPa KeuPa 20 25 50 18
11 SaPa Pieksämäki SaPa 20 13 92 4
12 Warkaus JK Warkaus JK 0 0 0 0
13 HaPK HaPK 21 77 24 51
14 MYPA MYPA 22 57 25 47
15 Kultsu Kultsu 22 49 32 41
16 Edustus IPS Edustus IPS 22 65 48 40
17 Mikkelin Kissat Mikkelin 22 51 32 34
18 KJP KJP 22 49 46 33
19 KoPa KoPa 22 44 42 32
20 Union Plaani Union Plaani 22 37 36 32
21 SavU SavU 22 56 52 31
22 STPS STPS 21 39 60 20
23 RPS Lions RPS Lions 22 23 83 12
24 Ri-Pa Ri-Pa 22 26 93 4
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 ToTe ToTe 11 30 9 26
2 SexyPöxyt SexyPöxyt 11 27 11 26
3 EBK EBK 11 34 21 24
4 Kirkkonummi Kirkkonummi 11 26 17 19
5 CLE CLE 11 30 21 18
6 EPS II EPS II 11 23 23 18
7 FC Espoo FC Espoo 11 23 18 17
8 EsPa EsPa 11 25 20 14
9 Ekenäs IF II Ekenäs 11 19 30 13
10 Töölön Taisto Töölön 11 13 28 10
11 Espoon Tikka Espoon Tikka 11 18 41 5
12 NuPS NuPS 11 10 39 1
13 PPJ PPJ 11 39 10 23
14 HPS HPS 11 26 13 22
15 Finnkurd Finnkurd 11 31 19 22
16 MPS / Atletico Malmi Atletico 11 24 13 22
17 TiPS TiPS 11 28 15 19
18 LPS LPS 11 34 25 19
19 HIFK 2 HIFK 2 11 17 10 17
20 PuiU Helsinki PuiU 11 17 22 14
21 KoiPS KoiPS 11 15 23 13
22 SaPa SaPa 11 11 24 8
23 Viikingit Viikingit 11 9 38 7
24 FC Espoo II FC Espoo II 11 4 43 0
25 Futura Futura 11 33 13 30
26 Valtti Valtti 11 21 12 23
27 Atlantis II Atlantis II 11 37 14 22
28 FC Kontu FC Kontu 11 28 15 22
29 PKKU II PKKU II 11 24 15 19
30 MPS MPS 11 26 22 17
31 Ponnistajat Ponnistajat 11 24 27 12
32 Kapina Kapina 11 22 23 11
33 FC Kuusysi FC Kuusysi 11 22 28 11
34 RiPS RiPS 11 14 22 10
35 TuPS TuPS 11 14 44 7
36 NJS II NJS II 11 12 42 0
Ver
TEMPORADA 2019/2020
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

  USO DE MEMORIA  
5,506,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1074
Total Execution Time  0.1108
  CADENA URL  
/cuarta_finlandia_kolmonen2024/grupo3/historico
  GET DATOS  
$_GET['/cuarta_finlandia_kolmonen2024/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'cuarta_finlandia_kolmonen2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_finlandia_kolmonen' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2355 AND type_rel = 3
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2355 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75428 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0057  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2355 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 75428 AND t.round = 2 ORDER BY team.conference ASC,t.position 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 `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 = 70997 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.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 = 66706 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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.0027  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.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:49:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:49:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:49:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:49:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_finlandia_kolmonen' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75428 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75428 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75428 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  SELECT *,(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 = 75428 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC