4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tabasalu Charma
TEMPORADA 2023/2024
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Harju JK Laagri Harju Laagri 8 20 6 18
2 Tartu Welco Tartu Welco 8 17 5 16
3 FC Flora Tallin II Flora Tallin 8 15 11 15
4 Viimsi JK Viimsi JK 8 16 10 13
5 Levadia Tallinn II Levadia 8 17 12 13
6 FC Tallinn FC Tallinn 8 16 15 11
7 FC Elva FC Elva 8 9 16 9
8 Tallinna Kalev II Tallinna 8 11 20 6
9 Tabasalu Charma Tabasalu 8 8 18 5
10 Paide II Paide II 8 4 20 4
TEMPORADA 2022/2023
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Nõmme United Nõmme 36 114 29 90
2 Viimsi JK Viimsi JK 36 67 35 71
3 FC Flora Tallin II Flora Tallin 36 86 53 69
4 Levadia Tallinn II Levadia 36 57 46 57
5 Tabasalu Charma Tabasalu 36 81 70 55
6 FC Tallinn FC Tallinn 36 72 65 52
7 Paide II Paide II 36 66 82 41
8 FC Elva FC Elva 36 45 75 40
9 TJK Legion TJK Legion 36 37 97 21
10 Alliance FC Alliance FC 36 50 123 20
TEMPORADA 2021/2022
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 FC Tallinn FC Tallinn 36 117 38 81
2 Tabasalu Charma Tabasalu 36 120 50 79
3 Tallinna Kalev II Tallinna 36 88 49 66
4 Tartu Welco Tartu Welco 36 73 46 64
5 Tammeka II Tammeka II 36 70 59 56
6 TJK Legion II Legion 36 60 86 42
7 Tartu Kalev Tartu Kalev 36 54 77 41
8 Läänemaa Haapsalu Läänemaa 36 49 84 37
9 Nõmme Kalju II Nõmme Kalju 36 49 103 33
10 Raplamaa Raplamaa 36 33 121 9
TEMPORADA 2020/2021
SEGUNDA B ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Alliance FC Alliance FC 5 12 5 15
2 Harju JK Laagri Harju Laagri 5 17 7 9
3 Viimsi JK Viimsi JK 5 11 4 9
4 Tallinna Kalev II Tallinna 5 8 10 7
5 FC Tallinn FC Tallinn 5 8 19 3
6 Tabasalu Charma Tabasalu 5 2 13 1
TEMPORADA 2019/2020
SEGUNDA B ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide II Paide II 2 8 2 68
2 Tartu Welco Tartu Welco 2 8 7 62
3 Tallinna Kalev II Tallinna 2 4 13 55
4 Tabasalu Charma Tabasalu 2 5 3 51
TEMPORADA 2018/2019
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Nõmme United Nõmme 36 118 38 85
2 Vändra JK Vaprus Vändra 36 97 71 68
3 Pärnu Jalgpalliklubi Pärnu 36 82 53 62
4 Nõmme Kalju II Nõmme Kalju 36 79 50 61
5 Viimsi JK Viimsi JK 36 75 68 52
6 Keila Keila 36 67 87 46
7 Tabasalu Charma Tabasalu 36 85 80 43
8 Paide II Paide II 36 61 87 39
9 Võru Võru 36 48 101 34
10 Põhja-Tallinna JK Volta Põhja-Talli 36 54 131 29
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
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Merkuur Merkuur 26 99 51 55
2 Ajax Lasnamäe Ajax 26 55 39 51
3 Johvi FC Lokomotiv Johvi 26 67 33 50
4 Tabasalu Charma Tabasalu 26 63 48 45
5 Narva United Narva United 26 84 58 43
6 Levadia III Levadia III 26 58 51 39
7 Tallinna Dünamo Tallinna 26 50 52 38
8 Võru Võru 26 47 48 34
9 Jogeva SK Noorus 96 Jogeva 26 66 65 29
10 TJK Legion TJK Legion 26 55 62 29
11 Tartu Santos II Tartu Santos 26 57 68 26
12 JK Piraaja JK Piraaja 26 33 61 22
13 Kuusalu JK Rada Kuusalu Rada 26 32 85 20
14 Kiviõli Irbis Kiviõli 26 24 69 19
TEMPORADA 2014/2015
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Paide II Paide II 26 81 41 61
2 Tartu Welco Tartu Welco 26 64 36 56
3 Johvi FC Lokomotiv Johvi 26 69 38 54
4 Luunja Luunja 26 76 42 53
5 Visadus Visadus 26 80 55 51
6 Tabasalu Charma Tabasalu 26 57 67 37
7 Võru Võru 26 56 57 36
8 JK Piraaja JK Piraaja 26 42 53 33
9 Tallinna Dünamo Tallinna 26 42 52 30
10 Jogeva SK Noorus 96 Jogeva 26 53 75 27
11 Kuusalu JK Rada Kuusalu Rada 26 45 67 23
12 Levadia III Levadia III 26 48 61 19
13 Ajax Lasnamäe Ajax 26 42 69 18
14 TJK Legion TJK Legion 26 42 84 17
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,898,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5402
Total Execution Time  0.5415
  CADENA URL  
/historico/Tabasalu-Charma
  GET DATOS  
$_GET['/historico/Tabasalu-Charma']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0267  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 = 75170
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63110 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0132  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 = '63110' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75170 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=63110 AND l.year in (2023,2024,2025) 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 (75170,71963,71432) 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 = 75170 AND teamId = 63110
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 63110
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 63110
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 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 = 75170 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '63110' 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 = '63110' and rp.type = 4
0.0128  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 = '63110' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 63110 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.0135  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 63110 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 63110 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 63110 AND l.year <= 2024 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 `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 = 75170 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 70893 AND t.round = 36 ORDER BY team.conference ASC,t.position 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 `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 = 66759 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 61476 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 65677 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 55084 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 60008 AND t.round = 2 ORDER BY team.conference ASC,t.position 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 `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 = 48714 AND t.round = 36 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.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 `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.0135  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 = 22219 AND t.round = 26 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 `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 = 11805 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 `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.0126  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.0125  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 = 75170 ORDER BY nameShow LIMIT 100