4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Helios Voru
TEMPORADA 2023/2024
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ajax Lasnamäe Ajax 0 0 0 0
2 Ararat Ararat 0 0 0 0
3 FC Elva II FC Elva II 0 0 0 0
4 FC Helios Tartu Helios Tartu 0 0 0 0
5 FC Helios Voru Helios Voru 0 0 0 0
6 FC Puuma FC Puuma 0 0 0 0
7 FC Tallinn II Tallinn 0 0 0 0
8 FCI Tallinn FCI Tallinn 0 0 0 0
9 Maardu FC Maardu FC 0 0 0 0
10 NPM Silmet NPM Silmet 0 0 0 0
11 Rakvere JK Tarvas Rakvere 0 0 0 0
12 Tartu Kalev II Tartu Kalev 0 0 0 0
13 Tartu Welco II Tartu Welco 0 0 0 0
14 Viimsi JK II Viimsi 0 0 0 0
TEMPORADA 2022/2023
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 26 125 23 69
2 Rakvere JK Tarvas Rakvere 26 97 24 58
3 Johvi Phoenix Johvi 26 97 22 54
4 FCI Tallinn FCI Tallinn 26 75 29 51
5 Viimsi JK II Viimsi 26 75 24 49
6 Tartu Welco II Tartu Welco 26 79 43 48
7 FC Tallinn II Tallinn 26 74 38 43
8 Tartu Kalev II Tartu Kalev 26 54 57 33
9 FC Helios Tartu Helios Tartu 26 67 76 29
10 FC Helios Voru Helios Voru 26 66 77 28
11 Ajax Lasnamäe Ajax 26 49 77 24
12 Ararat Ararat 26 44 86 22
13 K-Järve JK Järve III K-Järve 26 21 108 5
14 Warrior Valga Warrior 26 10 249 4
TEMPORADA 2021/2022
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 FCI Tallinn FCI Tallinn 26 61 16 63
2 Rakvere JK Tarvas Rakvere 26 60 20 58
3 Maardu II Maardu II 26 92 51 49
4 Trans II Trans II 25 65 32 48
5 Tartu Welco II Tartu Welco 26 60 46 43
6 Jogeva SK Noorus 96 Jogeva 25 52 50 41
7 FC Helios Voru Helios Voru 26 53 49 37
8 Viimsi JK II Viimsi 26 43 43 34
9 Johvi Phoenix Johvi 26 38 58 31
10 FC Tallinn II Tallinn 26 47 62 30
11 Sillamäe Kalev Sillamäe 26 51 67 24
12 FC Elva II FC Elva II 26 47 73 23
13 FC Helios Tartu Helios Tartu 26 41 82 21
14 JK Järve II Järve 26 34 95 18
TEMPORADA 2020/2021
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tartu Kalev Tartu Kalev 23 70 30 55
2 Trans II Trans II 22 69 24 49
3 FCI Tallinn FCI Tallinn 23 74 26 49
4 Sillamäe Kalev Sillamäe 21 74 32 49
5 FC Helios Voru Helios Voru 23 82 44 41
6 Maardu II Maardu II 23 55 40 39
7 FC Elva II FC Elva II 22 51 33 30
8 Jogeva SK Noorus 96 Jogeva 22 50 58 30
9 Rakvere JK Tarvas Rakvere 22 38 42 27
10 Tartu Welco II Tartu Welco 23 49 63 25
11 FC Helios Tartu Helios Tartu 21 39 51 20
12 Ajax Lasnamäe Ajax 22 29 79 14
13 JK Järve II Järve 21 24 101 14
14 Põhja-Tallinna JK Volta Põhja-Talli 20 16 97 10
TEMPORADA 2019/2020
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Tallinn FC Tallinn 26 82 29 58
2 TJK Legion II Legion 26 104 61 58
3 FCI Tallinn FCI Tallinn 26 86 25 57
4 Trans II Trans II 26 81 46 53
5 Tartu Welco II Tartu Welco 26 49 49 43
6 Sillamäe Kalev Sillamäe 26 63 43 42
7 Põhja-Tallinna JK Volta Põhja-Talli 26 29 41 33
8 JK Järve II Järve 26 54 56 32
9 Jogeva SK Noorus 96 Jogeva 26 49 65 32
10 Maardu II Maardu II 26 52 71 30
11 FC Helios Voru Helios Voru 26 63 63 28
12 Ajax Lasnamäe Ajax 26 50 76 24
13 Tammeka III Tammeka III 26 45 71 21
14 Jõgeva Wolves Jõgeva 26 22 133 13

  USO DE MEMORIA  
5,310,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0842
Total Execution Time  0.0854
  CADENA URL  
/historico/Fc-Helios-Tartu
  GET DATOS  
$_GET['/historico/Fc-Helios-Tartu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0032  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 = 'Fc-Helios-Tartu' AND l.year = 2024 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=116758 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=116758 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=116758 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 = 75487
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=116758 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0023  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 = '116758' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '116758' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 75487 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=116758 AND l.year in (2023,2024,2025) 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 (75678,75487,67740) 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 = 75487 AND teamId = 116758
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67740 AND teamId = 116758
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75678 AND teamId = 116758
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 FROM `tables2024` 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 = 75487 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75487 WHERE rp.league_id = 75487 AND rp.teamId = 116758 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75487 WHERE rp.league_id = 75487 AND rp.teamId = 116758 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75487 WHERE rp.league_id = 75487 AND rp.teamId = 116758 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 116758 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 75487 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2023` 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 = 71377 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 67073 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 62689 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 55928 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC