4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del KamAZ
TEMPORADA 2023/2024
PRIMERA RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dynamo Makhachkala Dynamo 28 30 14 51
2 FK Khimki FK Khimki 28 43 31 51
3 Akron Tolyatti Akron 28 41 21 50
4 Arsenal Tula Arsenal Tula 28 32 19 46
5 Rodina Moskva Rodina 28 43 25 44
6 Tyumen Tyumen 28 31 28 41
7 Neftekhimik Neftekhimik 28 29 27 40
8 Alaniya Vladikavkaz Alaniya 28 34 36 40
9 Yenisey Yenisey 28 47 38 39
10 SKA-Khabarovsk SKA-Khabarov 28 30 30 37
11 Shinnik Yaroslavl Shinnik 28 32 38 37
12 KamAZ KamAZ 28 26 28 36
13 Torpedo Moscow Torpedo 28 25 27 36
14 Chernomorets Novorossisk Chernomorets 28 27 31 32
15 Sokol Saratov Sokol 28 23 45 28
16 Leningradets Leningradets 28 19 35 27
17 Volgar Astrakhan Volgar 28 24 38 26
18 PFC Kuban Krasnodar Kuban 28 19 44 22
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
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tyumen Tyumen 28 55 22 63
2 KamAZ KamAZ 27 72 25 61
3 Volga Ulyanovsk Volga 28 45 15 59
4 FC Chelyabinsk Chelyabinsk 27 59 22 56
5 Zvezda Perm Zvezda Perm 26 54 23 55
6 FK Novosibirsk Novosibirsk 27 50 25 55
7 Dinamo Barnaul Dinamo 27 30 38 41
8 NoSta NoSta 26 38 34 36
9 Ural II Ural II 28 39 40 35
10 Volna Nizhegorodskaya Volna 28 32 39 35
11 Lada Sok Lada Sok 28 33 34 27
12 Zenit Izhevsk Zenit 27 31 40 22
13 Lada Tolyatti Lada 28 15 100 13
14 Orenburg II Orenburg II 28 15 70 12
15 Krylia Sovetov II Krylia 27 22 63 9
TEMPORADA 2019/2020
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Akron Tolyatti Akron 17 29 16 38
2 FC Chelyabinsk Chelyabinsk 17 34 17 36
3 Ural II Ural II 17 34 16 35
4 KamAZ KamAZ 17 37 23 32
5 Tyumen Tyumen 17 25 21 26
6 Lada Sok Lada Sok 17 19 18 24
7 Zvezda Perm Zvezda Perm 17 20 20 22
8 NoSta NoSta 17 23 26 22
9 Volga Ulyanovsk Volga 17 19 26 20
10 Zenit Izhevsk Zenit 17 27 27 18
11 Lada Tolyatti Lada 17 12 47 10
12 Ufa II Ufa II 17 17 39 6
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Neftekhimik Neftekhimik 25 53 14 63
2 KamAZ KamAZ 25 44 25 45
3 Syzran-2003 Syzran-2003 25 32 30 41
4 Zvezda Perm Zvezda Perm 25 39 34 37
5 Volga Ulyanovsk Volga 25 26 25 37
6 NoSta NoSta 25 39 43 37
7 Zenit Izhevsk Zenit 24 30 29 32
8 FC Chelyabinsk Chelyabinsk 24 29 24 28
9 Ural II Ural II 24 37 43 24
10 Ufa II Ufa II 24 23 44 18
11 Lada Tolyatti Lada 24 16 57 14
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Mordovia Saransk Mordovia 24 38 8 56
2 FC Chelyabinsk Chelyabinsk 24 41 19 49
3 Syzran-2003 Syzran-2003 24 35 22 46
4 KamAZ KamAZ 24 37 19 45
5 Neftekhimik Neftekhimik 24 42 21 42
6 Zenit Izhevsk Zenit 24 28 17 42
7 Volga Ulyanovsk Volga 24 33 17 41
8 NoSta NoSta 23 37 30 33
9 Lada Tolyatti Lada 24 25 51 25
10 Ural II Ural II 24 19 33 17
11 Anzhi-Junior Zelenodoslk Anzhi-Junior 23 18 38 16
12 Orenburg II Orenburg II 24 15 45 13
13 Krylia Sovetov II Krylia 24 15 63 11
14 Dinamo Kirov Dinamo Kirov 0 0 0 0
TEMPORADA 2016/2017
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Nizhny Novgorod Nizhny 24 47 17 55
2 Zenit Izhevsk Zenit 24 47 18 51
3 FC Chelyabinsk Chelyabinsk 24 37 21 39
4 Syzran-2003 Syzran-2003 24 21 21 35
5 NoSta NoSta 24 31 39 33
6 Volga Ulyanovsk Volga 24 23 25 31
7 KamAZ KamAZ 24 23 25 29
8 Lada Tolyatti Lada 24 15 41 21
9 Dinamo Kirov Dinamo Kirov 24 15 52 9
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 5
Equipo PJ GF GC Puntos
1 KamAZ KamAZ 20 35 5 48
2 Zenit Izhevsk Zenit 20 34 18 37
3 FC Chelyabinsk Chelyabinsk 20 24 17 35
4 Rubin Kazan 2 Rubin Kazan 20 34 20 34
5 Volga Ulyanovsk Volga 20 27 11 33
6 Syzran-2003 Syzran-2003 20 29 18 30
7 NoSta NoSta 20 15 26 22
8 Lada Tolyatti Lada 20 21 31 19
9 Neftekhimik Neftekhimik 20 19 29 19
10 Dinamo Kirov Dinamo Kirov 20 13 31 15
11 Spartak Yoshkar Ola Spartak 20 12 57 8
TEMPORADA 2013/2014
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 Tyumen Tyumen 22 34 13 53
2 Volga Ulyanovsk Volga 23 34 20 53
3 KamAZ KamAZ 23 41 30 42
4 FC Chelyabinsk Chelyabinsk 22 38 19 38
5 Syzran-2003 Syzran-2003 22 29 18 36
6 Zenit Izhevsk Zenit 22 21 13 33
7 Lada Tolyatti Lada 22 26 28 27
8 NoSta NoSta 22 24 30 20
9 Oktan Perm Oktan Perm 22 12 31 17
10 Spartak Yoshkar Ola Spartak 22 17 33 16
11 Rubin Kazan 2 Rubin Kazan 22 14 44 14
12 Dinamo Kirov Dinamo Kirov 22 9 20 13
TEMPORADA 2012/2013
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Orenburg FC Orenburg 28 54 15 69
2 Tyumen Tyumen 28 56 15 66
3 Volga Ulyanovsk Volga 28 37 17 52
4 FC Chelyabinsk Chelyabinsk 28 42 23 50
5 Lada Tolyatti Lada 28 39 28 48
6 Zenit Izhevsk Zenit 28 47 37 47
7 Syzran-2003 Syzran-2003 28 34 21 42
8 Rubin Kazan 2 Rubin Kazan 28 29 35 35
9 Gornyak Gornyak 28 22 40 31
10 Dinamo Kirov Dinamo Kirov 28 16 19 30
11 KamAZ KamAZ 28 23 29 30
12 NoSta NoSta 28 21 38 23
13 Oktan Perm Oktan Perm 28 21 47 22
14 Akademiya Tolyatti Akademiya 28 16 57 20
15 Spartak Yoshkar Ola Spartak 28 26 62 12
TEMPORADA 2011/2012
PRIMERA RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Alaniya Vladikavkaz Alaniya 38 50 24 73
2 Mordovia Saransk Mordovia 38 67 44 73
3 Shinnik Yaroslavl Shinnik 38 61 42 69
4 FK Nizhny Novgorod Nizhny 38 53 40 68
5 Sibir Novosibirsk Sibir 38 61 39 61
6 Torpedo Moscow Torpedo 38 50 30 60
7 Ural Yekaterinburg Ural 38 51 35 60
8 Dinamo Bryansk Dinamo 38 48 40 60
9 KamAZ KamAZ 38 48 36 59
10 Yenisey Yenisey 38 45 43 56
11 FK Khimki FK Khimki 38 47 61 48
12 SKA-Khabarovsk SKA-Khabarov 38 46 57 47
13 Volgar Astrakhan Volgar 38 36 49 47
14 Torpedo Vladimir Torpedo 38 45 61 43
15 Luch Vladivostok Luch 38 30 32 42
16 Chernomorets Novorossisk Chernomorets 38 32 36 41
17 Baltika Kaliningrad Baltika 38 31 45 41
18 FC Orenburg FC Orenburg 38 40 48 38
19 Fakel Fakel 38 26 46 30
20 Zhemchuzhina Sochi Zhemchuzhina 38 22 81 26
TEMPORADA 2009/2010
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FC Kuban FC Kuban 38 51 20 80
2 Volga Novgorod Volga 38 62 25 71
3 FK Nizhny Novgorod Nizhny 38 60 41 70
4 KamAZ KamAZ 38 55 43 66
5 FK Krasnodar Krasnodar 38 60 44 61
6 Mordovia Saransk Mordovia 38 53 40 58
7 Ural Yekaterinburg Ural 38 38 28 58
8 Zhemchuzhina Sochi Zhemchuzhina 38 45 44 57
9 Volgar Astrakhan Volgar 38 45 48 57
10 Shinnik Yaroslavl Shinnik 38 43 31 55
11 SKA-Khabarovsk SKA-Khabarov 38 37 39 53
12 Luch Vladivostok Luch 38 42 42 52
13 FK Khimki FK Khimki 38 39 38 50
14 Dinamo Bryansk Dinamo 38 53 54 44
15 Baltika Kaliningrad Baltika 38 38 47 43
16 Dynamo St Petersburg Dynamo 38 32 53 37
17 Salyut Belgorod Salyut 38 30 47 34
18 Rotor Volgograd Rotor 38 27 64 34
19 FC Irtysh Omsk Irtysh Omsk 38 26 52 28
20 Avangard Kursk Avangard 38 31 67 27
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
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FK Rostov FK Rostov 42 78 29 96
2 FC Kuban FC Kuban 42 84 36 87
3 KamAZ KamAZ 42 68 41 79
4 Ural Yekaterinburg Ural 42 69 39 75
5 NoSta NoSta 42 59 37 73
6 Anzhi Anzhi 42 63 35 72
7 Baltika Kaliningrad Baltika 42 43 34 65
8 Chernomorets Novorossisk Chernomorets 42 51 38 61
9 SKA-Khabarovsk SKA-Khabarov 42 63 60 61
10 Alaniya Vladikavkaz Alaniya 42 50 47 59
11 Sibir Novosibirsk Sibir 42 51 41 58
12 SKA Rostov SKA Rostov 42 52 50 58
13 Salyut Belgorod Salyut 42 51 51 58
14 Vityaz Podolsk Vityaz 42 49 57 58
15 FK Metallurg-Kuzbass Metallurg-Ku 42 44 42 57
16 SAC Moskva SAC Moskva 42 55 57 57
17 Volga Ulyanovsk Volga 42 50 65 49
18 Torpedo Moscow Torpedo 42 47 69 49
19 Mashuk-KMV Mashuk-KMV 42 39 79 32
20 Dinamo Barnaul Dinamo 42 31 80 27
21 Zvezda Irkutsk Zvezda 42 36 95 23
22 Dinamo Bryansk Dinamo 42 30 81 22
TEMPORADA 2006/2007
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Shinnik Yaroslavl Shinnik 42 68 30 92
2 Akhmat Grozny Akhmat 42 69 27 90
3 Sibir Novosibirsk Sibir 42 80 39 86
4 Ural Yekaterinburg Ural 42 70 33 77
5 KamAZ KamAZ 42 67 34 77
6 Torpedo Moscow Torpedo 42 75 59 69
7 NoSta NoSta 42 63 40 64
8 Dinamo Bryansk Dinamo 42 49 52 59
9 Salyut Belgorod Salyut 42 44 45 57
10 Anzhi Anzhi 42 41 44 57
11 Zvezda Irkutsk Zvezda 42 60 47 56
12 SKA-Khabarovsk SKA-Khabarov 42 50 48 56
13 Alaniya Vladikavkaz Alaniya 42 56 56 56
14 Mashuk-KMV Mashuk-KMV 42 53 55 55
15 Baltika Kaliningrad Baltika 42 53 49 54
16 SKA Rostov SKA Rostov 42 50 60 53
17 FK Metallurg-Kuzbass Metallurg-Ku 42 53 70 53
18 Avangard Kursk Avangard 42 50 55 51
19 Mordovia Saransk Mordovia 42 44 88 43
20 Tekstilshchik Tekstilshchi 42 38 68 38
21 Sodovik Sterlitamak Sodovik 42 32 65 34
22 FC Spartak-MZhK Spartak-MZhK 42 21 122 7
TEMPORADA 2005/2006
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FK Khimki FK Khimki 42 83 30 99
2 FC Kuban FC Kuban 42 92 25 97
3 Ural Yekaterinburg Ural 42 67 23 90
4 KamAZ KamAZ 42 54 26 77
5 SKA-Khabarovsk SKA-Khabarov 42 67 40 71
6 Sodovik Sterlitamak Sodovik 42 59 35 69
7 Sibir Novosibirsk Sibir 42 67 45 65
8 Akhmat Grozny Akhmat 42 48 47 62
9 Avangard Kursk Avangard 42 45 38 61
10 Dinamo Bryansk Dinamo 42 42 38 61
11 Volgar Astrakhan Volgar 42 45 47 60
12 Salyut Belgorod Salyut 42 46 58 56
13 Baltika Kaliningrad Baltika 42 41 56 55
14 Mashuk-KMV Mashuk-KMV 42 41 56 55
15 Anzhi Anzhi 42 57 66 53
16 Dynamo Makhachkala Dynamo 42 56 54 51
17 Lada Tolyatti Lada 42 38 63 45
18 Spartak Nizhny Novgorod Spartak 42 46 60 43
19 Fakel Fakel 42 27 54 42
20 FC Oryol FC Oryol 42 35 72 29
21 Yenisey Yenisey 42 30 80 21
22 Angusht Angusht 42 32 105 13

  USO DE MEMORIA  
7,662,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1664
Total Execution Time  0.1679
  CADENA URL  
/historico/Kamaz
  GET DATOS  
$_GET['/historico/Kamaz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0033  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 = 'Kamaz' 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=13447 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=13447 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=13447 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=13447 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 = 73402
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13447 AND type_rel = 2
0.0031  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 = '13447' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '13447' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 73402 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052  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=13447 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026  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 (73402,72237,71432) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72237 AND teamId = 13447
0.0044  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13447
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13447
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 = 72237 AND t.round = 30 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 = '13447' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13447' and rp.type = 4
0.0020  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 = '13447' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 = 72237 WHERE rp.league_id = 72237 AND rp.teamId = 13447 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.0033  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 = 72237 WHERE rp.league_id = 72237 AND rp.teamId = 13447 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 72237 WHERE rp.league_id = 72237 AND rp.teamId = 13447 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 13447 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72237 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.0023  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.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 `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 = 57518 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.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 `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 = 50437 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.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 `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 = 44475 AND t.round = 27 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 `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 = 39157 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 33932 AND t.round = 27 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 `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.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 `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 = 14064 AND t.round = 12 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 `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 = 4370 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 2868 AND t.round = 22 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 `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 = 25092 AND t.round = 32 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 `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 = 10500 AND t.round = 11 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 `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 = 10498 AND t.round = 38 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 = 10501 AND t.round = 40 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 `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.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 `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 = 12949 AND t.round = 42 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 `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 = 12950 AND t.round = 42 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 `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 = 12951 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC