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

Bodrumspor

Entrenador: Ismet Tasdemir

Temporada 2023/2024
TEMPORADA 2023/2024
1. LIG
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 31 70 27 69
2 Göztepe Göztepe 31 54 19 63
3 Corum FK Corum FK 31 52 31 55
4 Sakaryaspor Sakaryaspor 31 45 31 54
5 Bodrumspor Bodrumspor 31 39 21 52
6 Kocaelispor Kocaelispor 31 45 35 52
7 Bandirmaspor Bandirmaspor 31 46 27 47
8 Gençlerbirliği SK Gençlerbirl 31 37 30 47
9 Boluspor Boluspor 31 28 32 47
10 Erzurumspor Erzurumspor 31 28 27 41
11 Umraniyespor Umraniyespor 31 34 42 37
12 Manisa FK Manisa FK 31 38 37 36
13 Keciorengucu Keciorengucu 31 28 38 36
14 Sanliurfaspor Sanliurfaspo 31 28 33 34
15 Tuzlaspor Tuzlaspor 31 32 46 33
16 Adanaspor Adanaspor 31 24 44 32
17 Altay Altay 31 14 70 15
18 Giresunspor Giresunspor 31 13 65 7
TEMPORADA 2022/2023
1. LIG
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 36 70 26 78
2 Rizespor Rizespor 36 64 35 68
3 Pendikspor Pendikspor 36 65 36 67
4 Bodrumspor Bodrumspor 36 55 34 62
5 Sakaryaspor Sakaryaspor 36 59 47 62
6 Eyupspor Eyupspor 36 40 30 62
7 Göztepe Göztepe 35 45 28 60
8 Manisa FK Manisa FK 36 53 47 56
9 Keciorengucu Keciorengucu 36 59 47 56
10 Bandirmaspor Bandirmaspor 36 55 58 55
11 Boluspor Boluspor 36 44 46 52
12 Altay Altay 35 45 45 40
13 Erzurumspor Erzurumspor 36 43 48 39
14 Tuzlaspor Tuzlaspor 36 42 52 38
15 Gençlerbirliği SK Gençlerbirl 36 46 55 38
16 Altinordu Altinordu 36 41 57 35
17 Adanaspor Adanaspor 36 32 76 25
18 Denizlispor Denizlispor 36 35 67 23
19 Yeni Malatyaspor Yeni 36 22 81 16
TEMPORADA 2021/2022
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Sakaryaspor Sakaryaspor 38 75 24 84
2 1461 Trabzon FK 1461 Trabzon 38 63 32 74
3 Bodrumspor Bodrumspor 38 61 27 72
4 Sivas Belediyespor Sivas 38 66 34 69
5 Bayburt Bayburt 38 50 35 66
6 Vanspor FK Vanspor FK 38 55 46 66
7 Corum FK Corum FK 38 58 41 65
8 Afjet Afyonspor Afjet 38 67 44 62
9 Ankaraspor Ankaraspor 38 53 40 55
10 Somaspor Somaspor 38 50 50 53
11 Inegolspor Inegolspor 38 51 54 51
12 Etimesgut Etimesgut 38 45 54 47
13 Serik Belediye Serik 38 47 55 45
14 Sariyer Sariyer 38 50 59 43
15 Diyarbekirspor Diyarbekirsp 38 34 46 41
16 Adıyaman 1954 Spor Adıyaman 38 47 71 41
17 Turgutluspor Turgutluspor 38 31 62 37
18 Ergene Velimese Spor Ergene 38 38 72 35
19 Nigde Anadolu Nigde 38 45 84 29
20 Kahramanmarasspor Kahramanmara 38 23 79 19
TEMPORADA 2020/2021
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 38 82 25 92
2 Sakaryaspor Sakaryaspor 38 74 35 75
3 Kirsehirspor Kirsehirspor 38 57 32 72
4 Kirklarelispor Kirklarelisp 38 60 32 70
5 Vanspor FK Vanspor FK 38 59 35 69
6 Bodrumspor Bodrumspor 38 80 48 63
7 Etimesgut Etimesgut 38 63 36 61
8 Karacabey Birlikspor Karacabey 38 52 41 56
9 Turgutluspor Turgutluspor 38 44 56 54
10 Serik Belediye Serik 38 51 48 53
11 Pendikspor Pendikspor 38 66 53 52
12 Pazarspor Pazarspor 38 60 64 50
13 Tarsus Idman Yurdu Tarsus Idman 38 56 55 49
14 Bayburt Bayburt 38 52 61 48
15 Sivas Belediyespor Sivas 38 63 58 46
16 1922 Konyaspor 1922 38 47 49 42
17 Kastamonuspor Kastamonuspo 38 31 58 36
18 Elazigspor Elazigspor 38 61 90 33
19 Mamak Fk Mamak Fk 38 32 121 24
20 Karabükspor Karabükspor 38 16 109 3
TEMPORADA 2019/2020
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Bandirmaspor Bandirmaspor 28 58 26 60
2 Ankara Demirspor Ankara 28 46 21 57
3 Sakaryaspor Sakaryaspor 28 36 21 54
4 Kastamonuspor Kastamonuspo 28 49 28 53
5 Tuzlaspor Tuzlaspor 27 42 25 50
6 Kirsehirspor Kirsehirspor 28 33 24 47
7 Vanspor FK Vanspor FK 28 46 32 44
8 Usakspor Usakspor 27 40 34 44
9 Kahramanmarasspor Kahramanmara 28 30 32 41
10 Ergene Velimese Spor Ergene 28 43 34 37
11 Bodrumspor Bodrumspor 28 40 41 36
12 Sivas Belediyespor Sivas 28 36 38 36
13 Bayburt Bayburt 28 30 40 35
14 Eyupspor Eyupspor 28 25 39 29
15 Etimesgut Etimesgut 28 28 34 28
16 Elazigspor Elazigspor 26 18 53 19
17 Nigde Anadolu Nigde 28 28 52 17
18 Karabükspor Karabükspor 28 11 65 9
TEMPORADA 2018/2019
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Keciorengucu Keciorengucu 34 69 24 76
2 Kastamonuspor Kastamonuspo 34 67 23 74
3 Samsunspor Samsunspor 34 60 25 73
4 Sakaryaspor Sakaryaspor 34 63 31 69
5 Sariyer Sariyer 34 56 32 68
6 Sancaktepe Belediye Istanbu Sancaktepe 34 52 36 53
7 Bodrumspor Bodrumspor 34 56 48 52
8 Amedspor Amedspor 34 44 42 49
9 Eyupspor Eyupspor 34 50 46 46
10 Inegolspor Inegolspor 34 45 48 45
11 Usakspor Usakspor 34 40 39 40
12 Gumushanespor Gumushanespo 34 41 42 40
13 Nigde Anadolu Nigde 34 38 47 37
14 Ankara Demirspor Ankara 34 36 50 34
15 Hacettepe SK Hacettepe 34 45 58 33
16 Bayrampasaspor Bayrampasasp 34 32 53 33
17 Manisaspor Manisaspor 34 31 100 15
18 Gaziantepspor Gaziantepspo 34 11 92 11
TEMPORADA 2017/2018
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 34 63 15 76
2 Menemenspor Menemenspor 34 68 26 74
3 Afjet Afyonspor Afjet 34 62 31 70
4 Sivas Belediyespor Sivas 34 57 29 67
5 Keciorengucu Keciorengucu 34 77 41 64
6 Sancaktepe Belediye Istanbu Sancaktepe 34 58 32 59
7 Inegolspor Inegolspor 34 53 41 59
8 Sariyer Sariyer 34 44 45 44
9 Tokatspor Tokatspor 34 37 45 43
10 Etimesgut Etimesgut 34 44 47 42
11 Kastamonuspor Kastamonuspo 34 46 49 40
12 Amedspor Amedspor 34 37 41 40
13 Eyupspor Eyupspor 34 52 62 39
14 Tuzlaspor Tuzlaspor 34 42 51 38
15 Bodrumspor Bodrumspor 34 39 53 38
16 Bucaspor Bucaspor 34 51 60 36
17 Korfez FK Korfez FK 34 30 78 13
18 Mersin Mersin 34 19 133 1
TEMPORADA 2016/2017
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Bodrumspor Bodrumspor 34 59 31 65
2 Erbaaspor Erbaaspor 34 48 29 60
3 Manisa FK Manisa FK 34 59 37 58
4 Silivrispor Kulübü Silivrispor 34 34 25 58
5 Çatalca Spor Çatalca 34 42 33 55
6 Düzcespor Düzcespor 34 55 46 54
7 Halide Edip Adivar Halide Edip 34 46 39 53
8 Kirikhanspor Kirikhanspor 34 36 39 47
9 Kemerspor Kemerspor 34 52 45 45
10 Yomraspor Yomraspor 34 28 29 44
11 Batman Petrolspor Batman 34 38 38 43
12 Buca FK Buca FK 34 41 46 43
13 Yeşil Bursa Yeşil Bursa 34 40 35 41
14 Canakkale Dardanelspor Canakkale 34 42 54 41
15 Pazarspor Pazarspor 34 34 46 39
16 Dersim Spor Dersim Spor 34 33 54 33
17 Derince Belediyespor Derince 34 31 59 26
18 Turk Metal Kirikkale Turk Metal. 34 28 61 23
TEMPORADA 2015/2016
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Etimesgut Etimesgut 36 51 26 70
2 Bodrumspor Bodrumspor 36 48 23 60
3 Diyarbekirspor Diyarbekirsp 36 39 26 59
4 Ofspor Ofspor 36 43 28 58
5 Çankaya FK Çankaya FK 36 43 33 58
6 Orhangazispor Orhangazispo 36 40 32 54
7 Kemerspor Kemerspor 36 60 45 53
8 Sancaktepe Belediye Istanbu Sancaktepe 36 43 46 51
9 Denizli Belediyespor Denizli 36 42 39 50
10 Sultanbeyli Belediyespor Sultanbeyli 36 33 31 49
11 Derince Belediyespor Derince 36 35 42 49
12 Sakaryaspor Sakaryaspor 36 36 42 48
13 Yomraspor Yomraspor 36 39 48 47
14 Payas Payas 36 38 39 46
15 Manisa FK Manisa FK 36 37 40 46
16 Kahramanmaras Belediyespor Kahramanmara 36 33 37 42
17 Zaraspor Zaraspor 36 26 49 33
18 Ayvalikgucu Belediyespor Ayvalikgucu 36 40 64 33
19 Gaziosmanpasaspor Gaziosmanpas 36 30 66 25

  USO DE MEMORIA  
6,467,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5231
Total Execution Time  0.5244
  CADENA URL  
/historico/Bodrumspor
  GET DATOS  
$_GET['/historico/Bodrumspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0137  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 = 'Bodrumspor' 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.0125  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=65752 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65752 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65752 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65752 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65752 AND type_rel = 2
0.0132  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 = '65752' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '65752' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144  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=65752 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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,72493,71798,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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72493 AND teamId = 65752
0.0183  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 65752
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71798 AND teamId = 65752
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65752
0.0134  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 = '65752' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65752' and rp.type = 4
0.0133  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 = '65752' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 65752 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.0152  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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 65752 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 65752 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 65752 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0271  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 = 68073 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.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 `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 = 63658 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.0138  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 = 58624 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.0133  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 = 50823 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.0136  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 = 44487 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 38969 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 33914 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 15824 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC