4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del PetroJet
TEMPORADA 2023/2024
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 PetroJet PetroJet 25 44 18 57
2 Ghazl El Mehalla Ghazl 25 30 16 45
3 Haras El-Hodood Haras 26 33 22 45
4 Wadi Degla Wadi Degla 25 33 19 44
5 La Viena La Viena 26 38 24 43
6 El Sekka El Hadid Sekka Hadid 25 28 18 38
7 Tanta Tanta 25 30 23 37
8 Raya Ghazl Raya Ghazl 25 25 26 35
9 Proxy Proxy 25 25 30 35
10 Olympic El Qanah Olympic 25 23 22 31
TEMPORADA 2022/2023
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 ZED ZED 30 44 19 65
2 Wadi Degla Wadi Degla 30 40 31 55
3 El Sekka El Hadid Sekka Hadid 30 42 27 54
4 Olympic El Qanah Olympic 30 33 25 53
5 PetroJet PetroJet 30 41 23 52
6 Itesalat Itesalat 30 43 31 49
7 Al Tersana Al Tersana 30 31 21 48
8 Shabab Al Obour Shabab Obour 30 24 25 46
9 Montakhab Suez Montakhab 30 39 32 44
10 El Entag El Harby Entag Harby 30 28 29 38
11 Porto Suez Porto Suez 30 30 37 38
12 Al Mostaqbal Mostaqbal 30 32 40 29
13 El Sharkeyah Sharkeyah 30 29 43 28
14 Kahraba Ismailia Kahraba 30 33 42 27
15 Al Nasr Al Nasr 30 24 47 24
16 El Alameen El Alameen 30 13 54 10
TEMPORADA 2021/2022
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 El Dakhleya El Dakhleya 30 48 25 69
2 PetroJet PetroJet 30 42 26 56
3 Wadi Degla Wadi Degla 30 46 36 48
4 ZED ZED 30 28 22 47
5 Olympic El Qanah Olympic 30 29 21 46
6 Al Tersana Al Tersana 30 43 36 45
7 Porto Suez Porto Suez 30 49 48 45
8 El Sekka El Hadid Sekka Hadid 30 33 31 44
9 Itesalat Itesalat 30 33 24 42
10 El Entag El Harby Entag Harby 30 34 32 40
11 Montakhab Suez Montakhab 30 24 27 39
12 Al Nasr Al Nasr 30 33 36 37
13 Al Merreikh Al Merreikh 30 25 36 26
14 Bur Fouad Bur Fouad 30 26 45 23
15 Belbeis Belbeis 30 26 43 21
16 Banha Banha 30 15 46 11
TEMPORADA 2020/2021
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 Porto Suez Porto Suez 24 22 19 38
2 Olympic El Qanah Olympic 24 22 15 36
3 Al Tersana Al Tersana 24 23 17 36
4 El Dakhleya El Dakhleya 24 24 21 36
5 Future FC Future FC 23 25 19 35
6 Montakhab Suez Montakhab 24 17 14 35
7 Al Nasr Al Nasr 24 34 32 32
8 PetroJet PetroJet 24 20 16 31
9 Al Merreikh Al Merreikh 23 16 14 30
10 Gomhoreyat Shepin Gomhoreyat 24 25 25 29
11 ZED ZED 24 19 21 29
12 El Sekka El Hadid Sekka Hadid 24 18 20 29
13 Nogoom Nogoom 24 18 22 27
14 El Zarqa El Zarqa 23 16 27 24
15 Sers Elyan Sers Elyan 24 18 29 23
16 Tanta Tanta 23 17 23 21
TEMPORADA 2019/2020
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 Ceramica Cleopatra Ceramica 22 29 13 43
2 PetroJet PetroJet 22 22 10 42
3 El Dakhleya El Dakhleya 22 32 16 41
4 Al Nasr Al Nasr 22 27 22 33
5 Olympic El Qanah Olympic 22 20 16 33
6 Montakhab Suez Montakhab 22 18 14 33
7 Gomhoreyat Shepin Gomhoreyat 22 12 11 26
8 Nogoom Nogoom 22 25 24 25
9 Al Merreikh Al Merreikh 22 22 33 21
10 Future FC Future FC 22 16 28 20
11 Al Tersana Al Tersana 22 13 30 17
12 El Zarqa El Zarqa 22 15 34 13
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 2017/2018
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 75 19 88
2 Ismaily Ismaily 34 50 27 68
3 Al-Masry Al-Masry 34 52 34 63
4 Zamalek Zamalek 34 45 30 61
5 Smouha SC Smouha SC 34 37 26 51
6 ENPPI ENPPI 34 39 38 50
7 El Entag El Harby Entag Harby 34 36 36 47
8 Misr El-Makasa Misr 34 48 44 46
9 Pyramids Pyramids 34 43 41 42
10 Al Mokawloon Mokawloon 34 42 49 42
11 Al Ittihad Alexandria Ittihad 34 41 43 41
12 PetroJet PetroJet 34 32 40 38
13 Talaea El-Gaish Talaea 34 26 42 38
14 El Dakhleya El Dakhleya 34 37 46 37
15 Wadi Degla Wadi Degla 34 31 46 34
16 El Raja El Raja 34 24 53 27
17 Tanta Tanta 34 27 44 26
18 Al Nasr Al Nasr 34 33 60 22
TEMPORADA 2016/2017
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 62 14 84
2 Misr El-Makasa Misr 34 65 34 74
3 Zamalek Zamalek 34 42 24 66
4 Al-Masry Al-Masry 34 51 36 62
5 Smouha SC Smouha SC 34 49 40 57
6 Ismaily Ismaily 34 48 28 54
7 Talaea El-Gaish Talaea 34 38 43 45
8 Al Ittihad Alexandria Ittihad 34 34 36 44
9 Al Mokawloon Mokawloon 34 34 39 44
10 PetroJet PetroJet 34 24 26 43
11 ENPPI ENPPI 34 45 38 43
12 Wadi Degla Wadi Degla 34 35 38 38
13 El Entag El Harby Entag Harby 34 32 40 33
14 El Dakhleya El Dakhleya 34 31 52 31
15 Tanta Tanta 34 21 39 31
16 Aswan SC Aswan SC 34 28 49 29
17 El Nasr Taadeen Nasr Taadeen 34 27 66 26
18 El Sharkia Zagazig Sharkia 34 24 48 23
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 3
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 3 5 0 7
2 Smouha SC Smouha SC 3 6 2 7
3 Zamalek Zamalek 3 3 3 3
4 PetroJet PetroJet 3 1 10 0
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

  USO DE MEMORIA  
7,183,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6844
Total Execution Time  0.6857
  CADENA URL  
/historico/Petrojet
  GET DATOS  
$_GET['/historico/Petrojet']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0145  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 = 'Petrojet' 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=5287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=5287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0263  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.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 = 74941
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5287 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
0.0133  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 = '5287' ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '5287' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '5287' 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 = 74941 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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.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=5287 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,74941) 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 = 75234 AND teamId = 5287
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 74941 AND teamId = 5287
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 = '5287' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  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 = '5287' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 5287 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.0131  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 = 5287 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 5287 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 5287 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 = 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.0132  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 = 70013 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.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 `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 = 64657 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.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 `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 = 60166 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.0132  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.0132  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 = 39904 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 35508 AND t.round = 34 ORDER BY team.conference 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 `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.0141  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.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 `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.0134  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 = 10299 AND t.round = 3 ORDER BY team.conference 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 `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.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 `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.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 `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.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 `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.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 `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.0128  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.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 `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