4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tulevik II
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
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
TERCERA ESTONIA GRUPO 2
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
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 1
Equipo PJ GF GC Puntos
1 Tartu FC Santos Tartu Santos 26 138 16 73
2 Ganvix Ganvix 26 57 60 48
3 Sörve Sörve 26 64 46 47
4 Nõmme United Nõmme 26 90 60 46
5 Jogeva SK Noorus 96 Jogeva 26 63 61 46
6 Rummu Dünamo Rummu 26 66 56 40
7 Keila Keila 26 67 48 39
8 Luunja Luunja 26 61 61 39
9 Tartu SK 10 Premium II Tartu 26 53 75 35
10 Tulevik II Tulevik II 26 62 74 28
11 Tartu Welco Tartu Welco 26 39 59 26
12 FC Metropool Metropool 26 41 88 25
13 Tarvastu Tarvastu 26 45 95 19
14 Kärdla LM Kärdla LM 26 35 82 15
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 2008/2009
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 96 21 86
2 Lootus Lootus 36 88 48 74
3 Warrior Valga Warrior 36 68 63 65
4 Ajax Lasnamäe Ajax 36 75 53 64
5 Kiviõli Irbis Kiviõli 36 77 77 53
6 TJK Legion TJK Legion 36 63 76 44
7 Vaprus Pärnu Vaprus 36 64 77 39
8 Tulevik II Tulevik II 36 49 79 36
9 FC Flora Tallin II Flora Tallin 36 35 64 32
10 Rakvere JK Tarvas Rakvere 36 48 105 26
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
TEMPORADA 2005/2006
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 132 24 88
2 Kuressaare Kuressaare 36 64 44 71
3 Tallinna Kalev Tallinna 36 84 63 66
4 FC Flora Tallin II Flora Tallin 36 81 56 60
5 Nomme Kalju Nomme Kalju 36 76 80 59
6 TVMK Tallinn II TVMK Tallinn 36 66 63 56
7 Tulevik II Tulevik II 36 53 52 38
8 Lootus Lootus 36 46 99 33
9 Tallinna Dünamo Tallinna 36 44 85 27
10 FC Elva FC Elva 36 20 100 15

  USO DE MEMORIA  
5,921,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5844
Total Execution Time  0.5864
  CADENA URL  
/historico/Tulevik-Ii/2019
  GET DATOS  
$_GET['/historico/Tulevik-Ii/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0143  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 = 'Tulevik-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.0125  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=61380 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61380 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=61380 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 49207
0.0135  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 = 43676
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61380 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0131  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 = '61380' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '61380' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = '61380' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0140  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 = 43676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 49207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=61380 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (55514,43676) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 55514 AND teamId = 61380
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 43676 AND teamId = 61380
0.0128  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 = '61380' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61380' and rp.type = 4
0.0126  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 = '61380' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 61380 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.0127  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 = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 61380 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 49207 WHERE rp.league_id = 49207 AND rp.teamId = 61380 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 61380 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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.0128  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.0132  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
0.0141  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.0130  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.0128  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.0129  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 = 27884 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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.0130  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 = 14946 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 `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.0131  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 = 14950 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC