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 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,090,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5799
Total Execution Time  0.5812
  CADENA URL  
/historico/Spartak-Moskva-Ii/2020
  GET DATOS  
$_GET['/historico/Spartak-Moskva-Ii/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0154  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 = 'Spartak-Moskva-Ii' 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.0145  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=19944 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=19944 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=19944 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19944 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=317 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 317 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1309284,1162132,1157300,1122023,1110027) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '19944' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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.0148  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 (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (57359,56547) 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 = 57359 AND teamId = 19944
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 19944
0.0151  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.0147  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19944' and rp.type = 4
0.0155  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.0191  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 = 49957 WHERE rp.league_id = 49957 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.0165  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 = 49957 WHERE rp.league_id = 49957 AND rp.teamId = 19944 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 49957 WHERE rp.league_id = 49957 AND rp.teamId = 19944 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0292  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.0154  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.0167  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.0174  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.0163  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.0153  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.0155  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.0174  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