4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dynamo Unacob
TEMPORADA 2023/2024
LIGA BENÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Buffles de Borgou Buffles 9 11 6 19
2 Béké Bembèrèkè Béké 9 14 7 15
3 Tonnerre FC Tonnerre FC 9 10 9 15
4 Panthères Panthères 9 9 7 14
5 Hodio FC Hodio FC 9 10 8 12
6 Abeilles FC Abeilles FC 9 11 13 12
7 Réal Sport Réal Sport 9 8 8 11
8 Dynamo Unacob Dynamo 9 10 14 11
9 Soleil FC Soleil FC 9 11 12 8
10 Dynamique FC Dynamique 9 6 16 5
11 Jeunesse Athletique De Keto Jeunesse 9 20 9 18
12 ASVO ASVO 9 9 5 15
13 Adjidja FC Adjidja FC 9 10 6 14
14 Aïnonvi Aïnonvi 9 7 9 13
15 Etoile Filante Etoile 9 7 7 12
16 JSO JSO 9 6 6 12
17 Aziza Aziza 9 10 14 11
18 AS Police AS Police 9 6 10 10
19 Djeffa FC Djeffa FC 9 5 8 8
20 Avrankou Omnisport Avrankou 9 6 12 7
TEMPORADA 2022/2023
LIGA BENÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Buffles de Borgou Buffles 16 24 12 32
2 Damissa FC Damissa FC 16 13 6 31
3 Cavaliers Cavaliers 16 18 11 26
4 Tukunnin Tukunnin 16 20 9 25
5 Panthères Panthères 16 12 9 21
6 Dynamo Unacob Dynamo 16 9 15 21
7 Béké Bembèrèkè Béké 16 12 13 17
8 Réal Sport Réal Sport 16 3 11 12
9 Dynamique FC Dynamique 16 6 31 5
10 Loto Popo Loto Popo 16 23 7 35
11 Dadje FC Dadje FC 16 19 12 31
12 Dynamo Abomey Dynamo 16 28 15 30
13 Bani Gansè Bani Gansè 16 21 20 28
14 Hodio FC Hodio FC 16 22 9 26
15 Tonnerre FC Tonnerre FC 16 15 19 21
16 Espoir FC Espoir FC 16 18 24 18
17 Energie Energie 16 10 25 11
18 Soleil FC Soleil FC 16 14 39 2
19 Coton Sport FC Coton Sport 16 28 5 36
20 Requins de l'Atlantique Requins 15 23 10 29
21 ASPAC ASPAC 16 20 12 28
22 AS Cotonou AS Cotonou 16 17 10 24
23 Eternel FC Eternel FC 16 17 15 22
24 Aziza Aziza 16 12 28 16
25 Adjidja FC Adjidja FC 16 10 20 14
26 AS Police AS Police 16 12 29 12
27 Sitatunga Sitatunga 15 8 18 11
28 Ayema Ayema 16 20 10 28
29 ASVO ASVO 16 23 13 27
30 AS Sobemap AS Sobemap 16 17 14 26
31 Jeunesse Athletique De Keto Jeunesse 16 15 12 26
32 Dragons de l'Ouémé Dragons 16 10 9 25
33 JSP JSP 16 16 15 21
34 Djeffa FC Djeffa FC 16 13 15 20
35 Avrankou Omnisport Avrankou 16 10 22 10
36 JSO JSO 16 12 26 10
TEMPORADA 2021/2022
LIGA BENÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Tukunnin Tukunnin 18 26 20 32
2 Damissa FC Damissa FC 18 16 11 26
3 Hodio FC Hodio FC 18 20 17 25
4 Réal Sport Réal Sport 18 13 11 25
5 Dynamique FC Dynamique 18 17 23 23
6 Dynamo Unacob Dynamo 18 20 21 22
7 Tonnerre FC Tonnerre FC 18 15 14 21
8 Soleil FC Soleil FC 18 16 19 21
9 Energie Energie 18 11 15 21
10 US Baboni US Baboni 18 17 20 20
11 ASPAC ASPAC 18 21 9 33
12 Dragons de l'Ouémé Dragons 18 22 16 31
13 Requins de l'Atlantique Requins 18 26 15 30
14 Sitatunga Sitatunga 18 22 22 28
15 AS Sobemap AS Sobemap 18 16 17 27
16 Avrankou Omnisport Avrankou 18 17 20 23
17 Jeunesse Athletique De Keto Jeunesse 18 15 16 22
18 Aziza Aziza 18 22 27 17
19 AS Police AS Police 18 17 29 17
20 ASOS ASOS 18 12 19 14
TEMPORADA 2020/2021
LIGA BENÍN GRUPO 2
Equipo PJ GF GC Puntos
1 ESAE ESAE 18 32 16 39
2 Buffles de Borgou Buffles 18 24 11 36
3 Dragons de l'Ouémé Dragons 18 21 14 31
4 Ayema Ayema 18 14 9 30
5 Béké Bembèrèkè Béké 18 20 17 26
6 Damissa FC Damissa FC 18 20 18 24
7 Requins de l'Atlantique Requins 18 19 21 23
8 Eternel FC Eternel FC 18 15 19 21
9 AS Cotonou AS Cotonou 18 15 21 21
10 Dynamo Unacob Dynamo 18 17 19 18
11 Hodio FC Hodio FC 18 17 27 13
12 ASOS ASOS 18 12 34 10
TEMPORADA 2019/2020
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Ayema Ayema 19 29 13 36
2 ESAE ESAE 19 17 11 35
3 Buffles de Borgou Buffles 19 17 9 30
4 Dragons de l'Ouémé Dragons 19 19 12 29
5 Panthères Panthères 19 19 15 28
6 ASPAC ASPAC 19 21 16 27
7 Béké Bembèrèkè Béké 19 21 16 26
8 Tonnerre FC Tonnerre FC 19 17 17 25
9 Energie Energie 19 16 16 23
10 JSP JSP 19 16 20 23
11 Réal Sport Réal Sport 19 13 17 23
12 ASVO ASVO 19 16 18 22
13 Jeunesse Athletique De Keto Jeunesse 19 15 20 21
14 Dynamo Unacob Dynamo 19 14 20 21
15 AS Sobemap AS Sobemap 19 14 29 18
16 Aziza Aziza 19 12 27 11

  USO DE MEMORIA  
5,542,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5271
Total Execution Time  0.5292
  CADENA URL  
/historico/Dynamo-Unacob
  GET DATOS  
$_GET['/historico/Dynamo-Unacob']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0138  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 = 'Dynamo-Unacob' 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=122449 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=122449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=122449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 75495
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=122449 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=328 AND type_rel = 3
0.0128  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 = '122449' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '122449' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '122449' 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,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 = 74380 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=122449 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 (75495) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 75495 AND teamId = 122449
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 = 75495 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 = '122449' 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 = '122449' and rp.type = 4
0.0127  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 = '122449' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130  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 = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 122449 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.0139  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 = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 122449 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 122449 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 122449 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74380 AND t.round = 18 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 `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 = 75495 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.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 `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 = 71172 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.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 `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 = 70484 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 65691 AND t.round = 18 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 `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 = 66959 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 61294 AND t.round = 18 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 = 62161 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 51514 AND t.round = 19 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 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 = 75495 ORDER BY nameShow LIMIT 100