4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tallinna Kalev II
TEMPORADA 2018/2019
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 TJK Legion TJK Legion 36 129 35 94
2 FC Flora Tallin II Flora Tallin 36 85 37 73
3 Vaprus Pärnu Vaprus 36 73 48 67
4 Tammeka II Tammeka II 36 59 55 58
5 FC Elva FC Elva 36 67 63 56
6 Levadia Tallinn II Levadia 36 80 65 53
7 Alliance FC Alliance FC 36 51 82 40
8 Rakvere JK Tarvas Rakvere 36 35 98 28
9 Tallinna Kalev II Tallinna 36 38 84 25
10 Tartu Welco Tartu Welco 36 39 89 24
TEMPORADA 2017/2018
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 36 126 38 88
2 FC Flora Tallin II Flora Tallin 36 115 31 71
3 Levadia Tallinn II Levadia 36 67 56 61
4 FC Elva FC Elva 36 51 64 55
5 Rakvere JK Tarvas Rakvere 36 59 60 52
6 Tartu Welco Tartu Welco 36 44 78 42
7 Tartu FC Santos Tartu Santos 36 47 68 41
8 Tallinna Kalev II Tallinna 36 37 52 39
9 Keila Keila 36 41 88 35
10 Nõmme Kalju II Nõmme Kalju 36 37 89 21
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 2014/2015
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 36 92 38 81
2 Alliance FC Alliance FC 36 65 29 70
3 Sillamäe Kalev II Sillamäe 36 73 57 63
4 Joker Joker 36 66 57 53
5 FC Elva FC Elva 36 62 45 52
6 Tallinna Kalev II Tallinna 36 60 55 50
7 Emmaste Emmaste 36 56 64 46
8 FC Puuma FC Puuma 36 60 89 45
9 Ararat Ararat 36 51 113 26
10 FC Flora Tallin III Flora Tallin 36 43 81 18
TEMPORADA 2013/2014
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tallinna Ülikool Tallinna 24 117 43 59
2 Tallinna Kalev II Tallinna 24 77 27 57
3 Viimsi JK Viimsi JK 24 60 46 37
4 Saue JK Saue JK 24 52 42 36
5 FC Metropool Metropool 24 62 57 35
6 Keila Keila 24 45 57 33
7 Tulevik II Tulevik II 24 43 49 30
8 Nõmme United Nõmme 24 69 75 28
9 Rummu Dünamo Rummu 24 49 66 28
10 Tondi Tondi 24 44 73 28
11 Sörve Sörve 24 38 55 25
12 Läänemaa Haapsalu Läänemaa 24 36 65 25
13 MC Tallin MC Tallin 24 35 72 21
14 Tarvastu Tarvastu 0 0 0 0
TEMPORADA 2012/2013
TERCERA ESTONIA GRUPO 2
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
TEMPORADA 2011/2012
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Johvi FC Lokomotiv Johvi 26 79 16 66
2 Nõmme Kalju II Nõmme Kalju 26 64 34 53
3 Sillamäe Kalev II Sillamäe 26 82 26 51
4 TJK Legion TJK Legion 26 63 38 49
5 Ararat Ararat 26 58 46 43
6 Tallinna Dünamo Tallinna 26 58 46 41
7 JK Alko Kohtla-Järve Alko 26 65 74 33
8 Ajax Lasnamäe Ajax 26 42 42 32
9 Maardu FC Maardu FC 26 62 61 31
10 Tallinna Kalev II Tallinna 26 45 49 31
11 Kaitseliit Kalev Kaitseliit 26 56 61 29
12 Tallinna Infonet II Tallinna 26 26 59 21
13 MC Tallin MC Tallin 26 48 115 20
14 FC Velldoris Velldoris 26 29 110 9
TEMPORADA 2010/2011
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Rakvere JK Tarvas Rakvere 26 100 29 66
2 Nõmme Kalju II Nõmme Kalju 26 94 19 61
3 Sillamäe Kalev II Sillamäe 26 102 37 54
4 JK Alko Kohtla-Järve Alko 26 41 40 42
5 Johvi FC Lokomotiv Johvi 26 48 37 37
6 Tallinna Infonet II Tallinna 26 57 59 36
7 Tallinna Kalev II Tallinna 26 59 48 35
8 Tallinna Dünamo Tallinna 26 49 64 34
9 MC Tallin MC Tallin 26 51 74 34
10 Kaitseliit Kalev Kaitseliit 26 47 57 29
11 TJK Legion II Legion 26 36 58 29
12 Tabasalu Charma Tabasalu 26 28 48 27
13 Olympic Tallinn Olympic 26 32 108 13
14 Ajax Lasnamäe II Ajax 26 33 99 11
TEMPORADA 2009/2010
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
5,606,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1130
Total Execution Time  0.1143
  CADENA URL  
/historico/Tallinna-Kalev-Ii/2019
  GET DATOS  
$_GET['/historico/Tallinna-Kalev-Ii/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0044  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 = 'Tallinna-Kalev-Ii' AND l.year = 2019 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.0019  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=61368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 48713
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61368 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0029  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 = '61368' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '61368' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '61368' 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 = 48713 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=61368 AND l.year in (2018,2019,2020) 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 (60008,48713,43475) 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 = 48713 AND teamId = 61368
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 60008 AND teamId = 61368
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 61368
0.0020  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 = '61368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61368' and rp.type = 4
0.0020  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 = '61368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0069  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 61368 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.0033  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 61368 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 61368 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 61368 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 48713 AND t.round = 36 ORDER BY team.conference 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 `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 = 42546 AND t.round = 36 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 `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.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 `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.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 `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 = 9472 AND t.round = 36 ORDER BY team.conference 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 `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 = 9435 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 `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.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 `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 = 27899 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 27909 AND t.round = 26 ORDER BY team.conference 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 `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.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 = 48713 ORDER BY nameShow LIMIT 100