4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Kontu
TEMPORADA 2023/2024
QUINTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Kontu FC Kontu 0 0 0 0
2 Finnkurd Finnkurd 0 0 0 0
3 HerTo HerTo 0 0 0 0
4 HIFK 2 HIFK 2 0 0 0 0
5 HPS HPS 0 0 0 0
6 Loviisa Loviisa 0 0 0 0
7 LPS LPS 0 0 0 0
8 MPS / Atletico Malmi Atletico 0 0 0 0
9 Ponnistus Ponnistus 0 0 0 0
10 PPJ / Lauttasaari Lauttasaari 0 0 0 0
11 Töölön Taisto Töölön 0 0 0 0
12 Valtti Valtti 0 0 0 0
TEMPORADA 2022/2023
QUINTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 EBK EBK 22 57 22 51
2 NuPS NuPS 22 56 19 49
3 EsPa EsPa 22 67 33 45
4 GrIFK Sub 23 GrIFK 22 34 21 38
5 Töölön Taisto Töölön 22 45 31 36
6 Ekenäs IF II Ekenäs 22 38 34 35
7 HIFK 2 HIFK 2 22 32 27 34
8 Kirkkonummi Kirkkonummi 22 33 42 28
9 EPS II EPS II 22 28 39 25
10 LJS LJS 22 22 48 23
11 FC Espoo FC Espoo 22 26 57 14
12 Kurvin Vauhti Kurvin 22 17 82 3
13 VJS VJS 22 90 13 55
14 HPS HPS 22 70 10 55
15 MPS / Atletico Malmi Atletico 22 79 37 48
16 FC Kontu FC Kontu 22 68 35 44
17 LPS LPS 22 77 40 41
18 PPJ / Ruoholahti Ruoholahti 22 52 40 36
19 Gnistan - Ogeli Gnistan 22 48 47 29
20 Ponnistajat Ponnistajat 22 48 51 23
21 Finnkurd Finnkurd 22 40 74 22
22 HerTo HerTo 22 28 80 17
23 SaPa SaPa 22 20 91 10
24 ToTe II ToTe II 22 13 115 1
25 JäPS II JäPS II 22 58 19 49
26 MPS MPS 22 62 27 45
27 ToTe ToTe 22 48 23 45
28 PuiU Helsinki PuiU 22 47 25 41
29 Valtti Valtti 22 47 33 36
30 TuPS TuPS 22 48 48 34
31 RiPS RiPS 22 36 36 31
32 PKKU II PKKU II 22 35 52 25
33 HyPS HyPS 22 27 51 24
34 Loviisa Loviisa 22 29 56 18
35 NouLa NouLa 22 31 58 16
36 KoiPS KoiPS 22 27 67 9
TEMPORADA 2021/2022
QUINTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 LePa LePa 2 0 10 0
2 EPS II EPS II 20 63 22 45
3 FC Espoo FC Espoo 21 46 28 44
4 SexyPöxyt SexyPöxyt 19 54 24 41
5 EBK EBK 20 66 38 36
6 Ekenäs IF II Ekenäs 21 39 35 30
7 GrIFK Sub 23 GrIFK 20 30 43 26
8 EsPa EsPa 20 37 54 26
9 SaPa SaPa 20 40 39 24
10 Kirkkonummi Kirkkonummi 20 31 41 24
11 Finnkurd Finnkurd 19 27 64 15
12 BK-46 BK-46 20 20 55 8
13 Atlantis II Atlantis II 22 88 21 56
14 ToTe ToTe 22 53 22 49
15 Valtti Valtti 22 58 29 45
16 FC Kontu FC Kontu 22 61 36 38
17 MPS MPS 22 43 24 37
18 PuiU Helsinki PuiU 22 49 49 30
19 Töölön Taisto Töölön 22 42 53 30
20 Ponnistajat Ponnistajat 22 35 41 28
21 HIFK 2 HIFK 2 22 35 58 25
22 HerTo HerTo 22 33 53 21
23 Viikingit Viikingit 22 21 76 8
24 FC POHU FC POHU 22 31 87 8
25 TiPS TiPS 22 60 16 53
26 HPS HPS 22 68 28 49
27 LPS LPS 22 79 43 45
28 PKKU II PKKU II 22 37 25 39
29 MPS / Atletico Malmi Atletico 22 56 36 38
30 JäPS II JäPS II 22 37 21 37
31 RiPS RiPS 22 41 43 29
32 KoiPS KoiPS 22 41 56 23
33 NouLa NouLa 22 31 65 22
34 TuPS TuPS 22 26 55 21
35 FC Kuusysi FC Kuusysi 22 31 71 11
36 Inter Helsinki Inter 22 34 82 9
TEMPORADA 2020/2021
QUINTA FINLANDIA GRUPO 7
Equipo PJ GF GC Puntos
1 ToTe ToTe 5 16 4 38
2 EBK EBK 5 15 6 37
3 SexyPöxyt SexyPöxyt 5 6 8 31
4 CLE CLE 5 11 21 24
5 Kirkkonummi Kirkkonummi 5 6 12 23
6 EPS II EPS II 5 9 12 21
7 PPJ PPJ 5 14 6 32
8 HPS HPS 5 9 6 31
9 MPS / Atletico Malmi Atletico 5 14 10 29
10 Finnkurd Finnkurd 5 12 13 29
11 TiPS TiPS 5 7 8 23
12 LPS LPS 5 6 19 20
13 Futura Futura 5 14 10 38
14 FC Kontu FC Kontu 5 12 6 28
15 Atlantis II Atlantis II 5 14 8 11
16 PKKU II PKKU II 5 12 7 10
17 Valtti Valtti 5 5 10 4
18 MPS MPS 5 5 21 1
TEMPORADA 2019/2020
QUINTA FINLANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 VJS VJS 17 64 21 42
2 Futura Futura 17 58 21 42
3 TiPS TiPS 17 57 18 41
4 SaPa SaPa 17 34 17 33
5 FC Kontu FC Kontu 17 43 25 30
6 PKKU II PKKU II 17 30 25 30
7 Valtti Valtti 17 31 29 26
8 TuPS TuPS 17 36 42 23
9 MPS / Atletico Malmi Atletico 17 48 37 22
10 NJS II NJS II 17 39 41 22
11 PuiU Helsinki PuiU 17 28 29 21
12 Ponnistajat Ponnistajat 17 27 32 21
13 FC Kuusysi FC Kuusysi 17 29 47 20
14 RiPS RiPS 17 29 41 19
15 KoiPS KoiPS 17 35 57 16
16 Nastolan Nopsa Nastolan 17 26 65 12
17 JoKi JoKi 17 16 47 10
18 JäPS II JäPS II 17 21 57 5
TEMPORADA 2015/2016
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Honka FC Honka 22 74 9 58
2 TPV Tampere TPV Tampere 22 47 22 45
3 BK-46 BK-46 22 51 35 41
4 FC Espoo FC Espoo 22 41 38 37
5 Klubi 04 Klubi 04 22 40 32 35
6 Kiffen Kiffen 22 31 31 31
7 SalPa SalPa 22 31 33 25
8 Viikingit Viikingit 22 29 37 23
9 EsPa EsPa 22 21 55 22
10 Åland Åland 22 25 38 21
11 Atlantis Atlantis 22 25 36 20
12 FC Kontu FC Kontu 22 20 69 11
TEMPORADA 2007/2008
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 Klubi 04 Klubi 04 26 68 19 58
2 Warkaus JK Warkaus JK 26 60 28 53
3 FC Kuusankoski Kuusankoski 26 62 34 53
4 Gnistan Gnistan 26 44 42 41
5 FC KTP FC KTP 26 39 34 40
6 Mikkelin Palloilijat Mikkelin 26 40 41 40
7 HIFK HIFK 26 39 31 38
8 PKKU PKKU 26 49 50 35
9 LPS LPS 26 42 44 34
10 HyPS HyPS 26 52 49 32
11 FC Jyvaskyla Blackbird Jyvaskyla 26 33 33 32
12 City Stars City Stars 26 33 41 31
13 FC Kontu FC Kontu 26 22 61 19
14 JP Rakuunat JP Rakuunat 26 20 96 6
TEMPORADA 2006/2007
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 KaPa KaPa 26 46 22 57
2 FC Kuusankoski Kuusankoski 26 57 25 54
3 Mikkelin Palloilijat Mikkelin 26 39 24 49
4 LPS LPS 26 43 28 45
5 City Stars City Stars 26 48 29 44
6 Warkaus JK Warkaus JK 26 43 30 41
7 Gnistan Gnistan 26 43 29 39
8 FC Kontu FC Kontu 26 39 35 35
9 HyPS HyPS 26 45 42 35
10 JP Rakuunat JP Rakuunat 26 35 59 27
11 FC Jyvaskyla Blackbird Jyvaskyla 26 29 48 24
12 PuiU Helsinki PuiU 26 29 51 24
13 MPS MPS 26 32 63 22
14 Mikkelin Kissat Mikkelin 26 25 68 13
TEMPORADA 2005/2006
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 JJK Jyväskylä Jyväskylä 26 53 20 52
2 HyPS HyPS 26 51 28 48
3 Kings Kuopio Kings Kuopio 26 45 29 45
4 Gnistan Gnistan 26 54 40 45
5 KaPa KaPa 26 49 34 42
6 Warkaus JK Warkaus JK 26 42 37 40
7 KuPS II KuPS II 26 46 46 40
8 LPS LPS 26 50 49 37
9 FC Kontu FC Kontu 26 41 44 36
10 MPS MPS 26 45 53 35
11 FC Kuusankoski Kuusankoski 26 47 37 34
12 Aanekosken Huima Aanekosken 26 35 56 31
13 Vaajakoski Vaajakoski 26 29 52 22
14 Ponnistus Ponnistus 26 15 77 6
TEMPORADA 2004/2005
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Klubi 04 Klubi 04 20 58 17 46
2 Gnistan Gnistan 20 48 21 41
3 FC Espoo FC Espoo 20 44 25 38
4 FC Kontu FC Kontu 20 32 26 36
5 KaPa KaPa 20 44 36 35
6 LPS LPS 20 44 46 25
7 Ekenäs IF Ekenäs IF 20 41 50 20
8 GrIFK Grankulla GrIFK 20 26 45 18
9 HyPS HyPS 20 32 55 18
10 Ponnistus Ponnistus 20 26 52 18
11 Salamat Salamat 20 30 52 13
TEMPORADA 2003/2004
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlantis Atlantis 17 43 13 46
2 PK-35 Vantaa PK-35 Vantaa 16 44 17 33
3 FC Espoo FC Espoo 17 38 23 33
4 Klubi 04 Klubi 04 17 41 26 28
5 FC Kontu FC Kontu 16 28 30 24
6 KaPa KaPa 18 22 32 22
7 Salamat Salamat 17 30 30 20
8 LPS LPS 16 27 33 20
9 Pantterit Pantterit 17 29 41 20
10 HyPS HyPS 17 19 30 19
11 Gnistan Gnistan 17 21 23 18
12 Kiffen Kiffen 17 17 31 14
13 TiPS TiPS 18 24 54 14
TEMPORADA 2002/2003
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 PK-35 Vantaa PK-35 Vantaa 22 38 21 43
2 IFK Mariehamn Mariehamn 22 37 25 38
3 Atlantis Atlantis 22 28 24 37
4 FC Espoo FC Espoo 22 42 36 35
5 Salamat Salamat 22 45 32 33
6 KaPa KaPa 22 36 29 32
7 Gnistan Gnistan 22 34 31 32
8 FC Kontu FC Kontu 22 34 36 31
9 HyPS HyPS 22 30 37 21
10 Kiffen Kiffen 22 18 37 21
11 AC Vantaa AC Vantaa 22 19 33 19
12 Futura Futura 22 28 48 17
TEMPORADA 1999/2000
CUARTA FINLANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 SalPa SalPa 22 70 18 59
2 KaaPo KaaPo 22 53 41 39
3 TPK TPK 22 52 36 36
4 Ponnistus Ponnistus 22 39 47 34
5 VG-62 Naantali VG-62 22 44 32 32
6 IFK Mariehamn Mariehamn 22 45 45 31
7 KaIK KaIK 22 53 49 30
8 PIF PIF 22 31 37 30
9 Ponnistajat Ponnistajat 22 35 40 28
10 FC Kontu FC Kontu 22 44 43 27
11 VJS VJS 22 32 64 17
12 EuPa EuPa 22 33 79 10
TEMPORADA 1995/1996
SEGUNDA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 HIK HIK 27 66 21 60
2 FC KTP FC KTP 27 35 17 52
3 K-Team K-Team 27 49 35 51
4 TiPS TiPS 27 45 28 44
5 FC Honka FC Honka 27 58 48 37
6 Gnistan Gnistan 27 29 39 36
7 Ponnistus Ponnistus 27 42 55 34
8 Kultsu Kultsu 27 31 49 27
9 JP Rakuunat JP Rakuunat 27 25 53 21
10 FC Kontu FC Kontu 27 24 59 11
TEMPORADA 1994/1995
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 Inter Turku Inter Turku 26 63 20 56
2 FC KTP FC KTP 26 45 37 42
3 Kultsu Kultsu 26 29 33 41
4 FC Reipas Lahti Reipas Lahti 26 34 36 40
5 KePS KePS 26 48 35 38
6 P-Iirot P-Iirot 26 44 48 38
7 K-Team K-Team 26 42 37 34
8 FC Kontu FC Kontu 26 39 38 34
9 Gnistan Gnistan 26 28 27 34
10 GBK GBK 26 36 44 34
11 JP Rakuunat JP Rakuunat 26 34 38 31
12 KuPS Kuopio KuPS Kuopio 26 27 36 25
13 KPV KPV 26 28 36 24
14 PP-70 Tampere PP-70 26 24 56 16
TEMPORADA 1993/1994
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 Ponnistus Ponnistus 26 40 10 58
2 VPS Vaasa VPS Vaasa 26 59 20 50
3 Inter Turku Inter Turku 26 47 25 42
4 FC Reipas Lahti Reipas Lahti 26 53 48 41
5 FC Kontu FC Kontu 26 33 26 37
6 P-Iirot P-Iirot 26 34 32 35
7 KePS KePS 26 39 42 35
8 KPV KPV 26 34 42 33
9 Kultsu Kultsu 26 35 41 32
10 FC KTP FC KTP 26 37 43 31
11 VIFK VIFK 26 43 50 27
12 PIF PIF 26 42 56 27
13 KajHa KajHa 26 30 38 26
14 FC 1991 FC 1991 26 27 80 22

  USO DE MEMORIA  
6,934,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5463
Total Execution Time  0.5475
  CADENA URL  
/historico/Fc-Kontu
  GET DATOS  
$_GET['/historico/Fc-Kontu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64170 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2355 AND type_rel = 3
0.0142  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 = '64170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=64170 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (75428,75296) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 75428 AND teamId = 64170
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 64170
0.0138  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 = '64170' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64170' and rp.type = 4
0.0138  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 = '64170' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 64170 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.0137  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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 64170 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 64170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 64170 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75428 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.0257  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 = 70864 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0254  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 = 66474 AND t.round = 40 ORDER BY team.conference ASC,t.position 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 `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 = 62652 AND t.round = 20 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 = 64667 AND t.round = 5 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 = 57728 AND t.round = 16 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 `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 = 20335 AND t.round = 22 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 `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 = 16320 AND t.round = 26 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 `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 = 16321 AND t.round = 26 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 `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 = 16324 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 16328 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 16331 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 16336 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 16350 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1996` 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 = 14486 AND t.round = 27 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 `tables1995` 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 = 14484 AND t.round = 26 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 `tables1994` 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 = 14483 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC