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

Erokspor

Entrenador: Mehmet Altiparmak

Temporada 2023/2024
TEMPORADA 2023/2024
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Erokspor Erokspor 35 77 29 80
2 Vanspor FK Vanspor FK 35 63 34 78
3 Bucaspor Bucaspor 35 51 24 70
4 1461 Trabzon FK 1461 Trabzon 35 66 35 69
5 Mersin Mersin 35 48 31 58
6 Ankaraspor Ankaraspor 35 42 32 57
7 Karacabey Birlikspor Karacabey 35 42 34 51
8 Beyoglu Yeni Carsi FK Beyoglu Yeni 35 44 37 49
9 Ankara Demirspor Ankara 35 38 44 47
10 Diyarbekirspor Diyarbekirsp 35 38 38 45
11 Kirklarelispor Kirklarelisp 35 32 38 44
12 Altinordu Altinordu 35 42 36 42
13 Afjet Afyonspor Afjet 35 24 34 42
14 Serik Belediye Serik 35 29 39 40
15 Nazilli Belediyespor Nazilli 36 38 57 39
16 Zonguldak Kömürspor Zonguldak 35 38 56 35
17 Kirsehirspor Kirsehirspor 35 34 71 23
18 Bursaspor Bursaspor 35 25 64 20
19 Adıyaman 1954 Spor Adıyaman 35 24 62 16
TEMPORADA 2022/2023
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Corum FK Corum FK 36 65 24 79
2 Sanliurfaspor Sanliurfaspo 36 75 25 75
3 Erokspor Erokspor 36 77 35 62
4 Amedspor Amedspor 36 63 36 60
5 Erzincanspor Erzincanspor 36 50 34 58
6 Ankaraspor Ankaraspor 36 58 42 58
7 Somaspor Somaspor 36 54 35 57
8 Düzcespor Düzcespor 36 55 46 52
9 Menemenspor Menemenspor 36 57 44 51
10 Afjet Afyonspor Afjet 36 48 47 47
11 Inegolspor Inegolspor 36 40 53 47
12 Ispartaspor Ispartaspor 36 43 42 46
13 Nazilli Belediyespor Nazilli 36 48 48 46
14 Arnavutkoy Arnavutkoy 36 41 42 46
15 Bursaspor Bursaspor 36 51 57 46
16 Batman Petrolspor Batman 36 40 44 45
17 Tarsus Idman Yurdu Tarsus Idman 36 26 125 21
18 Bayburt Bayburt 36 25 68 19
19 Sivas Belediyespor Sivas 36 27 96 15
TEMPORADA 2021/2022
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Erokspor Erokspor 34 84 26 76
2 Fethiyespor Fethiyespor 34 64 34 66
3 İçel İdmanyurdu Spor İçel 34 42 18 66
4 Orduspor 1967 Orduspor 34 66 33 64
5 Ofspor Ofspor 34 65 43 60
6 Belediye Derincespor Belediye 34 51 28 57
7 MKE Kırıkkalespor Kırıkkales 34 51 29 57
8 Karsiyaka Karsiyaka 34 55 34 49
9 Edirnespor Edirnespor 34 50 36 48
10 Tepecik Belediyespor Tepecik 34 49 42 44
11 Karaköprü Bld. Karaköprü 34 46 39 44
12 Ağrı Spor Ağrı Spor 34 39 43 42
13 Gumushanespor Gumushanespo 34 39 36 41
14 Çankaya FK Çankaya FK 34 37 44 41
15 Mardin Fosfat Mardin 34 42 42 37
16 Modafenspor Modafenspor 34 37 50 32
17 Karabükspor Karabükspor 34 11 126 4
18 Ceyhanspor Adana Ceyhanspor 34 12 137 4
TEMPORADA 2020/2021
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Somaspor Somaspor 32 64 30 69
2 Erokspor Erokspor 32 59 27 64
3 Ispartaspor Ispartaspor 32 49 35 50
4 İçel İdmanyurdu Spor İçel 32 41 32 50
5 Çatalca Spor Çatalca 32 35 31 49
6 Çarşambaspor Çarşambasp 32 37 29 45
7 Osmaniyespor Kulübü Osmaniyespor 32 35 32 44
8 Karsiyaka Karsiyaka 32 36 39 44
9 Kalecik FK Kalecik FK 32 36 34 43
10 Sile Yildizspor Sile 32 38 39 43
11 23 Elazig 23 Elazig 32 37 38 42
12 Erbaaspor Erbaaspor 32 29 35 40
13 Batman Petrolspor Batman 32 24 30 39
14 Cizrespor 2010 Cizrespor 32 30 55 32
15 Golcukspor Golcukspor 32 27 39 30
16 Arhavispor Arhavispor 32 23 49 27
17 Yalovaspor Yalovaspor 32 26 52 22
TEMPORADA 2019/2020
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kocaelispor Kocaelispor 27 56 22 64
2 Belediye Derincespor Belediye 27 41 28 50
3 Turgutluspor Turgutluspor 26 34 19 49
4 Erokspor Erokspor 27 42 25 47
5 Karsiyaka Karsiyaka 26 33 23 43
6 Tepecik Belediyespor Tepecik 27 29 30 41
7 Ofspor Ofspor 26 35 31 38
8 Fethiyespor Fethiyespor 26 28 25 38
9 Ağrı Spor Ağrı Spor 27 32 35 32
10 Cizrespor 2010 Cizrespor 24 31 33 31
11 Kozanspor Kozanspor 26 25 35 31
12 Fatsa Belediye Fatsa 26 24 35 29
13 Erbaaspor Erbaaspor 26 26 37 27
14 Payas Payas 26 23 33 25
15 23 Elazig 23 Elazig 25 22 35 25
16 1877 Alemdağspor 1877 26 28 42 22
17 Kemerspor Kemerspor 26 28 49 22
TEMPORADA 2018/2019
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kirsehirspor Kirsehirspor 34 54 38 63
2 Erokspor Erokspor 34 56 30 62
3 Vanspor FK Vanspor FK 34 60 27 60
4 Kizilcabolukspor Kizilcaboluk 34 60 39 55
5 Karsiyaka Karsiyaka 34 39 32 55
6 Kalecik FK Kalecik FK 34 46 30 54
7 Çatalca Spor Çatalca 34 39 45 48
8 Pazarspor Pazarspor 34 39 42 47
9 52 Orduspor 52 Orduspor 34 49 38 46
10 Osmaniyespor Kulübü Osmaniyespor 34 40 42 44
11 Sultanbeyli Belediyespor Sultanbeyli 34 32 39 43
12 Kemerspor Kemerspor 34 36 45 43
13 Düzcespor Düzcespor 34 35 44 43
14 Ofspor Ofspor 34 37 39 42
15 23 Elazig 23 Elazig 34 34 50 41
16 Adıyaman 1954 Spor Adıyaman 34 35 51 37
17 Alibeykoyspor Alibeykoyspo 34 40 51 33
18 Bergama Belediyespor Bergama 34 25 74 15
TEMPORADA 2017/2018
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Darica Genclerbirligi Darica 34 64 18 72
2 Ankara Demirspor Ankara 34 60 31 71
3 Diyarbekirspor Diyarbekirsp 34 63 40 64
4 Buca FK Buca FK 34 52 28 61
5 Erzincanspor Erzincanspor 34 53 30 61
6 Pazarspor Pazarspor 34 47 36 58
7 52 Orduspor 52 Orduspor 34 52 33 55
8 Vanspor FK Vanspor FK 34 56 47 49
9 Anadolu Bağcılar Anadolu 34 47 48 49
10 Golcukspor Golcukspor 34 56 49 47
11 Turgutluspor Turgutluspor 34 46 47 47
12 Erokspor Erokspor 34 42 37 46
13 Muğlaspor Muğlaspor 34 36 36 41
14 1461 Trabzon 1461 Trabzon 34 51 54 38
15 Ergene Velimese Spor Ergene 34 38 43 37
16 Kirikhanspor Kirikhanspor 34 28 55 27
17 Yeşil Bursa Yeşil Bursa 34 24 55 22
18 Kayseri Kayseri 34 17 145 3

  USO DE MEMORIA  
6,009,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1184
Total Execution Time  0.1200
  CADENA URL  
/historico/Erokspor
  GET DATOS  
$_GET['/historico/Erokspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0031  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Erokspor' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=101994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=101994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=101994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044  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 = 73214
0.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101994 AND type_rel = 2
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '101994' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '101994' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 73214 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=101994 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,73214,71799) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73214 AND teamId = 101994
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 101994
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71799 AND teamId = 101994
0.0028  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 = 73214 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '101994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '101994' 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 = '101994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 101994 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.0040  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 101994 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 101994 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 101994 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 = 73214 AND t.round = 38 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 `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 = 68198 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 63656 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.0035  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 = 58627 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.0029  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 = 50978 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.0042  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 = 38979 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73214 ORDER BY nameShow LIMIT 100