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

KS Cracovia

Entrenador: Dawid Kroczek

Temporada 2016/2017
TEMPORADA 2016/2017
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 7 14 9 34
2 Piast Gliwice Piast 7 14 5 31
3 Śląsk Wrocław Śląsk 7 15 7 29
4 Wisła Płock Wisła 7 7 13 28
5 KS Cracovia KS Cracovia 7 7 9 24
6 Arka Gdynia Arka Gdynia 7 7 10 24
7 Górnik Łęczna Górnik 7 11 11 22
8 Ruch Chorzów Ruch 7 5 16 19
TEMPORADA 2015/2016
LIGA POLACA GRUPO 2
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 7 12 4 43
2 Piast Gliwice Piast 7 11 9 40
3 Zaglebie Lubin Zaglebie 7 14 5 38
4 KS Cracovia KS Cracovia 7 9 8 36
5 Lechia Gdansk Lechia 7 8 7 33
6 Pogon Szczecin Pogon 7 7 13 30
7 Lech Poznań Lech Poznań 7 5 9 27
8 Ruch Chorzów Ruch 7 3 14 21
TEMPORADA 2014/2015
LIGA POLACA GRUPO 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 57 30 56
2 Lech Poznań Lech Poznań 30 53 27 56
3 Jagiellonia Bialystok Jagiellonia 30 43 35 49
4 Śląsk Wrocław Śląsk 30 44 36 48
5 Górnik Zabrze Górnik 30 43 43 43
6 Wisla Kraków Wisla 30 47 40 42
7 Pogon Szczecin Pogon 30 40 38 41
8 Lechia Gdansk Lechia 30 36 37 41
9 Piast Gliwice Piast 30 38 43 39
10 Korona Kielce Korona 30 34 42 39
11 Podbeskidzie Podbeskidzie 30 40 49 38
12 KS Cracovia KS Cracovia 30 35 41 37
13 Górnik Łęczna Górnik 30 31 37 34
14 Ruch Chorzów Ruch 30 33 38 33
15 GKS Bełchatów Bełchatów 30 24 42 31
16 Zawisza Bydgoszcz Zawisza 30 32 52 29
TEMPORADA 2013/2014
LIGA POLACA GRUPO 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 60 30 63
2 Lech Poznań Lech Poznań 30 56 34 53
3 Ruch Chorzów Ruch 30 40 38 50
4 Pogon Szczecin Pogon 30 47 38 47
5 Wisla Kraków Wisla 30 38 30 45
6 Zawisza Bydgoszcz Zawisza 30 43 37 42
7 Górnik Zabrze Górnik 30 42 46 42
8 Lechia Gdansk Lechia 30 38 37 40
9 Jagiellonia Bialystok Jagiellonia 30 46 43 39
10 KS Cracovia KS Cracovia 30 37 43 39
11 Korona Kielce Korona 30 36 41 37
12 Śląsk Wrocław Śląsk 30 38 40 34
13 Piast Gliwice Piast 30 29 47 34
14 Podbeskidzie Podbeskidzie 30 27 39 31
15 Zaglebie Lubin Zaglebie 30 31 40 29
16 Widzew Łódź Widzew 30 26 51 22
TEMPORADA 2012/2013
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zawisza Bydgoszcz Zawisza 34 69 26 66
2 KS Cracovia KS Cracovia 34 48 35 64
3 Termalica Nieciecza Termalica 34 54 28 63
4 Swinoujscie Swinoujscie 34 57 33 63
5 Arka Gdynia Arka Gdynia 34 46 29 57
6 GKS Tychy GKS Tychy 34 44 28 55
7 Dolcan Zabki Dolcan Zabki 34 52 41 54
8 Miedz Legnica Miedz 34 49 42 53
9 Olimpia Grudziadz Olimpia 34 39 34 51
10 GKS Katowice Katowice 34 43 36 50
11 Kolejarz Stroze Kolejarz 34 47 45 50
12 Górnik Łęczna Górnik 34 37 42 46
13 Stomil Olsztyn Stomil 34 37 45 38
14 Sandecja Nowy Sacz Sandecja 34 35 54 37
15 Brzesko Brzesko 34 38 54 32
16 Warta Poznan Warta Poznan 34 34 57 28
17 TS Polonia Bytom Polonia 34 29 64 22
18 LKS Lódz LKS Lódz 34 17 82 14
TEMPORADA 2011/2012
LIGA POLACA
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 30 47 31 56
2 Ruch Chorzów Ruch 30 44 28 55
3 Legia Warszawa Legia 30 42 17 53
4 Lech Poznań Lech Poznań 30 42 22 52
5 Korona Kielce Korona 30 34 29 48
6 Polonia W. Polonia W. 30 33 32 45
7 Wisla Kraków Wisla 30 29 26 43
8 Górnik Zabrze Górnik 30 36 30 42
9 Zaglebie Lubin Zaglebie 30 36 42 40
10 Widzew Łódź Widzew 30 25 26 39
11 Jagiellonia Bialystok Jagiellonia 30 35 45 39
12 Podbeskidzie Podbeskidzie 30 26 39 35
13 GKS Bełchatów Bełchatów 30 34 36 31
14 Lechia Gdansk Lechia 30 21 30 31
15 LKS Lódz LKS Lódz 30 23 53 24
16 KS Cracovia KS Cracovia 30 20 41 22
TEMPORADA 2010/2011
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 44 29 56
2 Śląsk Wrocław Śląsk 30 46 34 49
3 Legia Warszawa Legia 30 45 38 49
4 Jagiellonia Bialystok Jagiellonia 30 38 32 48
5 Lech Poznań Lech Poznań 30 37 23 45
6 Górnik Zabrze Górnik 30 36 40 45
7 Polonia W. Polonia W. 30 41 26 44
8 Widzew Łódź Widzew 30 41 34 43
9 Lechia Gdansk Lechia 30 37 36 43
10 GKS Bełchatów Bełchatów 30 31 33 40
11 Zaglebie Lubin Zaglebie 30 31 38 39
12 Ruch Chorzów Ruch 30 29 32 38
13 Korona Kielce Korona 30 34 48 37
14 KS Cracovia KS Cracovia 30 37 47 29
15 Arka Gdynia Arka Gdynia 30 22 43 28
16 TS Polonia Bytom Polonia 30 29 45 27
TEMPORADA 2009/2010
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 51 20 65
2 Wisla Kraków Wisla 30 48 20 62
3 Ruch Chorzów Ruch 30 40 30 53
4 Legia Warszawa Legia 30 36 22 52
5 GKS Bełchatów Bełchatów 30 37 27 48
6 Lechia Gdansk Lechia 30 30 32 37
7 TS Polonia Bytom Polonia 30 29 31 37
8 Korona Kielce Korona 30 35 41 37
9 Śląsk Wrocław Śląsk 30 32 33 36
10 Zaglebie Lubin Zaglebie 30 30 38 35
11 Jagiellonia Bialystok Jagiellonia 30 29 27 34
12 KS Cracovia KS Cracovia 30 25 39 34
13 Polonia W. Polonia W. 30 25 38 33
14 Arka Gdynia Arka Gdynia 30 28 39 28
15 Odra Wodzislaw Slaski Odra 30 27 45 27
16 Piast Gliwice Piast 30 30 50 27
TEMPORADA 2008/2009
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 53 21 64
2 Legia Warszawa Legia 30 52 17 61
3 Lech Poznań Lech Poznań 30 51 24 59
4 Polonia Warszawa Polonia 30 40 23 54
5 GKS Bełchatów Bełchatów 30 40 28 54
6 Śląsk Wrocław Śląsk 30 40 34 45
7 TS Polonia Bytom Polonia 30 30 46 35
8 LKS Lódz LKS Lódz 30 27 43 35
9 Jagiellonia Bialystok Jagiellonia 30 28 34 34
10 Ruch Chorzów Ruch 30 22 32 34
11 Piast Gliwice Piast 30 17 26 33
12 Lechia Gdansk Lechia 30 30 44 32
13 Odra Wodzislaw Slaski Odra 30 23 40 32
14 Arka Gdynia Arka Gdynia 30 27 39 30
15 KS Cracovia KS Cracovia 30 24 40 30
16 Górnik Zabrze Górnik 30 20 33 29
TEMPORADA 2007/2008
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 68 18 77
2 Legia Warszawa Legia 30 48 17 63
3 Dyskobolia Grodzisk Dyskobolia 30 52 24 60
4 Lech Poznań Lech Poznań 30 55 32 57
5 Zaglebie Lubin Zaglebie 30 43 30 52
6 Korona Kielce Korona 30 38 32 51
7 KS Cracovia KS Cracovia 30 30 32 39
8 Górnik Zabrze Górnik 30 34 39 39
9 GKS Bełchatów Bełchatów 30 26 32 38
10 Ruch Chorzów Ruch 30 35 41 34
11 LKS Lódz LKS Lódz 30 25 31 30
12 Odra Wodzislaw Slaski Odra 30 28 47 29
13 TS Polonia Bytom Polonia 30 22 45 28
14 Jagiellonia Bialystok Jagiellonia 30 27 57 27
15 Widzew Łódź Widzew 30 27 42 26
16 Zagłębie Sosnowiec Zagłębie 30 19 58 16
TEMPORADA 2006/2007
LIGA POLACA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 30 57 29 62
2 GKS Bełchatów Bełchatów 30 63 32 61
3 Legia Warszawa Legia 30 53 33 52
4 KS Cracovia KS Cracovia 30 48 41 49
5 Dyskobolia Grodzisk Dyskobolia 30 40 26 48
6 Lech Poznań Lech Poznań 30 53 36 47
7 Korona Kielce Korona 30 41 34 47
8 Wisla Kraków Wisla 30 41 25 46
9 LKS Lódz LKS Lódz 30 31 30 41
10 Arka Gdynia Arka Gdynia 30 43 39 40
11 Odra Wodzislaw Slaski Odra 30 29 36 40
12 Widzew Łódź Widzew 30 27 48 28
13 Górnik Łęczna Górnik 30 24 64 26
14 Górnik Zabrze Górnik 30 30 51 25
15 Wisła Płock Wisła 30 20 47 23
16 Pogon Szczecin Pogon 30 24 53 16
TEMPORADA 2005/2006
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 47 17 66
2 Wisla Kraków Wisla 30 50 20 64
3 Amica Wronki Amica Wronki 30 50 28 49
4 Zaglebie Lubin Zaglebie 30 45 32 49
5 Korona Kielce Korona 30 46 33 47
6 Lech Poznań Lech Poznań 30 45 45 42
7 Odra Wodzislaw Slaski Odra 30 23 27 40
8 GKS Bełchatów Bełchatów 30 30 32 37
9 Pogon Szczecin Pogon 30 29 34 37
10 Dyskobolia Grodzisk Dyskobolia 30 37 45 37
11 KS Cracovia KS Cracovia 30 32 44 37
12 Wisła Płock Wisła 30 30 45 34
13 Górnik Łęczna Górnik 30 23 31 33
14 Górnik Zabrze Górnik 30 29 46 29
15 Arka Gdynia Arka Gdynia 30 21 33 27
16 Polonia Warszawa Polonia 30 20 45 25
TEMPORADA 2004/2005
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 26 70 23 62
2 Dyskobolia Grodzisk Dyskobolia 26 46 28 51
3 Legia Warszawa Legia 26 42 19 47
4 Wisła Płock Wisła 26 35 30 41
5 KS Cracovia KS Cracovia 26 37 29 40
6 Amica Wronki Amica Wronki 26 29 28 38
7 Górnik Łęczna Górnik 26 36 36 36
8 Lech Poznań Lech Poznań 26 34 40 34
9 Pogon Szczecin Pogon 26 34 43 31
10 Polonia Warszawa Polonia 26 27 52 29
11 Górnik Zabrze Górnik 26 27 30 28
12 Zaglebie Lubin Zaglebie 26 31 41 28
13 Odra Wodzislaw Slaski Odra 26 27 41 24
14 GKS Katowice Katowice 26 23 58 16
TEMPORADA 2003/2004
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Pogon Szczecin Pogon 30 60 22 62
2 Szczakowianka Jaworzno Szczakowiank 30 56 34 62
3 Zaglebie Lubin Zaglebie 30 41 25 61
4 KS Cracovia KS Cracovia 30 55 24 57
5 GKS Bełchatów Bełchatów 30 47 25 57
6 Radomsko Radomsko 30 41 24 52
7 Podbeskidzie Podbeskidzie 30 37 45 40
8 LKS Lódz LKS Lódz 30 28 34 39
9 Jagiellonia Bialystok Jagiellonia 30 35 42 37
10 Piast Gliwice Piast 30 33 43 36
11 Ruch Chorzów Ruch 30 34 37 35
12 Ceramika Opoczno Ceramika 30 31 37 30
13 Arka Gdynia Arka Gdynia 30 25 37 29
14 Tloki Tloki 30 28 42 26
15 Polar Polar 30 23 68 20
16 Aluminium Aluminium 30 15 50 16
TEMPORADA 1983/1984
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 47 21 42
2 Widzew Łódź Widzew 30 43 25 42
3 Pogon Szczecin Pogon 30 54 27 38
4 Górnik Zabrze Górnik 30 34 26 34
5 Legia Warszawa Legia 30 42 32 33
6 Górnik Wałbrzych Górnik 30 40 35 31
7 Ruch Chorzów Ruch 30 30 30 30
8 Śląsk Wrocław Śląsk 30 41 47 30
9 GKS Katowice Katowice 30 41 42 29
10 Motor Lublin Motor Lublin 30 22 24 29
11 Wisla Kraków Wisla 30 33 38 27
12 Zagłębie Sosnowiec Zagłębie 30 25 35 27
13 Bałtyk Gdynia Bałtyk 30 25 30 25
14 LKS Lódz LKS Lódz 30 29 43 25
15 KS Cracovia KS Cracovia 30 19 35 21
16 Szombierki Bytom Szombierki 30 23 58 17
TEMPORADA 1982/1983
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 42 31 39
2 Widzew Łódź Widzew 30 50 30 38
3 Ruch Chorzów Ruch 30 34 22 35
4 Pogon Szczecin Pogon 30 44 28 33
5 Wisla Kraków Wisla 30 44 36 32
6 Śląsk Wrocław Śląsk 30 35 34 30
7 LKS Lódz LKS Lódz 30 36 38 30
8 Legia Warszawa Legia 30 43 39 29
9 Szombierki Bytom Szombierki 30 34 37 29
10 Bałtyk Gdynia Bałtyk 30 28 31 29
11 Zagłębie Sosnowiec Zagłębie 30 29 37 29
12 Górnik Zabrze Górnik 30 30 38 28
13 GKS Katowice Katowice 30 28 34 27
14 KS Cracovia KS Cracovia 30 20 33 27
15 Stal Mielec Stal Mielec 30 27 36 24
16 Gwardia Warszawa Gwardia 30 26 46 21

  USO DE MEMORIA  
7,389,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1964
Total Execution Time  0.1983
  CADENA URL  
/historico/Mks-Cracovia-Krakow/2017
  GET DATOS  
$_GET['/historico/Mks-Cracovia-Krakow/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0038  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 = 'Mks-Cracovia-Krakow' AND l.year = 2017 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.0020  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=1703 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1703 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1703 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=1703 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=1703 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=1703 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 31530
0.0026  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 = 38340
0.0028  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 = 31916
0.0027  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 = 33386
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1703 AND type_rel = 2
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1703 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (40650,44000,44521,73058,96047) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '1703' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '1703' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 33386 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 31916 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 31530 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  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=1703 AND l.year in (2016,2017,2018) 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 (43272,38795,38427,31916) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 43272 AND teamId = 1703
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 31916 AND teamId = 1703
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 38795 AND teamId = 1703
0.0122  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1703
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 31530 AND t.round = 30 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 = '1703' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1703' 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 = '1703' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0055  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 events2017 e ON e.player_id = p.id AND e.league_id = 31530 WHERE rp.league_id = 31530 AND rp.teamId = 1703 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.0052  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 events2017 e ON e.player_id = p.id AND e.league_id = 31530 WHERE rp.league_id = 31530 AND rp.teamId = 1703 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 events2017 e ON e.player_id = p.id AND e.league_id = 31530 WHERE rp.league_id = 31530 AND rp.teamId = 1703 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 1703 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 31530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 38340 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 15467 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 23684 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2015` 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 = 13704 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2015` 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 = 3818 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2014` 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 = 10840 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2014` 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 = 2422 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2013` 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 = 8850 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2012` 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 = 1363 AND t.round = 30 ORDER BY team.conference 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 `tables2011` 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 = 1076 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2010` 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 = 871 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2009` 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 = 803 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2008` 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 = 8782 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2007` 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 = 8785 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2006` 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 = 8787 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2005` 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 = 8790 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2004` 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 = 8829 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1984` 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 = 10697 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1983` 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 = 10696 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 31530 ORDER BY nameShow LIMIT 100