4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bardejov
TEMPORADA 2023/2024
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Stará Ľubovňa Stará 23 49 31 43
2 MSK Tesla Stropkov Tesla 22 44 24 41
3 Snina Snina 22 46 34 40
4 Odeva Lipany Odeva Lipany 23 40 29 39
5 FTC Filakovo Filakovo 22 34 30 38
6 Sobota Sobota 23 38 29 35
7 Vranov nad Topľou Vranov 23 50 42 34
8 Novohrad Lučenec Novohrad 24 31 37 33
9 Slávia TU Košice Slávia 22 40 37 32
10 Baník Kalinovo Baník 23 41 42 30
11 Námestovo Námestovo 23 35 42 30
12 Spišské Podhradie Spišské 24 37 42 27
13 Oravské Veselé Oravské 23 27 40 23
14 Bardejov Bardejov 23 27 51 19
15 Svidník Svidník 22 26 55 16
TEMPORADA 2022/2023
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spišská Nová Ves Spišská 30 68 21 71
2 Odeva Lipany Odeva Lipany 30 69 28 69
3 Vranov nad Topľou Vranov 30 58 25 62
4 Snina Snina 30 54 42 47
5 Sobota Sobota 30 58 58 47
6 Oravské Veselé Oravské 30 48 38 45
7 Slávia TU Košice Slávia 30 52 44 44
8 Bardejov Bardejov 30 46 44 41
9 MSK Tesla Stropkov Tesla 30 45 55 36
10 Svidník Svidník 30 33 48 33
11 FTC Filakovo Filakovo 30 38 55 31
12 Novohrad Lučenec Novohrad 30 23 34 30
13 Baník Kalinovo Baník 30 38 60 30
14 Poprad Poprad 30 33 50 28
15 Slovan Giraltovce Slovan 30 19 53 27
16 Námestovo Námestovo 30 26 53 26
TEMPORADA 2021/2022
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 30 86 25 74
2 MFK Dukla MFK Dukla 30 62 24 69
3 Skalica Skalica 30 49 20 62
4 Komárno Komárno 30 51 29 59
5 FK Košice FK Košice 30 73 38 56
6 Humenné Humenné 30 36 30 56
7 Šamorín Šamorín 30 47 42 44
8 FC Petržalka Petržalka 30 54 48 41
9 Žilina II Žilina II 30 46 48 37
10 Slavoj Trebišov Slavoj 30 28 48 34
11 Dubnica Dubnica 30 33 51 31
12 Púchov Púchov 30 36 49 29
13 Rohoznik Rohoznik 30 30 58 29
14 Slovan Bratislava II Slovan 30 36 61 26
15 Bardejov Bardejov 30 26 54 18
16 Námestovo Námestovo 30 19 87 9
TEMPORADA 2020/2021
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Liptovsky Mikulas Liptovsky 28 55 26 60
2 MFK Dukla MFK Dukla 28 70 38 56
3 Skalica Skalica 28 55 32 55
4 Podbrezová Podbrezová 28 57 25 54
5 FK Košice FK Košice 28 40 27 49
6 Šamorín Šamorín 28 41 34 41
7 Púchov Púchov 28 40 45 38
8 Komárno Komárno 28 31 42 38
9 FC Petržalka Petržalka 28 37 41 37
10 Slavoj Trebišov Slavoj 28 47 48 35
11 Žilina II Žilina II 28 56 47 33
12 Dubnica Dubnica 28 28 37 33
13 Bardejov Bardejov 28 27 41 28
14 Slovan Bratislava II Slovan 28 32 70 21
15 Poprad Poprad 28 25 88 4
TEMPORADA 2019/2020
SEGUNDA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 MFK Dukla MFK Dukla 18 41 20 41
2 Dubnica Dubnica 18 39 24 38
3 Skalica Skalica 18 33 19 35
4 Poprad Poprad 17 26 16 31
5 Žilina II Žilina II 18 38 29 31
6 Podbrezová Podbrezová 18 26 26 28
7 Liptovsky Mikulas Liptovsky 18 28 30 26
8 Púchov Púchov 18 22 24 24
9 Ružomberok II Ružomberok 18 23 36 22
10 FK Košice FK Košice 17 22 18 21
11 Bardejov Bardejov 18 19 23 21
12 Šamorín Šamorín 18 24 31 21
13 Komárno Komárno 18 19 28 20
14 FC Petržalka Petržalka 18 24 34 17
15 Slovan Bratislava II Slovan 18 16 31 17
16 Slavoj Trebišov Slavoj 18 23 34 15
TEMPORADA 2018/2019
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Pohronie Pohronie 30 48 25 61
2 Poprad Poprad 30 52 36 58
3 Skalica Skalica 30 47 32 53
4 Liptovsky Mikulas Liptovsky 30 56 41 50
5 MFK Dukla MFK Dukla 30 49 35 46
6 Komárno Komárno 30 48 38 46
7 Dubnica Dubnica 30 55 42 45
8 FC Petržalka Petržalka 30 41 38 45
9 Žilina II Žilina II 30 54 59 41
10 Bardejov Bardejov 30 41 46 39
11 Lokomotíva Košice Lokomotíva 30 38 44 38
12 Šamorín Šamorín 30 46 48 37
13 Slavoj Trebišov Slavoj 30 24 44 30
14 Inter Bratislava Inter 30 37 56 29
15 Tatran Prešov Tatran 30 30 41 27
16 Odeva Lipany Odeva Lipany 30 23 64 24
TEMPORADA 2017/2018
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Sered Sered 30 73 25 66
2 Skalica Skalica 30 46 27 62
3 Poprad Poprad 30 45 25 52
4 Lokomotíva Košice Lokomotíva 30 50 35 51
5 Žilina II Žilina II 30 71 41 49
6 Komárno Komárno 30 49 58 43
7 Šamorín Šamorín 30 38 34 42
8 Inter Bratislava Inter 30 45 46 41
9 Pohronie Pohronie 30 41 35 38
10 Slavoj Trebišov Slavoj 30 27 44 37
11 Liptovsky Mikulas Liptovsky 30 38 39 36
12 Bardejov Bardejov 30 39 47 35
13 Nove Mesto Nad Vahom Nove Mesto. 30 33 57 32
14 Spišská Nová Ves Spišská 30 32 60 30
15 Lokomotiva Zvolen Lokomotiva 30 26 53 28
16 Podbrezová II Podbrezová 30 24 51 26
TEMPORADA 2016/2017
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC VSS Kosice Kosice 12 12 20 61
2 Nitra Nitra 12 23 6 59
3 Skalica Skalica 12 19 9 58
4 Šamorín Šamorín 12 17 10 55
5 Žilina II Žilina II 12 37 20 51
6 Sered Sered 12 18 15 48
7 Lokomotíva Košice Lokomotíva 12 15 17 47
8 Pohronie Pohronie 12 20 16 46
9 Bardejov Bardejov 12 20 22 46
10 Liptovsky Mikulas Liptovsky 12 15 19 45
11 Lokomotiva Zvolen Lokomotiva 12 12 22 35
12 Spišská Nová Ves Spišská 12 2 34 28
TEMPORADA 2015/2016
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 10 15 8 58
2 Liptovsky Mikulas Liptovsky 10 20 11 56
3 FC VSS Kosice Kosice 10 12 8 56
4 Lokomotíva Košice Lokomotíva 10 22 12 54
5 Bardejov Bardejov 10 19 10 53
6 Pohronie Pohronie 12 9 15 51
7 Nitra Nitra 12 16 13 46
8 Žilina II Žilina II 12 13 14 41
9 Lokomotiva Zvolen Lokomotiva 10 5 12 39
10 Sered Sered 12 15 20 38
11 Slovan Bratislava II Slovan 12 8 31 31
12 Borčice Borčice 0 0 0 0
TEMPORADA 2014/2015
SEGUNDA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Zemplin Michalovce Zemplin 22 46 11 51
2 Lokomotiva Zvolen Lokomotiva 22 35 14 39
3 Bardejov Bardejov 22 36 17 39
4 Tatran Prešov Tatran 22 39 22 38
5 Liptovsky Mikulas Liptovsky 22 31 18 37
6 Poprad Poprad 22 31 37 28
7 Sobota Sobota 22 21 27 28
8 Lokomotíva Košice Lokomotíva 22 30 36 24
9 Dolný Kubín Dolný 22 21 40 23
10 Košice II Košice II 22 29 40 21
11 Bodva Moldava Bodva 22 18 37 19
12 Slavoj Trebišov Slavoj 22 13 51 16
TEMPORADA 2013/2014
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 33 64 16 82
2 Bardejov Bardejov 33 49 25 61
3 Zemplin Michalovce Zemplin 33 55 28 61
4 Tatran Prešov Tatran 33 56 28 60
5 Senec Senec 33 39 32 49
6 Spartak Trnava II Spartak 33 57 64 39
7 Sobota Sobota 33 32 39 38
8 Dubnica Dubnica 33 30 64 35
9 Pohronie Pohronie 33 38 60 34
10 Slovan Duslo Sala Slovan Duslo 33 30 45 32
11 FC ŠTK 1914 ŠTK 1914 33 33 55 31
12 Liptovsky Mikulas Liptovsky 33 25 52 28
TEMPORADA 2012/2013
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 DAC DAC 33 41 26 65
2 Podbrezová Podbrezová 33 45 20 61
3 Senec Senec 33 48 32 57
4 Bardejov Bardejov 33 41 36 53
5 Zemplin Michalovce Zemplin 33 41 43 43
6 FC ŠTK 1914 ŠTK 1914 33 29 32 41
7 Slovan Duslo Sala Slovan Duslo 33 41 45 41
8 Dubnica Dubnica 33 31 38 41
9 Sobota Sobota 33 39 47 40
10 Liptovsky Mikulas Liptovsky 33 26 39 36
11 Dolný Kubín Dolný 33 34 42 34
12 Baník Ruziná Baník 33 38 54 30
TEMPORADA 2011/2012
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bardejov Bardejov 30 56 27 67
2 Baník Ruziná Baník 30 85 34 62
3 Lokomotíva Košice Lokomotíva 30 65 23 62
4 Tatran Prešov II Tatran 30 58 42 50
5 Dukla II Dukla II 30 57 38 49
6 Sokol Dolna Zdana Sokol Dolna 30 46 37 49
7 Vranov nad Topľou Vranov 30 39 45 44
8 Spišská Nová Ves Spišská 30 44 32 43
9 Odeva Lipany Odeva Lipany 30 51 45 43
10 Košice II Košice II 31 53 54 42
11 Poprad Poprad 30 36 32 41
12 Námestovo Námestovo 31 34 49 38
13 Bodva Moldava II Bodva 30 45 61 37
14 Slavoj Trebišov Slavoj 30 41 54 34
15 Kremnička Kremnička 30 37 51 30
16 Lokomotiva Zvolen Lokomotiva 30 31 59 29
17 Stará Ľubovňa Stará 30 12 107 2
TEMPORADA 2010/2011
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Podbrezová II Podbrezová 30 49 15 64
2 Bardejov Bardejov 30 50 27 62
3 Baník Ruziná Baník 30 62 43 53
4 Spišská Nová Ves Spišská 30 50 38 53
5 Poprad Poprad 30 40 38 44
6 Žilina II Žilina II 30 41 41 44
7 Sokol Dolna Zdana Sokol Dolna 30 46 39 43
8 Tatran Prešov II Tatran 30 49 44 43
9 Odeva Lipany Odeva Lipany 30 33 25 42
10 Dukla II Dukla II 30 41 36 40
11 Vranov nad Topľou Vranov 30 43 46 36
12 Košice II Košice II 30 38 47 36
13 Lokomotiva Zvolen Lokomotiva 30 29 41 33
14 Slavoj Trebišov Slavoj 30 26 41 32
15 Stará Ľubovňa Stará 30 20 60 29
16 Futura Humenné Futura 30 21 57 22
TEMPORADA 1998/1999
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Slovan Bratislava Slovan 30 56 11 70
2 Inter Bratislava Inter 30 64 15 68
3 Spartak Trnava Spartak 30 59 20 64
4 FC VSS Kosice Kosice 30 51 26 61
5 Trenčín Trenčín 30 53 25 53
6 Žilina Žilina 30 36 42 48
7 Ruzomberok Ruzomberok 30 31 31 46
8 Tatran Prešov Tatran 30 38 35 43
9 FC Petržalka Petržalka 30 37 42 39
10 Futura Humenné Futura 30 24 37 35
11 Banská Bystrica Banská 30 34 46 34
12 Nitra Nitra 30 28 48 28
13 Dubnica Dubnica 30 28 60 28
14 FK Mesto Prievidza Mesto 30 34 56 24
15 Sobota Sobota 30 29 56 22
16 Bardejov Bardejov 30 14 66 7

  USO DE MEMORIA  
6,733,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6790
Total Execution Time  0.6802
  CADENA URL  
/historico/Bardejov
  GET DATOS  
$_GET['/historico/Bardejov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0142  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 = 'Bardejov' 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.0127  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=13488 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13488 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=13488 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=13488 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73417
0.0136  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 = 72674
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13488 AND type_rel = 2
0.0155  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 = '13488' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '13488' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0138  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 = '13488' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 73417 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=13488 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73417,72674,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73417 AND teamId = 13488
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 13488
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13488
0.0133  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 = 73417 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '13488' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13488' and rp.type = 4
0.0126  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 = '13488' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 13488 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.0126  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 13488 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 13488 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 13488 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 73417 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68510 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.0130  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 = 63443 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.0128  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 = 57040 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.0128  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 = 50117 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 44175 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 39124 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 33684 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 38660 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15806 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 23886 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 12462 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 4829 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 2873 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 14259 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24459 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24474 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,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 = 23717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC