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

Prostějov

Entrenador: Radim Kucera

Temporada 2021/2022
TEMPORADA 2021/2022
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Zbrojovka Brno Zbrojovka 30 61 29 69
2 Vlašim Vlašim 30 61 39 53
3 SFC Opava SFC Opava 30 47 33 51
4 SK Líšeň SK Líšeň 30 45 33 50
5 Sparta Praha II Sparta Praha 30 50 37 46
6 Varnsdorf Varnsdorf 30 47 35 45
7 Vysocina Jihlava Vysocina 30 29 34 42
8 FC Táborsko Táborsko 30 33 34 40
9 FK Dukla Praha Dukla Praha 30 40 41 39
10 Chrudim Chrudim 30 32 36 38
11 Prostějov Prostějov 30 32 50 37
12 Vyškov Vyškov 30 43 44 35
13 Pribram Pribram 30 38 51 35
14 Třinec Třinec 30 38 54 33
15 FK Viagem Ústí nad Labem Viagem 30 26 49 28
16 Viktoria Žižkov Viktoria 30 29 52 18
TEMPORADA 2020/2021
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Hradec Králové Hradec 26 51 22 58
2 SK Líšeň SK Líšeň 26 43 24 50
3 Prostějov Prostějov 26 40 35 43
4 Viktoria Žižkov Viktoria 26 42 38 42
5 FK Viagem Ústí nad Labem Viagem 26 24 29 41
6 Vlašim Vlašim 26 38 33 37
7 Vysocina Jihlava Vysocina 26 44 44 35
8 FK Dukla Praha Dukla Praha 26 36 30 34
9 Třinec Třinec 26 32 33 33
10 Chrudim Chrudim 26 33 36 31
11 FC Táborsko Táborsko 26 25 28 31
12 Varnsdorf Varnsdorf 26 20 27 30
13 Blansko Blansko 26 30 34 27
14 Slavoj Vyšehrad Slavoj 26 15 60 7
TEMPORADA 2019/2020
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Zbrojovka Brno Zbrojovka 30 75 29 67
2 Pardubice Pardubice 29 54 19 67
3 FK Dukla Praha Dukla Praha 30 62 40 59
4 Hradec Králové Hradec 30 54 29 54
5 Vysocina Jihlava Vysocina 30 59 46 49
6 Viktoria Žižkov Viktoria 30 45 40 49
7 FK Viagem Ústí nad Labem Viagem 30 46 47 41
8 SK Líšeň SK Líšeň 30 49 47 36
9 Chrudim Chrudim 30 44 61 36
10 Prostějov Prostějov 30 33 42 35
11 Vlašim Vlašim 29 30 42 34
12 Slavoj Vyšehrad Slavoj 30 40 55 33
13 Třinec Třinec 28 39 52 31
14 Baník Sokolov Baník 30 34 51 26
15 Varnsdorf Varnsdorf 30 37 65 26
16 Vitkovice Vitkovice 30 35 71 17
TEMPORADA 2018/2019
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 České Budějovice České 30 60 24 72
2 Vysocina Jihlava Vysocina 30 50 33 58
3 Zbrojovka Brno Zbrojovka 30 63 31 57
4 Hradec Králové Hradec 30 36 18 53
5 FK Viagem Ústí nad Labem Viagem 30 44 39 49
6 Varnsdorf Varnsdorf 30 33 26 48
7 Pardubice Pardubice 30 45 34 44
8 Vitkovice Vitkovice 30 32 44 40
9 Třinec Třinec 30 36 42 36
10 Prostějov Prostějov 30 28 37 36
11 Baník Sokolov Baník 30 28 40 33
12 Vlašim Vlašim 30 30 38 32
13 Chrudim Chrudim 30 39 56 29
14 Viktoria Žižkov Viktoria 30 33 59 27
15 FC Táborsko Táborsko 30 37 53 25
16 Znojmo Znojmo 30 40 60 25
TEMPORADA 2017/2018
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Prostějov Prostějov 30 79 33 70
2 Velké Meziříčí Velké 30 75 49 60
3 SK Líšeň SK Líšeň 30 63 44 54
4 Kromeriz Kromeriz 30 57 48 50
5 Hlučín Hlučín 30 52 41 46
6 Hodonín-Šardice Hodonín-Ša 30 54 52 43
7 Jiskra Rýmařov Jiskra 30 51 61 42
8 Spartak Hulín Spartak 30 65 60 41
9 Vyškov Vyškov 30 54 51 41
10 Uhersky Brod Uhersky Brod 30 36 44 41
11 Uničov Uničov 30 62 46 40
12 Odra Petřkovice Odra 30 49 49 40
13 FC Zlínsko FC Zlínsko 30 45 61 36
14 Valašské Meziříčí Valašské 30 43 72 35
15 HFK Olomouc HFK Olomouc 30 39 74 22
16 Mohelnice Mohelnice 30 34 73 14
TEMPORADA 2016/2017
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Sigma Olomouc Sigma 30 59 22 69
2 Baník Ostrava Baník 30 48 20 64
3 SFC Opava SFC Opava 30 61 33 63
4 Vlašim Vlašim 30 61 34 54
5 České Budějovice České 30 39 31 46
6 Znojmo Znojmo 30 49 47 41
7 Viktoria Žižkov Viktoria 30 49 41 39
8 Pardubice Pardubice 30 31 33 39
9 FK Viagem Ústí nad Labem Viagem 30 34 41 37
10 FC Táborsko Táborsko 30 38 48 36
11 Varnsdorf Varnsdorf 30 44 46 35
12 Třinec Třinec 30 40 52 34
13 Baník Sokolov Baník 30 28 44 32
14 Vitkovice Vitkovice 30 35 47 31
15 Frýdek-Místek Frýdek-Mís 30 40 57 29
16 Prostějov Prostějov 30 20 80 12
TEMPORADA 2015/2016
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Prostějov Prostějov 30 66 31 62
2 Vitkovice Vitkovice 30 50 32 57
3 Spartak Hulín Spartak 30 57 35 55
4 Uničov Uničov 30 52 32 51
5 Hlučín Hlučín 30 49 34 49
6 Vyškov Vyškov 30 58 33 47
7 SK Hanácká Hanácká 30 48 50 44
8 Mohelnice Mohelnice 30 39 36 42
9 Zlín II Zlín II 30 41 47 42
10 FC Zlínsko FC Zlínsko 30 39 46 39
11 Slovácko II Slovácko 30 50 46 35
12 Velké Meziříčí Velké 30 45 52 35
13 SK Líšeň SK Líšeň 30 32 52 32
14 HFK Olomouc HFK Olomouc 30 27 54 26
15 Třebíč Třebíč 30 36 66 24
16 Břeclav Břeclav 30 29 72 20
TEMPORADA 2014/2015
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Sigma Olomouc II Sigma 30 77 27 64
2 SK Hanácká Hanácká 30 50 36 54
3 Prostějov Prostějov 30 57 37 51
4 Slovácko II Slovácko 30 63 47 50
5 Uničov Uničov 30 53 42 48
6 Hlučín Hlučín 30 46 45 46
7 Zábřeh Zábřeh 30 39 33 45
8 Spartak Hulín Spartak 30 54 49 45
9 Zlín II Zlín II 30 49 45 43
10 SK Líšeň SK Líšeň 30 52 53 39
11 Slavia Orlová-Lutyně Slavia 30 40 44 37
12 Vyškov Vyškov 30 47 48 36
13 Třebíč Třebíč 30 27 48 32
14 HFK Olomouc HFK Olomouc 30 29 54 31
15 Břeclav Břeclav 30 40 60 30
16 Opava II Opava II 30 25 80 10
TEMPORADA 2013/2014
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 SFC Opava SFC Opava 30 48 21 62
2 Sigma Olomouc II Sigma 30 57 31 57
3 Prostějov Prostějov 30 53 41 51
4 Spartak Hulín Spartak 30 44 34 48
5 Zábřeh Zábřeh 30 44 35 48
6 Slovácko II Slovácko 30 40 39 45
7 Třebíč Třebíč 30 29 28 45
8 HFK Olomouc HFK Olomouc 30 39 35 38
9 Uničov Uničov 30 39 38 38
10 Slavia Orlová-Lutyně Slavia 30 31 32 38
11 Hlučín Hlučín 30 33 42 36
12 Zlín II Zlín II 30 39 49 34
13 Mikulovice Mikulovice 30 33 53 34
14 SK Hanácká Hanácká 30 42 38 33
15 Břeclav Břeclav 30 25 46 28
16 Žďár nad Sázavou Žďár 30 31 65 23
TEMPORADA 2012/2013
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Třinec Třinec 30 80 27 68
2 Frýdek-Místek Frýdek-Mís 30 60 27 64
3 Prostějov Prostějov 30 74 50 57
4 Sigma Olomouc II Sigma 30 53 34 46
5 Břeclav Břeclav 30 49 42 43
6 Hlučín Hlučín 30 42 35 42
7 Slovácko II Slovácko 30 59 57 42
8 Uničov Uničov 30 53 57 42
9 Zábřeh Zábřeh 30 43 45 39
10 Baník Ostrava II Baník 30 41 48 39
11 Zlín II Zlín II 30 38 50 38
12 Slavia Orlová-Lutyně Slavia 30 43 50 36
13 SK Hanácká Hanácká 30 39 66 32
14 Žďár nad Sázavou Žďár 30 31 65 31
15 Spartak Hulín Spartak 30 36 56 28
16 Slovan Rosice Slovan 30 33 65 26
TEMPORADA 2011/2012
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavia Orlová-Lutyně Slavia 30 62 29 66
2 Prostějov Prostějov 30 62 26 64
3 Mikulovice Mikulovice 30 70 52 55
4 Šumperk Šumperk 30 56 36 53
5 Mohelnice Mohelnice 30 53 49 50
6 Brumov Brumov 30 43 52 42
7 Lokomotiva Petrovice Lokomotiva 30 41 44 40
8 REAL Lískovec REAL 30 46 47 39
9 Kravaře Kravaře 30 46 52 37
10 Opava II Opava II 30 49 61 36
11 Valašské Meziříčí Valašské 30 45 59 36
12 Slavičín Slavičín 30 50 46 35
13 Havířov Havířov 30 47 51 35
14 Nový Jičín Nový 30 52 69 33
15 Dolní Benešov Dolní 30 26 58 30
16 Krnov Krnov 30 45 62 27
TEMPORADA 2004/2005
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Vysocina Jihlava II Vysocina 30 90 35 66
2 Břeclav Břeclav 30 54 41 56
3 Mutenice Mutenice 30 71 44 52
4 Napajedla Napajedla 30 55 43 51
5 Slavičín Slavičín 30 53 41 51
6 Brumov Brumov 30 51 48 50
7 Třebíč Třebíč 30 42 44 45
8 Vyškov Vyškov 30 44 39 44
9 Hrusovany nad Jevisovkou Hrusovany 30 52 44 43
10 Horka nad Moravou Horka 30 45 50 42
11 Ždírec nad Droubravou Ždírec 30 34 38 37
12 Rousínov Rousínov 30 38 64 36
13 FC Kyjov 1919 Kyjov 1919 30 48 49 33
14 Žďár nad Sázavou Žďár 30 54 67 31
15 Lipnik nad Becvou Lipnik 30 23 68 17
16 Prostějov Prostějov 30 27 66 15
TEMPORADA 2003/2004
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 SK Hanácká Hanácká 30 60 28 69
2 Uničov Uničov 30 48 28 54
3 Synot B Synot B 30 56 37 54
4 Baník Ostrava II Baník 30 50 23 53
5 Bystrc Kníničky Bystrc 29 45 33 53
6 Třinec Třinec 30 41 30 47
7 Vitkovice B Vitkovice B 29 35 42 41
8 Hranice Hranice 30 46 48 40
9 Dolní Benešov Dolní 30 41 45 35
10 Znojmo Znojmo 30 47 54 34
11 Dolni Kounice Dolni 30 30 46 34
12 Zlín II Zlín II 30 30 35 33
13 Bystrice pod Hostýnem Bystrice 30 35 48 33
14 Postorna Postorna 30 36 41 32
15 Frýdek-Místek Frýdek-Mís 30 28 45 29
16 Prostějov Prostějov 30 30 75 25
TEMPORADA 2002/2003
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 57 31 62
2 SFC Opava SFC Opava 30 51 26 60
3 Sparta Praha II Sparta Praha 30 35 23 48
4 Mostecký Mostecký 30 36 23 47
5 Vitkovice Vitkovice 30 38 28 47
6 Mladá Boleslav Mladá 30 35 27 46
7 Vysocina Jihlava Vysocina 30 43 34 44
8 Kunovice Kunovice 30 35 32 42
9 Xaverov Xaverov 30 44 56 41
10 Sigma Olomouc II Sigma 30 39 41 36
11 Pardubice Pardubice 29 38 44 36
12 HFK Olomouc HFK Olomouc 29 37 38 35
13 Neratovice-Byškovice Neratovice-B 30 26 30 31
14 Prostějov Prostějov 30 30 47 31
15 Chomutov Chomutov 30 34 65 25
16 Dolni Kounice Dolni 30 26 59 22
TEMPORADA 2001/2002
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 České Budějovice České 30 58 20 66
2 FC Trinity Zlín Trinity 30 56 24 64
3 Mladá Boleslav Mladá 30 40 29 52
4 Viktoria Plzeň Viktoria 30 56 34 50
5 Pardubice Pardubice 30 39 30 46
6 Xaverov Xaverov 30 44 36 46
7 Vysocina Jihlava Vysocina 30 47 46 42
8 Vitkovice Vitkovice 30 38 38 40
9 HFK Olomouc HFK Olomouc 29 36 39 37
10 Mostecký Mostecký 30 36 37 36
11 Prostějov Prostějov 30 33 34 36
12 Sigma Olomouc II Sigma 29 33 53 34
13 Chomutov Chomutov 30 30 50 34
14 Neratovice-Byškovice Neratovice-B 30 33 39 30
15 FK Kolín FK Kolín 30 22 56 21
16 Ratiskovice Ratiskovice 30 19 55 21
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
2. LIGA CHECA
Equipo PJ GF GC Puntos
1 Synot Synot 30 76 29 76
2 Viktoria Plzeň Viktoria 30 50 22 59
3 Ratiskovice Ratiskovice 29 46 31 50
4 Mostecký Mostecký 30 43 32 45
5 Nova Hut Ostrava Nova Ostrava 30 46 39 43
6 Bohdanec Bohdanec 30 36 33 43
7 Neratovice-Byškovice Neratovice-B 30 42 45 42
8 FC Trinity Zlín Trinity 30 44 33 41
9 Xaverov Xaverov 30 34 41 37
10 Třinec Třinec 30 39 60 37
11 Karviná Karviná 30 44 48 33
12 Prostějov Prostějov 30 39 47 33
13 Vitkovice Vitkovice 30 23 38 33
14 Mladá Boleslav Mladá 29 29 38 32
15 Postorna Postorna 30 30 47 25
16 Frýdek-Místek Frýdek-Mís 30 26 64 16

  USO DE MEMORIA  
7,297,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1568
Total Execution Time  0.1580
  CADENA URL  
/historico/Prost-Jov/2022
  GET DATOS  
$_GET['/historico/Prost-Jov/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0035  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 = 'Prost-Jov' AND l.year = 2022 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.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=30945 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=30945 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=30945 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=30945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 63120
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 = 63448
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30945 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=367 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 367 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (808298,779859,463893,375302) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '30945' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '30945' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '30945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 63448 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 63120 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=30945 AND l.year in (2021,2022,2023) 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 (70655,68174,68039,67320) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68039 AND teamId = 30945
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68174 AND teamId = 30945
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 30945
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 70655 AND teamId = 30945
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 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 = 63120 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '30945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30945' and rp.type = 4
0.0020  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 = '30945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  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 events2022 e ON e.player_id = p.id AND e.league_id = 63120 WHERE rp.league_id = 63120 AND rp.teamId = 30945 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.0035  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 events2022 e ON e.player_id = p.id AND e.league_id = 63120 WHERE rp.league_id = 63120 AND rp.teamId = 30945 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 events2022 e ON e.player_id = p.id AND e.league_id = 63120 WHERE rp.league_id = 63120 AND rp.teamId = 30945 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 30945 AND l.year <= 2022 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 `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 = 63120 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 58012 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 50144 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 44039 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 `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 = 38900 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 = 33332 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 `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 = 15612 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 9181 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 `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 = 24454 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 `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 = 24662 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 25124 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 `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 = 27604 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 24489 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 `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 = 8772 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 8775 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 `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.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 `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 = 8778 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 63120 ORDER BY nameShow LIMIT 100