4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rynninge
TEMPORADA 2019/2020
CUARTA SUECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Assyriska FF Assyriska 13 37 11 31
2 Åtvidabergs Åtvidabergs 13 33 18 31
3 BK Forward BK Forward 13 32 14 30
4 Tyreso Tyreso 13 29 19 25
5 Arameiska / Syrianska Arameiska 13 23 26 20
6 Värmbols Värmbols 13 24 21 19
7 Kumla Kumla 13 31 26 18
8 Trosa-Vagnhärad Trosa-Vagnh 13 20 25 16
9 IFK Eskilstuna Eskilstuna 13 17 28 14
10 Gute Gute 13 17 25 13
11 Huddinge Huddinge 13 20 26 12
12 Rynninge Rynninge 13 15 28 11
13 Assyriska IF Assyriska 13 14 30 9
14 Newroz Newroz 13 19 34 8
TEMPORADA 2018/2019
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Akropolis Akropolis 30 77 28 75
2 Umeå Umeå 30 52 35 56
3 Linköping City Linköping 30 61 31 53
4 Carlstad United Carlstad 30 56 43 53
5 Karlstad BK Karlstad BK 30 53 35 51
6 Vasalunds IF Vasalunds 30 64 49 46
7 Sandvikens IF Sandvikens 30 52 47 43
8 Nyköpings BIS Nyköpings 30 45 54 38
9 Sylvia Sylvia 30 48 65 38
10 Karlslund Karlslund 30 45 55 35
11 Gefle Gefle 30 33 48 34
12 Team TG Team TG 30 38 55 34
13 Sollentuna Sollentuna 30 37 42 33
14 Bodens Bodens 30 42 60 31
15 Rynninge Rynninge 30 46 78 25
16 BK Forward BK Forward 30 36 60 20
TEMPORADA 2017/2018
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Västerås SK Västerås 30 56 26 68
2 Syrianska FC Syrianska 30 56 37 59
3 Carlstad United Carlstad 30 65 39 54
4 Akropolis Akropolis 30 65 42 53
5 Umeå Umeå 30 45 38 49
6 Sandvikens IF Sandvikens 30 47 39 45
7 Sollentuna Sollentuna 30 40 38 43
8 BK Forward BK Forward 30 48 49 43
9 Linköping City Linköping 30 44 47 40
10 Nyköpings BIS Nyköpings 30 47 54 38
11 Rynninge Rynninge 30 46 48 37
12 Team TG Team TG 30 44 45 36
13 Karlslund Karlslund 30 36 47 35
14 Arameiska / Syrianska Arameiska 30 40 77 23
15 Assyriska FF Assyriska 30 45 71 21
16 Skellefteå Skellefteå 30 40 67 13
TEMPORADA 2016/2017
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Linköping City Linköping 26 63 19 67
2 Rynninge Rynninge 26 51 28 58
3 Sleipner Sleipner 26 48 28 55
4 Haninge Haninge 26 50 45 42
5 Motala Motala 26 44 41 39
6 Sylvia Sylvia 26 46 42 38
7 Värmdö Värmdö 26 43 43 32
8 Örebro Syrianska Örebro 26 44 40 29
9 Värmbols Värmbols 26 46 52 28
10 Södertälje Södertälje 26 32 55 27
11 Boo FK Boo FK 26 36 57 26
12 Huddinge Huddinge 26 32 42 25
13 Assyriska IF Assyriska 26 32 53 24
14 Kumla Kumla 26 33 55 20
TEMPORADA 2015/2016
CUARTA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Skovde AIK Skovde AIK 26 75 31 55
2 Uddevalla Uddevalla 26 56 36 47
3 Skoftebyn Skoftebyn 26 46 36 44
4 Stenungsund Stenungsund 26 47 38 43
5 Karlstad BK Karlstad BK 26 49 27 42
6 Grebbestad Grebbestad 26 49 50 42
7 Gauthiod Gauthiod 26 42 48 37
8 Kumla Kumla 26 40 56 36
9 Örebro Syrianska Örebro 26 43 55 35
10 Vänersborgs IF Vänersborgs 26 50 45 34
11 Rynninge Rynninge 26 41 42 33
12 Lidköping Lidköping 26 41 43 30
13 Gunnilse Gunnilse 26 38 61 17
14 Kortedala Kortedala 26 30 79 16
TEMPORADA 2014/2015
CUARTA SUECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Trollhattan FC Trollhattan 26 75 35 59
2 Karlstad BK Karlstad BK 26 72 27 55
3 Grebbestad Grebbestad 26 59 34 51
4 Uddevalla Uddevalla 26 46 29 51
5 Gauthiod Gauthiod 26 57 34 46
6 Skovde AIK Skovde AIK 26 56 31 45
7 Lidköping Lidköping 26 56 49 40
8 Vänersborgs IF Vänersborgs 26 45 46 38
9 Stenungsund Stenungsund 26 36 51 34
10 Rynninge Rynninge 26 43 53 31
11 Karlslund Karlslund 26 40 71 24
12 Nordvärmland Nordvärmlan 26 46 47 22
13 Tibro Tibro 26 32 83 13
14 IFK Skövde IFK Skövde 26 27 100 9
TEMPORADA 2013/2014
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Södertälje Södertälje 26 68 31 59
2 Sleipner Sleipner 26 64 27 57
3 Enskede Enskede 26 66 28 54
4 Boo FK Boo FK 26 51 30 52
5 Eskilstuna City Eskilstuna 26 46 37 46
6 Ekerö Ekerö 26 55 44 41
7 Rynninge Rynninge 26 43 45 38
8 Arameiska / Syrianska Arameiska 26 44 37 36
9 Linköping City Linköping 26 37 46 31
10 Karlslund Karlslund 26 30 46 27
11 Gute Gute 26 35 56 26
12 Smedby Smedby 26 25 44 21
13 Värmbols Värmbols 26 16 62 15
14 Karlskoga Karlskoga 26 26 73 13
TEMPORADA 2012/2013
CUARTA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Uddevalla Uddevalla 22 51 28 42
2 Carlstad United Carlstad 22 48 25 39
3 Gauthiod Gauthiod 22 51 31 39
4 Rynninge Rynninge 22 32 28 36
5 IFK Amal IFK Amal 22 36 29 32
6 Nordvärmland Nordvärmlan 22 37 26 31
7 Jonsered Jonsered 22 36 45 31
8 Karlslund Karlslund 22 33 40 27
9 Tibro Tibro 22 31 41 27
10 Sävedalen Sävedalen 22 33 46 27
11 Ytterby Ytterby 22 30 53 23
12 Götene Götene 22 30 56 15
TEMPORADA 2011/2012
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Nyköpings BIS Nyköpings 22 58 22 52
2 Carlstad United Carlstad 22 46 28 42
3 Rynninge Rynninge 22 43 31 38
4 Enskede Enskede 22 43 33 38
5 Värmbols Värmbols 22 45 39 35
6 Värmdö Värmdö 22 46 36 33
7 Arameiska / Syrianska Arameiska 22 42 34 33
8 Karlslund Karlslund 22 31 34 30
9 Gute Gute 22 29 45 21
10 Konyaspor KIF Konyaspor 22 24 46 21
11 Karlskoga Karlskoga 22 27 51 19
12 Eskilstuna Södra Eskilstuna 22 23 58 9
TEMPORADA 2010/2011
CUARTA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gauthiod Gauthiod 22 30 23 44
2 Assyriska BK Assyriska 22 40 22 39
3 Rynninge Rynninge 22 50 33 38
4 Tibro Tibro 22 42 42 36
5 Carlstad United Carlstad 22 34 35 33
6 Gunnilse Gunnilse 22 36 32 31
7 Ytterby Ytterby 22 40 35 30
8 Götene Götene 22 48 51 30
9 Jonsered Jonsered 22 32 40 28
10 Karlskoga Karlskoga 22 38 38 27
11 Skoftebyn Skoftebyn 22 28 41 23
12 Örebro II Örebro II 22 26 52 13
TEMPORADA 2007/2008
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Karlslund Karlslund 22 45 24 42
2 Eskilstuna City Eskilstuna 22 46 28 42
3 Hammarby Nacka FF Hammarby 22 48 25 38
4 Enskede Enskede 22 41 34 37
5 Akropolis Akropolis 22 53 44 31
6 Värmbols Värmbols 22 38 35 29
7 Karlskoga Karlskoga 22 32 38 29
8 Gute Gute 22 35 38 28
9 Älvsjö AIK Älvsjö 22 33 41 24
10 Panellinios Panellinios 22 30 52 24
11 Rynninge Rynninge 22 27 44 23
12 IFK Eskilstuna Eskilstuna 22 30 55 19
TEMPORADA 2006/2007
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Arameiska / Syrianska Arameiska 22 55 31 46
2 Eskilstuna City Eskilstuna 22 51 32 43
3 Rynninge Rynninge 22 48 28 40
4 Nyköpings BIS Nyköpings 22 49 45 39
5 Akropolis Akropolis 22 57 38 37
6 Värmbols Värmbols 22 36 34 33
7 Enskede Enskede 22 37 37 31
8 IFK Eskilstuna Eskilstuna 22 40 56 27
9 Karlskoga Karlskoga 22 35 35 24
10 Hammarby Nacka FF Hammarby 22 38 44 23
11 Spårvägen Spårvägen 22 25 52 14
12 Tyreso Tyreso 22 18 57 10

  USO DE MEMORIA  
6,185,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1257
Total Execution Time  0.1270
  CADENA URL  
/historico/Rynninge/2020
  GET DATOS  
$_GET['/historico/Rynninge/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0029  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 = 'Rynninge' AND l.year = 2020 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.0018  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=61945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 55394
0.0025  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 = 49745
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61945 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1652 AND type_rel = 3
0.0023  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 = '61945' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '61945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '61945' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 49745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 55394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=61945 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (62416,49745,49506,48618) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 48618 AND teamId = 61945
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 62416 AND teamId = 61945
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 49745 AND teamId = 61945
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 61945
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 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 = 55394 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '61945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61945' 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 = '61945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 55394 WHERE rp.league_id = 55394 AND rp.teamId = 61945 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.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 55394 WHERE rp.league_id = 55394 AND rp.teamId = 61945 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 55394 WHERE rp.league_id = 55394 AND rp.teamId = 61945 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 61945 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 55394 AND t.round = 26 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 `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 = 48618 AND t.round = 30 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 `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 = 42429 AND t.round = 30 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 `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 = 37780 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 `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 = 20360 AND t.round = 26 ORDER BY team.conference 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 `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 = 9556 AND t.round = 26 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 `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 = 25177 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 `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 = 25186 AND t.round = 22 ORDER BY team.conference 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 `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 = 25200 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 `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 = 25209 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 `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 = 27377 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 `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 = 27404 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 55394 ORDER BY nameShow LIMIT 100