4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al Hudod
TEMPORADA 2023/2024
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 26 50 20 59
2 Al Shorta Al Shorta 27 56 27 58
3 Al Zawraa Al Zawraa 27 38 15 52
4 Zakho Zakho 26 23 10 47
5 Al Najaf Al Najaf 27 30 20 46
6 Newroz SC Newroz SC 26 44 30 41
7 Duhok Duhok 27 26 22 41
8 Al Naft Al Naft 26 30 28 38
9 Al Hudod Al Hudod 27 28 35 37
10 Naft Maysan Naft Maysan 27 31 26 36
11 Al Talaba Al Talaba 23 27 26 34
12 Al Minaa Al Minaa 27 24 44 31
13 Al Kahrabaa Al Kahrabaa 26 33 33 29
14 Karbala Karbala 26 28 42 26
15 Al Karkh Al Karkh 27 23 32 25
16 Naft Al-Basra Naft 27 22 34 25
17 Erbil Erbil 25 27 34 24
18 Al-Qasim Al-Qasim 27 28 42 18
19 Baghdad FC Baghdad FC 27 21 39 18
20 Naft Al-Wasat Naft 27 10 40 12
TEMPORADA 2022/2023
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 37 61 23 79
2 Al Quwa Al Jawiya Quwa Jawiya 38 62 26 78
3 Al Zawraa Al Zawraa 38 50 32 68
4 Al Talaba Al Talaba 38 52 39 66
5 Al Kahrabaa Al Kahrabaa 38 51 38 62
6 Erbil Erbil 38 44 39 58
7 Al Najaf Al Najaf 38 46 41 56
8 Karbala Karbala 38 39 34 56
9 Al Karkh Al Karkh 38 40 36 51
10 Newroz SC Newroz SC 38 45 43 51
11 Naft Maysan Naft Maysan 38 42 54 51
12 Duhok Duhok 38 34 39 50
13 Al Hudod Al Hudod 37 39 35 49
14 Naft Al-Basra Naft 38 34 40 43
15 Zakho Zakho 38 39 42 42
16 Al-Qasim Al-Qasim 38 31 40 40
17 Al Naft Al Naft 38 39 50 40
18 Naft Al-Wasat Naft 38 26 34 36
19 Al Sinaah Al Sinaah 38 26 54 28
20 Al Diwaniya Al Diwaniya 38 25 86 12
TEMPORADA 2020/2021
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 38 68 29 83
2 Al Zawraa Al Zawraa 38 46 19 75
3 Al Najaf Al Najaf 38 46 26 74
4 Al Shorta Al Shorta 38 60 27 72
5 Naft Al-Wasat Naft 38 46 31 63
6 Al Naft Al Naft 38 36 34 53
7 Baghdad FC Baghdad FC 38 30 32 50
8 Al Minaa Al Minaa 38 45 44 49
9 Zakho Zakho 38 35 40 46
10 Al Karkh Al Karkh 38 35 40 45
11 Naft Al-Janoob Naft 38 35 45 44
12 Naft Misan Naft Misan 38 38 48 43
13 Erbil Erbil 37 38 41 41
14 Al Kahrabaa Al Kahrabaa 38 36 39 41
15 Al-Qasim Al-Qasim 38 39 50 41
16 Al Diwaniya Al Diwaniya 38 22 36 41
17 Al Talaba Al Talaba 38 36 47 39
18 Alsinat Alkahrabaiya Alsinat 38 27 39 37
19 Al Hudod Al Hudod 37 32 47 31
20 Al Simawa Al Simawa 38 22 58 26
TEMPORADA 2019/2020
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Naft Al Naft 5 6 1 11
2 Al Quwa Al Jawiya Quwa Jawiya 4 7 2 10
3 Naft Al-Wasat Naft 5 3 2 9
4 Al Najaf Al Najaf 4 5 1 8
5 Al Simawa Al Simawa 3 2 0 7
6 Al Talaba Al Talaba 5 7 6 7
7 Al Diwaniya Al Diwaniya 4 3 3 7
8 Al Hudod Al Hudod 4 4 3 6
9 Erbil Erbil 5 5 6 6
10 Alsinat Alkahrabaiya Alsinat 5 6 11 6
11 Al Shorta Al Shorta 3 7 5 5
12 Naft Al-Janoob Naft 5 1 4 4
13 Baghdad FC Baghdad FC 5 2 5 3
14 Al Kahrabaa Al Kahrabaa 5 3 7 2
15 Naft Misan Naft Misan 4 2 7 0
TEMPORADA 2018/2019
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 38 73 22 89
2 Al Quwa Al Jawiya Quwa Jawiya 38 58 27 84
3 Al Zawraa Al Zawraa 38 57 40 65
4 Al Naft Al Naft 38 60 39 63
5 Naft Maysan Naft Maysan 38 57 47 59
6 Al Karkh Al Karkh 38 44 35 57
7 Naft Al-Wasat Naft 38 38 37 50
8 Baghdad FC Baghdad FC 38 36 35 50
9 Al Hudod Al Hudod 38 35 41 50
10 Al Kahrabaa Al Kahrabaa 38 41 41 48
11 Erbil Erbil 38 34 36 48
12 Al Najaf Al Najaf 38 41 43 44
13 Al Talaba Al Talaba 38 47 52 44
14 Al Diwaniya Al Diwaniya 38 32 43 44
15 Naft Al-Janoob Naft 38 37 53 42
16 Alsinat Alkahrabaiya Alsinat 38 30 38 41
17 Al Minaa Al Minaa 38 34 42 40
18 Al Simawa Al Simawa 38 26 59 33
19 Al Bahri Al Bahri 38 39 66 29
20 Al Hussein Al Hussein 38 29 52 27
TEMPORADA 2017/2018
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Zawraa Al Zawraa 38 66 26 88
2 Al Quwa Al Jawiya Quwa Jawiya 38 66 23 84
3 Al Naft Al Naft 38 59 20 84
4 Al Shorta Al Shorta 38 69 24 83
5 Al Kahrabaa Al Kahrabaa 38 39 30 58
6 Al Najaf Al Najaf 38 50 40 55
7 Baghdad FC Baghdad FC 38 31 34 53
8 Naft Maysan Naft Maysan 38 45 36 49
9 Naft Al-Wasat Naft 38 42 38 49
10 Naft Al-Janoob Naft 38 34 41 49
11 Alsinat Alkahrabaiya Alsinat 38 46 46 47
12 Al Simawa Al Simawa 38 42 50 44
13 Al Hudod Al Hudod 38 40 45 43
14 Al Talaba Al Talaba 38 43 59 43
15 Al Minaa Al Minaa 38 34 47 41
16 Al Bahri Al Bahri 38 41 55 38
17 Al Diwaniya Al Diwaniya 38 32 58 31
18 Al Hussein Al Hussein 38 26 58 27
19 Karbala Karbala 38 26 76 27
20 Zakho Zakho 38 27 52 25
TEMPORADA 2016/2017
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 36 59 23 81
2 Al Naft Al Naft 36 61 17 77
3 Al Shorta Al Shorta 36 55 26 75
4 Al Zawraa Al Zawraa 36 67 28 72
5 Naft Al-Wasat Naft 36 45 26 68
6 Al Minaa Al Minaa 36 40 24 66
7 Al Talaba Al Talaba 36 51 38 54
8 Baghdad FC Baghdad FC 36 26 21 51
9 Al Najaf Al Najaf 36 41 38 49
10 Naft Al-Janoob Naft 36 36 42 39
11 Naft Maysan Naft Maysan 36 28 36 39
12 Al Hudod Al Hudod 36 35 46 38
13 Al Kahrabaa Al Kahrabaa 36 24 36 38
14 Al Bahri Al Bahri 36 42 63 35
15 Karbala Karbala 36 24 46 33
16 Zakho Zakho 36 18 51 24
17 Al Hussein Al Hussein 36 23 52 23
18 Al Simawa Al Simawa 36 26 47 22
19 Al Karkh Al Karkh 36 24 65 20
20 Erbil Erbil 0 0 0 0
TEMPORADA 2015/2016
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Zawraa Al Zawraa 17 24 10 39
2 Naft Al-Wasat Naft 17 24 14 35
3 Al Naft Al Naft 17 21 10 32
4 Al Talaba Al Talaba 17 20 14 27
5 Naft Maysan Naft Maysan 17 16 16 24
6 Al Kahrabaa Al Kahrabaa 17 9 17 16
7 Naft Al-Janoob Naft 17 15 20 15
8 Al Karkh Al Karkh 17 11 20 12
9 Al Simawa Al Simawa 17 14 26 10
10 Duhok Duhok 9 8 15 7
11 Al Quwa Al Jawiya Quwa Jawiya 17 22 11 33
12 Al Minaa Al Minaa 18 27 17 32
13 Baghdad FC Baghdad FC 18 22 17 30
14 Al Shorta Al Shorta 18 20 19 29
15 Zakho Zakho 18 17 10 28
16 Erbil Erbil 17 19 17 23
17 Al Najaf Al Najaf 18 13 22 23
18 Karbala Karbala 18 17 16 22
19 Al Hudod Al Hudod 18 11 23 12
20 Al Sinaah Al Sinaah 18 8 24 10
TEMPORADA 2014/2015
IRAQ STARS LEAGUE GRUPO 1
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 18 20 10 33
2 Al Zawraa Al Zawraa 18 21 16 33
3 Naft Al-Janoob Naft 18 20 17 30
4 Naft Al-Wasat Naft 18 16 12 28
5 Al Karkh Al Karkh 18 20 18 26
6 Erbil Erbil 18 21 17 25
7 Zakho Zakho 18 14 22 20
8 Karbala Karbala 18 12 18 19
9 Al Kahrabaa Al Kahrabaa 18 18 23 16
10 Al-Masafi Al-Masafi 18 16 25 14
11 Al Shorta Al Shorta 16 32 7 40
12 Al Minaa Al Minaa 16 22 18 25
13 Baghdad FC Baghdad FC 16 19 16 24
14 Duhok Duhok 17 19 21 24
15 Al Talaba Al Talaba 17 19 18 20
16 Al Hudod Al Hudod 17 16 21 19
17 Al Naft Al Naft 17 18 21 18
18 Naft Maysan Naft Maysan 16 14 20 17
19 Al Najaf Al Najaf 16 10 20 15
20 Al Sulimaniya Sulimaniya 4 0 7 0

  USO DE MEMORIA  
6,065,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5077
Total Execution Time  0.5089
  CADENA URL  
/historico/Al-Hudod
  GET DATOS  
$_GET['/historico/Al-Hudod']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
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 = 'Al-Hudod' 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.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=60135 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=60135 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 = 74409
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60135 AND type_rel = 2
0.0139  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 = '60135' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '60135' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '60135' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 74409 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=60135 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74409) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 74409 AND teamId = 60135
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 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 = 74409 AND t.round = 27 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 = '60135' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60135' and rp.type = 4
0.0130  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 = '60135' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 60135 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.0151  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 60135 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 60135 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 60135 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 74409 AND t.round = 27 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 `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 = 70002 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.0154  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 = 59800 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.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 `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 = 51287 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 45268 AND t.round = 38 ORDER BY team.conference 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 `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 = 42074 AND t.round = 38 ORDER BY team.conference 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 `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 = 36091 AND t.round = 37 ORDER BY team.conference 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 `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 = 15621 AND t.round = 18 ORDER BY team.conference 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 `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 = 12134 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC