4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Asyut Petroleum
TEMPORADA 2023/2024
SEGUNDA EGIPTO GRUPO 3
Equipo PJ GF GC Puntos
1 Abo Qir Semad Semad 26 30 20 42
2 Asyut Petroleum Asyut 25 24 23 36
3 Itesalat Itesalat 26 29 27 36
4 Aswan SC Aswan SC 25 28 23 35
5 Dekernes SC Dekernes SC 26 29 32 33
6 Gomhoreyat Shepin Gomhoreyat 26 19 32 25
7 Makadi Makadi 26 29 35 23
8 Nogoom Nogoom 26 21 43 18
9 Misr El-Makasa Misr 26 26 61 12
10 Al Nasr Taaden Nasr Taaden 26 21 51 8
TEMPORADA 2022/2023
SEGUNDA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 El Gounah El Gounah 30 54 23 69
2 La Viena La Viena 30 51 19 68
3 Asyut Petroleum Asyut 30 40 18 59
4 Al Nasr Taaden Nasr Taaden 30 40 26 53
5 Misr El-Makasa Misr 30 46 41 48
6 El Minya El Minya 30 32 24 46
7 Kima Aswan Kima Aswan 30 34 31 45
8 Dayrout Dayrout 30 40 30 41
9 Aluminium Naq Hammadi Aluminium 30 36 28 40
10 Asmant Asyut Asmant Asyut 30 32 38 38
11 Shoban Moslemen Qena Shoban 30 31 40 30
12 AL Fayoum AL Fayoum 30 26 39 26
13 Tamya Tamya 30 22 44 25
14 Nasr Maloy Nasr Maloy 30 24 53 23
15 Telephonaat Beni Suef Telephonaat 30 26 50 23
16 Madina Monowara Madina 30 27 57 20
TEMPORADA 2021/2022
SEGUNDA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 Aswan SC Aswan SC 30 54 23 70
2 Aluminium Naq Hammadi Aluminium 30 53 27 54
3 Kima Aswan Kima Aswan 30 42 27 53
4 Asyut Petroleum Asyut 30 45 22 52
5 El Minya El Minya 30 43 28 49
6 Telephonaat Beni Suef Telephonaat 30 34 32 44
7 Tamya Tamya 30 40 38 38
8 Madina Monowara Madina 30 36 35 37
9 El Alameen El Alameen 30 25 28 37
10 AL Fayoum AL Fayoum 30 28 34 37
11 Nasr Maloy Nasr Maloy 30 32 38 35
12 Dayrout Dayrout 30 25 37 35
13 Beni Suef Beni Suef 30 33 39 33
14 Sohag Sohag 30 30 38 33
15 Qena Qena 30 30 65 17
16 El Badari El Badari 30 18 57 16
TEMPORADA 2020/2021
SEGUNDA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 El Sharkeyah Sharkeyah 30 50 29 59
2 Aluminium Naq Hammadi Aluminium 30 40 23 57
3 El Minya El Minya 30 38 23 55
4 El Alameen El Alameen 30 35 28 46
5 AL Fayoum AL Fayoum 30 30 25 43
6 Asyut Petroleum Asyut 30 26 21 43
7 Beni Suef Beni Suef 30 28 28 43
8 Sohag Sohag 30 22 21 40
9 Dayrout Dayrout 30 45 43 38
10 Qena Qena 30 29 32 36
11 Kima Aswan Kima Aswan 30 27 30 36
12 Telephonaat Beni Suef Telephonaat 30 24 25 35
13 Shoban Moslemen Qena Shoban 30 20 26 33
14 Asmant Asyut Asmant Asyut 30 29 37 33
15 Markaz Shabab Markaz 30 21 36 29
16 Tahta Tahta 30 27 64 15
TEMPORADA 2019/2020
SEGUNDA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 Beni Suef Beni Suef 22 31 12 44
2 National Bank of Egypt National 22 29 12 44
3 Aluminium Naq Hammadi Aluminium 22 33 17 43
4 Shoban Moslemen Qena Shoban 22 18 19 35
5 Asyut Petroleum Asyut 22 25 24 33
6 El Minya El Minya 22 29 23 32
7 Telephonaat Beni Suef Telephonaat 22 21 21 30
8 Sohag Sohag 22 18 17 28
9 El Alameen El Alameen 22 20 31 22
10 AL Fayoum AL Fayoum 22 17 25 21
11 Dayrout Dayrout 22 21 41 15
12 Tahta Tahta 22 16 36 13
TEMPORADA 2012/2013
SEGUNDA EGIPTO GRUPO 2
Equipo PJ GF GC Puntos
1 Asyut Petroleum Asyut 22 50 22 48
2 El Minya El Minya 22 33 24 43
3 Sokar El Hawamidiya Sokar 22 24 19 38
4 Bani Sweef Bani Sweef 22 25 17 37
5 El Wasty El Wasty 22 31 22 32
6 Samlot Samlot 22 37 34 29
7 Magagh Magagh 22 24 23 27
8 AL Fayoum AL Fayoum 22 24 32 27
9 Manflot Manflot 22 21 30 25
10 Naser Al Fekrya Naser Fekrya 22 23 31 24
11 Dayrot Dayrot 22 15 31 17
12 MS Ebshway MS Ebshway 22 19 41 13
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 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  
5,876,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4770
Total Execution Time  0.4783
  CADENA URL  
/historico/Asyut-Petroleum
  GET DATOS  
$_GET['/historico/Asyut-Petroleum']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0299  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 = 75235
0.0153  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.0153  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.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15322 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
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 = '15322' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0146  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.0148  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=15322 AND l.year in (2023,2024,2025) 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 (75235,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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 75235 AND teamId = 15322
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 74941 AND teamId = 15322
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 = 15322 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 75235 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 `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 = 70012 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.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 `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 = 64656 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 60165 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.0147  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 = 58505 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 3301 AND t.round = 22 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 `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.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 `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.0158  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