4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Busaiteen Busaiteen 18 44 12 44
2 Al-Muharraq Al-Muharraq 18 48 17 42
3 Al-Hadd Al-Hadd 18 38 19 37
4 Al-Riffa Al-Riffa 18 25 25 28
5 Manama Manama 18 36 31 23
6 Al Najma Manama Najma Manama 18 18 30 22
7 Al-Hala Al-Hala 18 26 33 16
8 Al-Shabab Manama Al-Shabab 18 22 38 13
9 Malkiya Malkiya 18 18 35 13
10 Bahrain SC Bahrain SC 18 24 59 11
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 34 16 45
2 Al-Muharraq Al-Muharraq 18 41 13 38
3 Busaiteen Busaiteen 18 34 28 34
4 Al-Hadd Al-Hadd 18 23 26 22
5 Al-Hala Al-Hala 18 29 33 21
6 Bahrain SC Bahrain SC 18 25 29 21
7 Al Najma Manama Najma Manama 18 24 26 20
8 Manama Manama 18 20 29 20
9 Al Ahli Manama Ahli Manama 18 15 28 18
10 East Riffa East Riffa 18 19 36 15
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 11 25 12 23
2 Al-Muharraq Al-Muharraq 11 18 12 21
3 Al Ahli Manama Ahli Manama 11 23 15 20
4 Al-Hadd Al-Hadd 13 24 23 20
5 Manama Manama 12 20 21 15
6 Busaiteen Busaiteen 12 16 21 12
7 Al-Hala Al-Hala 12 11 25 8
8 Al Najma Manama Najma Manama 12 12 20 7
9 Al-Shabab Manama Al-Shabab 0 0 0 0
10 Malkiya Malkiya 0 0 0 0
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 18 26 17 41
2 Al-Muharraq Al-Muharraq 18 38 20 40
3 Al-Riffa Al-Riffa 18 36 18 38
4 Al Najma Manama Najma Manama 18 27 18 32
5 Busaiteen Busaiteen 18 29 23 23
6 Manama Manama 18 23 33 18
7 Al-Shabab Manama Al-Shabab 18 18 35 17
8 Al-Hala Al-Hala 18 27 30 16
9 Malkiya Malkiya 18 18 31 16
10 East Riffa East Riffa 18 21 38 13
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 50 9 45
2 Al-Riffa Al-Riffa 18 51 11 44
3 Al Ahli Manama Ahli Manama 18 35 10 42
4 East Riffa East Riffa 18 38 22 40
5 Busaiteen Busaiteen 18 38 22 32
6 Al Najma Manama Najma Manama 18 29 19 31
7 Manama Manama 18 38 27 30
8 Al-Shabab Manama Al-Shabab 18 37 31 30
9 Malkiya Malkiya 18 23 18 29
10 Al-Hala Al-Hala 18 29 20 28
11 Al-Hadd Al-Hadd 18 35 32 28
12 Sitra Sitra 18 22 25 25
13 Bahrain SC Bahrain SC 18 26 21 22
14 Budaiya Budaiya 18 15 26 18
15 Qalali Qalali 18 19 40 12
16 Al Ittihad Bahrain Ittihad 18 16 41 10
17 Al Ittifaq Maqaba Ittifaq 18 12 43 8
18 Isa Town Isa Town 18 11 54 5
19 Al Tadamun Buri Tadamun Buri 18 10 63 2
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 22 66 14 52
2 Busaiteen Busaiteen 22 45 23 42
3 Al Ahli Manama Ahli Manama 22 36 28 42
4 Al-Riffa Al-Riffa 22 40 22 40
5 East Riffa East Riffa 22 28 36 30
6 Al Najma Manama Najma Manama 22 33 26 28
7 Manama Manama 22 27 36 28
8 Al Ittihad Bahrain Ittihad 22 26 39 24
9 Al-Hala Al-Hala 22 28 50 22
10 Al-Shabab Manama Al-Shabab 22 30 44 21
11 Al-Hadd Al-Hadd 22 20 39 20
12 Bahrain SC Bahrain SC 22 19 41 19
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 22 56 17 53
2 Al-Riffa Al-Riffa 22 34 16 41
3 Al Najma Manama Najma Manama 22 32 23 38
4 Busaiteen Busaiteen 22 35 27 33
5 Bahrain SC Bahrain SC 22 27 32 29
6 Al-Hala Al-Hala 22 42 44 28
7 Al-Shabab Manama Al-Shabab 22 30 29 27
8 Al Ahli Manama Ahli Manama 22 30 31 27
9 East Riffa East Riffa 22 27 32 27
10 Malkiya Malkiya 22 22 30 22
11 Manama Manama 22 23 38 22
12 Sitra Sitra 22 16 55 12
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 29 17 38
2 Al Ahli Manama Ahli Manama 18 47 20 37
3 Al-Riffa Al-Riffa 18 36 17 33
4 Al Najma Manama Najma Manama 18 29 28 25
5 Sitra Sitra 18 25 33 22
6 Malkiya Malkiya 18 27 23 20
7 East Riffa East Riffa 18 29 36 20
8 Busaiteen Busaiteen 18 19 29 20
9 Al-Shabab Manama Al-Shabab 18 21 39 18
10 Bahrain SC Bahrain SC 18 16 36 13
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 40 18 40
2 Al-Muharraq Al-Muharraq 18 36 18 36
3 Al Ahli Manama Ahli Manama 18 30 26 33
4 Al-Shabab Manama Al-Shabab 18 33 28 32
5 Al Najma Manama Najma Manama 18 33 18 31
6 Busaiteen Busaiteen 18 25 28 23
7 Bahrain SC Bahrain SC 18 21 30 18
8 East Riffa East Riffa 18 26 33 17
9 Manama Manama 18 22 41 15
10 Al-Hala Al-Hala 18 16 42 8
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 45 9 48
2 Al-Riffa Al-Riffa 18 42 17 36
3 Al Ahli Manama Ahli Manama 18 30 20 30
4 Busaiteen Busaiteen 18 32 30 23
5 Bahrain SC Bahrain SC 18 30 33 23
6 Al-Shabab Manama Al-Shabab 18 24 27 21
7 East Riffa East Riffa 18 21 39 19
8 Al-Hala Al-Hala 18 30 36 18
9 Al Najma Manama Najma Manama 18 23 37 17
10 Al-Hadd Al-Hadd 18 16 45 10
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 48 20 40
2 Al-Muharraq Al-Muharraq 18 44 22 34
3 Al Ahli Manama Ahli Manama 18 46 30 32
4 Busaiteen Busaiteen 18 28 23 28
5 Al-Hala Al-Hala 18 36 40 22
6 East Riffa East Riffa 18 29 42 22
7 Bahrain SC Bahrain SC 18 22 26 21
8 Al-Shabab Manama Al-Shabab 18 25 40 19
9 Al Najma Manama Najma Manama 18 25 36 18
10 Malkiya Malkiya 18 20 44 13
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 17 53 10 46
2 Al Ahli Manama Ahli Manama 17 46 9 46
3 Al-Riffa Al-Riffa 17 51 14 36
4 Busaiteen Busaiteen 17 33 21 32
5 Malkiya Malkiya 17 31 22 30
6 Al-Shabab Manama Al-Shabab 17 35 29 30
7 Bahrain SC Bahrain SC 17 29 21 28
8 Al Najma Manama Najma Manama 17 28 19 26
9 Al-Hala Al-Hala 17 32 25 26
10 East Riffa East Riffa 17 27 23 25
11 Isa Town Isa Town 17 31 27 23
12 Budaiya Budaiya 17 14 28 19
13 Al Tadamun Buri Tadamun Buri 17 21 33 14
14 Sitra Sitra 17 19 38 14
15 Al Ittihad Bahrain Ittihad 17 15 36 13
16 Al Ittifaq Maqaba Ittifaq 17 16 40 6
17 Al Sahel Bahrain Sahel 17 18 60 6
18 Manama Manama 17 13 57 6

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,773,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4052
Total Execution Time  0.4071
  CADENA URL  
/premier_league_bahrein2013/grupo1/historico
  GET DATOS  
$_GET['/premier_league_bahrein2013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=431 ORDER BY order_id ASC
0.0133  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 = 3022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 431 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0146  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 = 3022 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables2012` 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 = 8945 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables2011` 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 = 8943 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 8941 AND t.round = 18 ORDER BY team.conference 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 `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 = 8939 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2008` 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 = 8937 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 8935 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2006` 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 = 8934 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2005` 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 = 8930 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2004` 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 = 23367 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2003` 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 = 23369 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2002` 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 = 23370 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 14:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 14:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 14:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 14:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0166  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 events2013 e ON e.player_id = p.id AND e.league_id = 3022 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3022 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.0129  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 events2013 e ON e.player_id = p.id AND e.league_id = 3022 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3022 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2013 e ON e.player_id = p.id AND e.league_id = 3022 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3022 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 3022 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC