4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Persiraja Banda Aceh
TEMPORADA 2023/2024
LIGA 2 INDONESIA GRUPO 2
Equipo PJ GF GC Puntos
1 Semen Padang Semen Padang 6 5 2 10
2 Persiraja Banda Aceh Persiraja 6 6 3 9
3 PSIM Yogyakarta PSIM 6 7 7 9
4 PSMS Medan PSMS Medan 6 3 9 2
5 Malut United FC Malut United 6 9 6 10
6 Deltras Deltras 6 6 5 9
7 Persela Persela 6 6 7 6
8 FC Bekasi City Bekasi City 6 8 11 5
9 PSBS Biak Numfor PSBS Biak N. 6 10 3 16
10 Gresik United Gresik 6 6 5 8
11 Persewar Persewar 6 7 11 6
12 Persipal Palu Persipal 6 6 10 4
TEMPORADA 2021/2022
LIGA 2 INDONESIA GRUPO 1
Equipo PJ GF GC Puntos
1 PSMS Medan PSMS Medan 6 11 4 16
2 Sada Sumut Sada Sumut 5 6 1 12
3 Sriwijaya Sriwijaya 6 7 4 11
4 Semen Padang Semen Padang 6 12 5 9
5 Persiraja Banda Aceh Persiraja 6 5 10 9
6 PSKC Cimahi PSKC Cimahi 6 4 5 7
7 Perserang Perserang 7 3 12 6
8 PSDS Deli Serdang PSDS Deli S. 6 5 7 5
9 PSPS Pekanbaru PSPS 6 6 11 1
10 FC Bekasi City Bekasi City 7 10 3 16
11 Persijap Persijap 7 9 7 12
12 Gresik United Gresik 7 6 3 10
13 PSCS Cilacap PSCS Cilacap 7 6 5 10
14 Persipa Pati Persipa Pati 7 9 9 9
15 PSIM Yogyakarta PSIM 7 6 8 9
16 Persikab Bandung Persikab 7 4 6 7
17 Persela Persela 7 11 13 6
18 Persekat Persekat 7 4 7 6
19 Nusantara United Nusantara 7 2 6 5
20 Persipura Persipura 6 9 4 11
21 Persiba Balikpapan Persiba 6 12 7 10
22 Persipal Palu Persipal 6 4 2 10
23 Deltras Deltras 6 12 7 9
24 Persewar Persewar 7 11 9 9
25 Sulut United Sulut United 5 7 5 9
26 Malut United FC Malut United 6 9 10 8
27 PSBS Biak Numfor PSBS Biak N. 5 2 6 4
28 Kalteng Putra Kalteng 5 1 17 1
TEMPORADA 2019/2020
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 Persib Persib 3 7 2 9
2 Bali United Bali United 3 5 2 7
3 Borneo Samarinda Borneo 3 6 4 6
4 Persipura Persipura 3 6 5 6
5 PSIS Semarang PSIS 3 5 4 6
6 PSM PSM 3 4 3 5
7 Persiraja Banda Aceh Persiraja 3 1 0 5
8 Madura United Madura 3 5 3 4
9 Persija Persija 2 5 4 4
10 Persikabo 1973 Persikabo 3 3 3 4
11 Bhayangkara FC Bhayangkara 3 3 3 3
12 Arema FC Arema FC 3 3 4 3
13 Persik Kediri Persik 3 2 3 2
14 Persita Persita 3 2 4 2
15 Persebaya Persebaya 2 4 5 1
16 PSS Sleman PSS Sleman 3 2 4 1
17 Barito Putera Barito 3 2 7 1
18 Persela Persela 3 3 8 0

  USO DE MEMORIA  
5,361,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.2796
Total Execution Time  0.2807
  CADENA URL  
/historico/Persatuan-Sepakbola-Persiraja-Banda-Acel
  GET DATOS  
$_GET['/historico/Persatuan-Sepakbola-Persiraja-Banda-Acel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0040  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74033
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75062
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75267
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=120098 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2277 AND type_rel = 3
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '120098' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75062 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '120098' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '120098' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '120098' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74033 WHERE rp.league_id = 74033 AND rp.teamId = 120098 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74033 WHERE rp.league_id = 74033 AND rp.teamId = 120098 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74033 WHERE rp.league_id = 74033 AND rp.teamId = 120098 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 120098 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 `tables2024` 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 = 74033 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `tables2024` 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 = 75062 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 68309 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
0.0026  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 = 68892 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
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 `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 = 55523 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