4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kozaf
TEMPORADA 2023/2024
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Douanes Douanes 23 36 10 49
2 Majestic FC Majestic FC 23 27 14 41
3 Sonabel Sonabel 23 19 10 40
4 Salitas Salitas 23 31 25 36
5 Sporting Cascades Sporting 23 18 17 33
6 Vitesse FC Vitesse FC 23 20 20 32
7 ASEC-K ASEC-K 23 13 14 30
8 Rail Club Kadiogo Rail Club K. 23 12 14 30
9 Étoile Filante Ouagadougou Étoile 23 19 24 29
10 AS Faso/Yennenga Faso/Yenneng 23 21 18 28
11 US Forces Armees Forces 23 13 18 26
12 ASF Bobo-Dioulasso Bobo-Dioulas 23 13 16 25
13 Rahimo Rahimo 23 17 27 24
14 Racing Club Bobo Racing Club 23 15 22 22
15 Royal FC Royal FC 23 18 24 20
16 Kozaf Kozaf 23 13 32 17
TEMPORADA 2020/2021
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Sonabel Sonabel 34 50 24 67
2 Douanes Douanes 34 55 32 64
3 Salitas Salitas 34 48 33 60
4 US Forces Armees Forces 34 35 23 57
5 Racing Club Bobo Racing Club 34 36 21 49
6 AS Faso/Yennenga Faso/Yenneng 34 34 33 47
7 Étoile Filante Ouagadougou Étoile 34 27 27 43
8 Royal FC Royal FC 34 36 37 43
9 ASF Bobo-Dioulasso Bobo-Dioulas 34 34 37 43
10 Majestic FC Majestic FC 34 32 38 42
11 ASEC-K ASEC-K 34 27 29 41
12 Rail Club Kadiogo Rail Club K. 34 23 38 41
13 Police Police 34 30 31 39
14 Vitesse FC Vitesse FC 34 31 37 39
15 Rahimo Rahimo 34 27 37 37
16 US Ouagadougou Ouagadougou 34 26 38 35
17 AS Léopards de Saint-Camill Léopards 34 22 40 35
18 Kozaf Kozaf 34 27 45 30
TEMPORADA 2019/2020
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Salitas Salitas 24 38 15 51
2 Majestic FC Majestic FC 24 30 20 45
3 Rahimo Rahimo 24 27 23 41
4 ASF Bobo-Dioulasso Bobo-Dioulas 24 30 17 40
5 Douanes Douanes 24 24 19 37
6 US Forces Armees Forces 24 29 24 35
7 AS Faso/Yennenga Faso/Yenneng 24 23 20 34
8 Racing Club Bobo Racing Club 24 22 21 32
9 Sonabel Sonabel 24 24 25 30
10 Étoile Filante Ouagadougou Étoile 24 23 28 30
11 ASEC-K ASEC-K 24 17 24 29
12 Kozaf Kozaf 24 19 24 28
13 Royal FC Royal FC 24 23 33 24
14 US Ouagadougou Ouagadougou 24 19 30 23
15 Rail Club Kadiogo Rail Club K. 24 16 29 22
16 Police Police 24 19 31 18
TEMPORADA 2018/2019
SEGUNDA BURKINA FASO
Equipo PJ GF GC Puntos
1 Kozaf Kozaf 18 36 11 44
2 AS de Tèma AS de Tèma 18 36 11 42
3 Koupéla du Kouritenga Koupéla 18 23 20 30
4 AS Ouagadougou Ouagadougou 18 15 21 25
5 AS Léopards de Saint-Camill Léopards 18 22 26 24
6 Santos FC Santos FC 18 13 16 17
7 Canon du Sud Canon 18 15 20 17
8 Faso Athletic Club Faso 18 15 25 17
9 CFFEB CFFEB 18 12 27 16
10 AS Ecol AS Ecol 18 16 26 15
11 Royal FC Royal FC 18 21 7 39
12 AS Espérance Club de Ouahig Espérance 18 18 10 34
13 JC de Bobo-Dioulasso Bobo-Dioulas 18 16 10 33
14 US Yatenga US Yatenga 18 13 12 28
15 Vitesse FC Vitesse FC 18 21 16 22
16 IFFA Matourkou IFFA 18 12 13 22
17 Kiko FC Kiko FC 18 12 19 21
18 BPS Koudougou Koudougou 18 11 16 18
19 AS Maya AS Maya 18 10 15 18
20 Club Bobo Sports Club Bobo S. 18 9 25 10
TEMPORADA 2017/2018
SEGUNDA BURKINA FASO
Equipo PJ GF GC Puntos
1 Douanes Douanes 22 43 12 50
2 Kozaf Kozaf 22 31 12 44
3 Koupéla du Kouritenga Koupéla 22 22 16 36
4 AS de Tèma AS de Tèma 22 20 16 34
5 AS Ouagadougou Ouagadougou 22 21 22 29
6 AS Léopards de Saint-Camill Léopards 22 18 24 28
7 CFFEB CFFEB 22 24 28 27
8 Canon du Sud Canon 22 18 22 27
9 Faso Athletic Club Faso 22 20 22 26
10 Fabao Foot Espoir Fabao Foot. 22 14 18 25
11 Athlétic Club Athlétic 22 11 26 18
12 Étoile Africaine de Ziniaré Étoile 22 13 37 16
13 ASEC Koudougou ASEC 22 27 15 42
14 AS Maya AS Maya 22 32 20 38
15 AS Espérance Club de Ouahig Espérance 22 27 18 36
16 US Yatenga US Yatenga 22 21 15 35
17 Royal FC Royal FC 22 26 24 33
18 IFFA Matourkou IFFA 22 24 21 32
19 BPS Koudougou Koudougou 22 22 20 31
20 Kiko FC Kiko FC 22 19 25 30
21 JC de Bobo-Dioulasso Bobo-Dioulas 22 18 19 28
22 FALEM FALEM 22 18 21 27
23 Bafuji FC Bafuji FC 22 12 24 19
24 AFAC Bobo-Dioulasso AFAC 22 11 35 7
TEMPORADA 2016/2017
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Rail Club Kadiogo Rail Club K. 30 46 21 59
2 Étoile Filante Ouagadougou Étoile 30 29 15 54
3 US Forces Armees Forces 30 34 21 49
4 Rahimo Rahimo 30 29 23 44
5 Ajeb Ajeb 30 29 28 41
6 ASF Bobo-Dioulasso Bobo-Dioulas 30 22 24 41
7 Police Police 29 30 26 40
8 AS Faso/Yennenga Faso/Yenneng 30 29 34 40
9 Sonabel Sonabel 29 24 22 37
10 Racing Club Bobo Racing Club 29 24 25 37
11 Majestic FC Majestic FC 30 22 30 37
12 US Ouagadougou Ouagadougou 29 26 22 36
13 US Comoe US Comoe 30 16 28 31
14 Bouloumpoukou FC Bouloumpouko 30 12 28 30
15 Kozaf Kozaf 30 20 32 27
16 Santos FC Santos FC 30 16 29 27
TEMPORADA 2015/2016
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Rail Club Kadiogo Rail Club K. 30 34 14 60
2 US Ouagadougou Ouagadougou 30 32 12 59
3 Racing Club Bobo Racing Club 30 35 16 56
4 Santos FC Santos FC 31 33 21 47
5 Kozaf Kozaf 31 35 25 45
6 AS Faso/Yennenga Faso/Yenneng 30 27 25 45
7 Étoile Filante Ouagadougou Étoile 31 24 30 39
8 Sonabel Sonabel 30 19 20 38
9 Bouloumpoukou FC Bouloumpouko 31 25 30 38
10 US Forces Armees Forces 30 24 30 36
11 Majestic FC Majestic FC 30 25 30 35
12 Ajeb Ajeb 30 21 30 35
13 ASF Bobo-Dioulasso Bobo-Dioulas 30 27 33 33
14 US Comoe US Comoe 30 11 19 33
15 US Yatenga US Yatenga 30 23 33 31
16 Bankuy Sports Bankuy 30 11 38 15
TEMPORADA 2014/2015
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Racing Club Bobo Racing Club 31 45 18 61
2 US Forces Armees Forces 31 50 22 57
3 Étoile Filante Ouagadougou Étoile 30 45 18 57
4 Sonabel Sonabel 30 33 17 53
5 Rail Club Kadiogo Rail Club K. 31 31 22 51
6 US Ouagadougou Ouagadougou 31 27 16 49
7 AS Faso/Yennenga Faso/Yenneng 31 25 27 40
8 Kozaf Kozaf 30 21 23 40
9 Majestic FC Majestic FC 31 23 30 37
10 US Comoe US Comoe 32 21 30 34
11 Santos FC Santos FC 31 20 33 34
12 Bouloumpoukou FC Bouloumpouko 30 20 33 32
13 ASF Bobo-Dioulasso Bobo-Dioulas 32 9 28 32
14 Bankuy Sports Bankuy 31 15 31 31
15 Bobo Sport Bobo Sport 31 15 33 27
16 Canon du Sud Canon 31 11 30 23
TEMPORADA 2013/2014
LIGA BURKINA FASO
Equipo PJ GF GC Puntos
1 Étoile Filante Ouagadougou Étoile 30 35 12 64
2 US Forces Armees Forces 30 47 20 61
3 Rail Club Kadiogo Rail Club K. 30 27 19 52
4 Racing Club Bobo Racing Club 30 33 23 50
5 ASF Bobo-Dioulasso Bobo-Dioulas 30 30 23 47
6 Sonabel Sonabel 30 26 22 45
7 Santos FC Santos FC 30 29 27 45
8 Majestic FC Majestic FC 30 27 18 43
9 AS Faso/Yennenga Faso/Yenneng 30 30 30 38
10 US Ouagadougou Ouagadougou 30 24 30 36
11 Bobo Sport Bobo Sport 30 19 22 35
12 Kozaf Kozaf 30 23 27 33
13 US Comoe US Comoe 30 23 33 31
14 Bouloumpoukou FC Bouloumpouko 30 16 26 30
15 US Yatenga US Yatenga 30 12 36 18
16 USFRAN USFRAN 30 10 43 15

  USO DE MEMORIA  
5,936,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1123
Total Execution Time  0.1135
  CADENA URL  
/historico/Kozaf
  GET DATOS  
$_GET['/historico/Kozaf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0034  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 = 'Kozaf' 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.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=25070 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=25070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25070 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=510 AND type_rel = 3
0.0024  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 = '25070' ORDER BY l.year DESC,cat.coefficient DESC
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 = '25070' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '25070' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73646 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=25070 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73646) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73646 AND teamId = 25070
0.0030  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 = 73646 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '25070' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25070' and rp.type = 4
0.0020  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 = '25070' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 73646 WHERE rp.league_id = 73646 AND rp.teamId = 25070 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.0041  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 = 73646 WHERE rp.league_id = 73646 AND rp.teamId = 25070 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73646 WHERE rp.league_id = 73646 AND rp.teamId = 25070 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 25070 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 = 73646 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 58665 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 51068 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 56435 AND t.round = 18 ORDER BY team.conference 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 `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 = 56436 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 37530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 15758 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 8366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC