4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2013/2014
PREMIER LEAGUE RUSIA
Equipo PJ GF GC Puntos
1 CSKA Moskva CSKA Moskva 30 49 26 64
2 Zenit Zenit 30 63 32 63
3 Lokomotiv Moskva Lokomotiv 30 51 23 59
4 Dinamo Moskva Dinamo 30 54 37 52
5 FK Krasnodar Krasnodar 30 46 39 50
6 Spartak Moskva Spartak 30 46 36 50
7 FK Rostov FK Rostov 30 40 40 39
8 FC Kuban FC Kuban 30 40 42 38
9 Rubin Kazán Rubin Kazán 30 36 30 38
10 Amkar Perm Amkar Perm 30 36 37 38
11 Ural Yekaterinburg Ural 30 28 46 34
12 Akhmat Grozny Akhmat 30 27 33 33
13 Tom Tomsk Tom Tomsk 30 23 39 31
14 Krylia Sovetov Krylia 30 27 46 29
15 Volga Novgorod Volga 30 22 65 21
16 Anzhi Anzhi 30 25 42 20
TEMPORADA 2012/2013
PREMIER LEAGUE RUSIA
Equipo PJ GF GC Puntos
1 CSKA Moskva CSKA Moskva 30 49 25 64
2 Zenit Zenit 30 53 25 62
3 Anzhi Anzhi 30 45 34 53
4 Spartak Moskva Spartak 30 51 39 51
5 FC Kuban FC Kuban 30 48 28 51
6 Rubin Kazán Rubin Kazán 30 39 27 50
7 Dinamo Moskva Dinamo 30 41 34 48
8 Akhmat Grozny Akhmat 30 38 40 48
9 Lokomotiv Moskva Lokomotiv 30 39 36 43
10 FK Krasnodar Krasnodar 30 45 39 42
11 Amkar Perm Amkar Perm 30 34 51 29
12 Volga Novgorod Volga 30 28 46 29
13 FK Rostov FK Rostov 30 30 41 29
14 Krylia Sovetov Krylia 30 31 52 28
15 Mordovia Saransk Mordovia 30 30 57 20
16 Alaniya Vladikavkaz Alaniya 30 26 53 19
TEMPORADA 2011/2012
PREMIER LEAGUE RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Zenit Zenit 14 26 15 88
2 Spartak Moskva Spartak 14 20 15 75
3 CSKA Moskva CSKA Moskva 14 14 18 73
4 Dinamo Moskva Dinamo 14 15 20 72
5 Anzhi Anzhi 14 16 10 70
6 Rubin Kazán Rubin Kazán 14 15 14 68
7 Lokomotiv Moskva Lokomotiv 14 10 18 66
8 FC Kuban FC Kuban 14 12 18 61
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
PREMIER LEAGUE RUSIA
Equipo PJ GF GC Puntos
1 Rubin Kazán Rubin Kazán 30 62 21 63
2 Spartak Moskva Spartak 30 61 33 55
3 Zenit Zenit 30 48 27 54
4 Lokomotiv Moskva Lokomotiv 30 43 30 54
5 CSKA Moskva CSKA Moskva 30 48 30 52
6 FK Moskva FK Moskva 30 39 28 48
7 Saturn Moskva Saturn 30 38 41 45
8 Dinamo Moskva Dinamo 30 31 37 42
9 Tom Tomsk Tom Tomsk 30 31 39 41
10 Krylia Sovetov Krylia 30 32 42 36
11 Spartak Nalchik Spartak 30 36 33 35
12 Akhmat Grozny Akhmat 30 33 48 33
13 Amkar Perm Amkar Perm 30 27 37 33
14 FK Rostov FK Rostov 30 28 39 32
15 FC Kuban FC Kuban 30 23 51 28
16 FK Khimki FK Khimki 30 20 64 10
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
PREMIER LEAGUE RUSIA
Equipo PJ GF GC Puntos
1 Zenit Zenit 30 53 33 61
2 Spartak Moskva Spartak 30 50 30 59
3 CSKA Moskva CSKA Moskva 30 43 24 53
4 FK Moskva FK Moskva 30 41 31 52
5 Saturn Moskva Saturn 30 34 28 45
6 Dinamo Moskva Dinamo 30 37 35 41
7 Lokomotiv Moskva Lokomotiv 30 39 42 41
8 Amkar Perm Amkar Perm 30 30 27 41
9 FK Khimki FK Khimki 30 32 33 37
10 Rubin Kazán Rubin Kazán 30 31 39 35
11 Tom Tomsk Tom Tomsk 30 37 35 35
12 Spartak Nalchik Spartak 30 29 38 33
13 Krylia Sovetov Krylia 30 35 46 32
14 Luch Vladivostok Luch 30 26 39 32
15 FC Kuban FC Kuban 30 27 38 32
16 FK Rostov FK Rostov 30 18 44 18
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
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
TEMPORADA 2003/2004
PREMIER LEAGUE RUSIA
Equipo PJ GF GC Puntos
1 Lokomotiv Moskva Lokomotiv 30 44 19 61
2 CSKA Moskva CSKA Moskva 30 53 22 60
3 Krylia Sovetov Krylia 30 50 41 56
4 Zenit Zenit 30 55 37 56
5 Torpedo Moscow Torpedo 30 53 37 54
6 Shinnik Yaroslavl Shinnik 30 29 29 44
7 Saturn Moskva Saturn 30 37 30 41
8 Spartak Moskva Spartak 30 43 44 40
9 FK Moskva FK Moskva 30 38 39 40
10 Rubin Kazán Rubin Kazán 30 32 31 33
11 Amkar Perm Amkar Perm 30 27 42 30
12 FK Rostov FK Rostov 30 28 42 29
13 Dinamo Moskva Dinamo 30 27 38 29
14 Alaniya Vladikavkaz Alaniya 30 28 52 28
15 FC Kuban FC Kuban 30 26 42 28
16 Rotor Volgograd Rotor 30 28 53 22
TEMPORADA 2002/2003
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Amkar Perm Amkar Perm 42 50 20 87
2 FC Kuban FC Kuban 42 75 38 86
3 Akhmat Grozny Akhmat 42 56 21 85
4 Tom Tomsk Tom Tomsk 42 55 23 85
5 Dynamo St Petersburg Dynamo 42 66 37 77
6 Anzhi Anzhi 42 52 33 70
7 Baltika Kaliningrad Baltika 42 58 49 64
8 Sokol Saratov Sokol 42 52 36 62
9 Metallurg Lipetsk Metallurg 42 53 38 62
10 SKA-Khabarovsk SKA-Khabarov 42 51 47 60
11 FK Khimki FK Khimki 42 36 46 57
12 FK Chita FK Chita 42 55 66 57
13 FK Metallurg-Kuzbass Metallurg-Ku 42 42 47 54
14 Mordovia Saransk Mordovia 42 54 60 53
15 Spartak Nalchik Spartak 42 34 49 52
16 Neftekhimik Neftekhimik 42 50 60 51
17 FC Soyuz Izhevsk Soyuz 42 44 56 50
18 Fakel Fakel 42 44 56 49
19 Ural Yekaterinburg Ural 42 43 65 41
20 Kristall Kristall 42 40 72 35
21 Volgar Astrakhan Volgar 42 28 60 29
22 Lada Tolyatti Lada 42 27 86 18
TEMPORADA 2001/2002
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Rubin Kazán Rubin Kazán 34 51 14 72
2 Chernomorets Novorossisk Chernomorets 34 59 29 70
3 Tom Tomsk Tom Tomsk 34 51 23 61
4 Amkar Perm Amkar Perm 34 47 31 54
5 FC Kuban FC Kuban 34 44 30 54
6 Spartak Nalchik Spartak 34 42 30 53
7 FK Khimki FK Khimki 34 38 27 52
8 Lada Tolyatti Lada 34 54 35 50
9 FK Chita FK Chita 34 38 46 45
10 FC Soyuz Izhevsk Soyuz 34 34 32 44
11 Kristall Kristall 34 39 43 44
12 SKA-Khabarovsk SKA-Khabarov 34 35 37 42
13 Fakel Fakel 34 34 42 40
14 Neftekhimik Neftekhimik 34 34 49 38
15 Volgar Astrakhan Volgar 34 34 51 36
16 Dynamo St Petersburg Dynamo 34 28 56 36
17 SKA Rostov SKA Rostov 34 38 62 31
18 Yenisey Yenisey 34 24 87 16
TEMPORADA 2000/2001
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Shinnik Yaroslavl Shinnik 34 58 21 69
2 Elista Uralan Elista 34 55 31 65
3 FC Kuban FC Kuban 34 56 29 60
4 Amkar Perm Amkar Perm 34 46 29 56
5 Spartak Nalchik Spartak 34 48 37 55
6 Volgar Astrakhan Volgar 34 40 40 50
7 Tom Tomsk Tom Tomsk 34 31 28 47
8 Rubin Kazán Rubin Kazán 34 44 44 46
9 Yenisey Yenisey 34 39 47 45
10 Kristall Kristall 34 37 45 44
11 Neftekhimik Neftekhimik 34 49 56 43
12 FK Khimki FK Khimki 34 42 54 43
13 FC Soyuz Izhevsk Soyuz 34 38 44 42
14 Lada Tolyatti Lada 34 40 50 41
15 Arsenal Tula Arsenal Tula 34 27 35 40
16 FK Chita FK Chita 34 38 50 40
17 Baltika Kaliningrad Baltika 34 35 51 39
18 Lokomotiv Nizhny Novgorod Lokomotiv 34 26 58 32
TEMPORADA 1999/2000
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Kuban FC Kuban 38 95 13 99
2 SKA Rostov SKA Rostov 38 104 16 98
3 Angusht Angusht 38 80 30 89
4 Druzhba Maykop Druzhba 38 89 27 83
5 Dynamo Stavropol Dynamo 38 68 24 82
6 Avtodor Avtodor 38 83 30 73
7 Dinamo Stavropol Dinamo 38 52 35 67
8 Kavkazkabel Kavkazkabel 38 54 34 62
9 Aruan Nartkala Aruan 38 54 57 61
10 Vityaz Krymsk Vityaz 38 46 62 51
11 Astrakhan Astrakhan 38 48 53 50
12 Aroma Gulkevichi Aroma 38 32 78 39
13 Mozdok Mozdok 38 42 57 35
14 Dynamo Makhachkala Dynamo 38 41 68 33
15 Rostselmash 2 Rostselmash 38 36 79 33
16 Shahtyor Shahtyor 38 26 71 33
17 Slavyanskiy Slavyanskiy 38 33 67 32
18 Spartak Vladikavkaz Spartak 38 30 90 31
19 Chernomorets D Chernomorets 38 44 76 30
20 Torpedo Taganrog Torpedo 38 23 113 10
TEMPORADA 1997/1998
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Saturn Moskva Saturn 42 73 34 84
2 Lokomotiv Nizhny Novgorod Lokomotiv 42 65 34 77
3 Sokol Saratov Sokol 42 58 32 76
4 Kristall Kristall 42 59 47 72
5 Arsenal Tula Arsenal Tula 42 65 53 65
6 Akademiya Tolyatti Akademiya 41 65 60 64
7 Dynamo St Petersburg Dynamo 41 51 37 63
8 Rubin Kazán Rubin Kazán 42 56 50 63
9 Fakel Fakel 42 54 45 60
10 FC Soyuz Izhevsk Soyuz 41 53 55 60
11 Anzhi Anzhi 42 47 56 57
12 Tom Tomsk Tom Tomsk 42 54 45 56
13 Spartak Nalchik Spartak 42 49 52 56
14 Metallurg Lipetsk Metallurg 42 41 50 56
15 FK Chita FK Chita 41 38 38 53
16 Neftekhimik Neftekhimik 41 44 53 52
17 Lada Tolyatti Lada 41 49 70 51
18 Druzhba Maykop Druzhba 42 45 55 50
19 Lokomotiv St Petersburg Lokomotiv 37 45 50 44
20 FC Kuban FC Kuban 42 42 68 43
21 FC Irtysh Omsk Irtysh Omsk 42 36 58 41
22 KamAZ KamAZ 41 32 79 26
TEMPORADA 1996/1997
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Elista Uralan Elista 42 67 22 92
2 Metallurg Lipetsk Metallurg 42 80 41 84
3 Sokol Saratov Sokol 42 58 35 74
4 Spartak Nalchik Spartak 42 74 53 72
5 Lokomotiv St Petersburg Lokomotiv 42 55 38 70
6 Akademiya Tolyatti Akademiya 42 80 71 69
7 Kristall Kristall 42 70 45 68
8 FK Chita FK Chita 42 62 63 65
9 Saturn Moskva Saturn 42 65 55 63
10 Dynamo St Petersburg Dynamo 42 54 58 62
11 FC Soyuz Izhevsk Soyuz 42 42 39 61
12 Neftekhimik Neftekhimik 42 53 54 61
13 Lada Tolyatti Lada 42 61 56 60
14 Anzhi Anzhi 42 66 72 60
15 FC Irtysh Omsk Irtysh Omsk 42 52 53 57
16 FC Kuban FC Kuban 42 63 66 57
17 Druzhba Maykop Druzhba 42 51 62 57
18 Zarya Leninsk Zarya 42 39 58 45
19 Tekstilshchik Kamyshin Tekstilshchi 42 46 67 38
20 Ural Yekaterinburg Ural 42 43 77 35
21 Energiya Volzhskiy Energiya 42 29 72 30
22 Luch Vladivostok Luch 42 23 76 21
TEMPORADA 1995/1996
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Druzhba Arzamas Druzhba 84 97 111 103
2 Tyumen Tyumen 42 82 34 84
3 Shinnik Yaroslavl Shinnik 42 66 32 83
4 Fakel Fakel 42 72 33 82
5 FC Soyuz Izhevsk Soyuz 42 69 44 79
6 Dynamo St Petersburg Dynamo 42 64 45 74
7 Zarya Leninsk Zarya 42 63 54 66
8 Elista Uralan Elista 42 47 41 66
9 Sokol Saratov Sokol 42 56 49 62
10 FC Kuban FC Kuban 42 65 60 59
11 Spartak Nalchik Spartak 42 62 59 59
12 Saturn Moskva Saturn 42 48 48 57
13 Lokomotiv St Petersburg Lokomotiv 42 57 46 55
14 Neftekhimik Neftekhimik 42 45 55 55
15 Luch Vladivostok Luch 42 39 49 54
16 Energiya Volzhskiy Energiya 42 57 71 54
17 FK Chita FK Chita 42 50 56 51
18 Okean Nakhodka Okean 42 42 76 39
19 Zvezda Irkutsk Zvezda 42 31 63 38
20 Yenisey Yenisey 42 33 61 35
21 Chkalovets Ns Chkalovets 42 44 102 27
TEMPORADA 1992/1993
PRIMERA RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomorets Novorossisk Chernomorets 42 121 33 94
2 Avtodor Avtodor 42 73 48 80
3 Erzu Groznyi Erzu Groznyi 42 72 26 79
4 Saturn-1991 Saturn-1991 42 70 50 76
5 Baltika Kaliningrad Baltika 42 67 44 75
6 Torpedo Vladimir Torpedo 42 67 53 73
7 Elista Uralan Elista 42 60 64 71
8 Druzhba Maykop Druzhba 42 70 55 69
9 Akhmat Grozny Akhmat 42 79 60 67
10 Metallurg Lipetsk Metallurg 42 68 50 66
11 Fakel Fakel 42 58 38 64
12 Spartak UGP Anapa Spartak 42 59 65 62
13 FK Taganrog FK Taganrog 42 62 65 61
14 Kolos Krasnodar Kolos 42 47 57 59
15 FC Kuban FC Kuban 42 62 84 53
16 Spartak Nalchik Spartak 42 52 73 47
17 Tekstilshchik Tekstilshchi 42 49 58 44
18 Znamya Znamya 42 42 64 41
19 Dinamo Vologda Dinamo 42 36 65 40
20 Asmaral Kislovodsk Asmaral 42 33 68 34
21 Nart Cherkessk Nart 42 30 84 32
22 APK Morozovsk Morozovsk 42 25 98 17
TEMPORADA 1991/1992
PREMIER LEAGUE RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Moskva Spartak 18 35 9 28
2 Asmaral Moskva Asmaral 18 34 21 26
3 Lokomotiv Nizhny Novgorod Lokomotiv 18 16 11 23
4 FK Rostov FK Rostov 18 20 17 20
5 Krylia Sovetov Krylia 18 12 19 18
6 Torpedo Moscow Torpedo 18 20 20 17
7 Rotor Volgograd Rotor 18 23 19 16
8 Zenit Zenit 18 21 35 14
9 FC Kuban FC Kuban 18 19 30 12
10 Shinnik Yaroslavl Shinnik 18 11 30 6

  USO DE MEMORIA  
8,217,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  1.2792
Total Execution Time  1.2811
  CADENA URL  
/historico/Kuban-Krasnodar
  GET DATOS  
$_GET['/historico/Kuban-Krasnodar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (102)  
0.0112  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 = 'Kuban-Krasnodar' 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.0245  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 = 'Kuban-Krasnodar' 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.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0116  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0116  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1473 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0115  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 = 2836
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1473 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1473 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  SELECT /*35 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 (2453,2793,31282,31347,33292) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '1473' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient 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 = '1473' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '1473' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 2836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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 = 41747 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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=1473 AND l.year in (2013,2014,2015) 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 (41748,20581,3819,3804,2836) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 3819 AND teamId = 1473
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 2836 AND teamId = 1473
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 20581 AND teamId = 1473
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 41748 AND teamId = 1473
0.0249  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 1473
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 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 = 2836 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108  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 = '1473' 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 = '1473' 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 = '1473' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0112  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 events2014 e ON e.player_id = p.id AND e.league_id = 2836 WHERE rp.league_id = 2836 AND rp.teamId = 1473 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.0113  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 events2014 e ON e.player_id = p.id AND e.league_id = 2836 WHERE rp.league_id = 2836 AND rp.teamId = 1473 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 events2014 e ON e.player_id = p.id AND e.league_id = 2836 WHERE rp.league_id = 2836 AND rp.teamId = 1473 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 1473 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 2477 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 1916 AND t.round = 30 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 `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 = 1864 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1876 AND t.round = 44 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 `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.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 `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 = 802 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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.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 `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 = 237 AND t.round = 30 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 `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
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 `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
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 `tables2004` 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 = 240 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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 `tables2003` 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 = 26506 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2002` 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 = 26508 AND t.round = 34 ORDER BY team.conference 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 `tables2001` 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 = 26510 AND t.round = 34 ORDER BY team.conference 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 `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 = 26824 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables1998` 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 = 26517 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1997` 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 = 26519 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1996` 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 = 26523 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 `tables1993` 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 = 26541 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1992` 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 = 10495 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2836 ORDER BY nameShow LIMIT 100