4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wakirya
TEMPORADA 2023/2024
LIGA GUINEA
Equipo PJ GF GC Puntos
1 CI Kamsar CI Kamsar 14 30 22 25
2 ASM Sangarédi Sangarédi 14 24 12 24
3 Hafia FC Hafia FC 14 25 19 23
4 Milo Milo 14 25 19 22
5 Renaissance Renaissance 13 10 8 18
6 Gangan Gangan 14 11 18 18
7 Wakirya Wakirya 13 15 15 17
8 AS du Kaloum Star Kaloum Star 14 15 19 17
9 Loubha Télimélé Loubha 14 11 18 17
10 Ashanti GB Ashanti GB 13 11 12 16
11 Horoya AC Horoya AC 14 9 10 16
12 CO Coyah CO Coyah 14 10 16 15
13 Flamme Olympique Flamme 13 13 15 14
14 Sequence Sequence 14 15 21 13
TEMPORADA 2022/2023
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Hafia FC Hafia FC 26 45 26 50
2 Horoya AC Horoya AC 26 39 15 49
3 Milo Milo 26 33 32 42
4 CO Coyah CO Coyah 26 30 23 38
5 CI Kamsar CI Kamsar 26 26 32 38
6 Flamme Olympique Flamme 26 35 24 36
7 Renaissance Renaissance 26 25 30 36
8 ASM Sangarédi Sangarédi 26 29 33 35
9 Wakirya Wakirya 26 22 23 34
10 AS du Kaloum Star Kaloum Star 26 24 23 33
11 Ashanti GB Ashanti GB 26 28 34 32
12 Sequence Sequence 26 28 41 31
13 Fello Star Fello Star 26 25 31 27
14 Satellite FC Satellite 26 20 42 19
TEMPORADA 2021/2022
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 26 41 5 64
2 CO Coyah CO Coyah 26 34 21 50
3 Milo Milo 26 38 28 47
4 Ashanti GB Ashanti GB 26 25 18 46
5 CI Kamsar CI Kamsar 26 27 16 43
6 Wakirya Wakirya 26 24 19 41
7 Hafia FC Hafia FC 26 30 23 38
8 AS du Kaloum Star Kaloum Star 26 23 30 32
9 Sequence Sequence 26 30 28 29
10 Fello Star Fello Star 26 28 35 29
11 Satellite FC Satellite 26 28 36 25
12 Flamme Olympique Flamme 26 25 40 24
13 Eléphant Coléah Eléphant 26 29 44 19
14 Loubha Télimélé Loubha 26 24 63 17
TEMPORADA 2020/2021
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 26 48 13 58
2 CI Kamsar CI Kamsar 26 33 17 46
3 Wakirya Wakirya 26 47 31 45
4 Ashanti GB Ashanti GB 26 24 24 43
5 Hafia FC Hafia FC 26 33 21 42
6 CO Coyah CO Coyah 26 31 31 39
7 AS du Kaloum Star Kaloum Star 26 34 28 38
8 Fello Star Fello Star 26 28 34 33
9 Satellite FC Satellite 26 25 33 31
10 Flamme Olympique Flamme 26 24 35 31
11 Eléphant Coléah Eléphant 26 25 36 23
12 Loubha Télimélé Loubha 26 21 28 23
13 Santoba FC Santoba FC 26 26 45 23
14 ASFAG ASFAG 26 27 50 22
TEMPORADA 2019/2020
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 13 14 7 29
2 Ashanti GB Ashanti GB 14 13 4 25
3 Wakirya Wakirya 14 15 9 25
4 AS du Kaloum Star Kaloum Star 15 13 10 23
5 Fello Star Fello Star 14 16 16 22
6 Flamme Olympique Flamme 14 21 16 21
7 Hafia FC Hafia FC 13 13 11 19
8 Loubha Télimélé Loubha 13 13 12 19
9 CI Kamsar CI Kamsar 14 19 14 18
10 Santoba FC Santoba FC 13 16 17 17
11 ASFAG ASFAG 13 14 14 12
12 Eléphant Coléah Eléphant 13 5 13 11
13 CO Coyah CO Coyah 13 5 15 10
14 Satellite FC Satellite 14 7 26 6
TEMPORADA 2018/2019
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 26 49 17 60
2 Hafia FC Hafia FC 26 36 25 44
3 Santoba FC Santoba FC 26 35 31 41
4 CO Coyah CO Coyah 26 35 26 40
5 Wakirya Wakirya 26 24 17 38
6 AS du Kaloum Star Kaloum Star 26 26 23 36
7 CI Kamsar CI Kamsar 26 27 30 31
8 ASFAG ASFAG 26 27 33 31
9 Fello Star Fello Star 26 25 33 30
10 Ashanti GB Ashanti GB 26 18 20 29
11 Eléphant Coléah Eléphant 26 31 39 28
12 Satellite FC Satellite 26 27 37 28
13 Renaissance Renaissance 26 29 41 24
14 Gangan Gangan 26 21 38 21
TEMPORADA 2017/2018
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 26 56 14 62
2 Hafia FC Hafia FC 26 44 23 51
3 Wakirya Wakirya 26 41 30 42
4 AS du Kaloum Star Kaloum Star 26 24 21 40
5 Gangan Gangan 26 31 25 38
6 Eléphant Coléah Eléphant 26 22 30 32
7 Fello Star Fello Star 26 27 32 32
8 ASFAG ASFAG 26 23 23 31
9 Ashanti GB Ashanti GB 26 20 35 30
10 CI Kamsar CI Kamsar 26 25 33 29
11 Renaissance Renaissance 26 26 36 28
12 Satellite FC Satellite 26 17 31 28
13 Milo Milo 26 24 29 27
14 Athlético Coléah Athlético 26 17 35 20
TEMPORADA 2016/2017
LIGA GUINEA
Equipo PJ GF GC Puntos
1 Horoya AC Horoya AC 26 61 6 69
2 Wakirya Wakirya 26 28 18 46
3 ASFAG ASFAG 26 26 21 43
4 Hafia FC Hafia FC 26 34 25 41
5 Satellite FC Satellite 26 27 31 36
6 Renaissance Renaissance 26 30 30 34
7 Ashanti GB Ashanti GB 26 24 24 33
8 Fello Star Fello Star 26 19 30 30
9 CI Kamsar CI Kamsar 26 24 29 29
10 Gangan Gangan 26 22 27 29
11 AS du Kaloum Star Kaloum Star 26 21 19 29
12 Athlético Coléah Athlético 26 26 33 28
13 Soumba Soumba 26 17 38 26
14 CO Coyah CO Coyah 26 14 42 20

  USO DE MEMORIA  
5,411,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1281
Total Execution Time  0.1294
  CADENA URL  
/historico/Wakirya-Athletic-Club
  GET DATOS  
$_GET['/historico/Wakirya-Athletic-Club']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0033  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 = 'Wakirya-Athletic-Club' 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=100220 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=100220 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 74487
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100220 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 100220 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (645249,769644) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '100220' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '100220' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '100220' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 74487 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=100220 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (74487) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74487 AND teamId = 100220
0.0032  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 = 74487 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '100220' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '100220' and rp.type = 4
0.0021  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 = '100220' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74487 WHERE rp.league_id = 74487 AND rp.teamId = 100220 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.0022  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 = 74487 WHERE rp.league_id = 74487 AND rp.teamId = 100220 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 74487 WHERE rp.league_id = 74487 AND rp.teamId = 100220 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 100220 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 = 74487 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.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 `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 = 70322 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.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 `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 = 65509 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.0029  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 = 60119 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.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 `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 = 51627 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.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 `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 = 48560 AND t.round = 26 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 `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 = 42070 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 37529 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC