4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
3 jugadores
Al-Nahda Al-Nahda
A. Al-Rashidi A. Al-Rashidi
F. Al Hajri F. Al Hajri 32 años DEF
J. Béhé J. Béhé 35 años 187cm 75kg DEL
9 jugadores
Dhofar Dhofar
Al Najjar Ghazi Al Najjar Ghazi
Y. Sikh Y. Sikh
A. Salem A. Salem
Harib Al Saadi Harib Al Saadi 34 años 168cm MED
Abdullah Fawaz Abdullah Fawaz 27 años MED
O. Al-Malki O. Al-Malki 30 años MED
K. Al Hajri K. Al Hajri 30 años DEL
L. Bekui L. Bekui 29 años 184cm 80kg DEL
Yazed Al-Maashani Yazed Al-Maashani 25 años 179cm DEL
5 jugadores
Al-Suwaiq Al-Suwaiq
Patrick Patrick
M. Al Balushi M. Al Balushi 34 años 183cm 87kg DEF
D. Barboza D. Barboza 34 años MED
Wal Wal 30 años 172cm 65kg DEL
Issam Al Sabhi Issam Al Sabhi 27 años 180cm DEL
6 jugadores
Al-Nasr Salalah Al-Nasr Salalah
Y. Al Rajibi Y. Al Rajibi
J. Al Noubi J. Al Noubi
Matheus Índio Matheus Índio 28 años 179cm 70kg MED
H. Al Habsi H. Al Habsi 30 años MED
Abdullah Noah Abdullah Noah MED
M. Kabiru M. Kabiru 37 años 175cm DEL
5 jugadores
Al-Seeb Al-Seeb
A. Al Busaidi A. Al Busaidi 33 años DEF
A. Al-Harthi A. Al-Harthi 30 años DEF
S. Al Yahyaei S. Al Yahyaei MED
Z. Al-Aghbari Z. Al-Aghbari 24 años 178cm MED
A. Al Muqbali A. Al Muqbali 35 años DEL
5 jugadores
Saham Saham
S. Al Biriki S. Al Biriki 29 años
Y. Mbaya Y. Mbaya
Abdal Al Marzouqi Abdal Al Marzouqi 34 años DEF
K. Muhire K. Muhire 25 años MED
A. Al Ghassani A. Al Ghassani 33 años DEL
2 jugadores
Al Shabab Muscat Shabab Muscat
V. Calamari V. Calamari 35 años MED
A. Fall A. Fall 37 años 173cm 58kg DEL
2 jugadores
Al Ittihad Al Ittihad
M. Awad M. Awad
Ali Salah Ali Salah 37 años 189cm MED

Clasificación

Equipo PJ GF GC Puntos
1 Dhofar Dhofar 10 19 3 26
2 Al-Seeb Al-Seeb 10 21 3 22
3 Al Musannah Al Musannah 10 14 10 20
4 Al-Nasr Salalah Al-Nasr 10 11 8 18
5 Al-Suwaiq Al-Suwaiq 10 11 9 17
6 Bahla Bahla 10 10 9 15
7 Al Rustaq Al Rustaq 10 9 9 14
8 Al-Nahda Al-Nahda 10 9 9 12
9 Al Ittihad Al Ittihad 10 10 12 12
10 Oman FC Oman FC 10 6 9 11
11 Sohar Sohar 10 8 14 8
12 Nizwa Nizwa 10 8 15 7
13 Saham Saham 10 7 20 6
14 Al Shabab Muscat Shabab 10 4 17 3

  USO DE MEMORIA  
5,084,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0670
Total Execution Time  0.0690
  CADENA URL  
/league_oman2021/grupo1/jugadores
  GET DATOS  
$_GET['/league_oman2021/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'league_oman2021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_oman' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=502 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 502 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=502 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 60364 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 60364 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0032  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 60364 AND dt.id IN (15511,15520,15517,15518,15509,15521,84131,19044,15512,62151,84126,15515,19039,84122) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 11:09:28' 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=2 AND last_update > '2024-05-02 11:09:28' 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-05-02 11:09:28' 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-05-02 11:09:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_oman' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0037  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 events2021 e ON e.player_id = p.id AND e.league_id = 60364 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60364 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.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 60364 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60364 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 60364 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60364 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 60364 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC