4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Haras El-Hodood
TEMPORADA 2023/2024
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 PetroJet PetroJet 27 48 20 61
2 Ghazl El Mehalla Ghazl 27 32 17 49
3 Haras El-Hodood Haras 27 34 22 48
4 Wadi Degla Wadi Degla 27 35 23 45
5 La Viena La Viena 27 39 26 43
6 Tanta Tanta 27 31 24 40
7 El Sekka El Hadid Sekka Hadid 27 28 22 38
8 Proxy Proxy 27 27 32 37
9 Raya Ghazl Raya Ghazl 27 26 27 37
10 Olympic El Qanah Olympic 27 27 23 35
TEMPORADA 2022/2023
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 63 13 83
2 Pyramids Pyramids 34 58 24 73
3 Zamalek Zamalek 34 52 36 60
4 Future FC Future FC 34 34 23 58
5 Al-Masry Al-Masry 34 34 33 48
6 ENPPI ENPPI 34 34 40 45
7 Al Mokawloon Mokawloon 34 35 33 44
8 Al Ittihad Alexandria Ittihad 34 36 43 43
9 Pharco FC Pharco FC 34 31 34 42
10 Smouha SC Smouha SC 34 36 43 42
11 Ismaily Ismaily 34 35 38 40
12 National Bank of Egypt National 34 35 40 39
13 Ceramica Cleopatra Ceramica 34 31 32 37
14 Talaea El-Gaish Talaea 34 33 45 36
15 El Dakhleya El Dakhleya 34 32 43 35
16 Aswan SC Aswan SC 34 31 45 33
17 Ghazl El Mehalla Ghazl 34 26 47 33
18 Haras El-Hodood Haras 34 21 45 25
TEMPORADA 2021/2022
SEGUNDA EGIPTO GRUPO 3
Equipo PJ GF GC Puntos
1 Haras El-Hodood Haras 30 43 15 60
2 Dekernes SC Dekernes SC 30 41 20 56
3 El Olympi El Olympi 30 44 31 54
4 Abo Qir Semad Semad 30 45 27 51
5 Baladiyyat Baladiyyat 30 39 24 51
6 El Magd El Magd 30 32 21 47
7 Kafr El Shaikh Kafr Shaikh 30 36 25 45
8 Al Masry Salloum Masry 30 37 22 43
9 Alexandria SC Alexandria 30 42 29 43
10 Pioneers Pioneers 30 37 31 40
11 El Mansura El Mansura 30 27 29 39
12 El Hammam El Hammam 30 31 31 35
13 Alaab Damanhour Alaab 30 29 38 28
14 El Zarqa El Zarqa 30 24 48 22
15 Sed Elmahla Sed Elmahla 30 27 53 17
16 El Raja El Raja 30 6 96 5
TEMPORADA 2020/2021
SEGUNDA EGIPTO GRUPO 3
Equipo PJ GF GC Puntos
1 Pharco FC Pharco FC 23 41 16 48
2 Haras El-Hodood Haras 23 33 9 48
3 El Olympi El Olympi 23 30 19 41
4 Abo Qir Semad Semad 23 36 23 39
5 Baladiyyat Baladiyyat 23 27 16 37
6 Dekernes SC Dekernes SC 23 25 19 33
7 El Raja El Raja 23 18 17 30
8 Alexandria SC Alexandria 23 20 22 29
9 El Mansura El Mansura 23 16 20 26
10 Alaab Damanhour Alaab 23 17 28 25
11 Matroh Matroh 23 20 34 25
12 Maleyeit Kafr El Zayiat Maleyeit 23 18 23 23
13 Kafr El Shaikh Kafr Shaikh 23 15 24 22
14 El Hammam El Hammam 23 16 27 20
15 Biyala Biyala 23 14 34 16
16 Bani Ebeid Bani Ebeid 23 9 24 15
TEMPORADA 2019/2020
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 74 8 89
2 Zamalek Zamalek 34 50 27 71
3 Pyramids Pyramids 34 54 33 65
4 Al Mokawloon Mokawloon 34 45 34 54
5 Smouha SC Smouha SC 34 44 33 51
6 Al-Masry Al-Masry 34 36 35 48
7 ENPPI ENPPI 34 34 33 48
8 El Entag El Harby Entag Harby 34 35 38 44
9 Misr El-Makasa Misr 34 40 39 42
10 Al Ittihad Alexandria Ittihad 34 36 36 42
11 Ismaily Ismaily 34 38 48 41
12 Talaea El-Gaish Talaea 34 31 37 39
13 El Gounah El Gounah 34 32 45 37
14 Aswan SC Aswan SC 34 39 50 37
15 Wadi Degla Wadi Degla 34 32 43 35
16 Haras El-Hodood Haras 34 31 41 33
17 Tanta Tanta 34 22 55 22
18 ZED ZED 34 18 56 22
TEMPORADA 2018/2019
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 56 20 80
2 Zamalek Zamalek 34 65 31 72
3 Pyramids Pyramids 34 61 31 70
4 Al-Masry Al-Masry 34 45 38 52
5 Al Mokawloon Mokawloon 34 45 38 48
6 Misr El-Makasa Misr 34 34 36 46
7 Ismaily Ismaily 34 30 36 43
8 Talaea El-Gaish Talaea 34 41 39 41
9 ENPPI ENPPI 34 39 42 40
10 Wadi Degla Wadi Degla 34 41 47 40
11 Al Ittihad Alexandria Ittihad 34 41 56 39
12 Haras El-Hodood Haras 34 30 37 38
13 El Entag El Harby Entag Harby 34 36 44 38
14 Smouha SC Smouha SC 34 33 41 38
15 El Gounah El Gounah 34 38 52 38
16 PetroJet PetroJet 34 30 43 35
17 El Dakhleya El Dakhleya 34 34 52 27
18 Nogoom Nogoom 34 30 46 26
TEMPORADA 2015/2016
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 65 24 76
2 Zamalek Zamalek 34 49 25 69
3 Smouha SC Smouha SC 34 45 37 55
4 Al-Masry Al-Masry 34 50 37 55
5 Wadi Degla Wadi Degla 34 38 31 54
6 Ismaily Ismaily 34 47 36 53
7 El Entag El Harby Entag Harby 34 38 26 52
8 El Dakhleya El Dakhleya 34 35 33 50
9 Misr El-Makasa Misr 34 47 41 47
10 ENPPI ENPPI 34 42 39 47
11 PetroJet PetroJet 34 35 31 46
12 Al Mokawloon Mokawloon 34 34 42 41
13 Talaea El-Gaish Talaea 34 34 35 41
14 Al Ittihad Alexandria Ittihad 34 26 44 39
15 Aswan SC Aswan SC 34 28 44 35
16 Ittihad El-Shorta Ittihad 34 30 48 25
17 Haras El-Hodood Haras 34 17 52 19
18 Ghazl El Mehalla Ghazl 34 16 51 13
TEMPORADA 2014/2015
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Zamalek Zamalek 38 69 21 87
2 Al-Ahly Al-Ahly 38 65 26 79
3 ENPPI ENPPI 38 65 29 70
4 Misr El-Makasa Misr 38 57 51 64
5 Wadi Degla Wadi Degla 38 46 36 57
6 Ismaily Ismaily 38 44 32 55
7 Al Mokawloon Mokawloon 38 47 41 55
8 Haras El-Hodood Haras 38 30 31 52
9 Talaea El-Gaish Talaea 38 49 56 52
10 Smouha SC Smouha SC 38 43 37 51
11 Al-Masry Al-Masry 38 37 41 50
12 El Dakhleya El Dakhleya 38 43 41 49
13 PetroJet PetroJet 38 49 53 49
14 Al Ittihad Alexandria Ittihad 38 39 38 48
15 Ittihad El-Shorta Ittihad 38 36 42 47
16 El Gounah El Gounah 38 33 35 46
17 El Raja El Raja 38 47 57 43
18 Al Nasr Al Nasr 38 34 70 29
19 Pyramids Pyramids 38 40 88 16
20 Alaab Damanhour Alaab 38 34 82 14
TEMPORADA 2013/2014
LIGA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 Zamalek Zamalek 20 35 21 35
2 PetroJet PetroJet 20 28 17 35
3 Ittihad El-Shorta Ittihad 20 25 16 35
4 Ismaily Ismaily 20 24 16 32
5 Talaea El-Gaish Talaea 20 19 17 25
6 Wadi Degla Wadi Degla 20 26 24 24
7 Al-Masry Al-Masry 20 17 20 24
8 Haras El-Hodood Haras 20 11 15 24
9 Telephonat Beni Sweif Telephonat 20 16 22 22
10 Olympic El Qanah Olympic 20 14 24 22
11 El Minya El Minya 20 15 38 12
TEMPORADA 2012/2013
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 15 27 10 39
2 ENPPI ENPPI 15 24 15 29
3 Smouha SC Smouha SC 16 19 9 27
4 Telephonat Beni Sweif Telephonat 15 10 10 21
5 Haras El-Hodood Haras 15 14 16 17
6 El Gounah El Gounah 15 12 19 14
7 Wadi Degla Wadi Degla 15 12 20 14
8 Misr El-Makasa Misr 15 9 17 12
9 Ghazl El Mehalla Ghazl 15 14 25 11
10 Zamalek Zamalek 15 26 11 39
11 Ismaily Ismaily 16 20 11 30
12 Ittihad El-Shorta Ittihad 15 21 15 22
13 Talaea El-Gaish Talaea 15 19 21 20
14 Al Mokawloon Mokawloon 15 21 20 19
15 El Dakhleya El Dakhleya 15 10 11 19
16 PetroJet PetroJet 15 16 21 17
17 Ittihad Bnei Sakhnin Ittihad Bnei 15 10 19 14
18 El Entag El Harby Entag Harby 15 9 23 6
TEMPORADA 2011/2012
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Haras El-Hodood Haras 14 25 9 37
2 Al-Ahly Al-Ahly 15 28 12 36
3 Zamalek Zamalek 14 27 11 32
4 Al-Masry Al-Masry 15 17 10 26
5 Ittihad El-Shorta Ittihad 15 16 10 26
6 Ismaily Ismaily 14 17 13 25
7 Misr El-Makasa Misr 15 29 19 24
8 ENPPI ENPPI 16 28 25 24
9 El Gounah El Gounah 16 22 18 22
10 Wadi Degla Wadi Degla 14 17 15 19
11 Telephonat Beni Sweif Telephonat 16 16 21 19
12 Talaea El-Gaish Talaea 16 19 21 17
13 Ittihad Bnei Sakhnin Ittihad Bnei 16 14 21 15
14 Smouha SC Smouha SC 15 15 23 13
15 PetroJet PetroJet 14 12 21 11
16 Ghazl El Mehalla Ghazl 14 11 29 11
17 Al Mokawloon Mokawloon 15 17 24 10
18 El Entag El Harby Entag Harby 17 8 26 9
19 El Dakhleya El Dakhleya 15 12 22 8
TEMPORADA 2010/2011
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 47 27 61
2 Zamalek Zamalek 30 49 32 56
3 Ismaily Ismaily 30 48 33 49
4 Ittihad El-Shorta Ittihad 30 31 23 47
5 ENPPI ENPPI 30 37 30 47
6 Misr El-Makasa Misr 30 41 28 45
7 Al-Masry Al-Masry 30 28 22 43
8 Haras El-Hodood Haras 30 40 39 39
9 Talaea El-Gaish Talaea 30 25 31 36
10 PetroJet PetroJet 30 31 38 35
11 El Gounah El Gounah 30 26 33 34
12 Wadi Degla Wadi Degla 30 39 50 33
13 El Entag El Harby Entag Harby 30 33 44 33
14 Ittihad Bnei Sakhnin Ittihad Bnei 30 37 51 30
15 Smouha SC Smouha SC 30 33 45 28
16 Al Mokawloon Mokawloon 30 27 46 24
TEMPORADA 2009/2010
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 47 23 65
2 Zamalek Zamalek 30 43 26 55
3 Ismaily Ismaily 30 34 25 48
4 Ittihad El-Shorta Ittihad 30 35 24 47
5 PetroJet PetroJet 30 42 37 47
6 Haras El-Hodood Haras 30 39 31 45
7 El Entag El Harby Entag Harby 30 36 32 41
8 ENPPI ENPPI 30 29 35 41
9 Al-Jaish Al-Jaish 30 42 38 40
10 Ittihad El-Iskandary Ittihad 30 27 36 35
11 Al Mokawloon Mokawloon 30 36 34 34
12 El Gounah El Gounah 29 26 30 34
13 Al-Masry Al-Masry 30 28 35 34
14 Ghazl El Mehalla Ghazl 29 15 30 28
15 El Mansura El Mansura 30 21 37 19
16 Asyut Petroleum Asyut 30 29 56 19
TEMPORADA 2008/2009
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 52 25 63
2 Ismaily Ismaily 30 52 31 63
3 PetroJet PetroJet 30 47 38 51
4 Haras El-Hodood Haras 30 34 22 50
5 ENPPI ENPPI 30 49 39 49
6 Zamalek Zamalek 30 34 29 42
7 Al-Jaish Al-Jaish 30 40 51 38
8 Al-Masry Al-Masry 30 36 34 37
9 Al Mokawloon Mokawloon 30 36 37 37
10 Ittihad El-Shorta Ittihad 30 28 29 37
11 Ittihad El-Iskandary Ittihad 30 29 35 37
12 Ghazl El Mehalla Ghazl 30 20 26 33
13 Asyut Petroleum Asyut 30 25 39 33
14 Itesalat Itesalat 30 43 46 32
15 Al Tersana Al Tersana 30 29 45 24
16 Olympia Alexandria Olympia 30 30 58 24
TEMPORADA 2007/2008
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 47 22 70
2 Ismaily Ismaily 30 47 27 53
3 Zamalek Zamalek 30 45 30 53
4 Al-Jaish Al-Jaish 30 33 22 51
5 PetroJet PetroJet 30 51 38 46
6 Haras El-Hodood Haras 30 38 26 46
7 ENPPI ENPPI 30 42 33 46
8 Ghazl El Mehalla Ghazl 30 45 37 43
9 Al-Masry Al-Masry 30 29 32 34
10 Ittihad El-Iskandary Ittihad 30 32 39 33
11 Al Tersana Al Tersana 30 30 40 32
12 Al Mokawloon Mokawloon 30 34 38 31
13 Itesalat Itesalat 30 25 46 31
14 Aluminium Naq Hammadi Aluminium 30 29 50 30
15 Baladiyyat Baladiyyat 30 24 41 25
16 Suez Cement Suez Cement 30 28 58 22
TEMPORADA 2006/2007
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 64 17 73
2 Zamalek Zamalek 30 58 23 68
3 Ismaily Ismaily 30 64 23 67
4 Al-Jaish Al-Jaish 30 31 29 44
5 Haras El-Hodood Haras 30 36 39 44
6 Ghazl El Mehalla Ghazl 30 33 28 42
7 PetroJet PetroJet 30 36 39 40
8 Al Mokawloon Mokawloon 30 21 30 37
9 ENPPI ENPPI 30 21 26 35
10 Al-Masry Al-Masry 30 23 33 35
11 Suez Cement Suez Cement 30 25 39 33
12 Al Tersana Al Tersana 30 26 28 31
13 Ittihad El-Iskandary Ittihad 30 27 40 31
14 Tanta Tanta 30 20 37 26
15 Asyut Petroleum Asyut 30 21 44 22
16 Olympia Alexandria Olympia 30 22 53 22
TEMPORADA 2005/2006
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 26 57 6 72
2 Zamalek Zamalek 26 48 22 58
3 ENPPI ENPPI 26 32 18 46
4 Ismaily Ismaily 26 33 32 39
5 Haras El-Hodood Haras 26 35 24 38
6 Talaea El-Gaish Talaea 26 27 31 34
7 Al Ittihad Alexandria Ittihad 26 18 28 32
8 Al-Masry Al-Masry 26 27 30 31
9 Al Mokawloon Mokawloon 26 26 34 28
10 Suez Cement Suez Cement 26 28 45 28
11 Ghazl El Mehalla Ghazl 26 21 34 27
12 Asmant Asyut Asmant Asyut 26 26 36 26
13 Aluminium Naq Hammadi Aluminium 26 16 36 25
14 El Koroum El Koroum 26 22 40 20
TEMPORADA 2004/2005
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 26 59 13 74
2 ENPPI ENPPI 26 43 26 43
3 Haras El-Hodood Haras 26 42 33 39
4 Ismaily Ismaily 26 30 25 39
5 Suez Cement Suez Cement 26 29 31 37
6 Zamalek Zamalek 26 37 31 36
7 Al-Masry Al-Masry 26 29 22 32
8 Ghazl El Mehalla Ghazl 26 25 28 31
9 Al Ittihad Alexandria Ittihad 26 26 37 31
10 Talaea El-Gaish Talaea 26 23 33 30
11 Asmant Asyut Asmant Asyut 26 24 36 29
12 Baladiyyat Baladiyyat 26 27 42 26
13 Al Tersana Al Tersana 26 24 41 25
14 El Mansura El Mansura 26 17 37 20

  USO DE MEMORIA  
7,088,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1462
Total Execution Time  0.1473
  CADENA URL  
/historico/Haras-Hodood
  GET DATOS  
$_GET['/historico/Haras-Hodood']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0034  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 = 'Haras-Hodood' 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.0020  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=5281 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5281 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=5281 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 75234
0.0026  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 = 73991
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5281 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
0.0026  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 = '5281' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '5281' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '5281' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73991 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=5281 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75234,71621,70707,70087) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70087 AND teamId = 5281
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75234 AND teamId = 5281
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 70707 AND teamId = 5281
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71621 AND teamId = 5281
0.0022  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 = 75234 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '5281' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5281' 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 = '5281' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 75234 WHERE rp.league_id = 75234 AND rp.teamId = 5281 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.0019  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 = 75234 WHERE rp.league_id = 75234 AND rp.teamId = 5281 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75234 WHERE rp.league_id = 75234 AND rp.teamId = 5281 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 5281 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 73991 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 75234 AND t.round = 8 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 `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 = 70087 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.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 `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 = 64658 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.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 `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 = 60167 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.0023  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 = 51406 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.0023  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 = 44243 AND t.round = 34 ORDER BY team.conference 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 `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 = 19337 AND t.round = 34 ORDER BY team.conference 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 `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 = 8378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 3573 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2013` 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 = 2212 AND t.round = 18 ORDER BY team.conference 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 `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 = 1570 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1258 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 10329 AND t.round = 30 ORDER BY team.conference 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 `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 = 10330 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 10333 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 10332 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2006` 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 = 15409 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2005` 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 = 15410 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC