4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nevşehir Belediyespor

Nevşehir Belediyespor

Entrenador: Halim Karaköse

Temporada 2023/2024
TEMPORADA 2023/2024
3. LIG GRUPO 4
Equipo PJ GF GC Puntos
1 Adana 1954 FK Adana 1954 28 60 27 63
2 Sebat Gençlik SK Sebat 28 42 27 50
3 Muş Menderesspor Muş 28 41 29 47
4 Tokat Bld Plevnespor Tokat 28 32 27 45
5 Alanya Kestelspor Alanya 28 42 33 43
6 Bursa Yıldırımspor Bursa 28 39 34 42
7 Orduspor 1967 Orduspor 28 49 33 41
8 Balikesirspor Balikesirspo 28 28 32 33
9 Bergama Belediyespor Bergama 28 34 39 31
10 Çankaya FK Çankaya FK 28 26 37 31
11 23 Elazig 23 Elazig 28 25 42 31
12 Nevşehir Belediyespor Nevşehir 28 19 31 30
13 Siirt İl Özel İdaresi Siirt Özel 28 21 32 29
14 Çatalca Spor Çatalca 28 27 38 26
15 Sultanbeyli Belediyespor Sultanbeyli 28 26 50 25
TEMPORADA 2022/2023
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Mersin Mersin 34 49 21 68
2 Belediye Derincespor Belediye 34 51 24 66
3 Belediye Kütahyaspor Belediye 34 52 34 65
4 52 Orduspor 52 Orduspor 34 54 34 64
5 Nevşehir Belediyespor Nevşehir 34 52 40 58
6 Karaköprü Bld. Karaköprü 34 44 32 56
7 Karsiyaka Karsiyaka 34 44 28 54
8 Çatalca Spor Çatalca 34 40 39 44
9 Yeni Amasyaspor Yeni 34 33 36 44
10 Elazigspor Elazigspor 34 44 53 42
11 1922 Konyaspor 1922 34 42 47 41
12 Hacettepe SK Hacettepe 34 41 50 36
13 Ağrı Spor Ağrı Spor 34 23 39 36
14 Edirnespor Edirnespor 34 35 45 35
15 1954 Kelkit Belediyespor 1954 Kelkit 34 25 35 35
16 Yomraspor Yomraspor 34 36 42 34
17 Eskişehirspor Eskişehirsp 34 39 69 26
18 Sile Yildizspor Sile 34 29 65 26
TEMPORADA 2021/2022
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Batman Petrolspor Batman 34 55 29 74
2 Belediye Kütahyaspor Belediye 34 63 32 66
3 Bursa Yıldırımspor Bursa 34 45 27 62
4 Artvin Hopaspor Artvin 34 45 26 59
5 Arnavutkoy Arnavutkoy 34 47 29 59
6 Erbaaspor Erbaaspor 34 48 33 52
7 Çatalca Spor Çatalca 34 47 32 50
8 Nevşehir Belediyespor Nevşehir 34 56 53 50
9 1954 Kelkit Belediyespor 1954 Kelkit 34 41 40 48
10 Bergama Belediyespor Bergama 34 54 47 46
11 Fatsa Belediye Fatsa 34 32 31 42
12 Osmaniyespor Kulübü Osmaniyespor 34 33 34 40
13 Karaman FK Karaman FK 34 33 44 40
14 Kahta 02 Spor Kahta Spor 34 39 42 39
15 Elazigspor Elazigspor 34 36 51 39
16 Hendek Spor Hendek Spor 34 33 41 32
17 Mamak Fk Mamak Fk 34 22 79 18
18 Sancaktepe Belediye Istanbu Sancaktepe 34 28 87 13
TEMPORADA 2020/2021
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Diyarbekirspor Diyarbekirsp 30 43 18 68
2 Bucaspor Bucaspor 30 58 18 67
3 Yeşilyurt Belediyespor Yeşilyurt 30 50 27 56
4 Ofspor Ofspor 30 43 31 53
5 Arnavutkoy Arnavutkoy 30 40 29 48
6 Edirnespor Edirnespor 30 34 31 45
7 Belediye Derincespor Belediye 30 41 29 43
8 Artvin Hopaspor Artvin 30 41 44 39
9 Fatsa Belediye Fatsa 30 22 31 38
10 Kizilcabolukspor Kizilcaboluk 30 34 33 37
11 Nevşehir Belediyespor Nevşehir 30 31 31 34
12 Çankaya FK Çankaya FK 30 28 48 34
13 1877 Alemdağspor 1877 30 37 48 33
14 Kemerspor Kemerspor 30 27 50 27
15 Payas Payas 30 29 56 23
16 Manisaspor Manisaspor 30 22 56 12
TEMPORADA 2019/2020
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Karacabey Birlikspor Karacabey 28 45 17 64
2 Somaspor Somaspor 28 39 29 45
3 Pazarspor Pazarspor 27 48 41 44
4 Nevşehir Belediyespor Nevşehir 28 28 19 42
5 Muğlaspor Muğlaspor 28 39 34 41
6 Osmaniyespor Kulübü Osmaniyespor 28 35 32 41
7 Nazilli Belediyespor Nazilli 28 47 30 40
8 Diyarbekirspor Diyarbekirsp 28 35 28 40
9 1954 Kelkit Belediyespor 1954 Kelkit 28 34 30 40
10 Darica Genclerbirligi Darica 28 29 34 35
11 Halide Edip Adivar Halide Edip 28 22 30 35
12 Yozgatspor Yozgatspor 28 24 32 34
13 Bayrampasaspor Bayrampasasp 28 22 24 33
14 Golcukspor Golcukspor 28 31 42 31
15 Yeşilyurt Belediyespor Yeşilyurt 27 27 32 29
16 Kalecik FK Kalecik FK 28 29 42 28
17 Batman Petrolspor Batman 28 31 49 28
18 Modafenspor Modafenspor 28 19 39 27
TEMPORADA 2018/2019
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 1461 Trabzon FK 1461 Trabzon 32 47 17 66
2 Nazilli Belediyespor Nazilli 32 57 27 65
3 Buca FK Buca FK 32 48 27 59
4 Nevşehir Belediyespor Nevşehir 32 50 30 57
5 Ergene Velimese Spor Ergene 32 43 33 50
6 Karaköprü Bld. Karaköprü 32 44 45 44
7 Artvin Hopaspor Artvin 32 33 33 42
8 Erbaaspor Erbaaspor 32 35 35 40
9 Silivrispor Kulübü Silivrispor 32 30 29 39
10 Yomraspor Yomraspor 32 39 46 39
11 Sile Yildizspor Sile 32 45 47 38
12 Batman Petrolspor Batman 32 36 44 38
13 İskenderunspor İskenderuns 32 47 43 37
14 Kozanspor Kozanspor 32 28 36 37
15 Tepecik Belediyespor Tepecik 32 36 46 37
16 Gebzespor Gebzespor 32 30 38 34
17 Korfez FK Korfez FK 32 16 88 8

  USO DE MEMORIA  
5,739,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4134
Total Execution Time  0.4149
  CADENA URL  
/historico/Nevsehirspor-Genclik
  GET DATOS  
$_GET['/historico/Nevsehirspor-Genclik']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92570 AND type_rel = 2
0.0166  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 = '92570' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0175  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=92570 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (74094,73222,71801) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73222 AND teamId = 92570
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 92570
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71801 AND teamId = 92570
0.0148  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 = '92570' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92570' and rp.type = 4
0.0146  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 = '92570' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 92570 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.0158  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 92570 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 92570 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 92570 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0296  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 = 68887 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.0150  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 = 63654 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.0148  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 = 58625 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.0150  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 = 50979 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 44489 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC