4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Paide III
TEMPORADA 2018/2019
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide III Paide III 26 100 26 64
2 Tallinna Kalev III Tallinna 26 72 35 56
3 Kuressaare II Kuressaare 26 63 36 47
4 Läänemaa Haapsalu Läänemaa 26 88 66 47
5 JK Piraaja JK Piraaja 26 66 62 39
6 FC Flora Tallin III Flora Tallin 27 56 72 37
7 Vaprus Pärnu II Vaprus 26 46 51 34
8 Viimsi JK II Viimsi 26 45 52 34
9 Pohja Sakala Pohja Sakala 26 51 61 32
10 Raplamaa Raplamaa 27 48 62 32
11 Joker Joker 26 49 60 31
12 Poseidon JK Poseidon JK 26 49 81 27
13 Tulevik II Tulevik II 26 41 70 25
14 Kose Kose 28 41 81 21
TEMPORADA 2017/2018
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide III Paide III 26 89 19 71
2 Viimsi JK Viimsi JK 26 97 19 65
3 Tabasalu Charma Tabasalu 26 78 40 57
4 Vaprus Pärnu II Vaprus 26 74 53 41
5 Läänemaa Haapsalu Läänemaa 26 65 57 41
6 TJK Legion II Legion 26 54 65 34
7 Poseidon JK Poseidon JK 26 45 62 33
8 Tulevik II Tulevik II 26 61 72 30
9 Kuressaare II Kuressaare 26 51 78 30
10 Ganvix Ganvix 26 40 72 30
11 Otepää Otepää 26 46 63 27
12 Torva Torva 26 50 81 26
13 Tallinna Kalev III Tallinna 26 45 74 25
14 Raplamaa Raplamaa 26 40 80 16

  USO DE MEMORIA  
5,049,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2964
Total Execution Time  0.2977
  CADENA URL  
/historico/Paide-Linnameeskond-Iii/2019
  GET DATOS  
$_GET['/historico/Paide-Linnameeskond-Iii/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101469 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0167  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 = '101469' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = 43676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = '101469' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '101469' and rp.type = 4
0.0146  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 = '101469' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 101469 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.0146  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 101469 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 101469 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 101469 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 `tables2019` 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 = 49207 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 42860 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC