4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del LPS
TEMPORADA 2023/2024
QUINTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Valtti Valtti 2 10 0 6
2 HPS HPS 2 6 1 6
3 LPS LPS 1 6 2 3
4 PPJ / Lauttasaari Lauttasaari 2 6 4 3
5 FC Kontu FC Kontu 2 5 3 3
6 MPS / Atletico Malmi Atletico 1 2 0 3
7 Ponnistus Ponnistus 1 2 1 3
8 Töölön Taisto Töölön 2 1 3 1
9 HIFK 2 HIFK 2 2 1 4 1
10 Loviisa Loviisa 1 0 5 0
11 Finnkurd Finnkurd 2 3 9 0
12 HerTo HerTo 2 0 10 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 3
Equipo PJ GF GC Puntos
1 KaPa KaPa 17 50 15 44
2 Atlantis II Atlantis II 17 54 27 36
3 SexyPöxyt SexyPöxyt 17 33 17 34
4 Kirkkonummi Kirkkonummi 17 37 23 34
5 HPS HPS 17 42 29 28
6 EsPa EsPa 17 36 27 28
7 LPS LPS 18 43 38 28
8 CLE CLE 17 29 30 28
9 Töölön Taisto Töölön 17 37 33 25
10 ToTe ToTe 17 29 36 25
11 Finnkurd Finnkurd 17 43 48 24
12 NuPS NuPS 16 35 35 22
13 FC Espoo II FC Espoo II 17 14 25 17
14 Ekenäs IF II Ekenäs 17 26 46 17
15 Espoon Tikka Espoon Tikka 17 39 49 15
16 HerTo HerTo 17 24 38 10
17 BK-46 BK-46 17 16 46 10
18 FC POHU FC POHU 17 19 44 7
TEMPORADA 2017/2018
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 MYPA MYPA 22 52 42 40
2 JaPS JaPS 22 60 38 38
3 JIPPO Joensuu JIPPO 22 34 25 37
4 Mikkelin Kissat Mikkelin 22 36 28 37
5 PEPO PEPO 22 38 21 36
6 Gnistan Gnistan 22 35 31 34
7 Mikkelin Palloilijat Mikkelin 22 39 31 33
8 Viikingit Viikingit 22 39 32 30
9 NJS NJS 22 25 36 27
10 Vaajakoski Vaajakoski 22 34 39 23
11 PKKU PKKU 22 33 41 23
12 LPS LPS 22 26 87 5
TEMPORADA 2012/2013
CUARTA FINLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ekenäs IF Ekenäs IF 27 52 25 57
2 Gnistan Gnistan 27 48 29 49
3 GrIFK Grankulla GrIFK 27 50 39 48
4 BK-46 BK-46 27 50 35 45
5 SalPa SalPa 27 41 33 38
6 Klubi 04 Klubi 04 27 27 29 37
7 KaPa KaPa 27 33 36 34
8 Pallohonka Pallohonka 27 32 36 33
9 EsPa EsPa 27 21 58 18
10 LPS LPS 27 23 57 17
TEMPORADA 2011/2012
CUARTA FINLANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 JaPS JaPS 27 59 33 53
2 Gnistan Gnistan 27 46 26 52
3 Mikkelin Palloilijat Mikkelin 27 68 37 49
4 Lahti Akatemia Lahti 27 45 39 40
5 Atlantis Atlantis 27 54 43 39
6 FC KTP FC KTP 27 43 54 37
7 Futura Futura 27 48 58 33
8 LPS LPS 27 37 50 32
9 Kiffen Kiffen 27 25 53 24
10 PK-35 VJS PK-35 VJS 27 23 55 19
TEMPORADA 2010/2011
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 Klubi 04 Klubi 04 26 96 33 60
2 Gnistan Gnistan 26 67 42 50
3 Mikkelin Palloilijat Mikkelin 26 61 33 49
4 GrIFK Grankulla GrIFK 26 41 38 43
5 Pallohonka Pallohonka 26 47 44 41
6 Lahti Akatemia Lahti 26 62 52 39
7 Futura Futura 26 51 52 37
8 Atlantis Atlantis 26 50 47 36
9 Kiffen Kiffen 26 28 40 33
10 LPS LPS 26 45 58 32
11 FC KTP FC KTP 26 34 49 32
12 Sudet Sudet 26 32 48 29
13 MPS MPS 26 41 75 18
14 KaPa KaPa 26 30 74 14
TEMPORADA 2009/2010
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 HIFK HIFK 26 49 23 51
2 Kiffen Kiffen 26 30 18 44
3 Gnistan Gnistan 26 49 25 43
4 City Stars City Stars 26 48 41 40
5 SC Riverball Riverball 26 35 33 40
6 Atlantis Atlantis 26 41 37 38
7 LPS LPS 26 48 47 38
8 Futura Futura 26 42 47 37
9 FC Kuusankoski Kuusankoski 26 35 38 34
10 KaPa KaPa 26 41 42 33
11 Warkaus JK Warkaus JK 26 32 42 33
12 PEPO PEPO 26 34 46 24
13 AC Vantaa AC Vantaa 26 33 56 24
14 PKKU PKKU 26 24 46 20
TEMPORADA 2008/2009
CUARTA FINLANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 Mikkelin Palloilijat Mikkelin 26 51 25 53
2 Gnistan Gnistan 26 41 23 46
3 KaPa KaPa 26 49 32 46
4 Warkaus JK Warkaus JK 26 49 41 46
5 PKKU PKKU 26 56 36 38
6 Futura Futura 26 55 50 38
7 HIFK HIFK 26 40 36 36
8 Kiffen Kiffen 26 35 33 36
9 GrIFK Grankulla GrIFK 26 42 39 35
10 LPS LPS 26 37 37 34
11 FC Kuusankoski Kuusankoski 26 35 48 34
12 FC KTP FC KTP 26 40 40 32
13 HyPS HyPS 26 38 60 26
14 Kultsu Kultsu 26 20 88 5
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

  USO DE MEMORIA  
6,919,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5761
Total Execution Time  0.5773
  CADENA URL  
/historico/Lps
  GET DATOS  
$_GET['/historico/Lps']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0134  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 = 'Lps' 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.0125  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=12612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=12612 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=12612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12612 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2355 AND type_rel = 3
0.0134  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 = '12612' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '12612' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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=12612 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75428 AND teamId = 12612
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75296 AND teamId = 12612
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 = '12612' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12612' and rp.type = 4
0.0127  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 = '12612' 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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 12612 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.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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 12612 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 = 75428 WHERE rp.league_id = 75428 AND rp.teamId = 12612 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 12612 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0253  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.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 `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.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 `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.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 `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.0136  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 = 57727 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.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 `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 = 43228 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 `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 = 2777 AND t.round = 27 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 = 16305 AND t.round = 27 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 `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 = 16313 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 `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 = 16315 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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.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 `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.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 `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.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 `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.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 `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