4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 TJK Legion TJK Legion 26 119 40 60
2 Levadia III Levadia III 26 97 50 52
3 Jogeva SK Noorus 96 Jogeva 26 71 53 50
4 Merkuur Merkuur 26 84 68 50
5 Võru Võru 26 55 30 45
6 Ajax Lasnamäe Ajax 26 68 67 45
7 Tallinna Dünamo Tallinna 26 57 36 41
8 Narva United Narva United 26 57 74 39
9 JK Piraaja JK Piraaja 26 43 51 34
10 Maardu II Maardu II 26 72 72 32
11 Tartu Santos II Tartu Santos 26 64 84 24
12 Maardu United Maardu 26 39 77 23
13 Ararat Ararat 26 36 74 17
14 JK Järve II Järve 26 13 99 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Paide II Paide II 26 92 24 67
2 Keila Keila 26 93 32 63
3 Nõmme United Nõmme 26 131 38 60
4 Pärnu Linnameeskond Pärnu 26 98 45 57
5 Saue JK Saue JK 26 85 47 52
6 Viimsi JK II Viimsi 26 60 51 39
7 Torva Torva 26 63 52 37
8 SK Imavere Forss Imavere 26 70 77 31
9 Ganvix Ganvix 26 47 59 29
10 Kuressaare II Kuressaare 26 55 69 26
11 FC Forza FC Forza 26 52 93 25
12 Ararat Ararat 26 41 101 19
13 Kose Kose 26 20 92 10
14 Rummu Dünamo Rummu 26 27 154 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Tallinna Ülikool Tallinna 26 130 61 63
2 Tulevik II Tulevik II 26 78 40 52
3 Ganvix Ganvix 26 72 37 51
4 Nõmme United Nõmme 26 93 41 50
5 Keila Keila 26 61 45 45
6 Viimsi JK Viimsi JK 26 62 45 39
7 SK Imavere Forss Imavere 26 59 68 37
8 Torva Torva 26 60 47 35
9 Saue JK Saue JK 26 51 57 34
10 Tondi Tondi 26 52 93 28
11 Kuressaare II Kuressaare 26 43 66 26
12 Kose Kose 26 48 75 26
13 Rummu Dünamo Rummu 26 24 93 17
14 FC Metropool Metropool 26 30 95 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Paide II Paide II 26 81 28 62
2 Joker Joker 26 76 31 55
3 Tartu Welco Tartu Welco 26 49 31 51
4 Luunja Luunja 26 70 42 44
5 Tallinna Dünamo Tallinna 26 51 45 40
6 Ganvix Ganvix 26 78 67 38
7 Võru Võru 26 49 46 37
8 Ajax Lasnamäe Ajax 26 62 52 35
9 Jogeva SK Noorus 96 Jogeva 26 68 65 33
10 TJK Legion II Legion 26 49 78 32
11 Levadia III Levadia III 26 63 51 31
12 Visadus Visadus 26 43 65 29
13 Kaitseliit Kalev Kaitseliit 26 57 76 23
14 JK Loo JK Loo 26 28 147 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 24 80 29 59
2 Tallinna Infonet II Tallinna 24 80 15 56
3 Tallinna Ülikool Tallinna 24 92 29 54
4 Tallinna Kalev II Tallinna 24 65 35 43
5 Saue JK Saue JK 24 50 35 42
6 Ajax Lasnamäe Ajax 24 69 46 37
7 TJK Legion II Legion 24 43 62 27
8 MC Tallin MC Tallin 24 51 78 26
9 Kaitseliit Kalev Kaitseliit 24 38 76 24
10 Joker Joker 24 31 64 22
11 JK Loo JK Loo 24 33 80 19
12 JK Järve II Järve 24 30 69 17
13 Koeru SK Koeru SK 24 37 81 16
14 Keskerakonna JK Keskerakonna 0 0 0 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Emmaste Emmaste 26 114 34 60
2 Tulevik Viljandi Tulevik 26 100 32 56
3 Vändra JK Vaprus Vändra 26 68 39 51
4 FC Elva FC Elva 26 65 29 50
5 Tartu SK 10 Premium II Tartu 26 96 50 46
6 Paide Kumake Paide Kumake 26 83 46 45
7 Pärnu II Pärnu II 26 78 75 38
8 FC Flora Tallin III Flora Tallin 26 76 77 37
9 Tarvastu Tarvastu 26 69 70 37
10 Keila Keila 26 51 63 36
11 Ganvix Ganvix 26 52 122 21
12 Sörve Sörve 26 32 72 20
13 Luunja Luunja 26 39 126 15
14 Nõmme United Nõmme 26 25 113 12
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Tartu SK 10 Tartu SK 10 26 77 23 60
2 Tammeka II Tammeka II 26 71 29 60
3 Tulevik Viljandi Tulevik 26 85 42 52
4 Paide Kumake Paide Kumake 26 64 28 52
5 Sörve Sörve 26 46 35 51
6 Luunja Luunja 26 65 52 48
7 Nõmme United Nõmme 26 55 56 39
8 Emmaste Emmaste 26 54 46 30
9 Tartu SK 10 Premium II Tartu 26 46 74 29
10 Ganvix Ganvix 26 45 86 29
11 Tarvastu Tarvastu 26 32 67 21
12 Viljandi Kotkad Viljandi 26 11 28 20
13 Pärnu II Pärnu II 26 41 73 16
14 Rummu Dünamo Rummu 26 31 84 10
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
5,727,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5035
Total Execution Time  0.5055
  CADENA URL  
/tercera_estonia2019/grupo2/historico
  GET DATOS  
$_GET['/tercera_estonia2019/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0145  SELECT type FROM routes WHERE alias = 'tercera_estonia2019'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_estonia' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0147  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1606 ORDER BY order_id ASC
0.0150  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 = 49207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1606 AND group_code = 2 and tables = 1 AND year <= 2019 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0155  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.0154  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.0151  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 = 38036 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2016` 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 = 22220 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2015` 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 = 11806 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 `tables2014` 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 = 9436 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27892 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 `tables2012` 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 = 27900 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2011` 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 = 27913 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 `tables2010` 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 = 27933 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 12:35:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 12:35:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 12:35:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 12:35:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_estonia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0158  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49207 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.0155  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49207 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 events2019 e ON e.player_id = p.id AND e.league_id = 49207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49207 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0197  SELECT *,(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