4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Turku II Inter Turku 5 21 11 13
2 P-Iirot P-Iirot 5 14 7 13
3 HJS Akatemia Akatemia 5 14 8 11
4 TPV Tampere TPV Tampere 6 9 8 10
5 EBK EBK 5 11 11 10
6 VJS VJS 6 15 9 8
7 Tampere United Tampere 5 9 6 7
8 Ilves II Ilves II 6 10 13 4
9 I-Kissat I-Kissat 6 8 23 3
10 FC Honka FC Honka 5 7 12 2
11 SexyPöxyt SexyPöxyt 4 4 14 0
TEMPORADA 2022/2023
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Espoon Palloseura FC Espoon 22 50 20 48
2 FC Jazz FC Jazz 22 63 31 45
3 I-Kissat I-Kissat 22 53 43 43
4 Atlantis Atlantis 22 54 30 41
5 Tampere United Tampere 22 40 32 37
6 GrIFK Grankulla GrIFK 22 39 40 35
7 Honka Akatemia Honka 22 39 42 32
8 P-Iirot P-Iirot 22 37 34 30
9 Ilves II Ilves II 22 28 50 20
10 HJS Akatemia Akatemia 22 28 45 18
11 SexyPöxyt SexyPöxyt 22 20 51 16
12 PIF PIF 22 25 58 12
TEMPORADA 2021/2022
QUINTA FINLANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 P-Iirot P-Iirot 19 60 13 53
2 Inter Turku II Inter Turku 19 49 34 38
3 ÅIFK ÅIFK 20 34 26 34
4 Åland Åland 18 43 25 32
5 TPS II TPS II 18 35 21 29
6 PaiHa PaiHa 18 28 36 23
7 MaPS MaPS 18 23 31 22
8 VG-62 Naantali VG-62 19 32 37 18
9 Peimari United Peimari 17 31 39 17
10 TPK TPK 18 20 38 17
11 Toejoen Veikot Toejoen 17 19 43 16
12 PIF II PIF II 19 27 58 10
13 TPV Tampere TPV Tampere 19 71 14 47
14 NoPS NoPS 19 70 17 47
15 TP-T TP-T 20 69 20 46
16 Haka Juniorit Haka 19 73 25 44
17 Tampere United Tampere 19 51 37 28
18 Loiske Loiske 18 28 42 23
19 PP-70 Tampere PP-70 19 25 45 22
20 Melody Melody 19 52 65 21
21 ACE ACE 18 42 51 19
22 PJK Pirkkala Pirkkala 18 21 68 11
23 TKT TKT 19 22 60 9
24 IkU IkU 17 15 95 7
25 Sporting Kristina Sporting 20 62 28 42
26 VPS II VPS II 18 52 18 42
27 Korsnäs Korsnäs 20 85 48 41
28 SIF SIF 19 53 29 37
29 KPV Akatemia Akatemia 19 54 34 33
30 Esse IK Esse IK 20 45 38 33
31 Kiisto Kiisto 19 45 33 31
32 SJK-Juniorit SJK-Juniorit 19 43 36 28
33 Nykarleby IK Nykarleby 20 35 42 21
34 Norrvalla FF Norrvalla 19 33 60 14
35 VPV VPV 19 21 62 14
36 Ylivieska Ylivieska 20 16 116 0
TEMPORADA 2020/2021
QUINTA FINLANDIA GRUPO 5
Equipo PJ GF GC Puntos
1 Kiisto Kiisto 4 6 2 33
2 Norrvalla FF Norrvalla 5 2 12 16
3 VPS II VPS II 5 8 3 11
4 SIF SIF 5 10 3 10
5 KPV Akatemia Akatemia 4 3 3 6
6 VPV VPV 5 3 9 4
7 P-Iirot P-Iirot 5 10 6 36
8 Åland Åland 5 16 7 34
9 TPS II TPS II 5 8 4 32
10 MaPS MaPS 5 8 12 22
11 ÅIFK ÅIFK 5 5 12 22
12 VG-62 Naantali VG-62 5 8 14 19
13 Tampere United Tampere 5 21 4 46
14 NoPS NoPS 5 21 9 40
15 Haka Juniorit Haka 5 12 12 37
16 TP-T TP-T 5 20 12 25
17 PJK Pirkkala Pirkkala 5 2 24 17
18 TKT TKT 5 4 19 15
TEMPORADA 2019/2020
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Klubi 04 Klubi 04 17 56 14 49
2 Ilves II Ilves II 17 39 23 34
3 HJS Akatemia Akatemia 17 32 30 28
4 PIF PIF 17 26 19 27
5 Atlantis Atlantis 17 42 41 26
6 KaaPo KaaPo 17 35 26 24
7 FC Jazz FC Jazz 17 32 28 21
8 GrIFK Grankulla GrIFK 17 32 41 19
9 SalPa SalPa 17 29 34 18
10 TPV Tampere TPV Tampere 17 24 38 18
11 FC Espoo FC Espoo 17 22 39 11
12 P-Iirot P-Iirot 17 10 46 8
TEMPORADA 2018/2019
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gnistan Gnistan 22 57 22 55
2 KaaPo KaaPo 22 43 22 40
3 Ilves II Ilves II 22 45 37 35
4 FC Espoo FC Espoo 22 42 30 34
5 SalPa SalPa 22 42 32 32
6 Honka Akatemia Honka 22 33 31 31
7 P-Iirot P-Iirot 22 29 35 30
8 FC Jazz FC Jazz 22 39 51 30
9 GrIFK Grankulla GrIFK 22 31 42 26
10 Espoon Palloseura FC Espoon 22 30 41 22
11 KaPa KaPa 22 22 37 22
12 Tampere United Tampere 22 18 51 11
TEMPORADA 2014/2015
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 GrIFK Grankulla GrIFK 27 78 32 63
2 Musan Salama Musan Salama 27 51 30 49
3 SalPa SalPa 27 35 36 40
4 Ekenas SC Ekenas SC 27 31 30 39
5 BK-46 BK-46 27 41 46 37
6 Närpes Kraft Närpes 27 52 51 34
7 MaPS MaPS 27 28 41 34
8 P-Iirot P-Iirot 27 50 44 30
9 ÅIFK ÅIFK 27 35 56 30
10 KaaPo KaaPo 27 32 67 24
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 3
Equipo PJ GF GC Puntos
1 FC Jazz FC Jazz 27 67 24 61
2 TPV Tampere TPV Tampere 27 60 32 49
3 P-Iirot P-Iirot 27 56 36 49
4 Hameenlinna Hameenlinna 27 56 42 48
5 Närpes Kraft Närpes 27 66 52 47
6 Masku Masku 27 59 50 42
7 ÅIFK ÅIFK 27 59 45 33
8 Sporting Kristina Sporting 27 31 55 28
9 Musan Salama Musan Salama 27 38 80 17
10 Harma Hameenlinna Harma 27 16 92 12
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 2
Equipo PJ GF GC Puntos
1 BK-46 BK-46 26 59 18 60
2 Ilves Ilves 26 69 32 56
3 P-Iirot P-Iirot 26 57 30 52
4 Närpes Kraft Närpes 26 64 37 47
5 SalPa SalPa 26 55 29 44
6 JaPS JaPS 26 68 41 41
7 FC Jazz FC Jazz 26 55 38 41
8 ÅIFK ÅIFK 26 56 51 41
9 TPV Tampere TPV Tampere 26 52 49 40
10 LoPa LoPa 26 41 56 33
11 I-Kissat I-Kissat 26 22 65 19
12 TuTo TuTo 26 24 65 17
13 Musan Salama Musan Salama 26 20 71 15
14 TiPS TiPS 26 23 83 8
TEMPORADA 2009/2010
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ilves Ilves 26 59 32 55
2 SalPa SalPa 26 50 28 52
3 GrIFK Grankulla GrIFK 26 48 24 43
4 P-Iirot P-Iirot 26 33 24 43
5 Pallohonka Pallohonka 26 54 34 42
6 LoPa LoPa 26 44 43 35
7 ÅIFK ÅIFK 26 38 41 34
8 BK-46 BK-46 26 34 38 34
9 Musan Salama Musan Salama 26 33 58 34
10 FC Jazz FC Jazz 26 39 47 33
11 Ekenäs IF Ekenäs IF 26 43 42 31
12 SoVo SoVo 26 42 56 26
13 KaaPo KaaPo 26 38 61 24
14 Sinimustat Turku Sinimustat 26 27 54 20
TEMPORADA 2008/2009
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Espoo FC Espoo 26 43 19 55
2 LoPa LoPa 26 41 15 54
3 Ilves Ilves 26 40 30 45
4 KaaPo KaaPo 26 35 32 39
5 P-Iirot P-Iirot 26 37 32 36
6 Pallohonka Pallohonka 26 41 37 36
7 SalPa SalPa 26 37 38 34
8 Ekenäs IF Ekenäs IF 26 43 43 33
9 ÅIFK ÅIFK 26 43 43 32
10 FC Jazz FC Jazz 26 29 42 32
11 Sinimustat Turku Sinimustat 26 30 34 31
12 PP-70 Tampere PP-70 26 31 49 28
13 Närpes Kraft Närpes 26 28 46 28
14 PJK Pirkkala Pirkkala 26 34 52 23
TEMPORADA 2007/2008
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC PoPa FC PoPa 26 88 28 64
2 LoPa LoPa 26 54 24 56
3 KaaPo KaaPo 26 55 33 56
4 PP-70 Tampere PP-70 26 44 28 47
5 Ilves Ilves 26 40 24 44
6 P-Iirot P-Iirot 26 46 38 41
7 SalPa SalPa 26 43 31 38
8 ÅIFK ÅIFK 26 48 33 37
9 FC Espoo FC Espoo 26 56 58 34
10 Ekenäs IF Ekenäs IF 26 35 48 32
11 Sinimustat Turku Sinimustat 26 45 38 27
12 Aanekosken Huima Aanekosken 26 24 68 18
13 IFFK Palsbole IFFK 26 23 66 17
14 FJK Forssa FJK Forssa 26 16 100 8
TEMPORADA 2006/2007
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 GrIFK Grankulla GrIFK 26 67 38 56
2 FC PoPa FC PoPa 26 61 22 55
3 KaaPo KaaPo 26 58 23 47
4 KOO VEE KOO VEE 26 38 36 46
5 SalPa SalPa 26 43 30 40
6 FC Espoo FC Espoo 26 39 41 35
7 Ekenäs IF Ekenäs IF 26 37 45 35
8 LoPa LoPa 26 35 46 34
9 P-Iirot P-Iirot 26 34 36 32
10 VG-62 Naantali VG-62 26 32 43 32
11 IFFK Palsbole IFFK 26 26 37 27
12 SoVo SoVo 26 20 53 24
13 Musan Salama Musan Salama 26 24 40 23
14 MaPS MaPS 26 24 48 21
TEMPORADA 2005/2006
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 TPV Tampere TPV Tampere 26 52 16 61
2 SalPa SalPa 26 55 23 54
3 FC PoPa FC PoPa 26 64 32 46
4 KaaPo KaaPo 26 57 46 46
5 FC Espoo FC Espoo 26 54 46 39
6 P-Iirot P-Iirot 26 35 30 39
7 VG-62 Naantali VG-62 26 35 39 36
8 Ekenäs IF Ekenäs IF 26 53 46 31
9 GrIFK Grankulla GrIFK 26 39 46 31
10 MaPS MaPS 26 29 38 30
11 SoVo SoVo 26 39 54 30
12 TKT TKT 26 30 41 26
13 PIF PIF 26 24 47 23
14 PS-44 PS-44 26 18 80 16
TEMPORADA 2004/2005
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 FC Honka FC Honka 26 57 17 57
2 VPS Vaasa VPS Vaasa 26 49 23 53
3 PK-35 Vantaa PK-35 Vantaa 26 28 21 45
4 KPV KPV 26 36 29 41
5 JP Rakuunat JP Rakuunat 26 34 36 41
6 Viikingit Viikingit 26 43 34 37
7 Atlantis Atlantis 26 39 35 34
8 PP-70 Tampere PP-70 26 32 39 32
9 Mikkelin Palloilijat Mikkelin 26 31 42 32
10 AC Oulu AC Oulu 26 32 33 31
11 Hameenlinna Hameenlinna 26 26 39 30
12 VG-62 Naantali VG-62 26 29 41 29
13 Oulun Luistinseura Oulun 26 23 42 28
14 P-Iirot P-Iirot 26 25 53 21
TEMPORADA 2003/2004
SEGUNDA FINLANDIA
Equipo PJ GF GC Puntos
1 KuPS Kuopio KuPS Kuopio 26 51 22 54
2 IFK Mariehamn Mariehamn 26 52 32 50
3 FC Honka FC Honka 26 55 38 43
4 Viikingit Viikingit 26 40 33 42
5 AC Oulu AC Oulu 26 39 33 39
6 VPS Vaasa VPS Vaasa 26 32 26 39
7 Mikkelin Palloilijat Mikkelin 26 46 40 38
8 JP Rakuunat JP Rakuunat 26 39 36 38
9 PP-70 Tampere PP-70 26 36 30 35
10 P-Iirot P-Iirot 26 34 43 35
11 VG-62 Naantali VG-62 26 34 40 33
12 Närpes Kraft Närpes 26 37 47 24
13 FC Kuusankoski Kuusankoski 26 28 54 18
14 GBK GBK 26 26 75 13
TEMPORADA 2002/2003
CUARTA FINLANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 P-Iirot P-Iirot 22 40 10 50
2 TPV Tampere TPV Tampere 22 48 20 50
3 Ekenäs IF Ekenäs IF 22 44 24 45
4 SalPa SalPa 22 29 33 32
5 PIF PIF 22 29 32 28
6 FJK Forssa FJK Forssa 22 36 40 27
7 Musan Salama Musan Salama 22 34 38 26
8 KaaPo KaaPo 22 28 35 24
9 Rauma Rauma 22 34 43 24
10 MaPS MaPS 22 22 39 21
11 PS-44 PS-44 22 29 41 19
12 FC PoPa FC PoPa 22 28 46 18

  USO DE MEMORIA  
7,100,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1226
Total Execution Time  0.1245
  CADENA URL  
/historico/P-Iirot
  GET DATOS  
$_GET['/historico/P-Iirot']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18030 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=342 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 342 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (861540,356212,352302,236817,112978) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '18030' 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 = '18030' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=18030 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 (75458,75296,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 = 75458 AND teamId = 18030
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 18030
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18030
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 = '18030' 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 = '18030' 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 = '18030' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 75458 WHERE rp.league_id = 75458 AND rp.teamId = 18030 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.0024  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 = 75458 WHERE rp.league_id = 75458 AND rp.teamId = 18030 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 = 75458 WHERE rp.league_id = 75458 AND rp.teamId = 18030 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 = 18030 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75458 AND t.round = 6 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 `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 = 71031 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.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 `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 = 66772 AND t.round = 35 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 `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 = 62651 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.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 `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 = 64665 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.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 `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 = 55529 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.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 `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 = 49439 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 `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 = 11773 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.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 `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 = 2778 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 `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.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 `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 = 16309 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 = 16312 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 `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 = 16316 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 `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 = 16319 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 `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 = 16322 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 = 16325 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 `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 = 14502 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 `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 = 14501 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 `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 = 16338 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC