4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pärnu Jalgpalliklubi
TEMPORADA 2023/2024
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Tartu Kalev Tartu Kalev 8 22 13 17
2 Tammeka II Tammeka II 8 16 7 17
3 Kuressaare II Kuressaare 8 16 13 16
4 Trans II Trans II 8 17 11 14
5 TJK Legion TJK Legion 8 15 12 10
6 Läänemaa Haapsalu Läänemaa 8 17 21 10
7 Pärnu Jalgpalliklubi Pärnu 8 13 20 10
8 Nõmme Kalju II Nõmme Kalju 7 18 16 9
9 Johvi Phoenix Johvi 7 11 21 4
10 Tulevik Viljandi Tulevik 8 11 22 4
TEMPORADA 2022/2023
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Tartu Welco Tartu Welco 36 92 42 74
2 Tallinna Kalev II Tallinna 36 99 53 67
3 Trans II Trans II 36 69 48 64
4 Tartu Kalev Tartu Kalev 36 85 71 61
5 Kuressaare II Kuressaare 36 87 76 61
6 Tulevik Viljandi Tulevik 36 58 55 55
7 Tammeka II Tammeka II 36 63 70 44
8 Nõmme Kalju II Nõmme Kalju 36 90 103 41
9 Läänemaa Haapsalu Läänemaa 36 67 120 26
10 Pärnu Jalgpalliklubi Pärnu 36 34 106 14
TEMPORADA 2021/2022
SEGUNDA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Harju JK Laagri Harju Laagri 36 97 46 76
2 Levadia Tallinn II Levadia 36 85 45 68
3 FC Elva FC Elva 36 76 52 66
4 Viimsi JK Viimsi JK 36 76 40 63
5 FC Flora Tallin II Flora Tallin 36 88 52 62
6 Nõmme United Nõmme 36 79 56 60
7 Paide II Paide II 36 75 88 52
8 Alliance FC Alliance FC 36 29 105 27
9 Tulevik Viljandi Tulevik 36 28 102 23
10 Pärnu Jalgpalliklubi Pärnu 36 30 77 20
TEMPORADA 2020/2021
SEGUNDA ESTONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 3 7 5 35
2 Pärnu Jalgpalliklubi Pärnu 3 5 4 29
3 Tammeka II Tammeka II 3 4 7 27
4 Tartu Welco Tartu Welco 3 4 4 19
TEMPORADA 2019/2020
SEGUNDA ESTONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 3 6 2 41
2 Pärnu Jalgpalliklubi Pärnu 3 12 1 40
3 Vändra JK Vaprus Vändra 3 5 8 32
4 Alliance FC Alliance FC 3 0 12 3
TEMPORADA 2018/2019
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Nõmme United Nõmme 36 118 38 85
2 Vändra JK Vaprus Vändra 36 97 71 68
3 Pärnu Jalgpalliklubi Pärnu 36 82 53 62
4 Nõmme Kalju II Nõmme Kalju 36 79 50 61
5 Viimsi JK Viimsi JK 36 75 68 52
6 Keila Keila 36 67 87 46
7 Tabasalu Charma Tabasalu 36 85 80 43
8 Paide II Paide II 36 61 87 39
9 Võru Võru 36 48 101 34
10 Põhja-Tallinna JK Volta Põhja-Talli 36 54 131 29
TEMPORADA 2017/2018
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 TJK Legion TJK Legion 36 125 30 98
2 Tammeka II Tammeka II 36 108 40 72
3 Alliance FC Alliance FC 36 80 39 69
4 Pärnu Jalgpalliklubi Pärnu 36 80 51 61
5 Nõmme United Nõmme 36 99 57 60
6 Võru Võru 36 80 66 54
7 Vändra JK Vaprus Vändra 36 61 96 38
8 Paide II Paide II 36 45 94 28
9 FC Flora Tallin III Flora Tallin 36 33 138 16
10 Ajax Lasnamäe Ajax 36 35 135 16
TEMPORADA 2016/2017
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Nõmme United Nõmme 26 158 18 71
2 Pärnu Jalgpalliklubi Pärnu 26 102 28 60
3 Tabasalu Charma Tabasalu 26 77 52 48
4 Ganvix Ganvix 26 48 50 40
5 Saue JK Saue JK 26 65 54 40
6 Tulevik II Tulevik II 26 55 71 40
7 FC Flora Tallin III Flora Tallin 26 43 49 34
8 Raplamaa Raplamaa 26 48 63 34
9 Otepää Otepää 26 63 69 32
10 Kuressaare II Kuressaare 26 38 93 29
11 SK Imavere Forss Imavere 26 42 83 29
12 Torva Torva 26 41 67 28
13 Vaprus Pärnu II Vaprus 26 42 66 28
14 Viimsi JK II Viimsi 26 30 89 11

  USO DE MEMORIA  
5,475,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0993
Total Execution Time  0.1014
  CADENA URL  
/historico/Fc-Peedu
  GET DATOS  
$_GET['/historico/Fc-Peedu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0043  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 = 75178
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64770 AND type_rel = 2
0.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0028  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 = '64770' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75178 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=64770 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75178,71963,71432) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75178 AND teamId = 64770
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 64770
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 64770
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 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 = 75178 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031  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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 64770 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.0036  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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 64770 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 64770 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 64770 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 75178 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 70894 AND t.round = 36 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 `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 = 66758 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 61475 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 65707 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.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 `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 = 55083 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 60121 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.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 `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 = 48714 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 42641 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 38034 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75178 ORDER BY nameShow LIMIT 100