4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dakkada
TEMPORADA 2023/2024
NNL
Equipo PJ GF GC Puntos
1 Madiba Madiba 19 31 12 42
2 Beyond Limits Beyond 19 35 18 36
3 Smart City Smart City 20 31 21 32
4 Edel Edel 19 19 16 31
5 Coal City Coal City 19 21 21 28
6 Abia Comets Abia Comets 19 22 24 28
7 Rovers FC Rovers FC 20 16 19 25
8 Dakkada Dakkada 19 19 21 24
9 1472 FC 1472 FC 20 27 29 21
10 Ekiti United Ekiti United 19 19 31 20
11 Stormers Stormers 19 19 30 18
12 Vandrezzer Vandrezzer 20 12 29 17
13 Ikorodu City Ikorodu City 18 24 14 30
14 Inter Lagos Inter Lagos 18 30 24 29
15 Crown Crown 17 23 17 27
16 Osun Osun 17 12 8 27
17 Warri Wolves FC Warri Wolves 18 18 21 25
18 Giant Brillars FC Giant 18 19 16 24
19 Gateway United Gateway 17 15 18 23
20 Ijebu Ijebu 17 14 17 23
21 Solution Solution 18 11 18 22
22 One Rocket One Rocket 17 14 16 21
23 Tradesafe Tradesafe 17 11 22 13
24 El Kanemi Warriors Kanemi 16 20 9 34
25 Nasarawa United Nasarawa 17 20 10 32
26 Wikki Tourist Wikki 15 27 10 29
27 Yobe Stars Yobe Stars 15 17 16 22
28 Zamfara United Zamfara 15 14 17 17
29 Mighty Jets Mighty Jets 15 14 19 16
30 Nigeria Airforce Nigeria 13 7 13 12
31 ABS FC ABS FC 15 5 17 12
32 EFCC EFCC 15 7 20 11
33 Sokoto Sokoto 12 16 10 23
34 Sporting Supreme Sporting 12 18 9 22
35 Adamawa United FC Adamawa 12 6 9 15
36 Kebbi United Kebbi United 12 13 11 14
37 Mailantarki Care Mailantarki 12 11 14 14
38 Jigawa Golden Stars Jigawa 12 9 14 14
39 City FC Abuja City Abuja 12 10 16 10
TEMPORADA 2022/2023
PREMIER LEAGUE NIGERIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bendel Insurance Bendel 18 22 11 34
2 Remo Stars Remo Stars 18 21 14 33
3 Enyimba Enyimba 18 25 12 32
4 Akwa United Akwa United 18 24 14 32
5 Plateau United Plateau 18 29 23 26
6 Shooting Stars Shooting 18 20 20 23
7 Gombe United Gombe United 18 10 20 19
8 Kwara United Kwara United 18 11 22 17
9 Nasarawa United Nasarawa 18 15 23 14
10 El Kanemi Warriors Kanemi 18 10 28 10
11 Rivers United Rivers 18 24 15 34
12 Lobi Stars Lobi Stars 18 20 17 30
13 Sunshine Stars Sunshine 18 20 14 27
14 Abia Warriors Abia 18 22 24 27
15 Doma United FC Doma United 18 15 15 26
16 Bayelsa United Bayelsa 18 27 24 24
17 Niger Tornadoes Niger 18 16 16 23
18 Enugu Rangers Enugu 18 16 16 21
19 Wikki Tourist Wikki 18 18 23 19
20 Dakkada Dakkada 18 15 29 13
TEMPORADA 2021/2022
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Rivers United Rivers 38 58 24 77
2 Plateau United Plateau 38 50 29 67
3 Remo Stars Remo Stars 38 43 26 62
4 Kwara United Kwara United 38 43 45 58
5 Enugu Rangers Enugu 38 41 30 56
6 Nasarawa United Nasarawa 38 42 48 53
7 Enyimba Enyimba 38 39 36 52
8 Gombe United Gombe United 38 39 39 52
9 Akwa United Akwa United 38 35 36 52
10 Wikki Tourist Wikki 38 34 35 52
11 Sunshine Stars Sunshine 38 30 30 51
12 Abia Warriors Abia 38 50 44 50
13 Niger Tornadoes Niger 38 32 38 49
14 Dakkada Dakkada 38 42 49 49
15 Lobi Stars Lobi Stars 38 36 48 49
16 Shooting Stars Shooting 38 41 45 48
17 Kano Pillars Kano Pillars 38 32 36 48
18 Katsina United Katsina 38 34 42 48
19 Heartland Owerri Heartland 38 32 48 47
20 MFM FC MFM FC 38 26 51 36
TEMPORADA 2020/2021
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Akwa United Akwa United 38 53 24 71
2 Enyimba Enyimba 38 41 33 66
3 Kwara United Kwara United 38 48 28 65
4 Nasarawa United Nasarawa 38 55 38 65
5 Kano Pillars Kano Pillars 38 38 29 64
6 Rivers United Rivers 38 48 36 63
7 Enugu Rangers Enugu 38 43 31 62
8 Lobi Stars Lobi Stars 38 43 39 58
9 Plateau United Plateau 38 45 35 51
10 MFM FC MFM FC 38 35 35 51
11 Dakkada Dakkada 38 37 47 50
12 Katsina United Katsina 38 35 42 49
13 Heartland Owerri Heartland 38 43 50 48
14 Abia Warriors Abia 38 48 42 47
15 Wikki Tourist Wikki 38 40 47 45
16 Sunshine Stars Sunshine 38 28 39 45
17 Jigawa Golden Stars Jigawa 38 29 46 43
18 Warri Wolves FC Warri Wolves 38 30 45 41
19 Ifeanyi Ubah Ifeanyi Ubah 38 33 51 39
20 Adamawa United FC Adamawa 38 20 55 25
TEMPORADA 2019/2020
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Plateau United Plateau 25 36 15 49
2 Enyimba Enyimba 20 30 20 36
3 Rivers United Rivers 25 28 15 45
4 Lobi Stars Lobi Stars 25 26 19 43
5 Enugu Rangers Enugu 24 25 20 37
6 Kano Pillars Kano Pillars 24 27 18 34
7 Katsina United Katsina 24 18 25 34
8 Akwa United Akwa United 25 23 22 35
9 Warri Wolves FC Warri Wolves 24 25 23 33
10 Sunshine Stars Sunshine 25 27 29 34
11 Ifeanyi Ubah Ifeanyi Ubah 25 25 28 33
12 Dakkada Dakkada 26 26 26 34
13 Heartland Owerri Heartland 25 21 21 32
14 Wikki Tourist Wikki 25 23 24 31
15 MFM FC MFM FC 25 19 19 31
16 Abia Warriors Abia 25 23 28 30
17 Nasarawa United Nasarawa 25 27 27 29
18 Jigawa Golden Stars Jigawa 25 25 35 29
19 Kwara United Kwara United 25 23 33 28
20 Adamawa United FC Adamawa 25 17 47 20

  USO DE MEMORIA  
5,844,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4758
Total Execution Time  0.4779
  CADENA URL  
/historico/Akwa-Starlets
  GET DATOS  
$_GET['/historico/Akwa-Starlets']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0154  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 = 'Akwa-Starlets' 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.0129  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=123195 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=123195 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 75333
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=123195 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2504 AND type_rel = 3
0.0142  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 = '123195' ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '123195' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '123195' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 75333 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=123195 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75333,70854) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 70854 AND teamId = 123195
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75333 AND teamId = 123195
0.0128  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 = '123195' 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 = '123195' and rp.type = 4
0.0129  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 = '123195' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75333 WHERE rp.league_id = 75333 AND rp.teamId = 123195 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.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 = 75333 WHERE rp.league_id = 75333 AND rp.teamId = 123195 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75333 WHERE rp.league_id = 75333 AND rp.teamId = 123195 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 123195 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0170  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 = 75333 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.0142  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 = 70854 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.0138  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 = 66211 AND t.round = 38 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 `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 = 60356 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC