4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
6 jugadores
Al-Muharraq Al-Muharraq
Al-Jaben Al-Jaben
A. Al Malood A. Al Malood 33 años 179cm 69kg MED
A. Ali A. Ali 39 años 180cm 75kg MED
Jhonnattann Jhonnattann 34 años 165cm DEL
A. Barakat A. Barakat 26 años DEL
I. Abdullatif I. Abdullatif 37 años DEL
9 jugadores
Al-Riffa Al-Riffa
Hamad Al Shamsan Hamad Al Shamsan 26 años DEF
Sayed Reda Issa Sayed Reda Issa 29 años DEF
Sayed Baqer Sayed Baqer 30 años DEF
Kamil Al Aswad Kamil Al Aswad 30 años 169cm MED
M. Ali Jaafar Madan M. Ali Jaafar Madan 33 años MED
Mohamed Marhoon Mohamed Marhoon 26 años 176cm MED
Ali Haram Ali Haram 35 años 184cm 71kg MED
Ali Madan Ali Madan 28 años 167cm 63kg DEL
Mahdi Al-Humaidan Mahdi Al-Humaidan 30 años 175cm DEL
4 jugadores
Busaiteen Busaiteen
Junior Timbó Junior Timbó 32 años 181cm 83kg MED
D. Soungole D. Soungole 29 años 176cm 69kg MED
S. Alsalatna S. Alsalatna MED
I. Khojali I. Khojali DEL
7 jugadores
East Riffa East Riffa
Luiz Fernando Luiz Fernando 35 años 169cm 64kg MED
Isa Ali Jehad Isa Ali Jehad 31 años MED
M. Al Romaihi M. Al Romaihi 33 años DEL
F. Bodahoom F. Bodahoom 35 años DEL
Yuri Yuri 32 años 169cm DEL
L. Gikiewicz L. Gikiewicz 36 años 188cm 75kg DEL
S. Al Husaini S. Al Husaini 34 años DEL
2 jugadores
Al Najma Manama Al Najma Manama
Cacule Cacule 32 años 182cm MED
Luis Junior Luis Junior DEL
2 jugadores
Manama Manama
Mahdi Abduljabbar Mahdi Abduljabbar 32 años DEL
Ali Hasan Isa Ali Hasan Isa 27 años 177cm 73kg DEL
5 jugadores
Al Ahli Manama Al Ahli Manama
M. Taradah M. Taradah
Issa Muthanna Issa Muthanna 33 años MED
Tareq Keda Tareq Keda MED
Hamza Sanhaji Hamza Sanhaji 30 años 179cm 76kg DEL
J. Rahman J. Rahman 35 años DEL
3 jugadores
Malkiya Malkiya
Sayed Isa Sayed Isa 26 años DEF
I. Abd Al Wahab I. Abd Al Wahab 35 años DEL
Emmanuel Onyeka Emmanuel Onyeka 30 años 173cm DEL
5 jugadores
Al-Hadd Al-Hadd
A. Abdulla A. Abdulla 38 años MED
M. Abdalwahab M. Abdalwahab 28 años MED
Erick Erick 31 años 183cm 72kg DEL
A. Al Hashash A. Al Hashash DEL
S. Al Amer S. Al Amer 33 años DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 31 13 45
2 East Riffa East Riffa 18 32 20 35
3 Manama Manama 18 26 18 31
4 Al-Muharraq Al-Muharraq 18 24 15 27
5 Al-Hadd Al-Hadd 18 26 23 27
6 Al Ahli Manama Ahli Manama 18 17 25 21
7 Budaiya Budaiya 18 11 19 17
8 Al Najma Manama Najma Manama 18 17 31 15
9 Malkiya Malkiya 18 11 26 13
10 Busaiteen Busaiteen 18 17 22 12

  USO DE MEMORIA  
4,823,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0754
Total Execution Time  0.0773
  CADENA URL  
/premier_league_bahrein2021/grupo1/jugadores
  GET DATOS  
$_GET['/premier_league_bahrein2021/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_bahrein2021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_bahrein' 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=431 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 = 431 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=431 GROUP BY l.year ORDER BY l.year DESC
0.0038  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 = 60287 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 60287 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0033  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 = 60287 AND dt.id IN (15456,15460,15454,25044,57517,15459,57515,15457,57516,15453) ORDER BY dt.relations DESC,dp.role ASC
0.0033  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 07:58:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 07:58:24' 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-09 07:58:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 07:58:24' 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 = 'premier_league_bahrein' 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.0035  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 = 60287 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60287 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 = 60287 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60287 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 = 60287 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60287 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 = 60287 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC