4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hradec Králové

Hradec Králové

Entrenador: David Horejs

Temporada 2017/2018
TEMPORADA 2017/2018
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 SFC Opava SFC Opava 30 76 33 63
2 Pribram Pribram 30 56 32 58
3 Pardubice Pardubice 30 44 30 51
4 Hradec Králové Hradec 30 50 36 50
5 Třinec Třinec 30 42 30 47
6 České Budějovice České 30 44 33 44
7 Baník Sokolov Baník 30 34 39 41
8 Vlašim Vlašim 30 42 49 38
9 Znojmo Znojmo 30 36 49 37
10 FK Viagem Ústí nad Labem Viagem 30 37 47 36
11 Varnsdorf Varnsdorf 30 40 46 35
12 Viktoria Žižkov Viktoria 30 42 52 35
13 FK Olympia Praha Olympia 30 33 45 34
14 FC Táborsko Táborsko 30 36 46 33
15 Vitkovice Vitkovice 30 35 52 30
16 Frýdek-Místek Frýdek-Mís 30 26 54 27
TEMPORADA 2016/2017
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 65 22 69
2 Viktoria Plzeň Viktoria 30 47 21 67
3 Sparta Praha Sparta Praha 30 47 26 57
4 Mladá Boleslav Mladá 30 47 37 49
5 Teplice Teplice 30 38 25 48
6 FC Trinity Zlín Trinity 30 34 35 41
7 FK Dukla Praha Dukla Praha 30 39 35 40
8 Jablonec Jablonec 30 43 38 39
9 Slovan Liberec Slovan 30 31 28 39
10 Karviná Karviná 30 39 49 34
11 Zbrojovka Brno Zbrojovka 30 32 45 32
12 Slovácko Slovácko 30 29 38 32
13 Bohemians 1905 Bohemians 30 22 39 28
14 Vysocina Jihlava Vysocina 30 26 47 27
15 Hradec Králové Hradec 30 29 51 27
16 Pribram Pribram 30 29 61 22
TEMPORADA 2015/2016
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Karviná Karviná 28 50 17 59
2 Hradec Králové Hradec 28 45 16 59
3 Znojmo Znojmo 28 62 33 56
4 Baník Sokolov Baník 28 32 26 41
5 FC Táborsko Táborsko 28 39 34 39
6 Pardubice Pardubice 28 29 29 38
7 Vlašim Vlašim 28 35 33 35
8 FK Viagem Ústí nad Labem Viagem 28 39 38 35
9 Varnsdorf Varnsdorf 28 35 44 34
10 Frýdek-Místek Frýdek-Mís 28 30 37 33
11 SFC Opava SFC Opava 28 34 37 32
12 České Budějovice České 28 41 48 32
13 Třinec Třinec 28 29 41 27
14 Sigma Olomouc II Sigma 28 23 49 21
15 Slavoj Vyšehrad Slavoj 28 20 61 20
TEMPORADA 2014/2015
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 24 72
2 Sparta Praha Sparta Praha 30 57 20 67
3 Jablonec Jablonec 30 58 22 64
4 Mladá Boleslav Mladá 30 43 34 46
5 Pribram Pribram 30 40 45 43
6 FK Dukla Praha Dukla Praha 30 34 40 41
7 Teplice Teplice 30 41 37 38
8 Bohemians 1905 Bohemians 30 35 41 38
9 Slovácko Slovácko 30 43 46 37
10 Vysocina Jihlava Vysocina 30 33 38 36
11 Slavia Praha Slavia Praha 30 40 45 34
12 Slovan Liberec Slovan 30 39 43 33
13 Baník Ostrava Baník 30 23 41 33
14 Zbrojovka Brno Zbrojovka 30 34 45 33
15 Hradec Králové Hradec 30 26 52 25
16 České Budějovice České 30 29 72 22
TEMPORADA 2013/2014
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 České Budějovice České 30 57 20 62
2 Hradec Králové Hradec 30 54 27 61
3 FC Táborsko Táborsko 30 46 27 59
4 Varnsdorf Varnsdorf 30 42 31 47
5 Viktoria Žižkov Viktoria 30 39 30 47
6 Baník Sokolov Baník 30 33 37 46
7 Karviná Karviná 30 46 37 45
8 FK Viagem Ústí nad Labem Viagem 30 38 37 43
9 Třinec Třinec 30 37 44 39
10 FC Trinity Zlín Trinity 30 33 30 37
11 Mostecký Mostecký 30 34 46 37
12 Vlašim Vlašim 30 29 46 36
13 Pardubice Pardubice 30 30 34 34
14 Frýdek-Místek Frýdek-Mís 30 33 40 34
15 FK Bohemians (Střížkov) Bohemians 30 30 66 22
16 Loko Vltavin Loko Vltavin 30 25 54 20
TEMPORADA 2012/2013
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 54 21 65
2 Sparta Praha Sparta Praha 30 55 23 63
3 Slovan Liberec Slovan 30 46 34 54
4 Jablonec Jablonec 30 49 41 49
5 Sigma Olomouc Sigma 30 38 29 47
6 FK Dukla Praha Dukla Praha 30 48 37 46
7 Slavia Praha Slavia Praha 30 41 33 42
8 Mladá Boleslav Mladá 30 34 43 38
9 Slovácko Slovácko 30 37 41 37
10 Vysocina Jihlava Vysocina 30 36 42 36
11 Pribram Pribram 30 27 39 32
12 Teplice Teplice 30 36 47 32
13 Zbrojovka Brno Zbrojovka 30 34 53 32
14 Baník Ostrava Baník 30 34 44 29
15 České Budějovice České 30 24 49 26
16 Hradec Králové Hradec 30 27 44 25
TEMPORADA 2011/2012
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 68 29 66
2 Sparta Praha Sparta Praha 30 51 25 64
3 Viktoria Plzeň Viktoria 30 66 33 63
4 Mladá Boleslav Mladá 30 49 34 50
5 Teplice Teplice 30 36 30 46
6 FK Dukla Praha Dukla Praha 30 42 35 42
7 Slovácko Slovácko 30 29 32 41
8 Jablonec Jablonec 30 54 43 40
9 Pribram Pribram 30 44 56 39
10 České Budějovice České 30 30 51 35
11 Sigma Olomouc Sigma 30 42 38 34
12 Slavia Praha Slavia Praha 30 28 34 34
13 Hradec Králové Hradec 30 22 38 31
14 Baník Ostrava Baník 30 31 48 28
15 Bohemians 1905 Bohemians 30 20 54 24
16 Viktoria Žižkov Viktoria 30 23 55 19
TEMPORADA 2010/2011
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 28 69
2 Sparta Praha Sparta Praha 30 54 21 68
3 Jablonec Jablonec 30 65 34 58
4 Sigma Olomouc Sigma 30 47 29 47
5 Mladá Boleslav Mladá 30 49 40 46
6 Bohemians 1905 Bohemians 30 33 33 43
7 Slovan Liberec Slovan 30 45 36 43
8 Hradec Králové Hradec 30 26 36 41
9 Slavia Praha Slavia Praha 30 41 36 40
10 Teplice Teplice 30 39 46 39
11 České Budějovice České 30 30 48 33
12 Slovácko Slovácko 30 27 43 31
13 Pribram Pribram 30 22 36 31
14 Baník Ostrava Baník 30 31 46 30
15 Zbrojovka Brno Zbrojovka 30 33 55 24
16 FK Viagem Ústí nad Labem Viagem 30 22 67 19
TEMPORADA 2009/2010
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Hradec Králové Hradec 30 47 18 68
2 FK Viagem Ústí nad Labem Viagem 30 52 27 65
3 FC Trinity Zlín Trinity 30 48 35 54
4 Vysocina Jihlava Vysocina 30 57 37 52
5 Viktoria Žižkov Viktoria 30 42 41 46
6 FK Dukla Praha Dukla Praha 30 45 41 44
7 Vlašim Vlašim 30 40 41 40
8 Karviná Karviná 30 44 36 39
9 Třinec Třinec 30 34 38 38
10 Mostecký Mostecký 30 37 37 37
11 Baník Sokolov Baník 30 37 43 37
12 SFC Opava SFC Opava 30 30 37 29
13 Hlučín Hlučín 30 27 43 29
14 Sparta Praha II Sparta Praha 30 33 50 29
15 FK Caslav FK Caslav 30 28 49 29
16 Vitkovice Vitkovice 30 23 51 18
TEMPORADA 2008/2009
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Bohemians 1905 Bohemians 30 36 14 63
2 FK Caslav FK Caslav 30 42 27 56
3 Vysocina Jihlava Vysocina 30 36 27 51
4 FK Viagem Ústí nad Labem Viagem 30 39 38 49
5 FK Dukla Praha Dukla Praha 30 37 25 46
6 Baník Sokolov Baník 30 56 37 43
7 SFC Opava SFC Opava 30 44 38 43
8 Karviná Karviná 30 45 42 43
9 Třinec Třinec 30 31 29 39
10 Slovácko Slovácko 30 25 29 39
11 Sparta Praha II Sparta Praha 30 39 38 38
12 Mostecký Mostecký 30 30 43 37
13 Hradec Králové Hradec 30 36 32 35
14 Vitkovice Vitkovice 30 34 47 33
15 HFK Olomouc HFK Olomouc 30 32 42 27
16 Fulnek Fulnek 30 16 70 9
TEMPORADA 2007/2008
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 FK Bohemians (Střížkov) Bohemians 30 46 38 53
2 Pribram Pribram 30 33 18 52
3 SFC Opava SFC Opava 30 46 31 50
4 Hradec Králové Hradec 30 34 24 50
5 Slovácko Slovácko 30 40 27 48
6 Fulnek Fulnek 29 34 34 46
7 Vysocina Jihlava Vysocina 30 42 35 43
8 HFK Olomouc HFK Olomouc 30 33 38 41
9 Baník Sokolov Baník 30 26 24 40
10 Vitkovice Vitkovice 30 35 41 36
11 FK Caslav FK Caslav 30 37 44 33
12 FK Dukla Praha Dukla Praha 30 36 44 33
13 FK Viagem Ústí nad Labem Viagem 29 33 42 33
14 Třinec Třinec 29 22 38 33
15 Hlučín Hlučín 30 26 35 30
16 Sparta Krč Sparta Krč 29 26 36 24
TEMPORADA 2006/2007
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Žižkov Viktoria 30 55 23 64
2 Bohemians 1905 Bohemians 30 47 21 60
3 SFC Opava SFC Opava 30 47 28 53
4 HFK Olomouc HFK Olomouc 30 40 28 53
5 Vysocina Jihlava Vysocina 30 49 26 51
6 Baník Sokolov Baník 30 36 33 46
7 Hradec Králové Hradec 30 41 34 43
8 Chmel Blšany Chmel 30 27 33 38
9 FK Viagem Ústí nad Labem Viagem 30 41 44 37
10 Jakubcovice Jakubcovice 30 35 44 37
11 FK Caslav FK Caslav 30 34 48 37
12 Vitkovice Vitkovice 30 31 50 32
13 Třinec Třinec 30 21 42 32
14 Hlučín Hlučín 30 24 34 29
15 Sigma Olomouc II Sigma 30 27 43 29
16 Bystrc Kníničky Bystrc 30 22 46 25
TEMPORADA 2005/2006
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 SK Kladno SK Kladno 29 45 19 57
2 České Budějovice České 30 55 26 55
3 FK Viagem Ústí nad Labem Viagem 30 47 39 49
4 Hradec Králové Hradec 30 31 28 49
5 Viktoria Žižkov Viktoria 29 40 33 43
6 SK Hanácká Hanácká 30 34 32 42
7 HFK Olomouc HFK Olomouc 30 27 31 41
8 Xaverov Xaverov 30 36 37 37
9 Vitkovice Vitkovice 30 26 33 36
10 Hlučín Hlučín 30 31 47 36
11 Kunovice Kunovice 30 35 43 35
12 AS Pardubice Pardubice 30 35 38 34
13 Sparta Praha II Sparta Praha 30 32 37 34
14 Sigma Olomouc II Sigma 30 33 40 34
15 Drnovice Drnovice 30 24 40 34
16 Zbrojovka Brno II Zbrojovka 30 24 32 32
TEMPORADA 2004/2005
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Mostecký Mostecký 28 58 30 61
2 Viktoria Plzeň Viktoria 28 32 23 46
3 Viktoria Žižkov Viktoria 28 42 36 46
4 Vysocina Jihlava Vysocina 27 43 29 45
5 SK Kladno SK Kladno 28 37 22 43
6 Vitkovice Vitkovice 28 35 30 42
7 Zbrojovka Brno II Zbrojovka 27 32 28 36
8 Hradec Králové Hradec 28 37 38 34
9 Kunovice Kunovice 28 29 42 33
10 Sparta Praha II Sparta Praha 28 24 30 32
11 Sigma Olomouc II Sigma 28 32 39 31
12 FK Viagem Ústí nad Labem Viagem 28 27 40 30
13 SK Hanácká Hanácká 28 29 45 28
14 AS Pardubice Pardubice 28 20 34 27
15 Tatran Prachatice Tatran 28 28 39 26
TEMPORADA 2003/2004
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Mladá Boleslav Mladá 30 50 24 55
2 Drnovice Drnovice 30 34 22 54
3 Bohemians 1905 Bohemians 30 37 21 51
4 SK Kladno SK Kladno 30 47 27 50
5 Vysocina Jihlava Vysocina 30 40 33 46
6 AS Pardubice Pardubice 30 40 35 46
7 Hradec Králové Hradec 30 27 30 39
8 Sparta Praha II Sparta Praha 30 32 24 38
9 Mostecký Mostecký 29 31 31 38
10 Vitkovice Vitkovice 30 28 36 37
11 Zbrojovka Brno II Zbrojovka 30 36 40 36
12 Sigma Olomouc II Sigma 29 39 49 35
13 Tatran Prachatice Tatran 30 31 49 34
14 HFK Olomouc HFK Olomouc 30 21 35 32
15 Kunovice Kunovice 29 23 42 30
16 Xaverov Xaverov 29 22 40 29
TEMPORADA 2002/2003
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 51 17 65
2 Slavia Praha Slavia Praha 30 65 19 64
3 Viktoria Žižkov Viktoria 30 38 33 50
4 Slovan Liberec Slovan 30 43 36 50
5 Baník Ostrava Baník 30 41 38 45
6 Teplice Teplice 30 33 32 45
7 FC Trinity Zlín Trinity 30 34 41 42
8 Synot Synot 30 39 40 40
9 Zbrojovka Brno Zbrojovka 30 35 31 39
10 Pribram Pribram 30 34 30 39
11 Sigma Olomouc Sigma 30 29 33 34
12 Jablonec Jablonec 30 29 39 34
13 České Budějovice České 30 36 54 30
14 Chmel Blšany Chmel 30 28 39 28
15 Bohemians 1905 Bohemians 30 34 56 24
16 Hradec Králové Hradec 30 23 54 22
TEMPORADA 2001/2002
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 55 26 64
2 Sparta Praha Sparta Praha 30 55 19 63
3 Viktoria Žižkov Viktoria 30 42 20 63
4 Bohemians 1905 Bohemians 30 40 35 48
5 Slavia Praha Slavia Praha 30 45 34 47
6 Baník Ostrava Baník 30 43 36 44
7 Teplice Teplice 30 37 41 41
8 Zbrojovka Brno Zbrojovka 30 34 42 40
9 Jablonec Jablonec 30 35 33 40
10 Sigma Olomouc Sigma 30 29 31 37
11 Synot Synot 30 31 38 36
12 Hradec Králové Hradec 30 28 42 35
13 Pribram Pribram 30 27 39 34
14 Chmel Blšany Chmel 30 35 51 29
15 Drnovice Drnovice 30 31 45 26
16 SFC Opava SFC Opava 30 23 58 18
TEMPORADA 2000/2001
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Hradec Králové Hradec 30 55 28 66
2 SFC Opava SFC Opava 30 57 20 60
3 Ratiskovice Ratiskovice 30 44 26 51
4 FC Trinity Zlín Trinity 30 42 24 49
5 Xaverov Xaverov 29 49 30 47
6 Vysocina Jihlava Vysocina 30 38 31 47
7 Pardubice Pardubice 30 39 38 44
8 Mostecký Mostecký 30 27 27 38
9 Vitkovice Vitkovice 29 37 41 37
10 Chomutov Chomutov 30 46 50 36
11 Mladá Boleslav Mladá 30 34 42 36
12 Neratovice-Byškovice Neratovice-B 30 39 50 35
13 HFK Olomouc HFK Olomouc 29 37 45 32
14 Prostějov Prostějov 30 31 49 32
15 Karviná Karviná 29 24 61 22
16 Třinec Třinec 30 33 70 18
TEMPORADA 1999/2000
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 81 23 76
2 Slavia Praha Slavia Praha 30 53 25 68
3 Drnovice Drnovice 30 36 32 48
4 Zbrojovka Brno Zbrojovka 30 35 33 42
5 Teplice Teplice 30 38 38 41
6 Pribram Pribram 30 33 36 40
7 Bohemians 1905 Bohemians 30 24 28 40
8 Slovan Liberec Slovan 30 21 24 38
9 Viktoria Žižkov Viktoria 30 37 41 37
10 Chmel Blšany Chmel 30 28 45 37
11 Baník Ostrava Baník 30 43 45 35
12 Sigma Olomouc Sigma 30 31 38 34
13 Jablonec Jablonec 30 24 36 32
14 České Budějovice České 30 34 49 32
15 SFC Opava SFC Opava 30 31 39 28
16 Hradec Králové Hradec 30 21 38 23
TEMPORADA 1998/1999
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 62 23 60
2 Teplice Teplice 30 55 30 55
3 Slavia Praha Slavia Praha 30 51 31 55
4 Sigma Olomouc Sigma 30 42 34 47
5 Baník Ostrava Baník 30 39 26 45
6 Chmel Blšany Chmel 30 48 44 42
7 Zbrojovka Brno Zbrojovka 30 37 33 41
8 Hradec Králové Hradec 30 33 40 39
9 Slovan Liberec Slovan 30 33 34 38
10 Viktoria Žižkov Viktoria 30 31 47 38
11 Drnovice Drnovice 30 35 44 37
12 Jablonec Jablonec 30 37 46 35
13 Pribram Pribram 30 28 41 33
14 SFC Opava SFC Opava 30 40 54 32
15 Viktoria Plzeň Viktoria 30 26 43 32
16 Karviná Karviná 30 28 55 23

  USO DE MEMORIA  
7,757,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9243
Total Execution Time  0.9255
  CADENA URL  
/historico/Hradec-Kralove/2018
  GET DATOS  
$_GET['/historico/Hradec-Kralove/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0211  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 = 'Hradec-Kralove' AND l.year = 2018 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.0150  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=4531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=4531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=4531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=4531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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 = 38788
0.0149  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 = 38840
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4531 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4531 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146  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 (463415,463893) ORDER BY n.cover_points DESC, update_date DESC
0.0153  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 = '4531' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '4531' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '4531' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 38840 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 38788 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=4531 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (44300,44039,43475,43333,33331) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 33331 AND teamId = 4531
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 44039 AND teamId = 4531
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 44300 AND teamId = 4531
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 43333 AND teamId = 4531
0.0354  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 4531
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 38788 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149  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 = '4531' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4531' and rp.type = 4
0.0147  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 = '4531' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  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 events2018 e ON e.player_id = p.id AND e.league_id = 38788 WHERE rp.league_id = 38788 AND rp.teamId = 4531 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.0159  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 events2018 e ON e.player_id = p.id AND e.league_id = 38788 WHERE rp.league_id = 38788 AND rp.teamId = 4531 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 events2018 e ON e.player_id = p.id AND e.league_id = 38788 WHERE rp.league_id = 38788 AND rp.teamId = 4531 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 4531 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 38788 AND t.round = 30 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 `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 = 33331 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 15518 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 3883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 2835 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 2041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 1355 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 1083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 8763 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 8764 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 8766 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 8767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 8768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 8770 AND t.round = 27 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 `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 = 8771 AND t.round = 30 ORDER BY team.conference 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 `tables2003` 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 = 8751 AND t.round = 30 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 `tables2002` 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 = 8752 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2001` 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 = 8776 AND t.round = 30 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 `tables2000` 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 = 8754 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1999` 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 = 8755 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 38788 ORDER BY nameShow LIMIT 100