4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Al-Hidd Al-Hidd 4 12 3 9
2 Al-Riffa Al-Riffa 4 8 2 9
3 Budaiya Budaiya 4 4 5 6
4 Sitra Sitra 4 3 10 3
5 Al Tadamun Buri Tadamun Buri 4 2 9 3
6 East Riffa East Riffa 4 13 2 12
7 Manama Manama 4 6 3 7
8 Isa Town Isa Town 4 5 5 5
9 Qalali Qalali 4 3 10 3
10 Malkiya Malkiya 4 2 9 1
11 Al-Muharraq Al-Muharraq 4 10 2 10
12 Al-Shabab Manama Al-Shabab 4 10 5 7
13 Al Ahli Manama Ahli Manama 4 7 6 6
14 Al Ittihad Bahrain Ittihad 4 4 11 3
15 Al Ittifaq Maqaba Ittifaq 4 3 10 3
16 Busaiteen Busaiteen 3 3 1 7
17 Bahrain SC Bahrain SC 3 3 2 5
18 Al Najma Manama Najma Manama 3 1 2 2
19 Al-Hala Al-Hala 3 0 2 1
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 4 10 1 12
2 Al-Muharraq Al-Muharraq 4 6 3 7
3 Busaiteen Busaiteen 4 4 7 6
4 Al-Shabab Manama Al-Shabab 4 3 6 4
5 Al Tadamun Buri Tadamun Buri 4 4 10 0
6 Al Najma Manama Najma Manama 4 7 2 10
7 Al-Hadd Al-Hadd 4 10 4 9
8 Al Ittihad Bahrain Ittihad 4 4 8 4
9 Qalali Qalali 4 2 7 3
10 Isa Town Isa Town 4 1 3 2
11 Bahrain SC Bahrain SC 4 7 2 8
12 Manama Manama 4 7 3 8
13 Al-Riffa Al-Riffa 4 6 3 5
14 Budaiya Budaiya 4 3 4 5
15 Al Ittifaq Maqaba Ittifaq 4 3 14 0
16 East Riffa East Riffa 3 4 1 7
17 Al-Hala Al-Hala 3 3 3 3
18 Malkiya Malkiya 3 0 1 2
19 Sitra Sitra 3 2 4 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Budaiya Budaiya 8 17 8 17
2 Al-Muharraq Al-Muharraq 8 17 7 16
3 Malkiya Malkiya 8 19 17 15
4 Al-Riffa Al-Riffa 8 24 11 13
5 Sitra Sitra 8 15 19 10
6 Al Ittihad Bahrain Ittihad 8 10 16 10
7 Al-Hala Al-Hala 8 8 12 8
8 Isa Town Isa Town 8 12 17 8
9 Qalali Qalali 8 9 24 1
10 Al-Hadd Al-Hadd 9 28 11 25
11 Bahrain SC Bahrain SC 9 18 9 19
12 Al Ahli Manama Ahli Manama 9 16 8 16
13 Al Najma Manama Najma Manama 9 20 19 16
14 Manama Manama 9 17 14 13
15 Busaiteen Busaiteen 9 12 17 13
16 East Riffa East Riffa 9 14 11 12
17 Al-Shabab Manama Al-Shabab 9 11 11 9
18 Al Tadamun Buri Tadamun Buri 9 6 19 3
19 Al Ittifaq Maqaba Ittifaq 9 10 33 1
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 8 22 5 24
2 Al-Hadd Al-Hadd 8 31 8 17
3 Al-Riffa Al-Riffa 8 17 9 16
4 Al Ittihad Bahrain Ittihad 8 22 16 13
5 Al-Muharraq Al-Muharraq 8 12 22 10
6 Busaiteen Busaiteen 8 10 18 7
7 Al-Shabab Manama Al-Shabab 8 13 19 6
8 Bahrain SC Bahrain SC 8 8 15 6
9 Qalali Qalali 8 7 30 4
10 Malkiya Malkiya 9 22 12 22
11 East Riffa East Riffa 9 24 17 21
12 Manama Manama 9 22 9 19
13 Al Najma Manama Najma Manama 9 10 9 13
14 Al-Hala Al-Hala 9 17 15 11
15 Sitra Sitra 9 15 14 11
16 Isa Town Isa Town 9 11 14 9
17 Budaiya Budaiya 9 8 12 8
18 Al Tadamun Buri Tadamun Buri 9 8 18 6
19 Al Ittifaq Maqaba Ittifaq 9 10 27 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 7 20 8 15
2 Al-Muharraq Al-Muharraq 8 13 8 15
3 Al Ahli Manama Ahli Manama 7 10 8 15
4 Al-Shabab Manama Al-Shabab 7 16 5 13
5 Bahrain SC Bahrain SC 7 15 10 12
6 Busaiteen Busaiteen 7 8 11 7
7 Al Najma Manama Najma Manama 6 9 13 7
8 Qalali Qalali 6 3 19 4
9 Isa Town Isa Town 7 6 18 1
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 8 21 3 22
2 Malkiya Malkiya 8 19 14 18
3 Busaiteen Busaiteen 8 19 7 16
4 Manama Manama 8 16 11 16
5 East Riffa East Riffa 8 11 10 13
6 Al Ittihad Bahrain Ittihad 7 8 12 6
7 Budaiya Budaiya 7 12 20 4
8 Al-Shabab Manama Al-Shabab 7 9 19 3
9 Qalali Qalali 7 6 25 1
10 Bahrain SC Bahrain SC 8 19 9 21
11 Al-Hala Al-Hala 8 21 12 16
12 Sitra Sitra 9 20 13 15
13 Al-Muharraq Al-Muharraq 8 12 8 15
14 Al-Hadd Al-Hadd 9 21 13 13
15 Al Ahli Manama Ahli Manama 9 18 21 13
16 Al Ittifaq Maqaba Ittifaq 8 8 16 7
17 Al Tadamun Buri Tadamun Buri 9 8 19 7
18 Al Najma Manama Najma Manama 7 8 15 5
19 Isa Town Isa Town 9 8 17 4

  USO DE MEMORIA  
5,646,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0942
Total Execution Time  0.0961
  CADENA URL  
/copa_bahrein2020/grupo1/historico
  GET DATOS  
$_GET['/copa_bahrein2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_bahrein2020'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_bahrein' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1593 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1593 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (571528,568499) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1593 ORDER BY order_id ASC
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1593 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=1593 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 = 51223 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1593 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 51223 AND t.round = 1 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 `tables2019` 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 = 48498 AND t.round = 6 ORDER BY team.conference 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 `tables2017` 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 = 34736 AND t.round = 9 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 `tables2016` 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 = 20633 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 9364 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 23375 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 06:14:19' 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 06:14:19' 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 06:14:19' 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 06:14:19' 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 = 'copa_bahrein' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1593 AND l.year = 2020
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51223,53455) 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, e.player_id ASC LIMIT 10
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (51223,53455) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (208735,312959,321660,865413,995610) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1593 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51223,53455) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1593 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51223,53455) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0039  SELECT *,(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 = 51223 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC