4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartak Moskva II
TEMPORADA 2023/2024
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo Moskva II Dinamo 4 12 3 10
2 Baltika II Baltika II 4 11 3 10
3 Chertanovo Chertanovo 4 8 3 8
4 Rodina Moskva III Rodina 4 6 3 8
5 Spartak Moskva II Spartak 4 5 3 8
6 Znamya Znamya 4 5 7 7
7 Torpedo Vladimir Torpedo 4 9 6 6
8 Zenit II Zenit II 4 7 5 6
9 Dynamo St Petersburg Dynamo 4 7 6 6
10 Dinamo Vologda Dinamo 4 3 3 5
11 Tver Tver 4 6 7 4
12 FC Saturn FC Saturn 3 3 8 3
13 Luki-Energiya Luki-Energiy 4 2 8 3
14 Irkutsk Irkutsk 3 2 8 1
15 Zvezda St. Petersburg Zvezda 4 1 7 1
16 Yenisey II Yenisey II 4 1 8 0
TEMPORADA 2021/2022
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Torpedo Moscow Torpedo 38 65 36 75
2 Fakel Fakel 38 60 33 74
3 FC Orenburg FC Orenburg 38 64 37 74
4 SKA-Khabarovsk SKA-Khabarov 38 48 38 65
5 Yenisey Yenisey 38 58 55 63
6 Alaniya Vladikavkaz Alaniya 38 75 53 60
7 Neftekhimik Neftekhimik 38 60 43 58
8 Baltika Kaliningrad Baltika 38 51 30 58
9 Spartak Moskva II Spartak 38 48 55 58
10 Akron Tolyatti Akron 38 47 40 58
11 FC Krasnodar II Krasnodar 38 45 45 53
12 PFC Kuban Krasnodar Kuban 38 45 48 49
13 Veles Veles 38 45 48 48
14 Tom Tomsk Tom Tomsk 38 51 60 48
15 FSC Dolgoprudniy Dolgoprudniy 38 35 47 41
16 Volgar Astrakhan Volgar 38 30 43 39
17 KamAZ KamAZ 38 29 45 37
18 Rotor Volgograd Rotor 38 37 53 36
19 Metallurg Lipetsk Metallurg 38 31 70 33
20 Tekstilshchik Tekstilshchi 38 31 76 23
TEMPORADA 2020/2021
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Krylia Sovetov Krylia 42 100 26 101
2 FC Orenburg FC Orenburg 42 78 33 94
3 FK Nizhny Novgorod Nizhny 42 67 28 88
4 Alaniya Vladikavkaz Alaniya 42 74 40 77
5 Baltika Kaliningrad Baltika 42 49 35 73
6 Torpedo Moscow Torpedo 42 65 41 72
7 Neftekhimik Neftekhimik 42 64 44 70
8 Veles Veles 42 54 46 66
9 Fakel Fakel 42 57 43 64
10 Yenisey Yenisey 42 52 54 63
11 SKA-Khabarovsk SKA-Khabarov 42 52 47 60
12 Chayka Chayka 42 44 53 56
13 Volgar Astrakhan Volgar 42 47 45 54
14 Spartak Moskva II Spartak 42 53 77 49
15 Tekstilshchik Tekstilshchi 42 32 51 47
16 FC Krasnodar II Krasnodar 42 46 68 45
17 Akron Tolyatti Akron 42 35 54 42
18 Tom Tomsk Tom Tomsk 42 32 50 41
19 FC Irtysh Omsk Irtysh Omsk 42 33 61 35
20 Dinamo Bryansk Dinamo 42 24 66 32
21 Chertanovo Chertanovo 42 35 80 27
22 Shinnik Yaroslavl Shinnik 42 39 90 25
TEMPORADA 2019/2020
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Rotor Volgograd Rotor 27 41 21 56
2 FK Khimki FK Khimki 27 50 19 54
3 Chertanovo Chertanovo 27 37 19 54
4 Torpedo Moscow Torpedo 27 39 25 53
5 Neftekhimik Neftekhimik 27 38 25 48
6 SKA-Khabarovsk SKA-Khabarov 27 42 30 43
7 Baltika Kaliningrad Baltika 27 34 23 43
8 Shinnik Yaroslavl Shinnik 27 43 35 43
9 Tom Tomsk Tom Tomsk 27 32 26 39
10 Chayka Chayka 27 31 29 38
11 FK Nizhny Novgorod Nizhny 27 28 29 36
12 FC Armavir FC Armavir 27 23 29 30
13 Avangard Kursk Avangard 27 29 39 29
14 Yenisey Yenisey 27 23 40 28
15 FC Krasnodar II Krasnodar 27 32 34 28
16 Luch Vladivostok Luch 27 28 40 27
17 Spartak Moskva II Spartak 27 38 45 26
18 Tekstilshchik Tekstilshchi 27 25 52 19
19 Fakel Fakel 27 14 44 19
20 Mordovia Saransk Mordovia 27 21 44 19
TEMPORADA 2018/2019
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Tambov Tambov 38 55 35 73
2 Sochi Sochi 38 63 34 69
3 Tom Tomsk Tom Tomsk 38 40 25 64
4 FK Nizhny Novgorod Nizhny 38 41 31 62
5 Chertanovo Chertanovo 38 65 53 61
6 Shinnik Yaroslavl Shinnik 38 42 31 60
7 SKA-Khabarovsk SKA-Khabarov 38 46 41 58
8 Avangard Kursk Avangard 38 48 42 56
9 FK Khimki FK Khimki 38 47 49 53
10 FC Krasnodar II Krasnodar 38 45 52 51
11 Rotor Volgograd Rotor 38 34 36 50
12 Luch Vladivostok Luch 38 29 28 47
13 Mordovia Saransk Mordovia 38 37 46 47
14 Spartak Moskva II Spartak 38 45 47 46
15 FC Armavir FC Armavir 38 32 44 44
16 Baltika Kaliningrad Baltika 38 38 52 42
17 Fakel Fakel 38 36 40 41
18 Sibir Novosibirsk Sibir 38 28 45 37
19 Tyumen Tyumen 38 30 46 31
20 Zenit II Zenit II 38 33 57 28
TEMPORADA 2017/2018
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FC Orenburg FC Orenburg 38 59 26 84
2 Krylia Sovetov Krylia 38 60 23 82
3 Yenisey Yenisey 38 68 32 81
4 Tambov Tambov 38 57 36 68
5 Baltika Kaliningrad Baltika 38 44 35 64
6 Dynamo St Petersburg Dynamo 38 52 47 55
7 Shinnik Yaroslavl Shinnik 38 45 45 53
8 Sibir Novosibirsk Sibir 38 38 31 53
9 FC Kuban FC Kuban 38 47 47 49
10 Volgar Astrakhan Volgar 38 40 46 45
11 Avangard Kursk Avangard 38 43 46 45
12 FK Nizhny Novgorod Nizhny 38 37 50 44
13 FK Khimki FK Khimki 38 33 49 43
14 Spartak Moskva II Spartak 38 47 64 42
15 Tom Tomsk Tom Tomsk 38 36 56 41
16 Luch Vladivostok Luch 38 40 52 40
17 Zenit II Zenit II 38 43 59 40
18 Rotor Volgograd Rotor 38 38 45 40
19 Tyumen Tyumen 38 41 54 39
20 Fakel Fakel 38 27 52 35
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 4
Equipo PJ GF GC Puntos
1 Sokol Saratov Sokol 30 62 24 69
2 Fakel Fakel 30 47 21 60
3 Vityaz Podolsk Vityaz 30 51 32 60
4 Spartak Moskva II Spartak 30 58 40 50
5 Dinamo Briansk Dinamo 30 35 32 48
6 Kaluga Kaluga 30 44 36 45
7 Avangard Kursk Avangard 30 37 39 42
8 Podolye Podolskiy Rayon Podolye 30 41 52 42
9 Metalurg Lypetsk Metalurg 30 35 36 40
10 Zenit Penza Zenit Penza 30 28 29 35
11 FK Ryazan FK Ryazan 30 20 30 33
12 Tambov Tambov 30 38 44 31
13 Lokomotiv Liski Lokomotiv 30 31 42 29
14 FC Oryol FC Oryol 30 30 41 29
15 FC Metallurg Vyksa Metallurg 30 25 40 29
16 Metallurg Oskol Metallurg 30 22 66 19
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,411,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4430
Total Execution Time  0.4442
  CADENA URL  
/historico/Spartak-Moskva-Ii
  GET DATOS  
$_GET['/historico/Spartak-Moskva-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0214  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 = 75689
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19944 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=382 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 382 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1268221,1267675,1162132,1037410,1031092) ORDER BY n.cover_points DESC, update_date DESC
0.0109  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 = '19944' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 75689 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=19944 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75689,67320) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 75689 AND teamId = 19944
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19944
0.0109  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75689 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '19944' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19944' and rp.type = 4
0.0107  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 = '19944' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19944 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.0118  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19944 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19944 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 19944 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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 = 75689 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 63115 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 57359 AND t.round = 42 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 `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 = 49957 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 43602 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 38675 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0115  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.0112  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.0114  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 = 2867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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