4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al Hilal Kadougli
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 1
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 14 34 10 32
2 Al Khartoum Al Khartoum 14 21 15 24
3 Hilal Obayed Hilal Obayed 14 20 17 19
4 Hay Al Wadi Hay Al Wadi 14 12 16 19
5 Al Mourada Al Mourada 14 13 19 19
6 Alamal Atbara Alamal 14 14 22 17
7 Al Ahli Khartoum Ahli 14 13 15 12
8 Al-Ahly Merowe Al-Ahly 14 10 23 8
9 Al-Hilal Omdurman Al-Hilal 14 31 10 31
10 Al Ahly Shendi Ahly Shendi 14 16 6 28
11 Al Shorta Al Shorta 14 18 17 20
12 Merreikh El-Fasher Merreikh 14 16 15 17
13 Hay Al-Arab Hay Al-Arab 14 12 17 16
14 Al Hilal Kadougli Hilal 14 13 16 15
15 Wad Hashim Sennar Hashim 14 7 14 15
16 Al Rabta Kosti Rabta Kosti 14 7 25 9
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
TEMPORADA 2015/2016
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 34 82 15 87
2 Al-Merreikh SC Al-Merreikh 34 65 29 77
3 Al Ahly Shendi Ahly Shendi 34 68 25 73
4 Hilal Obayed Hilal Obayed 34 48 21 70
5 Al Khartoum Al Khartoum 34 52 22 65
6 Al Hilal Kadougli Hilal 34 39 35 53
7 Merreikh El-Fasher Merreikh 33 32 38 42
8 Alamal Atbara Alamal 35 29 41 41
9 Merreikh Nyala Merreikh 34 28 36 40
10 Al Ahli Wad Medani Ahli Medani 34 33 39 39
11 Al Rabta Kosti Rabta Kosti 33 34 44 35
12 Merreikh Kosti Merreikh 34 22 42 35
13 Al Ahli Khartoum Ahli 35 22 38 34
14 El-Ahli Atbara El-Ahli 34 24 44 34
15 Al-Nil Al-Nil 34 27 53 33
16 Al Amir Al Amir 35 19 57 30
17 Hilal El-Fasher Hilal 33 21 45 26
18 Al Nsoor Al Nsoor 34 18 39 23
TEMPORADA 2014/2015
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 28 60 13 64
2 Al-Hilal Omdurman Al-Hilal 28 39 14 59
3 Al Ahly Shendi Ahly Shendi 28 40 21 53
4 Al Khartoum Al Khartoum 28 41 24 50
5 Merreikh El-Fasher Merreikh 28 25 16 45
6 Hilal Obayed Hilal Obayed 28 29 23 41
7 Merreikh Kosti Merreikh 28 26 30 36
8 Hilal El-Fasher Hilal 28 24 35 35
9 Al Ahli Wad Medani Ahli Medani 28 23 29 34
10 Al Nsoor Al Nsoor 28 30 40 28
11 Al Ahli Khartoum Ahli 28 26 39 28
12 Al Rabta Kosti Rabta Kosti 28 21 34 26
13 Alamal Atbara Alamal 28 29 44 26
14 Al Hilal Kadougli Hilal 28 23 44 26
15 Al Merghani Al Merghani 28 11 41 18
TEMPORADA 2013/2014
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 26 53 8 65
2 Al-Merreikh SC Al-Merreikh 26 56 12 64
3 Al Ahly Shendi Ahly Shendi 26 31 20 42
4 Al Khartoum Al Khartoum 26 31 19 41
5 Al Rabta Kosti Rabta Kosti 26 35 33 40
6 Merreikh El-Fasher Merreikh 26 30 28 40
7 Al Ahli Khartoum Ahli 26 29 28 35
8 Hilal El-Fasher Hilal 26 20 29 32
9 Al Nsoor Al Nsoor 26 19 31 30
10 Alamal Atbara Alamal 26 24 35 29
11 Al Hilal Kadougli Hilal 26 26 35 28
12 El-Ahli Atbara El-Ahli 26 22 34 28
13 Al Nil Al Nil 26 12 45 14
14 Al Ittihad Al Ittihad 26 10 41 10
TEMPORADA 2011/2012
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 26 62 12 70
2 Al-Merreikh SC Al-Merreikh 26 73 15 65
3 Al Ahly Shendi Ahly Shendi 26 29 23 41
4 Al Khartoum Al Khartoum 26 33 36 40
5 Al Nsoor Al Nsoor 26 27 32 34
6 Al Ahli Khartoum Ahli 26 31 36 33
7 Al Nil Al Nil 26 22 29 33
8 Alamal Atbara Alamal 26 20 28 33
9 Al Hilal Kadougli Hilal 26 26 30 32
10 Al-Mawrada Al-Mawrada 26 28 38 29
11 Al Ahli Wad Medani Ahli Medani 26 23 33 27
12 Al Hilal Port Sudan Hilal Port. 26 28 43 27
13 Al Rabta Kosti Rabta Kosti 26 19 36 26
14 Jazeerat Al-Feel Jazeerat 26 19 49 14
TEMPORADA 2010/2011
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 26 69 10 73
2 Al-Hilal Omdurman Al-Hilal 26 68 15 65
3 Alamal Atbara Alamal 26 28 30 42
4 Al Ahly Shendi Ahly Shendi 26 31 27 37
5 Al Khartoum Al Khartoum 26 28 35 34
6 Al Hilal Kadougli Hilal 26 32 44 33
7 Al Ahli Khartoum Ahli 26 29 33 31
8 Al Nsoor Al Nsoor 26 16 26 31
9 Al Hilal Port Sudan Hilal Port. 26 25 39 31
10 Al-Mawrada Al-Mawrada 26 26 35 28
11 Al Nil Al Nil 26 24 33 28
12 Al-Ittihad Madani Al-Ittihad 26 20 31 26
13 Jazeerat Al-Feel Jazeerat 26 22 40 26
14 Hay Al-Arab Hay Al-Arab 26 19 39 20
TEMPORADA 2009/2010
LIGA SUDÁN
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 26 70 13 70
2 Al-Merreikh SC Al-Merreikh 26 65 19 67
3 Al Khartoum Al Khartoum 26 33 31 40
4 Al Nil Al Nil 26 36 32 39
5 Al-Mawrada Al-Mawrada 26 26 35 32
6 Jazeerat Al-Feel Jazeerat 26 28 30 31
7 Hay Al-Arab Hay Al-Arab 26 28 34 31
8 Al Hilal Port Sudan Hilal Port. 26 23 24 30
9 Al Hilal Kadougli Hilal 26 19 32 30
10 Alamal Atbara Alamal 26 28 34 28
11 Al Ahli Khartoum Ahli 26 28 46 27
12 Al-Ittihad Madani Al-Ittihad 26 14 34 26
13 Al Ahli Wad Medani Ahli Medani 26 20 30 23
14 Al Merghani Al Merghani 26 23 47 23
TEMPORADA 2008/2009
LIGA SUDÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 24 60 8 67
2 Al-Merreikh SC Al-Merreikh 24 64 16 60
3 Al Khartoum Al Khartoum 24 28 27 36
4 Alamal Atbara Alamal 24 29 29 35
5 Al Nil Al Nil 24 26 22 32
6 Al Ahli Wad Medani Ahli Medani 24 29 31 31
7 Al-Mawrada Al-Mawrada 24 29 29 29
8 Al Merghani Al Merghani 24 26 31 28
9 Al Hilal Port Sudan Hilal Port. 24 25 43 27
10 Hay Al-Arab Hay Al-Arab 24 25 32 26
11 Al Hilal Kadougli Hilal 24 27 39 22
12 Al-Ittihad Madani Al-Ittihad 24 24 49 22
13 Al Shimali Al Shimali 24 13 49 11
TEMPORADA 2007/2008
LIGA SUDÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 22 66 8 61
2 Al-Hilal Omdurman Al-Hilal 22 63 12 59
3 Hay Al-Arab Hay Al-Arab 22 26 27 37
4 Al-Mawrada Al-Mawrada 22 27 33 33
5 Al Nil Al Nil 22 24 27 30
6 Al Ahli Wad Medani Ahli Medani 22 20 25 30
7 Alamal Atbara Alamal 22 22 32 28
8 Al Khartoum Al Khartoum 22 23 37 24
9 Al Hilal Port Sudan Hilal Port. 22 25 32 22
10 Al-Ittihad Madani Al-Ittihad 22 18 27 19
11 Al Hilal Kadougli Hilal 22 19 43 18
12 Jazeerat Al-Feel Jazeerat 22 17 47 10

  USO DE MEMORIA  
6,178,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9179
Total Execution Time  0.9191
  CADENA URL  
/historico/Al-Hilal-Kadougli
  GET DATOS  
$_GET['/historico/Al-Hilal-Kadougli']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0150  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-Hilal-Kadougli' 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.0158  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-Hilal-Kadougli' 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.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=17292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 60559
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17292 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=486 AND type_rel = 3
0.0147  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.0148  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.0150  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 = '17292' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '17292' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '17292' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = '17292' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 60559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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=17292 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (60559) 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 = 60559 AND teamId = 17292
0.0162  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 = '17292' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17292' and rp.type = 4
0.0155  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 = '17292' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 17292 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.0152  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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 17292 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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 17292 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 17292 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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.0152  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.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 `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.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 `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.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 `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.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 `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
0.0151  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 = 20343 AND t.round = 36 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 `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 = 9445 AND t.round = 30 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 `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 = 3556 AND t.round = 26 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 `tables2012` 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 = 10453 AND t.round = 26 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 `tables2011` 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 = 10458 AND t.round = 26 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 `tables2010` 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 = 10459 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2009` 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 = 10460 AND t.round = 26 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 `tables2008` 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 = 10461 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 60559 ORDER BY nameShow LIMIT 100