4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC POHU
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 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 2012/2013
CUARTA FINLANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 HIFK HIFK 27 64 22 62
2 Mikkelin Palloilijat Mikkelin 27 71 36 60
3 Atlantis Atlantis 27 49 42 48
4 FC Kuusysi FC Kuusysi 27 46 35 43
5 PKKU PKKU 27 58 43 42
6 FC KTP FC KTP 27 59 38 41
7 Futura Futura 27 44 45 35
8 JaPS JaPS 27 28 55 19
9 Sudet Sudet 27 24 54 19
10 FC POHU FC POHU 27 20 93 18

  USO DE MEMORIA  
5,212,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0719
Total Execution Time  0.0734
  CADENA URL  
/historico/Fc-Pohu
  GET DATOS  
$_GET['/historico/Fc-Pohu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12629 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=652 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 652 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1137782,176576,169810,163782,134921) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = '12629' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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=12629 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 12629
0.0019  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 = '12629' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12629' and rp.type = 4
0.0019  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 = '12629' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75296 WHERE rp.league_id = 75296 AND rp.teamId = 12629 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.0021  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 = 75296 WHERE rp.league_id = 75296 AND rp.teamId = 12629 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75296 WHERE rp.league_id = 75296 AND rp.teamId = 12629 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 12629 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042  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.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 `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.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 = 2779 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC