4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Veles
TEMPORADA 2023/2024
SEGUNDA A RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 FK Novosibirsk Novosibirsk 10 12 4 20
2 Chayka Chayka 9 10 5 15
3 Ufa Ufa 10 9 6 15
4 FC Krasnodar II Krasnodar 9 11 12 12
5 Murom Murom 9 10 13 12
6 Rotor Volgograd Rotor 9 12 11 11
7 Rodina Moskva II Rodina 9 12 11 10
8 Metallurg Lipetsk Metallurg 10 6 10 10
9 FC Chelyabinsk Chelyabinsk 8 9 12 9
10 Veles Veles 9 5 12 7
TEMPORADA 2022/2023
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Rubin Kazán Rubin Kazán 34 53 27 69
2 Baltika Kaliningrad Baltika 34 56 30 67
3 Alaniya Vladikavkaz Alaniya 34 56 35 62
4 Yenisey Yenisey 34 43 35 54
5 Rodina Moskva Rodina 34 42 38 50
6 Neftekhimik Neftekhimik 34 34 33 47
7 Shinnik Yaroslavl Shinnik 34 36 41 46
8 Akron Tolyatti Akron 34 38 36 46
9 Dynamo Makhachkala Dynamo 34 25 29 46
10 SKA-Khabarovsk SKA-Khabarov 34 50 39 44
11 KamAZ KamAZ 34 35 36 44
12 Volgar Astrakhan Volgar 34 37 41 44
13 Arsenal Tula Arsenal Tula 34 37 46 41
14 PFC Kuban Krasnodar Kuban 34 36 41 37
15 Veles Veles 34 35 55 33
16 Ufa Ufa 34 35 46 32
17 FC Krasnodar II Krasnodar 34 32 54 31
18 Volga Ulyanovsk Volga 34 23 41 30
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
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Veles Veles 16 34 13 36
2 FSC Dolgoprudniy Dolgoprudniy 17 29 16 35
3 Zenit II Zenit II 17 30 14 32
4 Torpedo Vladimir Torpedo 17 23 17 30
5 Leningradets Leningradets 17 27 20 28
6 Olimp Khimki Olimp Khimki 16 18 15 26
7 Murom Murom 16 31 23 24
8 Rodina Moskva Rodina 17 27 31 22
9 Pskov 747 Pskov 747 16 15 26 21
10 Kazanka Kazanka 16 26 27 17
11 Kolomna Kolomna 17 15 24 15
12 Znamya Znamya 17 14 23 15
13 Luki-Energiya Luki-Energiy 16 15 29 13
14 Zvezda St. Petersburg Zvezda 17 9 35 6
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kazanka Kazanka 24 53 27 52
2 Tekstilshchik Tekstilshchi 23 39 20 52
3 Veles Veles 24 44 18 49
4 FSC Dolgoprudniy Dolgoprudniy 24 43 21 40
5 Leningradets Leningradets 24 32 28 37
6 Murom Murom 24 39 37 36
7 Znamya Znamya 24 29 27 34
8 Torpedo Vladimir Torpedo 23 28 27 30
9 Luki-Energiya Luki-Energiy 24 22 24 29
10 Pskov 747 Pskov 747 24 34 42 29
11 Kolomna Kolomna 24 26 56 21
12 Dnepr Smolensk Dnepr 22 16 53 14
13 Chertanovo II Chertanovo 24 26 51 13
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Chertanovo Chertanovo 26 52 15 61
2 Tekstilshchik Tekstilshchi 26 49 20 54
3 Kazanka Kazanka 26 50 23 52
4 Veles Veles 26 46 32 46
5 Spartak Kostroma Spartak 26 34 26 43
6 FSC Dolgoprudniy Dolgoprudniy 26 49 27 43
7 Pskov 747 Pskov 747 26 30 36 37
8 Torpedo Vladimir Torpedo 26 38 34 36
9 Murom Murom 26 24 28 32
10 Dynamo St Petersburg II Dynamo 26 29 35 32
11 Luki-Energiya Luki-Energiy 26 19 23 28
12 Dnepr Smolensk Dnepr 26 26 40 25
13 Kolomna Kolomna 26 18 59 16
14 Znamya Znamya 26 12 78 4

  USO DE MEMORIA  
5,914,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1736
Total Execution Time  0.1751
  CADENA URL  
/historico/Veles-Moskva
  GET DATOS  
$_GET['/historico/Veles-Moskva']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0031  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 = 'Veles-Moskva' AND l.year = 2024 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=101966 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=101966 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=101966 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=101966 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=101966 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 74617
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 = 72430
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101966 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2827 AND type_rel = 3
0.0025  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 = '101966' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '101966' AND l.year = 2024 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 = '101966' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74617 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=101966 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74617,73402,71432,68025) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68025 AND teamId = 101966
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 74617 AND teamId = 101966
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 101966
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 101966
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 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 = 74617 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0068  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 = '101966' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0113  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '101966' and rp.type = 4
0.0028  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 = '101966' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 = 74617 WHERE rp.league_id = 74617 AND rp.teamId = 101966 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.0047  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 = 74617 WHERE rp.league_id = 74617 AND rp.teamId = 101966 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 74617 WHERE rp.league_id = 74617 AND rp.teamId = 101966 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 101966 AND l.year <= 2024 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 `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 = 72430 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 74617 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68025 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.0043  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.0071  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 = 50435 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 44474 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 `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 = 39158 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC