4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zenit II
TEMPORADA 2016/2017
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Dinamo Moskva Dinamo 38 64 25 87
2 Tosno Tosno 38 63 30 75
3 Yenisey Yenisey 38 54 42 63
4 SKA-Khabarovsk SKA-Khabarov 38 45 33 59
5 Tambov Tambov 38 42 34 57
6 Spartak Moskva II Spartak 38 56 43 56
7 FC Kuban FC Kuban 38 44 37 55
8 Shinnik Yaroslavl Shinnik 38 41 39 54
9 Tyumen Tyumen 38 48 43 53
10 Fakel Fakel 38 38 40 53
11 FK Khimki FK Khimki 38 40 47 49
12 Volgar Astrakhan Volgar 38 39 49 45
13 Zenit II Zenit II 38 44 51 43
14 Sibir Novosibirsk Sibir 38 31 46 42
15 Baltika Kaliningrad Baltika 38 25 35 42
16 Luch Vladivostok Luch 38 27 41 42
17 Mordovia Saransk Mordovia 38 39 50 40
18 Sokol Saratov Sokol 38 34 53 39
19 Spartak Nalchik Spartak 38 26 37 38
20 Neftekhimik Neftekhimik 38 28 53 27
TEMPORADA 2015/2016
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FC Orenburg FC Orenburg 38 61 20 86
2 Arsenal Tula Arsenal Tula 38 64 36 82
3 Tom Tomsk Tom Tomsk 38 58 35 74
4 Volgar Astrakhan Volgar 38 57 37 63
5 Spartak Moskva II Spartak 38 52 49 59
6 Fakel Fakel 38 51 42 56
7 Tosno Tosno 38 57 53 55
8 Tyumen Tyumen 38 44 45 54
9 Sokol Saratov Sokol 38 43 38 53
10 Volga Novgorod Volga 38 39 37 51
11 Sibir Novosibirsk Sibir 38 47 50 51
12 Shinnik Yaroslavl Shinnik 38 50 49 50
13 Zenit II Zenit II 38 61 56 50
14 SKA-Khabarovsk SKA-Khabarov 38 36 35 49
15 Luch Vladivostok Luch 38 31 46 45
16 Yenisey Yenisey 38 36 49 44
17 Baltika Kaliningrad Baltika 38 37 47 44
18 FC Armavir FC Armavir 38 28 44 40
19 Radian-Baykal Radian-Bayka 38 29 73 26
20 KamAZ KamAZ 38 20 60 24
TEMPORADA 2014/2015
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Moskva II Spartak 30 65 26 65
2 Zenit II Zenit II 30 78 41 57
3 FK Khimki FK Khimki 30 42 26 54
4 Strogino Strogino 30 39 29 54
5 Tekstilshchik Tekstilshchi 30 51 29 53
6 FSC Dolgoprudniy Dolgoprudniy 30 45 39 51
7 FC Saturn FC Saturn 30 42 31 50
8 Torpedo Vladimir Torpedo 30 41 36 48
9 Pskov 747 Pskov 747 30 39 38 42
10 Domodedovo Domodedovo 30 48 50 38
11 Volga Tver Volga Tver 30 36 54 32
12 Spartak Kostroma Spartak 30 26 39 28
13 Dnepr Smolensk Dnepr 30 32 49 28
14 Solaris Solaris 30 39 59 28
15 Kolomna Kolomna 30 28 67 23
16 Znamya Znamya 30 21 59 18
TEMPORADA 2013/2014
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tosno Tosno 32 51 16 71
2 Tekstilshchik Tekstilshchi 32 58 32 67
3 FK Khimki FK Khimki 32 67 37 58
4 Pskov 747 Pskov 747 32 44 31 56
5 Dnepr Smolensk Dnepr 32 48 43 52
6 Torpedo Vladimir Torpedo 32 48 38 49
7 Sever Murmansk Sever 32 39 34 48
8 Lokomotiv Moskva II Lokomotiv 32 49 40 45
9 FSC Dolgoprudniy Dolgoprudniy 32 40 32 45
10 Zenit II Zenit II 32 43 43 43
11 Strogino Strogino 32 37 39 39
12 Spartak Kostroma Spartak 32 31 33 36
13 Kolomna Kolomna 32 32 56 35
14 Znamya Znamya 32 19 52 30
15 FC Vologda FC Vologda 32 34 49 29
16 Volga Tver Volga Tver 32 28 52 26
17 FC Rus Saint Petersburg Saint 32 16 57 20
TEMPORADA 2003/2004
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Torpedo Vladimir Torpedo 32 59 22 64
2 Dynamo St Petersburg Dynamo 32 52 26 63
3 Volga Tver Volga Tver 32 42 28 59
4 Tekstilshchik Tekstilshchi 32 34 23 57
5 FK Reutov FK Reutov 32 52 32 54
6 Volochanin-Ratmir Volochanin-R 32 41 22 53
7 Sheksna Sheksna 32 52 40 51
8 Dinamo Vologda Dinamo 32 61 45 50
9 FK Spartak Shcholkovo Spartak 32 33 28 49
10 FK Vidnoye FK Vidnoye 32 50 61 45
11 BSK BSK 32 27 35 38
12 SAC Moskva SAC Moskva 32 39 62 37
13 Spartak Kostroma Spartak 32 35 41 34
14 Pskov 2000 Pskov 2000 32 33 41 32
15 Baltika-Tarko Baltika-Tark 32 40 60 28
16 Zenit II Zenit II 32 29 46 26
17 Almaz Almaz 32 26 93 12
TEMPORADA 2002/2003
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Arsenal Tula Arsenal Tula 36 83 18 83
2 Dinamo Vologda Dinamo 36 53 33 63
3 Petrotrest Petrotrest 36 40 31 61
4 Volochanin-Ratmir Volochanin-R 36 42 36 55
5 FK Reutov FK Reutov 36 50 46 54
6 FK Vidnoye FK Vidnoye 36 36 46 51
7 Svetogorets Svetogorets 37 42 46 49
8 Zenit II Zenit II 37 35 40 49
9 Pskov 2000 Pskov 2000 36 51 36 48
10 Spartak Kostroma Spartak 37 31 30 46
11 Mosenergo Mosenergo 37 36 39 46
12 Torpedo Vladimir Torpedo 36 37 48 44
13 Spartak-Telekom Spartak-Tele 37 27 38 44
14 BSK BSK 36 31 48 43
15 Tekstilshchik Tekstilshchi 37 30 36 42
16 FK Spartak Shcholkovo Spartak 36 34 44 41
17 Sheksna Sheksna 36 35 48 41
18 SAC Moskva SAC Moskva 36 31 44 40
19 FK Pikalevo FK Pikalevo 37 38 56 39
20 Uralan-Plus Uralan-Plus 7 8 7 9
TEMPORADA 2001/2002
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Baltika Kaliningrad Baltika 38 109 20 108
2 Arsenal Tula Arsenal Tula 38 66 29 77
3 Uralan-Plus Uralan-Plus 38 67 39 74
4 Svetogorets Svetogorets 38 71 54 67
5 Sheksna Sheksna 38 57 46 65
6 Pskov 2000 Pskov 2000 38 61 52 65
7 BSK BSK 38 55 36 64
8 Krasnoznamensk Krasnoznamen 38 59 50 59
9 Spartak-Telekom Spartak-Tele 38 48 42 57
10 FK Spartak Shcholkovo Spartak 38 58 53 55
11 Mosenergo Mosenergo 38 42 37 55
12 Volochanin-Ratmir Volochanin-R 38 52 48 55
13 SAC Moskva SAC Moskva 38 55 55 47
14 Dinamo Vologda Dinamo 38 40 47 41
15 Zenit II Zenit II 38 34 49 37
16 Torpedo Vladimir Torpedo 38 40 68 33
17 Spartak Kostroma Spartak 38 24 68 29
18 Znamya Noginsk Znamya 38 34 63 24
19 Neftyanik Yaroslavl Neftyanik 38 26 101 24
20 Rybinsk Rybinsk 38 32 73 22
TEMPORADA 2000/2001
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dynamo St Petersburg Dynamo 38 84 21 93
2 Pskov 2000 Pskov 2000 38 61 31 80
3 Volochanin-Ratmir Volochanin-R 38 45 21 72
4 Mosenergo Mosenergo 38 67 39 69
5 Dinamo Vologda Dinamo 38 58 31 69
6 Sheksna Sheksna 38 66 48 67
7 Svetogorets Svetogorets 38 66 46 66
8 Zenit II Zenit II 38 56 39 62
9 FK Spartak Shcholkovo Spartak 38 52 35 61
10 Neftyanik Ufa Neftyanik 38 46 38 56
11 Uralan-Plus Uralan-Plus 38 47 47 53
12 Spartak-Telekom Spartak-Tele 38 45 53 48
13 Torpedo Vladimir Torpedo 38 40 52 46
14 Spartak Kostroma Spartak 38 39 54 43
15 SAC Moskva SAC Moskva 38 40 61 37
16 Znamya Noginsk Znamya 38 30 62 31
17 Rybinsk Rybinsk 38 37 63 29
18 Oazis Yartsevo Oazis 38 31 68 24
19 Luki SKIF Luki SKIF 38 28 75 23
20 Nika Moskva Nika Moskva 38 36 90 20
TEMPORADA 1999/2000
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sheksna Sheksna 36 58 33 69
2 Dinamo Vologda Dinamo 36 53 30 67
3 Pskov 2000 Pskov 2000 36 65 29 64
4 FK Spartak Shcholkovo Spartak 36 48 31 64
5 Mosenergo Mosenergo 36 51 33 62
6 Torpedo Moskva II Torpedo 36 42 33 57
7 Volochanin-Ratmir Volochanin-R 36 36 28 57
8 Neftyanik Ufa Neftyanik 36 39 35 52
9 Zenit II Zenit II 36 50 41 50
10 Znamya Noginsk Znamya 36 35 34 48
11 SAC Moskva SAC Moskva 36 38 53 48
12 Lokomotiv Moskva II Lokomotiv 36 40 45 45
13 CSKA Moscow 2 CSKA Moscow 36 43 46 43
14 Oazis Yartsevo Oazis 36 35 40 41
15 Spartak Moskva II Spartak 36 35 55 37
16 Spartak Kostroma Spartak 36 33 60 37
17 Dinamo Moskva II Dinamo 36 46 65 35
18 Saturn-2 Moskovskaya Oblast Saturn-2 36 35 59 32
19 Luki SKIF Luki SKIF 36 23 55 32

  USO DE MEMORIA  
6,415,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1461
Total Execution Time  0.1473
  CADENA URL  
/historico/Zenit-Petersburg-2/2017
  GET DATOS  
$_GET['/historico/Zenit-Petersburg-2/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0034  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 = 'Zenit-Petersburg-2' AND l.year = 2017 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.0019  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=13410 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=13410 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=13410 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=13410 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 63844
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13410 AND type_rel = 2
0.0034  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13410 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 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 (317129) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '13410' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '13410' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 33004 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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=13410 AND l.year in (2016,2017,2018) 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 (63844,38675,30386) 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 38675 AND teamId = 13410
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 63844 AND teamId = 13410
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 13410
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33004 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '13410' 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 = '13410' and rp.type = 4
0.0022  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 = '13410' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0087  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 events2017 e ON e.player_id = p.id AND e.league_id = 33004 WHERE rp.league_id = 33004 AND rp.teamId = 13410 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.0066  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 events2017 e ON e.player_id = p.id AND e.league_id = 33004 WHERE rp.league_id = 33004 AND rp.teamId = 13410 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 events2017 e ON e.player_id = p.id AND e.league_id = 33004 WHERE rp.league_id = 33004 AND rp.teamId = 13410 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 13410 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 33004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 15403 AND t.round = 38 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 = 4366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 2866 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 26507 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 26530 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 26802 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables2001` 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 = 26810 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 26820 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC