4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tammeka

Tammeka

Entrenador: Marti Pähn

Temporada 2011/2012
TEMPORADA 2011/2012
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Nomme Kalju Nomme Kalju 36 106 17 92
2 Levadia Levadia 36 85 22 83
3 FC Flora FC Flora 36 87 24 81
4 Narva Trans Narva Trans 36 52 44 55
5 Sillamäe Kalev Sillamäe 36 51 43 55
6 Paide Paide 36 34 52 42
7 Kuressaare Kuressaare 36 31 80 26
8 Viljandi Viljandi 36 33 88 26
9 Tallinna Kalev Tallinna 36 27 87 21
10 Tammeka Tammeka 36 30 79 20
TEMPORADA 2010/2011
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora FC Flora 36 100 24 86
2 Nomme Kalju Nomme Kalju 36 82 23 79
3 Levadia Levadia 36 78 25 76
4 Narva Trans Narva Trans 36 107 29 73
5 Sillamäe Kalev Sillamäe 36 77 59 54
6 Paide Paide 36 40 51 45
7 Tammeka Tammeka 36 57 75 39
8 Viljandi Viljandi 36 37 69 30
9 Kuressaare Kuressaare 36 28 70 23
10 Ajax Lasnamäe Ajax 36 11 192 4
TEMPORADA 2009/2010
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora FC Flora 36 104 32 91
2 Levadia Levadia 36 100 16 86
3 Narva Trans Narva Trans 36 67 31 74
4 Nomme Kalju Nomme Kalju 36 59 42 62
5 Sillamäe Kalev Sillamäe 35 79 52 59
6 Tammeka Tammeka 36 50 66 40
7 Tulevik Viljandi Tulevik 36 33 62 29
8 Paide Paide 36 30 79 26
9 Kuressaare Kuressaare 35 32 93 21
10 Lootus Lootus 36 22 103 20
TEMPORADA 2008/2009
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 121 23 97
2 Narva Trans Narva Trans 36 82 29 76
3 Sillamäe Kalev Sillamäe 36 85 40 76
4 FC Flora FC Flora 36 79 31 72
5 Nomme Kalju Nomme Kalju 35 65 47 54
6 Tulevik Viljandi Tulevik 36 55 49 51
7 Tammeka Tammeka 36 29 86 24
8 Kuressaare Kuressaare 35 21 99 24
9 Paide Paide 36 21 97 22
10 Tallinna Kalev Tallinna 36 32 89 16
TEMPORADA 2007/2008
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 105 22 93
2 FC Flora FC Flora 36 113 28 91
3 FC TVMK FC TVMK 36 91 47 66
4 Narva Trans Narva Trans 36 62 54 56
5 Nomme Kalju Nomme Kalju 36 65 64 55
6 Sillamäe Kalev Sillamäe 36 49 79 45
7 Tammeka Tammeka 36 45 76 31
8 Tulevik Viljandi Tulevik 36 31 74 31
9 Tallinna Kalev Tallinna 36 37 70 26
10 Vaprus Pärnu Vaprus 36 41 125 17
TEMPORADA 2006/2007
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 126 20 91
2 FC Flora FC Flora 36 108 30 83
3 FC TVMK FC TVMK 36 116 36 79
4 Narva Trans Narva Trans 36 89 28 78
5 Tammeka Tammeka 36 54 40 62
6 Tallinna Kalev Tallinna 36 44 77 43
7 Tulevik Viljandi Tulevik 36 43 80 37
8 Vaprus Pärnu Vaprus 36 35 96 25
9 Kuressaare Kuressaare 36 25 94 18
10 Ajax Lasnamäe Ajax 36 14 153 5
TEMPORADA 2005/2006
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 114 29 94
2 Narva Trans Narva Trans 36 106 36 83
3 FC Flora FC Flora 36 93 34 82
4 FC TVMK FC TVMK 36 83 37 72
5 Maag Tartu Maag Tartu 36 65 68 48
6 Tammeka Tammeka 36 45 57 43
7 Vaprus Pärnu Vaprus 36 49 86 34
8 Ajax Lasnamäe Ajax 36 35 104 25
9 Tulevik Viljandi Tulevik 36 29 74 20
10 Warrior Valga Warrior 36 16 110 11
TEMPORADA 2004/2005
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC TVMK FC TVMK 36 138 21 95
2 Levadia Levadia 36 97 25 89
3 Narva Trans Narva Trans 36 99 35 75
4 FC Flora FC Flora 36 81 36 69
5 Tulevik Viljandi Tulevik 36 47 48 47
6 Maag Tartu Maag Tartu 36 52 86 40
7 Tammeka Tammeka 36 50 88 29
8 Warrior Valga Warrior 36 38 78 28
9 Kuressaare Kuressaare 36 40 96 27
10 Tallinna Dünamo Tallinna 36 28 157 12
TEMPORADA 2003/2004
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Tammeka Tammeka 28 74 34 58
2 Levadia Tallinn II Levadia 28 75 37 57
3 JK Tervis Pärnu Tervis 28 70 50 56
4 Tallinna Dünamo Tallinna 28 49 67 38
5 Kuressaare Kuressaare 28 56 70 35
6 Estel Estel 28 66 66 32
7 TVMK Tallinn II TVMK Tallinn 28 46 54 27
8 Tallinna JK Tallinna JK 28 29 87 19

  USO DE MEMORIA  
5,585,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5299
Total Execution Time  0.5312
  CADENA URL  
/historico/Tammeka/2012
  GET DATOS  
$_GET['/historico/Tammeka/2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0296  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 = 1564
0.0153  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 = 22584
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4354 AND type_rel = 2
0.0162  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 = '4354' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154  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 = 22584 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 1564 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=4354 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (22586,2276) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 2276 AND teamId = 4354
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 22586 AND teamId = 4354
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 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 = 1564 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '4354' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4354' and rp.type = 4
0.0147  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 = '4354' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 events2012 e ON e.player_id = p.id AND e.league_id = 1564 WHERE rp.league_id = 1564 AND rp.teamId = 4354 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.0153  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 events2012 e ON e.player_id = p.id AND e.league_id = 1564 WHERE rp.league_id = 1564 AND rp.teamId = 4354 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2012 e ON e.player_id = p.id AND e.league_id = 1564 WHERE rp.league_id = 1564 AND rp.teamId = 4354 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 4354 AND l.year <= 2012 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0161  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 = 1564 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 1357 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 1001 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2009` 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 = 10353 AND t.round = 36 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 `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 = 10352 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 10351 AND t.round = 36 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 `tables2006` 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 = 10350 AND t.round = 36 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 `tables2005` 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 = 10349 AND t.round = 36 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 `tables2004` 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 = 14952 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC