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

Karacabey Birlikspor

Entrenador: Ahmet Tasyürek

Temporada 2023/2024
TEMPORADA 2023/2024
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Erokspor Erokspor 34 76 29 77
2 Vanspor FK Vanspor FK 34 57 33 75
3 Bucaspor Bucaspor 34 51 24 69
4 1461 Trabzon FK 1461 Trabzon 34 64 35 66
5 Mersin Mersin 34 47 29 58
6 Ankaraspor Ankaraspor 34 42 32 56
7 Karacabey Birlikspor Karacabey 34 40 32 50
8 Ankara Demirspor Ankara 34 37 38 47
9 Beyoglu Yeni Carsi FK Beyoglu Yeni 34 42 36 46
10 Kirklarelispor Kirklarelisp 35 32 38 44
11 Diyarbekirspor Diyarbekirsp 34 36 37 42
12 Altinordu Altinordu 34 40 34 41
13 Afjet Afyonspor Afjet 34 24 34 41
14 Serik Belediye Serik 34 29 37 40
15 Nazilli Belediyespor Nazilli 35 38 57 38
16 Zonguldak Kömürspor Zonguldak 34 35 54 32
17 Kirsehirspor Kirsehirspor 34 32 68 23
18 Bursaspor Bursaspor 34 24 62 20
19 Adıyaman 1954 Spor Adıyaman 34 24 61 16
TEMPORADA 2022/2023
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kocaelispor Kocaelispor 38 73 28 84
2 Bucaspor Bucaspor 38 63 22 81
3 İskenderunspor İskenderuns 38 65 31 77
4 1461 Trabzon FK 1461 Trabzon 38 62 27 74
5 Vanspor FK Vanspor FK 38 58 27 74
6 Ankara Demirspor Ankara 38 65 32 71
7 Karacabey Birlikspor Karacabey 38 55 31 68
8 Fethiyespor Fethiyespor 38 59 51 55
9 Zonguldak Kömürspor Zonguldak 38 45 50 53
10 Serik Belediye Serik 38 54 43 50
11 Kirsehirspor Kirsehirspor 38 49 54 48
12 Kirklarelispor Kirklarelisp 38 38 35 46
13 Etimesgut Etimesgut 38 43 51 45
14 Kastamonuspor Kastamonuspo 38 41 47 43
15 Sariyer Sariyer 38 46 57 42
16 Usakspor Usakspor 38 37 64 33
17 Balikesirspor Balikesirspo 38 32 76 25
18 Adıyaman 1954 Spor Adıyaman 37 22 70 23
19 Pazarspor Pazarspor 38 29 79 23
20 Diyarbekirspor Diyarbekirsp 37 18 79 15
TEMPORADA 2021/2022
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Pendikspor Pendikspor 34 56 25 77
2 Amedspor Amedspor 34 43 35 57
3 Karacabey Birlikspor Karacabey 34 58 41 56
4 Ispartaspor Ispartaspor 34 39 28 55
5 Tarsus Idman Yurdu Tarsus Idman 34 43 34 55
6 Erzincanspor Erzincanspor 34 59 42 54
7 Bucaspor Bucaspor 34 50 42 53
8 Ankara Demirspor Ankara 34 44 35 49
9 Kirsehirspor Kirsehirspor 34 44 35 49
10 Kirklarelispor Kirklarelisp 34 40 35 47
11 Sanliurfaspor Sanliurfaspo 34 50 41 46
12 Nazilli Belediyespor Nazilli 34 36 37 45
13 Usakspor Usakspor 34 31 47 40
14 Zonguldak Kömürspor Zonguldak 34 37 47 38
15 Pazarspor Pazarspor 34 35 60 34
16 Akhisar Belediyespor Akhisar 34 34 56 31
17 1922 Konyaspor 1922 34 36 52 29
18 Eskişehirspor Eskişehirsp 34 31 74 22
19 Kastamonuspor Kastamonuspo 0 0 0 0
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
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 3
Equipo PJ GF GC Puntos
1 Bayburt Bayburt 34 48 22 68
2 Kocaelispor Kocaelispor 34 40 31 58
3 Karacabey Birlikspor Karacabey 34 45 40 58
4 Corum FK Corum FK 34 42 32 52
5 Serik Belediye Serik 34 38 36 51
6 Turgutluspor Turgutluspor 34 49 47 49
7 Erzincanspor Erzincanspor 34 45 38 48
8 Payas Payas 34 32 37 48
9 Halide Edip Adivar Halide Edip 34 40 40 46
10 Diyarbekirspor Diyarbekirsp 34 38 40 45
11 Muğlaspor Muğlaspor 34 31 33 42
12 Çankaya FK Çankaya FK 34 37 35 41
13 Fatsa Belediye Fatsa 34 32 36 40
14 Golcukspor Golcukspor 34 28 32 40
15 Cizrespor 2010 Cizrespor 34 33 39 40
16 1461 Trabzon 1461 Trabzon 34 31 39 37
17 Bagcilarspor Bagcilarspor 34 37 47 37
18 Bucaspor Bucaspor 34 35 57 28
TEMPORADA 2017/2018
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Usakspor Usakspor 33 54 26 65
2 Tarsus Idman Yurdu Tarsus Idman 34 60 36 61
3 Sultanbeyli Belediyespor Sultanbeyli 34 52 34 58
4 Kizilcabolukspor Kizilcaboluk 34 54 39 56
5 23 Elazig 23 Elazig 34 43 40 52
6 Tepecik Belediyespor Tepecik 34 39 40 52
7 Corum FK Corum FK 34 51 39 48
8 Cizrespor 2010 Cizrespor 34 39 46 46
9 Karaköprü Bld. Karaköprü 34 46 33 45
10 1461 Trabzon FK 1461 Trabzon 34 48 50 45
11 Karacabey Birlikspor Karacabey 34 28 32 42
12 Payas Payas 34 37 46 41
13 Kocaelispor Kocaelispor 34 35 42 40
14 Çankaya FK Çankaya FK 34 32 40 38
15 Osmaniyespor Kulübü Osmaniyespor 34 37 49 38
16 Aydinspor Aydinspor 34 28 50 32
17 Tekirdağspor Tekirdağspo 34 42 64 30
18 Arsinspor Arsinspor 33 22 41 29

  USO DE MEMORIA  
6,085,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4831
Total Execution Time  0.4843
  CADENA URL  
/historico/Karacabey-Belediye-Genclik-Ve-Sp
  GET DATOS  
$_GET['/historico/Karacabey-Belediye-Genclik-Ve-Sp']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0183  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 = 'Karacabey-Belediye-Genclik-Ve-Sp' 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.0131  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=89810 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=89810 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=89810 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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.0133  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 = 74094
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89810 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=359 AND type_rel = 3
0.0128  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 = '89810' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '89810' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0128  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=89810 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73214 AND teamId = 89810
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 89810
0.0130  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 = 37 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0142  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 = 89810 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.0143  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 = 89810 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 89810 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 89810 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  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 = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 68199 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.0146  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.0143  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.0146  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 = 44491 AND t.round = 34 ORDER BY team.conference 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 `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 = 38980 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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