4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Primera División Bolivia 2023
2022/2023

Temporada Regular

Primera División Bolivia 2023

  • The Strongest
  • Bolívar
  • Always Ready
  • Nacional Potosí
  • Aurora
  • Real Tomayapo
  • Real Santa Cruz
  • Jorge Wilstermann
  • Oriente Petrolero
  • Universitario de Vinto
  • Independiente Petrolero
  • Royal Pari
  • Guabirá Santa Cruz
  • Blooming
  • Libertad Gran Mamoré
  • Vaca Díez
  • Atlético Palmaflor
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 The Strongest Strongest 32 65 34 65
2 Bolívar Bolívar 32 84 42 57
3 Always Ready Always Ready 32 54 36 57
4 Nacional Potosí Nacional 32 72 46 54
5 Aurora Aurora 32 45 31 51
6 Real Tomayapo Real 32 36 34 49
7 Real Santa Cruz Real Santa. 32 31 42 46
8 Jorge Wilstermann Jorge 32 39 27 43
9 Oriente Petrolero Oriente 32 44 42 43
10 Universitario de Vinto Universitari 32 30 28 41
11 Independiente Petrolero Independient 32 33 45 40
12 Royal Pari Royal Pari 32 40 53 35
13 Guabirá Santa Cruz Guabirá 32 34 49 35
14 Blooming Blooming 32 37 56 33
15 Libertad Gran Mamoré Libertad 32 32 65 33
16 Vaca Díez Vaca Díez 32 42 61 32
17 Atlético Palmaflor Atlético 32 32 59 29
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Independiente Petrolero Independient 30 59 33 65
2 Always Ready Always Ready 30 66 31 64
3 The Strongest Strongest 30 57 24 63
4 Bolívar Bolívar 30 63 29 56
5 Royal Pari Royal Pari 30 66 45 51
6 Oriente Petrolero Oriente 30 46 29 51
7 Jorge Wilstermann Jorge 30 64 48 49
8 Guabirá Santa Cruz Guabirá 30 47 47 44
9 Atlético Palmaflor Atlético 30 42 45 40
10 Nacional Potosí Nacional 30 45 46 39
11 Real Santa Cruz Real Santa. 30 39 47 38
12 Aurora Aurora 30 40 51 33
13 Real Tomayapo Real 30 28 45 32
14 Blooming Blooming 30 34 56 26
15 Real Potosí Real Potosí 30 30 63 25
16 San José Oruro José Oruro 30 9 96 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Always Ready Always Ready 26 59 29 51
2 The Strongest Strongest 26 65 35 50
3 Bolívar Bolívar 26 60 29 49
4 Royal Pari Royal Pari 26 42 34 46
5 Jorge Wilstermann Jorge 26 36 28 42
6 Guabirá Santa Cruz Guabirá 26 43 43 42
7 Nacional Potosí Nacional 26 34 35 39
8 Atlético Palmaflor Atlético 26 29 30 38
9 Blooming Blooming 26 38 43 38
10 Oriente Petrolero Oriente 26 37 51 30
11 Aurora Aurora 26 26 37 23
12 Real Potosí Real Potosí 26 35 59 23
13 San José Oruro José Oruro 26 27 52 23
14 Real Santa Cruz Real Santa. 26 36 62 23

  USO DE MEMORIA  
5,374,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1301
Total Execution Time  0.1322
  CADENA URL  
/primera_division_bolivia2023/grupo1/historico
  GET DATOS  
$_GET['/primera_division_bolivia2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0023  SELECT type FROM routes WHERE alias = 'primera_division_bolivia2023'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_bolivia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2428 AND type_rel = 3
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2428 ORDER BY order_id ASC
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2428 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 61655 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.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 `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 = 53600 AND t.round = 26 ORDER BY team.conference ASC,t.position 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-04-27 09:48:21' 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-04-27 09:48:21' 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-04-27 09:48:21' 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-04-27 09:48:21' 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 = 'primera_division_bolivia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0234  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 events2023 e ON e.player_id = p.id AND e.league_id = 70916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70916 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.0351  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 events2023 e ON e.player_id = p.id AND e.league_id = 70916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70916 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  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 events2023 e ON e.player_id = p.id AND e.league_id = 70916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70916 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 70916 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC