4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vaprus Pärnu

Vaprus Pärnu

Entrenador: Igor Prins

Temporada 2018/2019
TEMPORADA 2018/2019
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 TJK Legion TJK Legion 36 129 35 94
2 FC Flora Tallin II Flora Tallin 36 85 37 73
3 Vaprus Pärnu Vaprus 36 73 48 67
4 Tammeka II Tammeka II 36 59 55 58
5 FC Elva FC Elva 36 67 63 56
6 Levadia Tallinn II Levadia 36 80 65 53
7 Alliance FC Alliance FC 36 51 82 40
8 Rakvere JK Tarvas Rakvere 36 35 98 28
9 Tallinna Kalev II Tallinna 36 38 84 25
10 Tartu Welco Tartu Welco 36 39 89 24
TEMPORADA 2017/2018
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Nomme Kalju Nomme Kalju 36 114 32 86
2 Levadia Levadia 36 109 26 84
3 FC Flora FC Flora 36 116 32 83
4 Narva Trans Narva Trans 36 76 57 61
5 Paide Paide 36 64 74 51
6 Tammeka Tammeka 36 56 58 49
7 Tulevik Viljandi Tulevik 36 37 100 29
8 Tallinna Kalev Tallinna 36 54 68 28
9 Kuressaare Kuressaare 36 34 115 21
10 Vaprus Pärnu Vaprus 36 25 123 13
TEMPORADA 2016/2017
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora FC Flora 36 100 28 90
2 Levadia Levadia 36 106 20 84
3 Nomme Kalju Nomme Kalju 36 101 32 78
4 FCI Tallinn FCI Tallinn 36 103 47 65
5 Narva Trans Narva Trans 36 46 63 45
6 Paide Paide 36 47 88 38
7 Tammeka Tammeka 36 40 63 37
8 Sillamäe Kalev Sillamäe 36 52 76 36
9 Tulevik Viljandi Tulevik 36 34 95 28
10 Vaprus Pärnu Vaprus 36 29 146 8
TEMPORADA 2015/2016
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FCI Tallinn FCI Tallinn 36 74 33 80
2 Levadia Levadia 36 77 30 78
3 Nomme Kalju Nomme Kalju 36 70 28 75
4 FC Flora FC Flora 36 96 31 73
5 Sillamäe Kalev Sillamäe 36 65 55 51
6 Paide Paide 36 58 61 48
7 Narva Trans Narva Trans 36 60 68 41
8 Tammeka Tammeka 36 43 65 41
9 Vaprus Pärnu Vaprus 36 24 98 17
10 Rakvere JK Tarvas Rakvere 36 15 113 3
TEMPORADA 2014/2015
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora FC Flora 36 72 24 84
2 Levadia Levadia 37 78 32 77
3 Nomme Kalju Nomme Kalju 36 69 36 71
4 FCI Tallinn FCI Tallinn 37 50 32 63
5 Sillamäe Kalev Sillamäe 36 63 43 59
6 Narva Trans Narva Trans 36 50 46 49
7 Paide Paide 36 50 73 33
8 Vaprus Pärnu Vaprus 36 38 87 26
9 Tammeka Tammeka 36 39 96 25
10 Tulevik Viljandi Tulevik 36 35 75 22
TEMPORADA 2013/2014
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora Tallin II Flora Tallin 36 104 40 78
2 Levadia Tallinn II Levadia 36 102 52 68
3 Vaprus Pärnu Vaprus 36 109 78 60
4 Nõmme Kalju II Nõmme Kalju 36 69 62 57
5 Tulevik Viljandi Tulevik 36 58 51 55
6 Kiviõli Irbis Kiviõli 36 72 82 47
7 Kuressaare Kuressaare 36 69 81 47
8 Rakvere JK Tarvas Rakvere 36 61 67 44
9 Vändra JK Vaprus Vändra 36 60 72 38
10 FC Puuma FC Puuma 36 32 151 7
TEMPORADA 2012/2013
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Nõmme Kalju II Nõmme Kalju 36 91 37 82
2 Vaprus Pärnu Vaprus 36 114 55 79
3 Sillamäe Kalev II Sillamäe 36 81 53 66
4 Ararat Ararat 36 77 50 63
5 Emmaste Emmaste 36 69 45 61
6 FC Elva FC Elva 36 60 64 49
7 TJK Legion TJK Legion 36 55 81 41
8 Tallinna Dünamo Tallinna 36 42 86 31
9 FC Flora Tallin III Flora Tallin 36 40 107 26
10 Alliance FC Alliance FC 36 28 79 17
TEMPORADA 2011/2012
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 FCI Tallinn FCI Tallinn 36 94 33 83
2 FC Flora Tallin II Flora Tallin 36 66 32 69
3 Rakvere JK Tarvas Rakvere 36 66 58 68
4 Tartu SK 10 Tartu SK 10 36 65 58 54
5 Levadia Tallinn II Levadia 36 77 56 53
6 Kiviõli Irbis Kiviõli 36 78 83 44
7 FC Puuma FC Puuma 36 55 61 43
8 Tammeka II Tammeka II 36 55 83 37
9 Vaprus Pärnu Vaprus 36 43 72 36
10 Lootus Lootus 36 40 103 19
TEMPORADA 2010/2011
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Tallinna Kalev Tallinna 36 102 39 73
2 FCI Tallinn FCI Tallinn 36 101 47 68
3 Kiviõli Irbis Kiviõli 36 73 61 67
4 Levadia Tallinn II Levadia 36 67 43 60
5 FC Flora Tallin II Flora Tallin 36 70 51 58
6 FC Puuma FC Puuma 36 81 72 54
7 Lootus Lootus 36 59 75 38
8 Vaprus Pärnu Vaprus 36 55 63 35
9 TJK Legion TJK Legion 36 44 104 27
10 Warrior Valga Warrior 36 34 131 16
TEMPORADA 2009/2010
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 107 28 89
2 FC Flora Tallin II Flora Tallin 36 93 45 72
3 Ajax Lasnamäe Ajax 36 71 38 69
4 Kiviõli Irbis Kiviõli 36 89 72 60
5 Tallinna Kalev Tallinna 36 67 65 53
6 TJK Legion TJK Legion 36 60 81 40
7 Vaprus Pärnu Vaprus 36 57 78 37
8 Warrior Valga Warrior 36 57 93 33
9 Rakvere JK Tarvas Rakvere 36 45 99 28
10 Johvi FC Lokomotiv Johvi 36 35 82 22
TEMPORADA 2008/2009
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 36 96 21 86
2 Lootus Lootus 36 88 48 74
3 Warrior Valga Warrior 36 68 63 65
4 Ajax Lasnamäe Ajax 36 75 53 64
5 Kiviõli Irbis Kiviõli 36 77 77 53
6 TJK Legion TJK Legion 36 63 76 44
7 Vaprus Pärnu Vaprus 36 64 77 39
8 Tulevik II Tulevik II 36 49 79 36
9 FC Flora Tallin II Flora Tallin 36 35 64 32
10 Rakvere JK Tarvas Rakvere 36 48 105 26
TEMPORADA 2007/2008
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 105 22 93
2 FC Flora FC Flora 36 113 28 91
3 FC TVMK FC TVMK 36 91 47 66
4 Narva Trans Narva Trans 36 62 54 56
5 Nomme Kalju Nomme Kalju 36 65 64 55
6 Sillamäe Kalev Sillamäe 36 49 79 45
7 Tammeka Tammeka 36 45 76 31
8 Tulevik Viljandi Tulevik 36 31 74 31
9 Tallinna Kalev Tallinna 36 37 70 26
10 Vaprus Pärnu Vaprus 36 41 125 17
TEMPORADA 2006/2007
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 126 20 91
2 FC Flora FC Flora 36 108 30 83
3 FC TVMK FC TVMK 36 116 36 79
4 Narva Trans Narva Trans 36 89 28 78
5 Tammeka Tammeka 36 54 40 62
6 Tallinna Kalev Tallinna 36 44 77 43
7 Tulevik Viljandi Tulevik 36 43 80 37
8 Vaprus Pärnu Vaprus 36 35 96 25
9 Kuressaare Kuressaare 36 25 94 18
10 Ajax Lasnamäe Ajax 36 14 153 5
TEMPORADA 2005/2006
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 Levadia Levadia 36 114 29 94
2 Narva Trans Narva Trans 36 106 36 83
3 FC Flora FC Flora 36 93 34 82
4 FC TVMK FC TVMK 36 83 37 72
5 Maag Tartu Maag Tartu 36 65 68 48
6 Tammeka Tammeka 36 45 57 43
7 Vaprus Pärnu Vaprus 36 49 86 34
8 Ajax Lasnamäe Ajax 36 35 104 25
9 Tulevik Viljandi Tulevik 36 29 74 20
10 Warrior Valga Warrior 36 16 110 11
TEMPORADA 2004/2005
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Vaprus Pärnu Vaprus 36 92 39 84
2 Levadia Tallinn II Levadia 36 104 31 82
3 Ajax Lasnamäe Ajax 36 111 30 77
4 Tallinna Kalev Tallinna 36 85 71 63
5 JK Tervis Pärnu Tervis 36 73 56 50
6 TVMK Tallinn II TVMK Tallinn 36 51 80 41
7 FC Elva FC Elva 36 42 71 36
8 Lelle Lelle 36 49 100 34
9 Tallinna JK Tallinna JK 36 41 100 31
10 Merkuur-Juunior Merkuur-Juun 36 30 100 14
TEMPORADA 2001/2002
LIGA ESTONIA
Equipo PJ GF GC Puntos
1 FC Flora FC Flora 28 79 25 64
2 Levadia Levadia 28 70 25 62
3 FC TVMK FC TVMK 28 90 35 53
4 Narva Trans Narva Trans 28 54 49 47
5 Tulevik Viljandi Tulevik 28 51 52 36
6 Levadia Tallinn II Levadia 28 32 70 23
7 Lootus Lootus 28 24 67 21
8 Vaprus Pärnu Vaprus 28 19 96 8

  USO DE MEMORIA  
6,415,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7482
Total Execution Time  0.7495
  CADENA URL  
/historico/Parnu/2019
  GET DATOS  
$_GET['/historico/Parnu/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0175  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 = 'Parnu' AND l.year = 2019 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.0146  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=17796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=17796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=17796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=17796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=17796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0307  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 = 48713
0.0159  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 = 51704
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17796 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0151  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 = '17796' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '17796' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 51704 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 48713 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159  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=17796 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (60120,51704,49884,49506,42545) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 42545 AND teamId = 17796
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 60120 AND teamId = 17796
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 51704 AND teamId = 17796
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 49884 AND teamId = 17796
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 17796
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 48713 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '17796' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17796' and rp.type = 4
0.0146  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 = '17796' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 17796 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.0157  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 17796 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2019 e ON e.player_id = p.id AND e.league_id = 48713 WHERE rp.league_id = 48713 AND rp.teamId = 17796 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 17796 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0158  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 = 48713 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 2848 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 15379 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 14943 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 14944 AND t.round = 36 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 `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 = 14945 AND t.round = 36 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 `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 = 14946 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 10351 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 10350 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 14951 AND t.round = 36 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 `tables2002` 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 = 23615 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 48713 ORDER BY nameShow LIMIT 100