4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hay Al Wadi
TEMPORADA 2022/2023
LIGA SUDÁN
Equipo PJ GF GC Puntos
TEMPORADA 2021/2022
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 30 59 13 77
2 Al-Merreikh SC Al-Merreikh 30 56 11 74
3 Al Hilal Port Sudan Hilal Port. 30 42 31 48
4 Al Ahly Shendi Ahly Shendi 30 26 27 42
5 Hilal El-Fasher Hilal 30 27 28 40
6 Al Ahli Khartoum Ahli 30 22 24 40
7 Kober Kober 30 29 32 37
8 Wad Nubawi Wad Nubawi 30 23 29 36
9 Al-Ahly Merowe Al-Ahly 30 34 40 35
10 Hay Al-Arab Hay Al-Arab 30 18 21 34
11 Hay Al Wadi Hay Al Wadi 30 23 30 34
12 Tuti SC Tuti SC 30 21 29 34
13 Alamal Atbara Alamal 30 22 35 33
14 Al Shorta Al Shorta 30 27 37 32
15 Hilal Obayed Hilal Obayed 30 23 39 29
16 Al Khartoum Al Khartoum 30 32 58 23
TEMPORADA 2020/2021
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 30 75 12 77
2 Al-Merreikh SC Al-Merreikh 30 50 16 68
3 Hay Al Wadi Hay Al Wadi 30 35 25 47
4 Al Khartoum Al Khartoum 30 34 34 41
5 Hilal Obayed Hilal Obayed 30 25 32 41
6 Hay Al-Arab Hay Al-Arab 30 26 34 40
7 Alamal Atbara Alamal 30 25 29 39
8 Al-Ahly Merowe Al-Ahly 30 24 28 38
9 Hilal El-Fasher Hilal 30 35 41 38
10 Al Hilal Port Sudan Hilal Port. 30 29 33 36
11 Al Shorta Al Shorta 30 26 36 35
12 Al Ahly Shendi Ahly Shendi 30 21 27 34
13 Tuti SC Tuti SC 30 26 39 34
14 Al Ahli Khartoum Ahli 30 17 28 32
15 Al Hilal Kadougli Hilal 30 22 39 25
16 Merreikh El-Fasher Merreikh 30 15 32 24
TEMPORADA 2019/2020
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 32 60 17 74
2 Al-Hilal Omdurman Al-Hilal 32 62 19 69
3 Hilal Obayed Hilal Obayed 32 48 25 56
4 Alamal Atbara Alamal 32 43 29 53
5 Merreikh El-Fasher Merreikh 32 39 29 49
6 Hay Al Wadi Hay Al Wadi 32 29 22 49
7 Hay Al-Arab Hay Al-Arab 32 38 42 49
8 Al Khartoum Al Khartoum 32 30 18 46
9 Al Ahly Shendi Ahly Shendi 32 42 35 44
10 Al-Ahly Merowe Al-Ahly 32 28 35 41
11 Al Ahli Khartoum Ahli 32 36 40 39
12 Hilal El-Fasher Hilal 31 27 37 37
13 Al Shorta Al Shorta 32 32 51 32
14 Al Fallah Al Fallah 32 29 47 30
15 Al Hilal Kadougli Hilal 32 28 48 30
16 Al Rabta Kosti Rabta Kosti 31 25 56 25
17 El-Ahli Atbara El-Ahli 32 26 72 17
TEMPORADA 2018/2019
LIGA SUDÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 2 2 0 6
2 Al Khartoum Al Khartoum 2 3 2 4
3 Al Ahly Shendi Ahly Shendi 1 2 1 3
4 Al-Hilal Omdurman Al-Hilal 1 1 0 3
5 Hilal Obayed Hilal Obayed 3 1 3 1
6 Hay Al Wadi Hay Al Wadi 3 2 5 0
TEMPORADA 2017/2018
LIGA SUDÁN GRUPO 3
Equipo PJ GF GC Puntos
1 Alamal Atbara Alamal 18 22 12 33
2 Wad Hashim Sennar Hashim 18 22 19 29
3 Al Ahli Khartoum Ahli 18 20 16 28
4 Hay Al Wadi Hay Al Wadi 19 18 16 28
5 Al Shorta Al Shorta 18 22 20 25
6 Kober Kober 19 23 22 24
7 El-Ahli Atbara El-Ahli 18 20 22 24
8 Al Hilal Kadougli Hilal 17 14 13 22
9 Merreikh Kosti Merreikh 18 16 22 19
10 Merreikh Nyala Merreikh 17 16 31 8
TEMPORADA 2016/2017
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 34 66 21 79
2 Al-Hilal Omdurman Al-Hilal 34 66 23 77
3 Hilal Obayed Hilal Obayed 34 56 34 59
4 Al Ahly Shendi Ahly Shendi 34 47 34 57
5 Al Khartoum Al Khartoum 34 59 31 56
6 Al Hilal Kadougli Hilal 34 40 32 51
7 Al Ahli Khartoum Ahli 34 45 43 51
8 Al Shorta Al Shorta 34 46 42 50
9 El-Ahli Atbara El-Ahli 34 32 40 44
10 Hay Al Wadi Hay Al Wadi 34 26 38 44
11 Hay Al-Arab Hay Al-Arab 34 27 30 42
12 Merreikh Kosti Merreikh 34 28 43 35
13 Alamal Atbara Alamal 34 32 43 34
14 Merreikh Nyala Merreikh 34 29 42 34
15 Merreikh El-Fasher Merreikh 34 27 47 30
16 Al Rabta Kosti Rabta Kosti 34 23 44 29
17 Triea Albiga Triea Albiga 34 19 50 29
18 Al Ahli Wad Medani Ahli Medani 34 24 55 25

  USO DE MEMORIA  
5,166,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4971
Total Execution Time  0.4983
  CADENA URL  
/historico/Hay-Al-Wadi
  GET DATOS  
$_GET['/historico/Hay-Al-Wadi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100534 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=486 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 486 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  SELECT /*53 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 (640190,432245,425175,420140,337172) ORDER BY n.cover_points DESC, update_date DESC
0.0158  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 = '100534' ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '100534' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160  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=100534 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (70006,63969) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 70006 AND teamId = 100534
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 63969 AND teamId = 100534
0.0146  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 = '100534' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '100534' and rp.type = 4
0.0147  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 = '100534' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 events2023 e ON e.player_id = p.id AND e.league_id = 70006 WHERE rp.league_id = 70006 AND rp.teamId = 100534 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.0146  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 events2023 e ON e.player_id = p.id AND e.league_id = 70006 WHERE rp.league_id = 70006 AND rp.teamId = 100534 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2023 e ON e.player_id = p.id AND e.league_id = 70006 WHERE rp.league_id = 70006 AND rp.teamId = 100534 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 100534 AND l.year <= 2023 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 `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 = 70006 AND t.round = 29 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 `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 = 66732 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.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 `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 = 60559 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.0150  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 = 51166 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.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 = 48562 AND t.round = 14 ORDER BY team.conference 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 = 49742 AND t.round = 4 ORDER BY team.conference 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 `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 = 42638 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 44364 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 37865 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC