4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA A RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 FK Novosibirsk Novosibirsk 10 13 6 19
2 Ufa Ufa 10 11 7 17
3 Chayka Chayka 10 10 6 15
4 Rotor Volgograd Rotor 10 14 12 14
5 Rodina Moskva II Rodina 10 17 12 13
6 FC Krasnodar II Krasnodar 10 11 12 13
7 Murom Murom 10 11 15 12
8 FC Chelyabinsk Chelyabinsk 9 9 12 10
9 Veles Veles 10 6 12 10
10 Metallurg Lipetsk Metallurg 11 7 15 10
TEMPORADA 2022/2023
SEGUNDA B RUSIA GRUPO 7
Equipo PJ GF GC Puntos
1 Sokol Saratov Sokol 12 15 13 46
2 Dinamo Bryansk Dinamo 12 19 6 38
3 Rodina Moskva II Rodina 12 19 10 36
4 Salyut Belgorod Salyut 12 20 8 35
5 Avangard Kursk Avangard 12 17 14 34
6 Metallurg Lipetsk Metallurg 12 17 19 34
7 Kaluga Kaluga 12 16 17 33
8 Dinamo Vladivostok Dinamo 12 14 18 26
9 FK Ryazan FK Ryazan 12 11 19 25
10 Kosmos Dolgoprudny Kosmos 12 10 14 22
11 FC Saturn FC Saturn 12 16 26 20
12 Sakhalinets Sakhalinets 12 13 23 19
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
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Metallurg Lipetsk Metallurg 29 59 25 63
2 FK Ryazan FK Ryazan 30 57 33 59
3 Salyut Belgorod Salyut 30 56 25 56
4 FC Saturn FC Saturn 29 60 29 55
5 Sokol Saratov Sokol 30 44 21 55
6 Strogino Strogino 30 51 42 48
7 Kaluga Kaluga 30 50 37 47
8 Khimik Novomoskovsk Khimik 30 45 41 43
9 Znamya Noginsk Znamya 29 41 38 40
10 Krasnyy Smolensk Krasnyy 30 40 49 40
11 Avangard Kursk Avangard 30 35 41 36
12 Khimki II Khimki II 30 42 65 32
13 Kvant Kvant 30 31 54 28
14 Metallurg Vidnoye Metallurg 30 32 76 25
15 Fakel II Fakel II 30 22 64 20
16 Sakhalin Yuzhno-Sakhalinsk Sakhalin 29 26 51 19
TEMPORADA 2019/2020
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Bryansk Dinamo 17 28 11 39
2 Sokol Saratov Sokol 17 37 10 37
3 Metallurg Lipetsk Metallurg 17 30 9 37
4 Khimik Novomoskovsk Khimik 17 27 20 26
5 Salyut Belgorod Salyut 17 23 23 26
6 FK Ryazan FK Ryazan 17 29 26 24
7 Zorkiy Krasnogorsk Zorkiy 16 31 32 23
8 FC Ararat Moscow Ararat 17 34 36 23
9 Kaluga Kaluga 17 24 23 22
10 FC Saturn FC Saturn 17 32 32 22
11 Khimki II Khimki II 17 23 32 18
12 Strogino Strogino 17 15 28 17
13 Rotor Volgograd II Rotor 16 14 33 8
14 Kvant Kvant 17 8 40 8
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Torpedo Moscow Torpedo 26 48 17 65
2 Sokol Saratov Sokol 26 49 18 58
3 Metallurg Lipetsk Metallurg 26 47 25 51
4 Dinamo Bryansk Dinamo 26 40 21 48
5 Zorkiy Krasnogorsk Zorkiy 26 40 34 36
6 Kaluga Kaluga 26 30 29 36
7 Khimik Novomoskovsk Khimik 26 24 33 32
8 Kvant Kvant 26 35 36 31
9 Salyut Belgorod Salyut 26 26 30 31
10 FK Ryazan FK Ryazan 26 26 31 31
11 Rotor Volgograd II Rotor 26 30 47 30
12 FC Saturn FC Saturn 26 23 40 23
13 Strogino Strogino 26 21 45 17
14 Khimki II Khimki II 26 22 55 14
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Ararat Moscow Ararat 26 52 17 63
2 Energomash Energomash 26 43 21 53
3 FC Spartak Ryazan Spartak 26 37 23 46
4 Metallurg Lipetsk Metallurg 26 35 32 43
5 Torpedo Moscow Torpedo 26 44 22 42
6 Zorkiy Krasnogorsk Zorkiy 25 39 26 40
7 Sokol Saratov Sokol 26 36 38 39
8 FC Saturn FC Saturn 26 37 34 37
9 Strogino Strogino 26 38 37 36
10 Dinamo Bryansk Dinamo 26 33 29 34
11 Khimik Novomoskovsk Khimik 26 31 35 31
12 Kaluga Kaluga 26 20 37 21
13 Rotor Volgograd II Rotor 26 19 51 11
14 Zenit Penza Zenit Penza 25 12 74 11
TEMPORADA 2016/2017
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Avangard Kursk Avangard 24 28 16 45
2 Torpedo Moscow Torpedo 24 36 19 42
3 FC Saturn FC Saturn 24 32 20 42
4 Energomash Energomash 24 47 24 41
5 Vityaz Podolsk Vityaz 24 43 35 40
6 Chertanovo Chertanovo 24 36 33 34
7 FK Ryazan FK Ryazan 24 29 25 31
8 Metallurg Lipetsk Metallurg 24 27 29 31
9 Dinamo Bryansk Dinamo 24 22 19 30
10 Kaluga Kaluga 24 25 28 30
11 Zenit Penza Zenit Penza 24 31 43 27
12 Arsenal Tula II Arsenal Tula 24 24 52 17
13 FK Orel FK Orel 24 13 50 15
TEMPORADA 2015/2016
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Tambov Tambov 26 41 19 54
2 Energomash Energomash 26 28 16 46
3 Metallurg Lipetsk Metallurg 26 26 21 40
4 FK Ryazan FK Ryazan 26 19 15 40
5 Avangard Kursk Avangard 26 33 22 39
6 Lokomotiv Liski Lokomotiv 26 27 19 39
7 Zenit Penza Zenit Penza 26 25 21 38
8 Kaluga Kaluga 26 24 27 33
9 Vityaz Podolsk Vityaz 26 31 32 31
10 Dinamo Bryansk Dinamo 26 22 25 31
11 Torpedo Moscow Torpedo 26 21 28 30
12 Chertanovo Chertanovo 26 30 42 28
13 FK Orel FK Orel 26 9 25 22
14 Arsenal Tula II Arsenal Tula 26 22 46 16
TEMPORADA 2014/2015
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Fakel Fakel 30 64 14 80
2 FK Ryazan FK Ryazan 30 51 13 69
3 Tambov Tambov 30 71 26 65
4 Lokomotiv Liski Lokomotiv 30 34 22 53
5 Metallurg Lipetsk Metallurg 30 42 29 49
6 Kaluga Kaluga 30 42 31 49
7 Zenit Penza Zenit Penza 30 32 22 49
8 Vityaz Podolsk Vityaz 30 43 47 44
9 Avangard Kursk Avangard 30 45 35 43
10 Dinamo Bryansk Dinamo 30 30 26 38
11 Vybor-Kurbatovo Vybor-Kurbat 29 22 43 29
12 Podolye Podolskiy Rayon Podolye 30 30 58 28
13 FK Orel FK Orel 30 25 59 20
14 FC Metallurg Vyksa Metallurg 29 16 54 19
15 Chertanovo Chertanovo 30 30 63 18
16 Arsenal Tula II Arsenal Tula 30 19 54 11
TEMPORADA 2012/2013
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Arsenal Tula II Arsenal Tula 30 74 20 73
2 Fakel Fakel 30 55 33 64
3 Sokol Saratov Sokol 30 44 17 54
4 Metallurg Lipetsk Metallurg 30 46 40 49
5 Kaluga Kaluga 30 52 33 47
6 Zenit Penza Zenit Penza 30 35 26 46
7 Podolye Podolskiy Rayon Podolye 30 50 40 44
8 Vityaz Podolsk Vityaz 30 41 42 43
9 Avangard Kursk Avangard 30 42 40 41
10 Lokomotiv Liski Lokomotiv 30 35 46 41
11 FK Ryazan FK Ryazan 30 47 36 39
12 Gubkin Gubkin 30 34 40 37
13 FC Metallurg Vyksa Metallurg 30 26 48 31
14 Metallurg Oskol Metallurg 30 28 61 26
15 Spartak Tambov Spartak 30 28 77 21
16 FK Orel FK Orel 30 18 56 11
TEMPORADA 2011/2012
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Salyut Belgorod Salyut 39 78 31 83
2 Avangard Kursk Avangard 39 62 36 70
3 Vityaz Podolsk Vityaz 39 58 59 62
4 Metallurg Oskol Metallurg 39 51 50 59
5 Lokomotiv Liski Lokomotiv 39 47 41 58
6 Gubkin Gubkin 39 43 38 58
7 Metallurg Lipetsk Metallurg 39 55 53 56
8 FK Orel FK Orel 39 52 60 53
9 Sokol Saratov Sokol 39 56 55 52
10 Kaluga Kaluga 39 37 41 52
11 Spartak Tambov Spartak 39 46 58 43
12 FK Ryazan FK Ryazan 39 44 60 42
13 Podolye Podolskiy Rayon Podolye 39 33 56 35
14 Zenit Penza Zenit Penza 39 22 46 32
TEMPORADA 2009/2010
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Torpedo Moscow Torpedo 30 59 26 57
2 Gubkin Gubkin 30 53 32 56
3 Metallurg Oskol Metallurg 30 47 32 55
4 Fakel Fakel 30 53 28 54
5 Avangard Podolsk Avangard 30 51 33 53
6 Vityaz Podolsk Vityaz 30 53 34 52
7 Zenit Penza Zenit Penza 30 48 36 50
8 Metallurg Lipetsk Metallurg 30 41 36 50
9 Lokomotiv Liski Lokomotiv 30 40 31 48
10 Kaluga Kaluga 30 27 31 43
11 FK Ryazan FK Ryazan 30 37 49 42
12 Saturn-2 Saturn-2 30 40 45 37
13 FK Orel FK Orel 30 44 43 31
14 Spartak Tambov Spartak 30 28 42 26
15 Znamya Znamya 30 26 71 11
16 Nika Moskva Nika Moskva 30 11 89 3
TEMPORADA 2008/2009
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Anzhi Anzhi 38 61 31 75
2 Sibir Novosibirsk Sibir 38 60 21 73
3 Alaniya Vladikavkaz Alaniya 38 57 30 70
4 Volga Novgorod Volga 38 54 32 65
5 KamAZ KamAZ 38 50 31 64
6 Salyut Belgorod Salyut 38 54 41 61
7 Shinnik Yaroslavl Shinnik 38 46 35 61
8 Ural Yekaterinburg Ural 38 40 32 60
9 FK Krasnodar Krasnodar 38 50 47 52
10 Baltika Kaliningrad Baltika 38 41 42 52
11 Vityaz Podolsk Vityaz 38 46 39 51
12 Volgar Astrakhan Volgar 38 40 41 51
13 Luch Vladivostok Luch 38 42 43 50
14 FK Nizhny Novgorod Nizhny 38 37 47 50
15 SKA-Khabarovsk SKA-Khabarov 38 43 42 47
16 NoSta NoSta 38 47 59 40
17 FK Chita FK Chita 38 27 65 35
18 Chernomorets Novorossisk Chernomorets 38 31 51 34
19 Metallurg Lipetsk Metallurg 38 30 62 31
20 MVD Rossii MVD Rossii 38 10 75 17
TEMPORADA 2007/2008
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Metallurg Lipetsk Metallurg 34 58 16 76
2 Avangard Kursk Avangard 34 48 18 75
3 Gubkin Gubkin 34 62 28 67
4 Lukhovitsy Lukhovitsy 34 52 29 67
5 FK Serpukhov Serpukhov 34 64 32 65
6 Dinamo Voronezh Dinamo 34 53 29 62
7 Mordovia Saransk Mordovia 33 45 38 53
8 FK Ryazan FK Ryazan 34 40 34 47
9 Yelets Yelets 34 44 51 46
10 Zenit Penza Zenit Penza 34 33 44 43
11 Lokomotiv Liski Lokomotiv 34 44 45 42
12 FK Orel FK Orel 34 32 41 38
13 Spartak Tambov Spartak 34 34 46 38
14 Metallurg Oskol Metallurg 33 31 49 32
15 Saturn-2 Saturn-2 34 31 51 31
16 Znamya Znamya 34 30 54 29
17 Nika Moskva Nika Moskva 34 23 77 23
18 FCS 73 Voronezh Voronezh 34 25 67 18
TEMPORADA 2006/2007
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Vityaz Podolsk Vityaz 29 57 14 74
2 Metallurg Lipetsk Metallurg 30 74 29 67
3 FK Ryazan FK Ryazan 30 51 19 61
4 Lukhovitsy Lukhovitsy 30 50 28 61
5 Yelets Yelets 30 39 31 49
6 Gubkin Gubkin 30 35 33 49
7 Lobnya Alla Lobnya Alla 29 40 36 39
8 Zenit Penza Zenit Penza 30 31 32 37
9 Dinamo Voronezh Dinamo 30 35 43 37
10 Spartak Tambov Spartak 30 33 37 36
11 Saturn Yegoryevsk Saturn 30 31 40 35
12 Znamya Znamya 30 30 36 34
13 Nika Moskva Nika Moskva 30 28 53 28
14 FK Serpukhov Serpukhov 30 26 58 27
15 Lokomotiv Liski Lokomotiv 30 30 56 26
16 Don Novomoskovsk Novomoskovsk 30 16 61 17
TEMPORADA 2005/2006
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Spartak-MZhK Spartak-MZhK 33 69 33 78
2 Mordovia Saransk Mordovia 35 66 30 75
3 Lobnya Alla Lobnya Alla 34 54 34 62
4 FK Ryazan FK Ryazan 34 48 30 61
5 Vityaz Podolsk Vityaz 34 53 40 60
6 Metallurg Lipetsk Metallurg 33 43 26 50
7 Lukhovitsy Lukhovitsy 33 39 33 49
8 Gubkin Gubkin 35 41 50 47
9 Don Novomoskovsk Novomoskovsk 34 41 46 46
10 Lokomotiv Liski Lokomotiv 34 45 54 43
11 Yelets Yelets 34 38 51 41
12 Lokomotiv Kaluga Lokomotiv 34 34 47 35
13 Spartak Tambov Spartak 34 27 46 35
14 FK Serpukhov Serpukhov 34 30 45 34
15 Dinamo Voronezh Dinamo 33 37 47 32
16 Nika Moskva Nika Moskva 34 37 54 32
17 Saturn Yegoryevsk Saturn 34 27 43 30
18 Zenit Penza Zenit Penza 34 38 58 29
TEMPORADA 2004/2005
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Luch Vladivostok Luch 42 81 32 92
2 Spartak Nalchik Spartak 42 67 36 86
3 KamAZ KamAZ 42 80 32 84
4 FK Khimki FK Khimki 42 75 36 82
5 FC Kuban FC Kuban 42 55 25 81
6 Dynamo Makhachkala Dynamo 42 64 41 76
7 Ural Yekaterinburg Ural 42 51 34 73
8 FC Oryol FC Oryol 42 55 48 63
9 Spartak Nizhny Novgorod Spartak 42 60 53 61
10 Sibir Novosibirsk Sibir 42 51 53 56
11 Anzhi Anzhi 42 47 48 55
12 SKA-Khabarovsk SKA-Khabarov 42 40 43 54
13 Dinamo Bryansk Dinamo 42 44 49 52
14 Volgar Astrakhan Volgar 42 50 56 51
15 FK Chita FK Chita 42 57 67 50
16 Avangard Kursk Avangard 42 36 45 48
17 Fakel Fakel 42 39 60 46
18 FK Metallurg-Kuzbass Metallurg-Ku 42 48 61 45
19 Amur-2010 Amur-2010 42 44 70 37
20 Metallurg Lipetsk Metallurg 42 40 78 26
21 Dynamo St Petersburg Dynamo 42 37 107 26
22 Sokol Saratov Sokol 42 37 84 25

  USO DE MEMORIA  
7,389,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1764
Total Execution Time  0.1775
  CADENA URL  
/historico/Metallurg-Lipetsk
  GET DATOS  
$_GET['/historico/Metallurg-Lipetsk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
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 = 'Metallurg-Lipetsk' 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=19992 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=19992 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=19992 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=19992 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=19992 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 72431
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19992 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2827 AND type_rel = 3
0.0027  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 = '19992' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '19992' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0024  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=19992 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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,71395) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74617 AND teamId = 19992
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71395 AND teamId = 19992
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 19992
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19992
0.0030  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 = '19992' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19992' and rp.type = 4
0.0029  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 = '19992' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0070  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 = 19992 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 events2024 e ON e.player_id = p.id AND e.league_id = 74617 WHERE rp.league_id = 74617 AND rp.teamId = 19992 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 19992 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 = 19992 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0034  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 = 72431 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.0032  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.0036  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 = 71395 AND t.round = 12 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 `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.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 `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 = 57803 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 50461 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.0039  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 = 44473 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 38854 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 33931 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 15686 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 4369 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 25086 AND t.round = 30 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 = 25102 AND t.round = 39 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 `tables2010` 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 = 25125 AND t.round = 30 ORDER BY team.conference 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 `tables2009` 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 = 10502 AND t.round = 40 ORDER BY team.conference 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 `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 = 25155 AND t.round = 34 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 `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 = 25159 AND t.round = 30 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 `tables2006` 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 = 25199 AND t.round = 34 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 `tables2005` 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 = 12952 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC