4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Viikingit Viikingit
A. Wikstrom A. Wikstrom 29 años DEF
C. Martinez C. Martinez DEF
Miska Hurme Miska Hurme DEF
E. Hirvimaki E. Hirvimaki DEF
J. Moskuvaara J. Moskuvaara MED
Leonard Quednau Leonard Quednau 25 años MED
Alex Andersson Alex Andersson 23 años MED
P. Leino P. Leino MED
J. Rännäli J. Rännäli MED
T. Arovaara T. Arovaara MED
N. Biga N. Biga 29 años MED
O. Simula O. Simula 30 años MED
M. Hadzhiev M. Hadzhiev MED
T. Honkanen T. Honkanen MED
R. Mainz R. Mainz MED
M. Matalamäki M. Matalamäki MED
M. Ailio M. Ailio 30 años MED
J. Forsten J. Forsten MED
P. Tenho P. Tenho POR
Niko Ruuth Niko Ruuth 36 años 188cm POR
J. Ailio J. Ailio POR
A. Hyvönen A. Hyvönen POR
S. Kuosmanen S. Kuosmanen POR
A. Laalo A. Laalo POR
D. Stierncreutz D. Stierncreutz DEF
T. Porkka T. Porkka DEF
N. Lautanala N. Lautanala DEF
A. Kuhmola A. Kuhmola 31 años MED
F. Andler F. Andler 29 años DEL
H. Martikainen H. Martikainen 30 años DEL
Adel Jrad Adel Jrad 21 años DEF

Clasificación

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

  USO DE MEMORIA  
5,682,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.2757
Total Execution Time  0.2785
  CADENA URL  
/cuarta_finlandia_kolmonen2022/grupo1/jugadores
  GET DATOS  
$_GET['/cuarta_finlandia_kolmonen2022/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'cuarta_finlandia_kolmonen2022'
0.0212  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2355 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2355 ORDER BY order_id ASC
0.0108  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 = 66474 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66474 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0109  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 66474 AND dt.id IN (12599,18024,12612,12633,64170,13217,65380,65400,62711,12617,64158,64168,62664,62715,65419,84223,65428,99473,62690,62686,62713,137979,142802,110863,137970,137972,137981,142803,137986,65377,12629,149912,137983,137968,149916,149915) ORDER BY dt.relations DESC,dp.role ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:16:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:16:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:16:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:16:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0119  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0119  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 events2022 e ON e.player_id = p.id AND e.league_id = 66474 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66474 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.0122  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 events2022 e ON e.player_id = p.id AND e.league_id = 66474 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66474 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0113  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 events2022 e ON e.player_id = p.id AND e.league_id = 66474 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66474 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  SELECT *,(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