4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
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
Ver
TEMPORADA 2022/2023
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
Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
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
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2012/2013
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

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,278,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.0969
Total Execution Time  0.0994
  CADENA URL  
/2nd_division_egipto2024/grupo2/historico
  GET DATOS  
$_GET['/2nd_division_egipto2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0104  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2nd_division_egipto' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 518 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=518 GROUP BY l.year ORDER BY l.year DESC
0.0023  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 518 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0028  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.0032  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.0033  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.0031  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.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 = 58506 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.0028  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.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:57:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:57:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:57:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:57:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0059  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75234 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75234 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75234 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  SELECT *,(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