4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Havířov
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 6
Equipo PJ GF GC Puntos
1 Unie Hlubina Unie Hlubina 23 53 20 49
2 Opava II Opava II 23 50 21 47
3 Bohumin Bospor Bohumin 23 37 28 40
4 FC Vratimov FC Vratimov 22 48 45 38
5 Havířov Havířov 22 39 25 36
6 Šumperk Šumperk 23 37 24 34
7 Bílovec Bílovec 23 30 33 34
8 Polanka nad Odrou Polanka 22 33 27 33
9 Vitkovice Vitkovice 23 42 40 32
10 Krnov Krnov 23 25 25 30
11 Valašské Meziříčí Valašské 23 41 47 29
12 Beskyd Frenstat Beskyd 22 29 33 28
13 TJ Repiste TJ Repiste 23 29 44 21
14 Břidličná Břidličná 22 21 41 21
15 Jeseník Jeseník 22 23 38 19
16 Bruntal Bruntal 23 20 66 9
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 6
Equipo PJ GF GC Puntos
1 Karviná II Karviná II 26 62 24 56
2 Unie Hlubina Unie Hlubina 26 46 23 50
3 Opava II Opava II 26 60 30 49
4 Valašské Meziříčí Valašské 26 49 38 44
5 Bohumin Bospor Bohumin 26 48 43 40
6 Nový Jičín Nový 26 47 43 40
7 Bílovec Bílovec 26 49 43 38
8 Polanka nad Odrou Polanka 26 32 31 36
9 Havířov Havířov 26 40 40 35
10 Krnov Krnov 26 33 40 35
11 Jiskra Rýmařov Jiskra 26 34 46 30
12 Bruntal Bruntal 26 29 65 20
13 Beskyd Frenstat Beskyd 26 28 61 19
14 Břidličná Břidličná 26 30 60 17
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 6
Equipo PJ GF GC Puntos
1 Frýdlant Frýdlant 26 60 25 54
2 Bohumin Bospor Bohumin 26 48 24 52
3 Polanka nad Odrou Polanka 26 43 23 50
4 Vitkovice Vitkovice 26 56 41 44
5 Opava II Opava II 26 61 38 41
6 Karviná II Karviná II 26 63 43 41
7 Jiskra Rýmařov Jiskra 26 43 34 40
8 Bílovec Bílovec 26 59 44 39
9 Beskyd Frenstat Beskyd 26 54 46 37
10 Nový Jičín Nový 26 49 41 35
11 Havířov Havířov 26 39 48 32
12 Bruntal Bruntal 26 35 51 27
13 SK Detmarovice Detmarovice 26 23 81 13
14 Heřmanice Slezská Heřmanice 26 18 112 8
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 6
Equipo PJ GF GC Puntos
1 Karviná II Karviná II 10 37 10 25
2 Bohumin Bospor Bohumin 10 16 12 21
3 Frýdlant Frýdlant 10 25 14 20
4 SK Detmarovice Detmarovice 10 24 16 20
5 Opava II Opava II 9 24 13 18
6 Jiskra Rýmařov Jiskra 10 24 14 18
7 Havířov Havířov 10 22 20 16
8 Vitkovice Vitkovice 10 15 23 11
9 Beskyd Frenstat Beskyd 9 21 21 10
10 Polanka nad Odrou Polanka 10 11 18 10
11 Třinec II Třinec II 10 18 23 9
12 Bruntal Bruntal 10 11 23 9
13 Nový Jičín Nový 10 7 27 9
14 Heřmanice Slezská Heřmanice 10 10 31 1
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 6
Equipo PJ GF GC Puntos
1 Opava II Opava II 1 10 1 3
2 Třinec II Třinec II 1 4 0 3
3 Heřmanice Slezská Heřmanice 1 4 3 3
4 SK Detmarovice Detmarovice 1 4 3 3
5 Bohumin Bospor Bohumin 1 2 1 3
6 Beskyd Frenstat Beskyd 1 2 1 3
7 Valašské Meziříčí Valašské 1 1 0 3
8 Jiskra Rýmařov Jiskra 1 3 4 0
9 Nový Jičín Nový 1 3 4 0
10 Karviná II Karviná II 1 1 2 0
11 Polanka nad Odrou Polanka 1 1 2 0
12 Frýdlant Frýdlant 1 0 1 0
13 Havířov Havířov 1 0 4 0
14 Bruntal Bruntal 1 1 10 0
TEMPORADA 2018/2019
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 30 68 35 65
2 Frýdlant Frýdlant 30 54 27 59
3 Nový Jičín Nový 30 68 36 58
4 Hranice Hranice 30 71 43 50
5 Opava II Opava II 30 66 37 49
6 Bohumin Bospor Bohumin 30 70 58 49
7 Kozlovice Kozlovice 30 49 39 47
8 Bruntal Bruntal 30 46 41 47
9 Havířov Havířov 30 45 55 44
10 FC Vsetín FC Vsetín 30 48 53 38
11 Heřmanice Slezská Heřmanice 30 56 69 38
12 SK Detmarovice Detmarovice 30 62 67 36
13 HFK Olomouc HFK Olomouc 30 39 59 30
14 Šumperk Šumperk 30 35 59 28
15 Přerov Přerov 30 29 69 19
16 Sokol Ústí Sokol Ústí 30 23 82 12
TEMPORADA 2017/2018
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Dolní Benešov Dolní 30 55 32 60
2 Havířov Havířov 30 75 41 59
3 Kozlovice Kozlovice 30 65 36 59
4 Nový Jičín Nový 30 53 29 55
5 Sokol Ústí Sokol Ústí 30 64 41 55
6 Opava II Opava II 30 60 33 54
7 Slavičín Slavičín 30 62 42 50
8 Frýdlant Frýdlant 30 44 47 43
9 Nove Sady Nove Sady 30 39 50 41
10 Bohumin Bospor Bohumin 30 49 47 37
11 FC Vsetín FC Vsetín 30 31 35 37
12 Jeseník Jeseník 30 41 69 30
13 Hranice Hranice 30 30 60 27
14 Lokomotiva Petrovice Lokomotiva 30 40 61 25
15 Šternberk Šternberk 30 39 72 21
16 Brumov Brumov 30 27 79 20
TEMPORADA 2016/2017
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Valašské Meziříčí Valašské 30 66 33 67
2 Jiskra Rýmařov Jiskra 30 64 34 60
3 Havířov Havířov 30 47 40 52
4 Nový Jičín Nový 30 64 49 49
5 Dolní Benešov Dolní 30 50 41 45
6 Jeseník Jeseník 30 56 63 42
7 Hranice Hranice 30 46 53 41
8 Kozlovice Kozlovice 30 47 51 40
9 Šumperk Šumperk 30 52 52 39
10 Lokomotiva Petrovice Lokomotiva 30 38 50 38
11 Frýdlant Frýdlant 30 40 44 37
12 Nove Sady Nove Sady 30 40 45 37
13 Opava II Opava II 30 36 50 37
14 Pustá Polom Pustá Polom 30 35 42 36
15 Přerov Přerov 30 36 49 33
16 Velké Karlovice Velké 30 26 47 21
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Odra Petřkovice Odra 30 53 29 64
2 Lokomotiva Petrovice Lokomotiva 30 54 23 55
3 Slavičín Slavičín 30 50 31 53
4 Valašské Meziříčí Valašské 30 50 36 51
5 Nový Jičín Nový 30 46 32 49
6 Jiskra Rýmařov Jiskra 30 58 40 46
7 Nove Sady Nove Sady 30 51 47 41
8 Dolní Benešov Dolní 30 41 47 41
9 Opava II Opava II 30 44 42 38
10 Hranice Hranice 30 48 48 37
11 Brumov Brumov 30 33 59 36
12 Havířov Havířov 30 37 56 35
13 Velké Karlovice Velké 30 25 37 34
14 Frýdlant Frýdlant 30 36 61 33
15 Krnov Krnov 30 34 54 31
16 FC Vsetín FC Vsetín 30 28 46 28
TEMPORADA 2014/2015
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Mohelnice Mohelnice 30 53 25 59
2 Vitkovice Vitkovice 30 62 34 57
3 Slavičín Slavičín 30 53 39 54
4 Brumov Brumov 30 58 41 51
5 Hranice Hranice 30 58 41 47
6 Lokomotiva Petrovice Lokomotiva 30 37 41 46
7 Nový Jičín Nový 30 47 43 45
8 Havířov Havířov 30 51 52 42
9 Jiskra Rýmařov Jiskra 30 53 45 41
10 Valašské Meziříčí Valašské 30 44 51 39
11 Kozlovice Kozlovice 30 56 60 38
12 Přerov Přerov 30 41 51 38
13 Dolní Benešov Dolní 30 43 53 31
14 REAL Lískovec REAL 30 37 68 31
15 Velké Karlovice Velké 30 29 49 28
16 Sokol Určice Sokol 30 32 61 24
TEMPORADA 2013/2014
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 REAL Lískovec REAL 30 60 38 53
2 Opava II Opava II 30 53 44 51
3 Slavičín Slavičín 30 43 38 49
4 Dolní Benešov Dolní 30 59 45 48
5 Mohelnice Mohelnice 30 37 26 48
6 Havířov Havířov 30 47 57 44
7 Lokomotiva Petrovice Lokomotiva 30 47 36 43
8 Brumov Brumov 30 44 49 42
9 Nový Jičín Nový 30 41 50 41
10 Sokol Určice Sokol 30 35 41 38
11 FC Zlínsko FC Zlínsko 30 46 39 37
12 Přerov Přerov 30 42 45 37
13 Hranice Hranice 30 36 42 37
14 Valašské Meziříčí Valašské 30 50 59 36
15 Karviná II Karviná II 30 42 50 35
16 Šumperk Šumperk 30 33 56 26
TEMPORADA 2012/2013
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Mikulovice Mikulovice 30 44 33 56
2 Přerov Přerov 30 52 41 47
3 Opava II Opava II 30 56 43 46
4 Hranice Hranice 30 44 43 46
5 Valašské Meziříčí Valašské 30 54 53 45
6 Šumperk Šumperk 30 51 41 43
7 Mohelnice Mohelnice 30 44 41 41
8 Brumov Brumov 30 41 40 40
9 Havířov Havířov 30 43 45 40
10 Slavičín Slavičín 30 49 52 40
11 Lokomotiva Petrovice Lokomotiva 30 35 42 40
12 Nový Jičín Nový 30 46 37 39
13 REAL Lískovec REAL 30 34 36 38
14 Karviná II Karviná II 30 42 48 36
15 Kravaře Kravaře 30 43 50 35
16 Morkovice Morkovice 30 29 62 29
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 2010/2011
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
TEMPORADA 2009/2010
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Zlín II Zlín II 30 81 34 61
2 Jakubcovice Jakubcovice 30 47 22 60
3 Spartak Hulín Spartak 30 47 24 54
4 Mikulovice Mikulovice 30 60 41 53
5 Šumperk Šumperk 30 44 30 51
6 Dolní Benešov Dolní 30 39 46 44
7 Opava II Opava II 30 47 43 43
8 Valašské Meziříčí Valašské 30 54 64 40
9 Slavia Orlová-Lutyně Slavia 30 47 45 39
10 Havířov Havířov 30 42 45 38
11 Brumov Brumov 30 45 53 38
12 Poruba Poruba 30 46 60 37
13 Kravaře Kravaře 30 35 54 31
14 Jiskra Rýmařov Jiskra 30 46 61 26
15 Hranice Hranice 30 44 78 26
16 Lázne Velké Losiny Lázne 30 46 70 24
TEMPORADA 2008/2009
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 30 69 29 63
2 Šumperk Šumperk 30 62 26 63
3 Lázne Velké Losiny Lázne 30 70 43 58
4 Slavia Orlová-Lutyně Slavia 30 46 31 52
5 Brumov Brumov 30 60 51 47
6 Mesto Albrechtice Mesto 30 39 50 42
7 Havířov Havířov 30 40 41 41
8 Poruba Poruba 30 44 46 41
9 Dolní Benešov Dolní 30 46 48 40
10 Jiskra Rýmařov Jiskra 30 46 46 35
11 Kravaře Kravaře 30 32 43 35
12 Valašské Meziříčí Valašské 30 51 67 34
13 Hranice Hranice 30 40 66 34
14 Bystrice pod Hostýnem Bystrice 30 29 46 31
15 Velké Karlovice Velké 30 34 52 27
16 Beskyd Frenstat Beskyd 30 27 50 22
TEMPORADA 2007/2008
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Baník Ostrava II Baník 30 70 19 69
2 Kravaře Kravaře 30 45 25 51
3 Slavičín Slavičín 30 64 33 49
4 Jiskra Rýmařov Jiskra 30 56 48 43
5 Beskyd Frenstat Beskyd 30 39 32 42
6 Hranice Hranice 30 49 48 40
7 Lázne Velké Losiny Lázne 30 42 51 40
8 Slavia Orlová-Lutyně Slavia 30 29 32 39
9 Brumov Brumov 30 41 53 39
10 Bystrice pod Hostýnem Bystrice 30 30 32 38
11 Napajedla Napajedla 30 42 50 38
12 Havířov Havířov 30 33 44 37
13 Mesto Albrechtice Mesto 30 35 51 37
14 Velké Karlovice Velké 30 29 43 36
15 SK Bohuslavice Bohuslavice 30 34 46 34
16 FC Vsetín FC Vsetín 30 29 60 24

  USO DE MEMORIA  
6,965,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1539
Total Execution Time  0.1554
  CADENA URL  
/historico/Havi-Ov
  GET DATOS  
$_GET['/historico/Havi-Ov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0047  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 = 'Havi-Ov' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.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=30968 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=30968 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=30968 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=30968 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 72429
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30968 AND type_rel = 2
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 = '30968' ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '30968' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '30968' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72429 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  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=30968 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72506,72429,71432) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72429 AND teamId = 30968
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30968
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30968
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 FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72429 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '30968' 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 = '30968' and rp.type = 4
0.0022  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 = '30968' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72429 WHERE rp.league_id = 72429 AND rp.teamId = 30968 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.0023  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72429 WHERE rp.league_id = 72429 AND rp.teamId = 30968 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72429 WHERE rp.league_id = 72429 AND rp.teamId = 30968 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056  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 = 30968 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72429 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68193 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.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 `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 = 63523 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.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 `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 = 57127 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 50446 AND t.round = 1 ORDER BY team.conference ASC,t.position 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 `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 = 44438 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 `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 = 39719 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 `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 = 33750 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 = 16003 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 `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 = 9187 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 25088 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 `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 = 25098 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 `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.0021  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 = 25113 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 `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 = 25134 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 `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 = 25140 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 27580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC