4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tammeka II
TEMPORADA 2016/2017
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Nõmme Kalju II Nõmme Kalju 36 73 43 69
2 Tallinna Kalev II Tallinna 36 71 40 64
3 Vändra JK Vaprus Vändra 36 75 67 62
4 Keila Keila 36 74 56 60
5 Alliance FC Alliance FC 36 55 48 51
6 Tammeka II Tammeka II 36 69 63 49
7 Joker Joker 36 58 73 46
8 Viimsi JK Viimsi JK 36 55 64 44
9 Paide II Paide II 36 50 79 34
10 Sillamäe Kalev II Sillamäe 36 38 85 28
TEMPORADA 2015/2016
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Kuressaare Kuressaare 36 117 48 74
2 FC Elva FC Elva 36 67 39 68
3 Tartu Welco Tartu Welco 36 74 50 64
4 Tammeka II Tammeka II 36 89 64 59
5 Tallinna Kalev II Tallinna 36 72 53 55
6 Sillamäe Kalev II Sillamäe 36 70 61 54
7 Joker Joker 36 74 66 52
8 Viimsi JK Viimsi JK 36 56 64 51
9 FC Flora Tallin III Flora Tallin 36 27 85 20
10 Tulevik II Tulevik II 36 26 142 12
TEMPORADA 2012/2013
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 94 41 70
2 Johvi FC Lokomotiv Johvi 36 80 39 69
3 FC Flora Tallin II Flora Tallin 36 56 54 57
4 Rakvere JK Tarvas Rakvere 36 68 58 56
5 Tartu SK 10 Tartu SK 10 36 58 67 54
6 Tammeka II Tammeka II 36 70 57 52
7 Vändra JK Vaprus Vändra 36 61 55 46
8 Tulevik Viljandi Tulevik 36 49 57 46
9 FC Puuma FC Puuma 36 40 91 29
10 Kiviõli Irbis Kiviõli 36 60 117 25
TEMPORADA 2011/2012
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 FCI Tallinn FCI Tallinn 36 94 33 83
2 FC Flora Tallin II Flora Tallin 36 66 32 69
3 Rakvere JK Tarvas Rakvere 36 66 58 68
4 Tartu SK 10 Tartu SK 10 36 65 58 54
5 Levadia Tallinn II Levadia 36 77 56 53
6 Kiviõli Irbis Kiviõli 36 78 83 44
7 FC Puuma FC Puuma 36 55 61 43
8 Tammeka II Tammeka II 36 55 83 37
9 Vaprus Pärnu Vaprus 36 43 72 36
10 Lootus Lootus 36 40 103 19
TEMPORADA 2010/2011
TERCERA ESTONIA GRUPO 2
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
TEMPORADA 2009/2010
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tartu FC Santos Tartu Santos 26 85 18 63
2 Emmaste Emmaste 26 61 31 52
3 Nõmme United Nõmme 26 67 52 47
4 Pärnu II Pärnu II 26 66 53 45
5 Tarvastu Tarvastu 26 54 55 42
6 Tartu SK 10 Premium II Tartu 26 72 51 40
7 Tammeka II Tammeka II 26 63 43 39
8 Tulevik II Tulevik II 26 52 63 35
9 Ganvix Ganvix 26 66 61 31
10 Rummu Dünamo Rummu 26 45 64 31
11 Vaprus Pärnu II Vaprus 26 40 49 30
12 Sörve Sörve 26 41 50 29
13 Võru Võru 26 40 89 23
14 FC Elva FC Elva 26 13 86 9
TEMPORADA 2007/2008
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 83 33 72
2 Kuressaare Kuressaare 36 67 35 69
3 FC Flora Tallin II Flora Tallin 36 62 41 62
4 Paide Paide 36 58 44 54
5 Warrior Valga Warrior 36 46 54 51
6 Kiviõli Irbis Kiviõli 36 51 66 44
7 Tammeka II Tammeka II 36 60 63 43
8 Rakvere JK Tarvas Rakvere 36 53 82 37
9 TVMK Tallinn II TVMK Tallinn 36 58 98 36
10 Ajax Lasnamäe Ajax 36 57 79 30
TEMPORADA 2006/2007
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 95 20 86
2 FC Flora Tallin II Flora Tallin 36 97 33 78
3 Sillamäe Kalev Sillamäe 36 67 40 69
4 TVMK Tallinn II TVMK Tallinn 36 81 68 53
5 Tammeka II Tammeka II 36 51 39 53
6 Nomme Kalju Nomme Kalju 36 74 69 51
7 Warrior Valga Warrior 36 72 73 44
8 Tulevik II Tulevik II 36 37 84 34
9 Valk 494 Tartu Valk Tartu 36 49 93 29
10 FC Elva FC Elva 36 17 121 8

  USO DE MEMORIA  
5,390,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1457
Total Execution Time  0.1470
  CADENA URL  
/historico/Tammeka-Ii/2017
  GET DATOS  
$_GET['/historico/Tammeka-Ii/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0030  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Tammeka-Ii' AND l.year = 2017 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13371 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13371 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 37789
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13371 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0050  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '13371' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '13371' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '13371' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 37789 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=13371 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (42641,38654) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 42641 AND teamId = 13371
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 38654 AND teamId = 13371
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 37789 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031  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 = '13371' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13371' and rp.type = 4
0.0031  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 = '13371' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0089  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 events2017 e ON e.player_id = p.id AND e.league_id = 37789 WHERE rp.league_id = 37789 AND rp.teamId = 13371 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.0099  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 events2017 e ON e.player_id = p.id AND e.league_id = 37789 WHERE rp.league_id = 37789 AND rp.teamId = 13371 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0063  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 events2017 e ON e.player_id = p.id AND e.league_id = 37789 WHERE rp.league_id = 37789 AND rp.teamId = 13371 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 13371 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 = 37789 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 20883 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 14942 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 14943 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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.0035  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 = 27928 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2008` 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 = 14947 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2007` 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 = 14948 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 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 = 37789 ORDER BY nameShow LIMIT 100