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

Manisa FK

Entrenador: Levent Devrim

Temporada 2019/2020
TEMPORADA 2019/2020
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 28 64 11 73
2 Manisa FK Manisa FK 28 79 31 63
3 1461 Trabzon FK 1461 Trabzon 28 51 34 55
4 Sancaktepe Belediye Istanbu Sancaktepe 28 51 23 52
5 Inegolspor Inegolspor 28 41 30 45
6 Afjet Afyonspor Afjet 28 47 30 43
7 Tarsus Idman Yurdu Tarsus Idman 28 45 39 43
8 Pendikspor Pendikspor 28 40 39 40
9 Sariyer Sariyer 28 34 33 40
10 Zonguldak Kömürspor Zonguldak 28 35 37 36
11 Corum FK Corum FK 28 36 42 36
12 Hacettepe SK Hacettepe 28 37 48 35
13 1922 Konyaspor 1922 28 38 45 33
14 Kirklarelispor Kirklarelisp 28 25 41 33
15 Mamak Fk Mamak Fk 27 34 41 28
16 Amedspor Amedspor 28 28 46 28
17 Gumushanespor Gumushanespo 27 31 54 25
18 Sanliurfaspor Sanliurfaspo 28 10 102 1
TEMPORADA 2018/2019
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Menemenspor Menemenspor 34 76 46 68
2 Fatih Karagümrük Fatih 33 52 34 65
3 Manisa FK Manisa FK 34 65 28 62
4 Tuzlaspor Tuzlaspor 34 57 25 59
5 Sanliurfaspor Sanliurfaspo 34 48 33 56
6 Etimesgut Etimesgut 34 46 41 55
7 Pendikspor Pendikspor 34 54 48 51
8 Kirklarelispor Kirklarelisp 34 46 40 45
9 Sivas Belediyespor Sivas 34 49 53 44
10 Tarsus Idman Yurdu Tarsus Idman 34 48 53 42
11 Zonguldak Kömürspor Zonguldak 34 36 49 42
12 Mamak Fk Mamak Fk 34 37 54 41
13 Bandirmaspor Bandirmaspor 34 46 57 38
14 Kahramanmarasspor Kahramanmara 34 38 54 38
15 1922 Konyaspor 1922 34 50 60 37
16 Fethiyespor Fethiyespor 34 35 40 35
17 Tokatspor Tokatspor 33 28 43 30
18 Darica Genclerbirligi Darica 34 26 79 21
TEMPORADA 2017/2018
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Manisa FK Manisa FK 34 60 27 75
2 Bayburt Bayburt 34 51 33 62
3 Kemerspor Kemerspor 34 62 44 57
4 Bayrampasaspor Bayrampasasp 34 43 34 57
5 Ofspor Ofspor 34 41 27 55
6 Düzcespor Düzcespor 34 41 34 55
7 Halide Edip Adivar Halide Edip 34 45 33 51
8 Batman Petrolspor Batman 34 43 36 48
9 Erbaaspor Erbaaspor 34 46 41 48
10 Kalecik FK Kalecik FK 34 42 44 42
11 Çatalca Spor Çatalca 34 33 37 41
12 Kozanspor Kozanspor 34 42 52 39
13 Yomraspor Yomraspor 34 23 42 37
14 İskenderunspor İskenderuns 34 35 53 36
15 12 Bingölspor Bingölspor 34 28 42 34
16 Bergama Belediyespor Bergama 34 35 54 34
17 Orhangazispor Orhangazispo 34 34 52 31
18 Canakkale Dardanelspor Canakkale 34 35 54 26
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  
5,761,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5449
Total Execution Time  0.5462
  CADENA URL  
/historico/Manisa-Bbsk/2020
  GET DATOS  
$_GET['/historico/Manisa-Bbsk/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0147  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 = 'Manisa-Bbsk' AND l.year = 2020 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.0126  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=65753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65753 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=65753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 50822
0.0130  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 = 57001
0.0132  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 = 51106
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65753 AND type_rel = 2
0.0133  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 = '65753' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '65753' AND l.year = 2020 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 = '65753' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 51106 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 50822 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=65753 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (59354,58623) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 58623 AND teamId = 65753
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 59354 AND teamId = 65753
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50822 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '65753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65753' and rp.type = 4
0.0127  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 = '65753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 50822 WHERE rp.league_id = 50822 AND rp.teamId = 65753 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.0144  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 events2020 e ON e.player_id = p.id AND e.league_id = 50822 WHERE rp.league_id = 50822 AND rp.teamId = 65753 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 events2020 e ON e.player_id = p.id AND e.league_id = 50822 WHERE rp.league_id = 50822 AND rp.teamId = 65753 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 65753 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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 = 50822 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.0145  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 = 44488 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 38978 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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.0137  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
0.0128  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 = 50822 ORDER BY nameShow LIMIT 100