4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Raja
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
SEGUNDA EGIPTO GRUPO 3
Equipo PJ GF GC Puntos
1 Ghazl El Mehalla Ghazl 22 32 11 47
2 Pharco FC Pharco FC 22 28 10 45
3 Dekernes SC Dekernes SC 22 27 17 37
4 Alaab Damanhour Alaab 22 28 24 37
5 El Mansura El Mansura 22 25 21 35
6 Abo Qir Semad Semad 22 28 17 33
7 El Raja El Raja 22 32 29 31
8 El Hammam El Hammam 22 25 28 30
9 El Olympi El Olympi 22 20 18 27
10 Baladiyyat Baladiyyat 22 25 32 25
11 Maleyeit Kafr El Zayiat Maleyeit 22 19 40 8
12 Biyala Biyala 22 10 52 5
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 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 1
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 20 30 10 40
2 Smouha SC Smouha SC 20 24 20 35
3 Al-Ittihad Al-Sakndary Al-Ittihad 20 20 17 31
4 Al Mokawloon Mokawloon 20 27 17 30
5 El Gounah El Gounah 20 17 16 26
6 El Dakhleya El Dakhleya 20 18 19 25
7 Misr El-Makasa Misr 20 17 22 24
8 ENPPI ENPPI 20 19 19 22
9 El Raja El Raja 20 23 34 21
10 Ghazl El Mehalla Ghazl 20 13 21 19
11 El Entag El Harby Entag Harby 20 15 28 14

  USO DE MEMORIA  
5,365,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0729
Total Execution Time  0.0741
  CADENA URL  
/historico/El-Raja
  GET DATOS  
$_GET['/historico/El-Raja']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17368 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
0.0022  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 = '17368' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '17368' 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 = 64658 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=17368 AND l.year in (2021,2022,2023) 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 (64658) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 64658 AND teamId = 17368
0.0022  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 = '17368' 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 = '17368' 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 = '17368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 events2022 e ON e.player_id = p.id AND e.league_id = 64658 WHERE rp.league_id = 64658 AND rp.teamId = 17368 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.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 64658 WHERE rp.league_id = 64658 AND rp.teamId = 17368 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2022 e ON e.player_id = p.id AND e.league_id = 64658 WHERE rp.league_id = 64658 AND rp.teamId = 17368 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 17368 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.0022  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.0022  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 = 58507 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.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 `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.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.0022  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 = 3574 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC