4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ASC Kara
TEMPORADA 2023/2024
LIGA TOGO
Equipo PJ GF GC Puntos
1 ASKO de Kara ASKO Kara 20 24 8 46
2 ASC Kara ASC Kara 20 25 9 40
3 Gomido Gomido 20 22 13 35
4 OTR OTR 20 26 16 32
5 Gbohloé su des Lacs Gbohloé 20 16 13 32
6 Togo-Port Togo-Port 20 18 17 31
7 Tambo FC Tambo FC 20 20 16 29
8 Entente II Entente II 20 17 19 28
9 Unisport de Sokode Unisport 20 22 17 27
10 Espoir FC Espoir FC 20 17 17 25
11 Doumbé de Mango Doumbé 20 20 25 24
12 Kakadl Kakadl 20 15 23 24
13 AS Binah AS Binah 20 9 17 17
14 AC Sèmassi AC Sèmassi 20 10 21 17
15 Gbikinti de Bassa Gbikinti 20 13 25 17
16 Dynamic Togolais Dynamic 20 11 29 10
TEMPORADA 2022/2023
LIGA TOGO
Equipo PJ GF GC Puntos
1 ASKO de Kara ASKO Kara 30 44 14 68
2 ASC Kara ASC Kara 30 44 18 62
3 Dynamic Togolais Dynamic 30 30 16 50
4 Gbohloé su des Lacs Gbohloé 30 34 27 46
5 OTR OTR 30 30 25 43
6 AC Sèmassi AC Sèmassi 30 26 22 41
7 AS Binah AS Binah 30 21 17 39
8 Tambo FC Tambo FC 30 35 37 38
9 Espoir FC Espoir FC 30 28 30 37
10 Unisport de Sokode Unisport 30 26 35 36
11 Gomido Gomido 30 22 29 33
12 Togo-Port Togo-Port 30 21 29 31
13 Entente II Entente II 30 27 39 31
14 Kakadl Kakadl 30 17 31 31
15 Anges de Notsé Anges Notsé 30 25 41 25
16 Sara Sport Sara Sport 30 20 40 23
TEMPORADA 2021/2022
LIGA TOGO GRUPO 2
Equipo PJ GF GC Puntos
1 ASKO de Kara ASKO Kara 10 16 4 22
2 ASC Kara ASC Kara 10 17 9 18
3 Dynamic Togolais Dynamic 10 8 10 13
4 Gomido Gomido 10 8 13 11
5 AS Binah AS Binah 10 8 14 9
6 Togo-Port Togo-Port 10 7 14 8
TEMPORADA 2020/2021
LIGA TOGO
Equipo PJ GF GC Puntos
1 ASC Kara ASC Kara 14 42 12 33
2 ASKO de Kara ASKO Kara 14 24 11 29
3 Unisport de Sokode Unisport 14 20 21 19
4 AS Binah AS Binah 14 9 16 18
5 Ifodjè Ifodjè 14 17 26 16
6 AC Sèmassi AC Sèmassi 14 18 22 15
7 Sara Sport Sara Sport 14 16 23 14
8 US Koroki US Koroki 14 14 29 11
9 Togo-Port Togo-Port 14 16 9 28
10 OTR OTR 14 15 10 23
11 Dynamic Togolais Dynamic 14 19 14 22
12 Entente II Entente II 14 12 7 22
13 Gomido Gomido 14 15 13 20
14 Gbohloé su des Lacs Gbohloé 14 13 12 16
15 Anges de Notsé Anges Notsé 14 10 21 11
16 Maranatha Maranatha 14 9 23 9
TEMPORADA 2019/2020
LIGA TOGO
Equipo PJ GF GC Puntos
1 ASKO de Kara ASKO Kara 20 20 10 40
2 Unisport de Sokode Unisport 20 19 16 34
3 OTR OTR 20 15 12 29
4 Dynamic Togolais Dynamic 20 21 17 29
5 Gbohloé su des Lacs Gbohloé 20 18 16 28
6 ASC Kara ASC Kara 20 21 17 27
7 Sara Sport Sara Sport 20 16 16 27
8 Togo-Port Togo-Port 20 21 18 27
9 Gomido Gomido 20 12 13 26
10 AC Sèmassi AC Sèmassi 20 19 14 25
11 Anges de Notsé Anges Notsé 20 12 16 23
12 US Koroki US Koroki 20 12 21 21
13 Ifodjè Ifodjè 20 12 17 21
14 Maranatha Maranatha 20 9 24 16
TEMPORADA 2018/2019
LIGA TOGO
Equipo PJ GF GC Puntos
1 ASC Kara ASC Kara 26 30 18 45
2 Maranatha Maranatha 26 23 25 40
3 Dynamic Togolais Dynamic 26 23 18 39
4 Anges de Notsé Anges Notsé 26 23 23 39
5 Gomido Gomido 26 21 15 38
6 Sara Sport Sara Sport 26 20 21 36
7 US Koroki US Koroki 26 23 23 35
8 OTR OTR 26 27 28 35
9 Togo-Port Togo-Port 26 31 31 34
10 ASKO de Kara ASKO Kara 26 26 26 34
11 AC Sèmassi AC Sèmassi 26 26 28 33
12 Gbohloé su des Lacs Gbohloé 26 17 18 32
13 Gbikinti de Bassa Gbikinti 26 25 30 28
14 Foadan Foadan 26 19 30 21
TEMPORADA 2017/2018
LIGA TOGO
Equipo PJ GF GC Puntos
1 US Koroki US Koroki 28 27 11 55
2 AC Sèmassi AC Sèmassi 28 35 18 51
3 Gomido Gomido 28 33 16 50
4 Togo-Port Togo-Port 28 35 22 49
5 Dynamic Togolais Dynamic 28 37 27 44
6 OTR OTR 28 34 28 43
7 ASC Kara ASC Kara 28 33 26 41
8 Maranatha Maranatha 28 29 26 41
9 Anges de Notsé Anges Notsé 28 19 27 37
10 Gbikinti de Bassa Gbikinti 28 25 22 36
11 ASKO de Kara ASKO Kara 28 24 30 35
12 Foadan Foadan 28 15 24 30
13 Unisport de Sokode Unisport 28 21 31 27
14 Agaza de Lome Agaza Lome 28 17 32 26
15 Espoir FC Espoir FC 28 20 34 25
16 Kotoko Kotoko 28 14 44 17

  USO DE MEMORIA  
5,594,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4451
Total Execution Time  0.4466
  CADENA URL  
/historico/Asc-Kara
  GET DATOS  
$_GET['/historico/Asc-Kara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0139  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 = 'Asc-Kara' 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.0128  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=109018 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=109018 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=109018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109018 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=482 AND type_rel = 3
0.0130  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 = '109018' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '109018' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=109018 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74386,73346) 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 = 74386 AND teamId = 109018
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73346 AND teamId = 109018
0.0129  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 = '109018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '109018' and rp.type = 4
0.0135  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 = '109018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144  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 = 74386 WHERE rp.league_id = 74386 AND rp.teamId = 109018 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.0140  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 = 74386 WHERE rp.league_id = 74386 AND rp.teamId = 109018 AND (e.action = 4 or e.action = 5) 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 = 74386 WHERE rp.league_id = 74386 AND rp.teamId = 109018 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 109018 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  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 = 74386 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 70036 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 66045 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 66916 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 61991 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 47224 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 42105 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC