4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Raplamaa
TEMPORADA 2023/2024
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Saku Sporting Saku 1 4 0 3
2 Vaprus Pärnu II Vaprus 1 5 2 3
3 Keila Keila 1 4 1 3
4 Vändra JK Vaprus Vändra 1 4 3 3
5 Nõmme United II Nõmme 2 3 2 3
6 JK Tabasalu II Tabasalu 1 2 1 3
7 Saue JK Laagri Saue Laagri 1 2 1 3
8 Hiiumaa Hiiumaa 2 3 3 3
9 Paide III Paide III 1 2 2 1
10 Tallinna Zapoos Tallinna 1 2 2 1
11 Raplamaa Raplamaa 1 1 2 0
12 Harju JK Laagri II Harju Laagri 2 3 6 0
13 Tabasalu Ulasabat Tabasalu 1 1 4 0
14 FC Flora Tallin III Flora Tallin 2 2 9 0
TEMPORADA 2022/2023
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Harju JK Laagri II Harju Laagri 26 107 36 67
2 Vaprus Pärnu II Vaprus 26 79 41 60
3 FC Flora Tallin III Flora Tallin 26 83 38 58
4 Hiiumaa Hiiumaa 26 50 55 42
5 Saku Sporting Saku 26 67 64 39
6 Nõmme United II Nõmme 26 53 38 37
7 JK Tervis Pärnu Tervis 26 88 80 36
8 Saue JK Laagri Saue Laagri 26 56 61 35
9 Vändra JK Vaprus Vändra 26 52 59 35
10 JK Tabasalu II Tabasalu 26 57 45 32
11 Raplamaa Raplamaa 26 56 72 30
12 Keila Keila 26 44 69 25
13 Kose Kose 26 46 100 16
14 Poseidon JK Poseidon JK 26 26 106 10
TEMPORADA 2021/2022
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 FC Tallinn FC Tallinn 36 117 38 81
2 Tabasalu Charma Tabasalu 36 120 50 79
3 Tallinna Kalev II Tallinna 36 88 49 66
4 Tartu Welco Tartu Welco 36 73 46 64
5 Tammeka II Tammeka II 36 70 59 56
6 TJK Legion II Legion 36 60 86 42
7 Tartu Kalev Tartu Kalev 36 54 77 41
8 Läänemaa Haapsalu Läänemaa 36 49 84 37
9 Nõmme Kalju II Nõmme Kalju 36 49 103 33
10 Raplamaa Raplamaa 36 33 121 9
TEMPORADA 2020/2021
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide III Paide III 23 61 23 57
2 Raplamaa Raplamaa 22 59 32 46
3 Kuressaare II Kuressaare 20 81 17 45
4 Vaprus Pärnu II Vaprus 22 65 36 42
5 FC Flora Tallin III Flora Tallin 23 75 51 42
6 Hiiumaa Hiiumaa 23 50 42 38
7 Viimsi JK II Viimsi 23 49 38 32
8 Saue JK Laagri Saue Laagri 23 58 57 29
9 Tulevik II Tulevik II 23 56 59 29
10 Joker Joker 23 45 53 29
11 JK Piraaja JK Piraaja 23 40 68 21
12 Keila Keila 23 44 74 18
13 Rummu Dünamo Rummu 23 42 108 14
14 Kose Kose 22 22 89 10
TEMPORADA 2019/2020
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide III Paide III 26 108 11 76
2 Harju JK Laagri Harju Laagri 26 105 41 59
3 Joker Joker 26 77 37 57
4 Saue JK Laagri Saue Laagri 26 72 39 55
5 Kuressaare II Kuressaare 26 91 44 49
6 Viimsi JK II Viimsi 26 63 50 41
7 Raplamaa Raplamaa 26 71 48 37
8 JK Piraaja JK Piraaja 26 50 70 34
9 FC Flora Tallin III Flora Tallin 26 49 61 31
10 Tulevik II Tulevik II 26 42 56 27
11 Vaprus Pärnu II Vaprus 26 48 77 26
12 Pohja Sakala Pohja Sakala 26 40 103 20
13 Kose Kose 26 36 97 9
14 Poseidon JK Poseidon JK 26 20 138 6
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
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,851,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0911
Total Execution Time  0.0924
  CADENA URL  
/historico/Raplamaa-Jk
  GET DATOS  
$_GET['/historico/Raplamaa-Jk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0042  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 = 75486
0.0026  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 = 75678
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88945 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0023  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 = '88945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 75678 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 75486 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=88945 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75678,75486,71963) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75486 AND teamId = 88945
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 88945
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75678 AND teamId = 88945
0.0019  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 = 75486 WHERE rp.league_id = 75486 AND rp.teamId = 88945 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.0019  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 = 75486 WHERE rp.league_id = 75486 AND rp.teamId = 88945 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75486 WHERE rp.league_id = 75486 AND rp.teamId = 88945 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 88945 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0057  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 = 75486 AND t.round = 6 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 `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 = 71376 AND t.round = 26 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 `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 = 66759 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 `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 = 62690 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 55514 AND t.round = 26 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 `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.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 `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
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 `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