4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VIFK
TEMPORADA 2023/2024
TERCERA FINLANDIA
Equipo PJ GF GC Puntos
1 JJK Jyväskylä Jyväskylä 3 9 3 9
2 Klubi 04 Klubi 04 3 6 1 7
3 KPV KPV 3 6 3 7
4 Atlantis Atlantis 3 4 1 7
5 FC Jazz FC Jazz 3 10 5 6
6 Oulun Luistinseura Oulun 3 2 2 4
7 Espoon Palloseura FC Espoon 3 3 4 3
8 KuPS II KuPS II 3 5 8 3
9 Vaajakoski Vaajakoski 3 5 8 3
10 RoPS Rovaniemi RoPS 3 3 5 1
11 VIFK VIFK 3 1 7 1
12 PKKU PKKU 3 3 10 0
TEMPORADA 2022/2023
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Oulun Luistinseura Oulun 22 53 22 45
2 Vaajakoski Vaajakoski 22 43 17 45
3 RoPS Rovaniemi RoPS 22 42 37 39
4 KuPS II KuPS II 22 33 27 37
5 VIFK VIFK 22 36 31 34
6 OTP OTP 22 37 33 33
7 GBK GBK 22 33 41 31
8 TP-47 TP-47 22 35 35 28
9 Närpes Kraft Närpes 22 30 37 25
10 Kuopion Elo Kuopion Elo 22 24 39 19
11 JS Hercules JS Hercules 22 23 48 19
12 JBK JBK 22 26 48 12
TEMPORADA 2021/2022
CUARTA FINLANDIA GRUPO 6
Equipo PJ GF GC Puntos
1 JJK Jyväskylä Jyväskylä 3 5 3 62
2 VIFK VIFK 3 8 5 55
3 JS Hercules JS Hercules 3 1 4 38
4 Oulun Luistinseura Oulun 3 1 3 35
TEMPORADA 2020/2021
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 SJK Akatemia Akatemia 22 68 27 54
2 JJK Jyväskylä Jyväskylä 22 44 12 46
3 JS Hercules JS Hercules 22 51 23 43
4 Vaajakoski Vaajakoski 22 32 18 40
5 OTP OTP 22 43 30 35
6 JBK JBK 22 36 48 30
7 RoPS II RoPS II 22 33 38 28
8 Oulun Luistinseura Oulun 22 33 36 27
9 VIFK VIFK 22 34 49 25
10 Närpes Kraft Närpes 22 33 48 23
11 GBK GBK 22 20 56 14
12 PS Kemi PS Kemi 22 20 62 7
TEMPORADA 2019/2020
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 JIPPO Joensuu JIPPO 17 31 10 40
2 JS Hercules JS Hercules 17 30 16 36
3 RoPS II RoPS II 17 32 24 29
4 JBK JBK 17 24 23 26
5 KuFu-98 KuFu-98 17 34 35 26
6 JJK Jyväskylä Jyväskylä 17 30 31 26
7 Vaajakoski Vaajakoski 17 28 29 24
8 PS Kemi PS Kemi 17 28 32 21
9 GBK GBK 17 30 28 19
10 VIFK VIFK 17 21 30 18
11 Oulun Luistinseura Oulun 17 20 29 17
12 Kiisto Kiisto 17 15 36 8
TEMPORADA 2018/2019
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 SJK Akatemia Akatemia 22 56 14 54
2 RoPS II RoPS II 22 60 29 45
3 JBK JBK 22 58 34 41
4 KuFu-98 KuFu-98 22 59 36 40
5 Vaajakoski Vaajakoski 22 46 42 38
6 GBK GBK 22 47 32 29
7 Oulun Luistinseura Oulun 22 36 40 29
8 VIFK VIFK 22 25 38 29
9 JS Hercules JS Hercules 22 40 49 27
10 KajHa KajHa 22 25 55 17
11 PK-37 PK-37 22 25 53 13
12 VPS II VPS II 22 13 68 7
TEMPORADA 2017/2018
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 TPV Tampere TPV Tampere 22 47 19 51
2 GBK GBK 22 51 25 51
3 SJK Akatemia Akatemia 22 53 26 43
4 JS Hercules JS Hercules 22 48 29 43
5 KuFu-98 KuFu-98 22 30 31 34
6 PK-37 PK-37 22 24 38 26
7 JBK JBK 22 30 41 24
8 Oulun Luistinseura Oulun 22 22 36 24
9 Tampere United Tampere 22 25 31 23
10 VIFK VIFK 22 29 33 22
11 Närpes Kraft Närpes 22 26 55 19
12 TP-47 TP-47 22 24 45 14
TEMPORADA 2016/2017
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 AC Kajaani AC Kajaani 22 63 20 50
2 GBK GBK 22 47 23 46
3 VIFK VIFK 22 41 32 39
4 Närpes Kraft Närpes 22 48 41 34
5 JS Hercules JS Hercules 22 49 41 33
6 TP-47 TP-47 22 39 37 30
7 JBK JBK 22 38 39 28
8 PK-37 PK-37 22 28 40 26
9 KuFu-98 KuFu-98 22 32 30 25
10 KajHa KajHa 22 23 37 23
11 Villiketut Villiketut 22 28 63 21
12 OTP OTP 22 20 53 13
TEMPORADA 2015/2016
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 OPS OPS 22 70 31 48
2 Musan Salama Musan Salama 22 51 18 48
3 AC Kajaani AC Kajaani 22 84 24 45
4 GBK GBK 22 60 25 40
5 TP-47 TP-47 22 37 34 37
6 FC YPA FC YPA 22 40 36 33
7 Närpes Kraft Närpes 22 39 39 31
8 JS Hercules JS Hercules 22 39 41 28
9 VIFK VIFK 22 37 35 27
10 PPT PPT 22 40 43 25
11 Santa Claus Santa Claus 22 24 102 8
12 Virkiä Virkiä 22 23 116 7
TEMPORADA 2014/2015
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 PS Kemi PS Kemi 27 50 30 53
2 PK-35 Vantaa PK-35 Vantaa 27 53 25 49
3 TPS TPS 27 40 18 49
4 JJK Jyväskylä Jyväskylä 27 43 27 46
5 AC Oulu AC Oulu 27 31 28 44
6 FC Haka FC Haka 27 48 41 41
7 FC Jazz FC Jazz 27 37 48 32
8 Ekenäs IF Ekenäs IF 27 36 49 31
9 Mikkelin Palloilijat Mikkelin 27 31 56 17
10 VIFK VIFK 27 27 74 14
TEMPORADA 2013/2014
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 VIFK VIFK 27 60 35 56
2 ÅIFK ÅIFK 27 49 35 47
3 Närpes Kraft Närpes 27 49 45 43
4 TPV Tampere TPV Tampere 27 52 41 42
5 MaPS MaPS 27 43 38 39
6 SJK Akatemia Akatemia 27 44 40 38
7 I-Kissat I-Kissat 27 37 36 38
8 P-Iirot P-Iirot 27 51 56 33
9 Hameenlinna Hameenlinna 27 46 54 28
10 Sporting Kristina Sporting 27 24 75 14
TEMPORADA 2012/2013
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 PS Kemi PS Kemi 27 63 24 61
2 FC YPA FC YPA 27 63 32 55
3 VIFK VIFK 27 50 35 45
4 TP-47 TP-47 27 45 39 41
5 GBK GBK 27 48 51 40
6 KPV KPV 27 46 47 37
7 SJK Akatemia Akatemia 27 40 40 36
8 PK-37 PK-37 27 45 53 32
9 ORPa ORPa 27 36 50 27
10 Tervarit Tervarit 27 18 83 6
TEMPORADA 2011/2012
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ilves Ilves 27 84 21 70
2 FC Jazz FC Jazz 27 58 23 57
3 P-Iirot P-Iirot 27 70 40 55
4 VIFK VIFK 27 46 25 52
5 Närpes Kraft Närpes 27 56 57 41
6 TPV Tampere TPV Tampere 27 43 38 36
7 Harma Hameenlinna Harma 27 39 59 27
8 Sporting Kristina Sporting 27 33 58 21
9 Kiisto Kiisto 27 20 68 13
10 JIlves JIlves 27 21 81 8
TEMPORADA 2010/2011
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 SJK SJK 26 72 14 70
2 GBK GBK 26 51 35 49
3 TP-47 TP-47 26 46 30 42
4 FC YPA FC YPA 26 46 30 41
5 VIFK VIFK 26 37 34 40
6 Kiisto Kiisto 26 33 37 38
7 ViPa ViPa 26 47 37 37
8 PK-37 PK-37 26 44 42 37
9 HauPa HauPa 26 27 41 35
10 Warkaus JK Warkaus JK 26 39 52 33
11 Santa Claus Santa Claus 26 47 44 32
12 JBK JBK 26 39 47 32
13 Vaajakoski Vaajakoski 26 35 73 15
14 SC Riverball Riverball 26 15 62 12
TEMPORADA 2009/2010
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Santa Claus Santa Claus 26 47 25 51
2 TP-47 TP-47 26 34 28 48
3 FC YPA FC YPA 26 64 40 47
4 PK-37 PK-37 26 47 33 44
5 SJK SJK 26 46 31 42
6 VIFK VIFK 26 46 24 41
7 GBK GBK 26 50 38 40
8 Kiisto Kiisto 26 39 33 39
9 Vaajakoski Vaajakoski 26 45 45 38
10 JBK JBK 26 37 41 34
11 OPA OPA 26 28 46 27
12 FC Jyvaskyla Blackbird Jyvaskyla 26 26 42 24
13 KajHa KajHa 26 33 52 21
14 FC Korsholm FC Korsholm 26 25 89 5
TEMPORADA 2008/2009
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 OPS OPS 26 68 25 66
2 OPA OPA 26 82 21 63
3 FC YPA FC YPA 26 66 34 55
4 VIFK VIFK 26 49 26 48
5 SJK SJK 26 56 52 43
6 Vaajakoski Vaajakoski 26 59 51 38
7 JBK JBK 26 45 46 35
8 GBK GBK 26 37 37 33
9 FC Jyvaskyla Blackbird Jyvaskyla 26 42 56 30
10 Santa Claus Santa Claus 26 52 75 29
11 PK-37 PK-37 26 33 47 26
12 Oulun Luistinseura Oulun 26 41 59 24
13 Norrvalla FF Norrvalla 26 41 82 19
14 Virkiä Virkiä 26 33 93 10
TEMPORADA 2007/2008
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 JJK Jyväskylä Jyväskylä 26 44 20 51
2 Viikingit Viikingit 26 44 26 46
3 Hameenlinna Hameenlinna 26 31 24 45
4 AC Oulu AC Oulu 26 40 26 41
5 KPV KPV 26 39 35 39
6 JIPPO Joensuu JIPPO 26 27 30 39
7 PS Kemi PS Kemi 26 34 35 35
8 PK-35 Vantaa PK-35 Vantaa 26 36 36 34
9 TPV Tampere TPV Tampere 26 28 29 34
10 TP-47 TP-47 26 21 24 30
11 Atlantis Atlantis 26 27 33 29
12 VIFK VIFK 26 33 36 27
13 GrIFK Grankulla GrIFK 26 36 54 24
14 KaPa KaPa 26 15 47 15
TEMPORADA 2006/2007
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 KuPS Kuopio KuPS Kuopio 26 44 17 56
2 RoPS Rovaniemi RoPS 26 44 23 55
3 JJK Jyväskylä Jyväskylä 26 45 30 41
4 Hameenlinna Hameenlinna 26 37 27 41
5 TP-47 TP-47 26 36 29 37
6 VIFK VIFK 26 31 35 36
7 Atlantis Atlantis 26 33 32 34
8 PK-35 Vantaa PK-35 Vantaa 26 36 33 33
9 JIPPO Joensuu JIPPO 26 32 37 32
10 KPV KPV 26 27 46 31
11 TPV Tampere TPV Tampere 26 24 37 30
12 GBK GBK 26 28 38 27
13 PP-70 Tampere PP-70 26 31 44 25
14 Klubi 04 Klubi 04 26 25 45 15
TEMPORADA 2005/2006
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 Viikingit Viikingit 26 65 25 56
2 AC Oulu AC Oulu 26 53 25 52
3 Atlantis Atlantis 26 49 34 47
4 TP-47 TP-47 26 35 25 41
5 JIPPO Joensuu JIPPO 26 33 34 41
6 Klubi 04 Klubi 04 26 49 27 38
7 RoPS Rovaniemi RoPS 26 40 35 38
8 VIFK VIFK 26 45 46 35
9 KPV KPV 26 42 47 33
10 PK-35 Vantaa PK-35 Vantaa 26 33 39 30
11 Hameenlinna Hameenlinna 26 35 35 28
12 PP-70 Tampere PP-70 26 28 51 25
13 Mikkelin Palloilijat Mikkelin 26 30 54 24
14 JP Rakuunat JP Rakuunat 26 14 74 9

  USO DE MEMORIA  
6,735,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1367
Total Execution Time  0.1386
  CADENA URL  
/historico/Vifk
  GET DATOS  
$_GET['/historico/Vifk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0041  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 = 75071
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12605 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2929 AND type_rel = 3
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 = '12605' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '12605' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 75071 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=12605 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (75296,75071,74326,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75071 AND teamId = 12605
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74326 AND teamId = 12605
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 12605
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12605
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12605' 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 = '12605' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12605' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 75071 WHERE rp.league_id = 75071 AND rp.teamId = 12605 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.0033  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 = 75071 WHERE rp.league_id = 75071 AND rp.teamId = 12605 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75071 WHERE rp.league_id = 75071 AND rp.teamId = 12605 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 12605 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75071 AND t.round = 3 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 `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 = 71032 AND t.round = 22 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 `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 = 67139 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 70711 AND t.round = 3 ORDER BY team.conference ASC,t.position 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 `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 = 61699 AND t.round = 22 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 `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 = 55530 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 49440 AND t.round = 22 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 `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 = 43232 AND t.round = 22 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 `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 = 37932 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 20336 AND t.round = 22 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 = 10090 AND t.round = 27 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 `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 = 3801 AND t.round = 27 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 `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 = 2776 AND t.round = 27 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 = 16304 AND t.round = 27 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 `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 = 16310 AND t.round = 26 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 `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 = 16314 AND t.round = 26 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 `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 = 16317 AND t.round = 26 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 `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 = 14506 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 14505 AND t.round = 26 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 `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 = 14503 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC