4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Persik Kediri

Persik Kediri

Entrenador: Marcelo Rospide

TEMPORADA 2023/2024
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 Borneo Samarinda Borneo 34 52 30 70
2 Persib Persib 34 65 37 63
3 Bali United Bali United 34 54 42 58
4 Madura United Madura 34 58 45 55
5 PSIS Semarang PSIS 34 48 39 54
6 Dewa United Dewa United 34 58 47 54
7 Persik Kediri Persik 34 58 55 48
8 Persis Solo Persis Solo 34 49 47 48
9 Barito Putera Barito 34 51 48 46
10 Persija Persija 34 47 40 46
11 PSM PSM 34 43 37 44
12 Persebaya Persebaya 34 33 46 42
13 Persita Persita 34 43 62 39
14 Arema FC Arema FC 34 42 60 38
15 PSS Sleman PSS Sleman 34 48 53 37
16 RANS Nusantara RANS 34 34 51 35
17 Bhayangkara FC Bhayangkara 34 42 56 27
18 Persikabo 1973 Persikabo 34 44 74 20
TEMPORADA 2022/2023
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 PSM PSM 34 63 28 75
2 Persija Persija 34 47 27 66
3 Persib Persib 34 54 50 62
4 Borneo Samarinda Borneo 34 64 40 57
5 Bali United Bali United 34 67 53 54
6 Persebaya Persebaya 34 52 45 52
7 Bhayangkara FC Bhayangkara 34 53 44 51
8 Madura United Madura 34 39 36 51
9 Persita Persita 34 43 46 47
10 Persis Solo Persis Solo 34 50 47 44
11 Persik Kediri Persik 34 42 43 44
12 Arema FC Arema FC 34 32 40 42
13 Persikabo 1973 Persikabo 34 43 48 41
14 PSIS Semarang PSIS 34 44 53 41
15 Barito Putera Barito 34 44 55 38
16 PSS Sleman PSS Sleman 34 34 57 34
17 Dewa United Dewa United 34 34 53 33
18 RANS Nusantara RANS 34 40 80 19
TEMPORADA 2021/2022
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 Bali United Bali United 34 57 26 75
2 Persib Persib 34 48 22 69
3 Bhayangkara FC Bhayangkara 34 48 27 66
4 Arema FC Arema FC 34 44 25 65
5 Persebaya Persebaya 34 56 35 63
6 Borneo Samarinda Borneo 34 43 35 52
7 PSIS Semarang PSIS 34 35 34 46
8 Persija Persija 34 43 40 45
9 Madura United Madura 34 45 43 41
10 Persikabo 1973 Persikabo 34 49 48 40
11 Persita Persita 34 39 49 39
12 Persik Kediri Persik 34 33 39 39
13 PSS Sleman PSS Sleman 34 40 48 39
14 PSM PSM 34 31 41 38
15 Barito Putera Barito 34 41 49 36
16 Persipura Persipura 34 36 47 36
17 Persela Persela 34 32 61 21
18 Persiraja Banda Aceh Persiraja 34 18 69 13
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
TEMPORADA 2013/2014
LIGA 1 INDONESIA GRUPO 1
Equipo PJ GF GC Puntos
1 Persebaya Persebaya 20 47 13 43
2 Persipura Persipura 20 29 15 39
3 Mitra Kukar Mitra Kukar 20 34 18 37
4 Persela Persela 20 28 33 28
5 Putra Samarinda Putra 20 29 22 25
6 PSM PSM 20 22 26 25
7 Persiba Balikpapan Persiba 20 21 28 25
8 Persiram Persiram 20 17 21 23
9 Persepam Persepam 20 28 35 23
10 Perseru Badak Lampung Perseru 20 21 29 23
11 Persiba Bantul Persiba 20 17 53 9
12 Arema FC Arema FC 20 49 13 46
13 Persib Persib 20 42 20 41
14 Semen Padang Semen Padang 20 30 17 38
15 Madura United Madura 20 30 21 35
16 Persija Persija 20 27 15 34
17 Sriwijaya Sriwijaya 20 22 29 23
18 Barito Putera Barito 20 23 31 22
19 Persik Kediri Persik 20 29 36 21
20 Gresik United Gresik 20 20 32 21
21 Persita Persita 20 21 35 15
22 Persijap Persijap 20 11 55 8
TEMPORADA 2009/2010
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 Arema FC Arema FC 34 57 22 73
2 Persipura Persipura 34 62 32 67
3 Persiba Balikpapan Persiba 34 44 31 54
4 Persib Persib 34 50 36 53
5 Persija Persija 34 41 36 52
6 Persiwa Wamena Persiwa 34 57 56 50
7 PSPS Pekanbaru PSPS 34 43 37 49
8 Sriwijaya FC Sriwijaya 34 48 49 48
9 Persijap Persijap 34 40 45 46
10 Persema Malang Persema 34 43 52 45
11 Bontang Bontang 34 53 52 44
12 Bali United Bali United 34 38 41 44
13 PSM PSM 34 31 46 43
14 Persela Persela 34 45 55 42
15 Madura United Madura 34 42 53 39
16 Persik Kediri Persik 34 41 55 39
17 Persebaya Persebaya 34 42 58 36
18 Persitara Jakarta Persitara 34 36 57 28
TEMPORADA 2008/2009
LIGA 1 INDONESIA
Equipo PJ GF GC Puntos
1 Persipura Persipura 34 81 25 80
2 Persiwa Wamena Persiwa 34 57 32 66
3 Persib Persib 34 63 40 66
4 Persik Kediri Persik 34 53 46 55
5 Sriwijaya FC Sriwijaya 34 60 45 54
6 Persela Persela 34 41 35 54
7 Persija Persija 34 61 48 53
8 PSM PSM 34 42 44 51
9 Pelita Bandung Raya Pelita 34 36 35 49
10 Arema FC Arema FC 34 40 42 47
11 Persijap Persijap 34 42 40 46
12 Persiba Balikpapan Persiba 34 40 42 46
13 Bontang Bontang 34 43 54 37
14 Persitara Jakarta Persitara 34 41 50 36
15 PSMS Medan PSMS Medan 34 41 54 31
16 Deltras Deltras 34 30 55 29
17 Persita Persita 34 26 65 25
18 PSIS Semarang PSIS 34 17 62 21

  USO DE MEMORIA  
5,899,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3148
Total Execution Time  0.3161
  CADENA URL  
/historico/Persik-Kediri
  GET DATOS  
$_GET['/historico/Persik-Kediri']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17677 AND type_rel = 2
0.0108  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 = '17677' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=17677 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72067,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 72067 AND teamId = 17677
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17677
0.0213  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72067 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '17677' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17677' and rp.type = 4
0.0106  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 = '17677' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0119  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 = 72067 WHERE rp.league_id = 72067 AND rp.teamId = 17677 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.0117  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 = 72067 WHERE rp.league_id = 72067 AND rp.teamId = 17677 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 72067 WHERE rp.league_id = 72067 AND rp.teamId = 17677 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 17677 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 71885 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.0110  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.0109  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
0.0110  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 = 3640 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 15627 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 15626 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC