4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Sporting San Miguelito II Sporting 16 30 11 39
2 Universidad de Panamá Universidad 15 24 9 30
3 UMECIT II UMECIT II 16 20 20 28
4 Champions Academy Champions 16 24 12 25
5 Árabe Unido II Árabe Unido 15 20 15 20
6 Colón C-3 Colón C-3 16 10 31 7
7 Tauro II Tauro II 16 44 21 35
8 Alianza II Alianza II 16 16 16 25
9 Panamá City Panamá City 16 25 24 23
10 Potros del Este II Potros Este 16 24 37 17
11 Plaza Amador II Plaza Amador 16 20 27 10
12 San Martín San Martín 16 17 51 4
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 UMECIT UMECIT 16 31 8 36
2 Sporting San Miguelito II Sporting 16 30 17 29
3 Champions Academy Champions 16 22 11 28
4 Árabe Unido II Árabe Unido 16 16 21 17
5 Colón C-3 Colón C-3 16 16 40 11
6 Centenario Centenario 16 10 40 8
7 Tauro II Tauro II 16 45 10 39
8 Panamá City Panamá City 16 25 19 28
9 Potros del Este II Potros Este 16 25 19 27
10 Plaza Amador II Plaza Amador 16 27 29 22
11 Alianza II Alianza II 16 20 36 10
12 San Martín San Martín 16 13 30 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 UMECIT UMECIT 15 26 14 31
2 Champions Academy Champions 15 17 9 24
3 Árabe Unido II Árabe Unido 15 16 13 23
4 Sporting San Miguelito II Sporting 15 16 13 21
5 Colón C-3 Colón C-3 16 22 27 16
6 Centenario Centenario 16 17 42 10
7 Plaza Amador II Plaza Amador 16 33 16 30
8 Alianza II Alianza II 16 26 19 30
9 Potros del Este II Potros Este 16 26 23 27
10 San Martín San Martín 16 27 28 18
11 Tauro II Tauro II 16 20 25 17
12 Panamá City Panamá City 16 10 27 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Centenario Centenario 7 10 9 14
2 Atl. Chiriquí Atl. 7 12 9 12
3 San Martín San Martín 7 7 5 12
4 Atl. Nacional Atl. 7 11 8 11
5 Panamá Oeste Panamá 7 13 7 10
6 Veraguas FC Veraguas FC 7 8 10 9
7 Herrera FC Herrera FC 7 7 12 5
8 Colón C-3 Colón C-3 7 8 16 3
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Potros del Este Potros Este 10 21 3 24
2 Herrera FC Herrera FC 10 10 10 16
3 San Martín San Martín 10 9 6 15
4 Panamá Oeste Panamá 10 11 10 13
5 Atl. Nacional Atl. 10 8 10 13
6 Colón C-3 Colón C-3 10 9 14 13
7 Centenario Centenario 10 9 9 12
8 Veraguas FC Veraguas FC 10 10 13 12
9 Deportivo San Miguelito Deportivo 10 7 10 11
10 Atl. Chiriquí Atl. 10 9 13 10
11 Río Abajo Río Abajo 10 3 8 5
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Veraguas FC Veraguas FC 13 21 15 27
2 Independiente Chorrera Independient 13 28 17 23
3 Potros del Este Potros Este 13 25 14 22
4 Centenario Centenario 13 12 10 22
5 Panama Viejo Panama Viejo 13 20 26 22
6 Río Abajo Río Abajo 13 25 14 21
7 Atl. Chiriquí Atl. 13 24 15 19
8 Deportivo San Miguelito Deportivo 13 19 15 19
9 Deportivo Vista Alegre Deportivo 13 16 16 19
10 Herrera FC Herrera FC 13 15 23 15
11 Panamá Oeste Panamá 13 11 14 14
12 New York Colon York Colon 13 16 27 13
13 Colón C-3 Colón C-3 13 11 22 10
14 Tierra Firme Tierra Firme 13 13 28 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Atlético Veragüense Atlético 13 25 8 26
2 Colón C-3 Colón C-3 13 22 11 26
3 Deportivo San Miguelito Deportivo 13 21 16 24
4 Independiente Chorrera Independient 13 25 13 23
5 Santa Gema Santa Gema 13 21 9 22
6 Potros del Este Potros Este 13 17 10 22
7 Deportivo Vista Alegre Deportivo 13 22 16 21
8 New York Colon York Colon 13 25 23 19
9 Tierra Firme Tierra Firme 13 23 20 17
10 Centenario Centenario 13 13 12 16
11 Río Abajo Río Abajo 13 17 30 16
12 Panamá Oeste Panamá 13 13 17 13
13 Veraguas FC Veraguas FC 13 11 19 11
14 Chiriquí Occidente Chiriquí 13 4 55 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Veraguas FC Veraguas FC 13 32 7 30
2 Potros del Este Potros Este 13 22 16 26
3 Colón C-3 Colón C-3 13 18 16 24
4 Centenario Centenario 13 16 14 23
5 Millenium Millenium 13 24 17 22
6 Atl. Nacional Atl. 13 22 17 21
7 Atlético Veragüense Atlético 13 15 10 20
8 Panamá Oeste Panamá 13 19 16 20
9 Santa Gema Santa Gema 13 15 13 19
10 Tierra Firme Tierra Firme 13 18 22 16
11 Río Abajo Río Abajo 13 13 20 13
12 Chiriquí Occidente Chiriquí 13 17 25 9
13 Deportivo Vista Alegre Deportivo 13 10 23 8
14 River Plate David River Plate 13 3 28 3
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Veraguas FC Veraguas FC 12 30 6 31
2 Deportivo San Miguelito Deportivo 12 21 15 20
3 Atl. Nacional Atl. 12 25 13 18
4 Colón C-3 Colón C-3 12 14 16 17
5 Tierra Firme Tierra Firme 12 16 16 15
6 Centenario Centenario 12 10 17 9
7 AD Orión AD Orión 12 11 44 2
8 Atl. Chiriquí Atl. 12 24 9 28
9 Santa Gema Santa Gema 12 23 16 22
10 Potros del Este Potros Este 12 20 11 21
11 Atlético Veragüense Atlético 12 19 16 19
12 Deportivo Vista Alegre Deportivo 12 11 19 9
13 Panamá Oeste Panamá 12 15 21 8
14 Chiriquí Occidente Chiriquí 12 6 26 6

  USO DE MEMORIA  
5,501,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4372
Total Execution Time  0.4391
  CADENA URL  
/liga_nacional_ascenso_panama_clausura2023/grupo1/historico
  GET DATOS  
$_GET['/liga_nacional_ascenso_panama_clausura2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0124  SELECT type FROM routes WHERE alias = 'liga_nacional_ascenso_panama_clausura2023'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nacional_ascenso_panama_clausura' 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.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1560 AND type_rel = 3
0.0124  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1560 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1560 GROUP BY l.categoryId
0.0126  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=1560 GROUP BY l.year ORDER BY l.year DESC
0.0126  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 = 72958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1560 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  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 `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 = 72958 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2022` 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 = 68731 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 63541 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 48940 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2018` 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 = 42428 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 37833 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 20324 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 9271 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 24205 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 14:33:10' 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=2 AND last_update > '2024-05-03 14:33:10' 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=4 AND last_update > '2024-05-03 14:33:10' 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-05-03 14:33:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nacional_ascenso_panama_clausura' 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.0127  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 = 72958 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72958 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 72958 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72958 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 events2023 e ON e.player_id = p.id AND e.league_id = 72958 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72958 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 72958 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC