4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Smolevichy
TEMPORADA 2020/2021
TERCERA BIELORRUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Edinstvo Dzerzhinsk Edinstvo 18 32 54 21
2 Molodechno Molodechno 18 99 12 51
3 FK Uzda FK Uzda 18 61 27 38
4 Kolos Cherven Kolos 18 45 29 36
5 Falko Falko 18 49 31 32
6 SMI Autotrans Autotrans 18 68 50 29
7 Smolevichy Smolevichy 18 56 37 28
8 Viliya Viliya 18 27 61 10
9 Berezino Berezino 18 24 107 10
10 Krupki Krupki 18 26 79 7
11 Partizan Salihorsk Partizan 20 65 13 48
12 BGU Minsk BGU Minsk 20 67 13 46
13 Viktoriya Maryina Horka Viktoriya 20 59 32 42
14 Energosbyt-BSATU Energosbyt-B 20 59 34 36
15 Kletsk Kletsk 20 36 51 34
16 Kronon Kronon 20 55 25 33
17 Stroitel Kapyl Stroitel 20 39 36 27
18 Starye Dorogi Starye 20 25 40 17
19 Spartak Slutsk Spartak 20 31 79 14
20 Lyuban Lyuban 20 28 75 10
21 Veras Nesvizh Veras 20 16 82 5
TEMPORADA 2019/2020
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 30 57 21 59
2 BATE Borisov BATE Borisov 30 65 32 58
3 Torpedo Zhodino Torpedo 30 55 37 56
4 Dinamo Brest Dinamo Brest 30 63 40 54
5 Neman Grodno Neman Grodno 30 41 29 53
6 Dinamo Minsk Dinamo Minsk 30 38 25 52
7 Isloch Isloch 30 47 46 45
8 Rukh Brest Rukh Brest 30 57 38 44
9 Slavia Mozyr Slavia Mozyr 30 41 49 39
10 Energetik-BGU Energetik-BG 30 43 46 38
11 Minsk Minsk 30 45 57 38
12 Vitebsk Vitebsk 30 30 38 36
13 FK Gorodeya FK Gorodeya 30 30 48 31
14 Slutsk Slutsk 29 31 55 27
15 Belshina Bobruisk Belshina 30 34 71 21
16 Smolevichy Smolevichy 29 27 72 14
TEMPORADA 2018/2019
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Belshina Bobruisk Belshina 28 74 22 68
2 Smolevichy Smolevichy 28 60 15 64
3 Rukh Brest Rukh Brest 28 69 26 56
4 Lokomotiv Gomel Lokomotiv 28 60 24 56
5 Naftan Novopolotsk Naftan 28 58 43 47
6 Sputnik Rechitsa Sputnik 28 46 36 45
7 FK Lida FK Lida 28 49 32 44
8 Krumkachy Krumkachy 28 41 38 40
9 Granit Mikashevichi Granit 28 38 40 35
10 FK Orsha FK Orsha 28 33 65 31
11 Khimik Svetlogorsk Khimik 28 26 59 26
12 Volna Pinsk Volna Pinsk 28 29 49 21
13 FC Slonim FC Slonim 28 18 47 21
14 FK Smorgon FK Smorgon 28 26 63 18
15 Baranovichi Baranovichi 28 12 80 9
16 Zhitkovichi Zhitkovichi 0 0 0 0
TEMPORADA 2017/2018
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 55 24 73
2 Shakhtyor Soligorsk Shakhtyor 30 45 14 64
3 Dinamo Minsk Dinamo Minsk 30 41 17 63
4 Vitebsk Vitebsk 30 47 20 62
5 Torpedo Zhodino Torpedo 30 36 18 55
6 Dinamo Brest Dinamo Brest 30 52 30 52
7 Neman Grodno Neman Grodno 30 31 32 43
8 Slutsk Slutsk 30 26 36 36
9 FK Gorodeya FK Gorodeya 30 31 33 34
10 Isloch Isloch 30 20 37 33
11 Minsk Minsk 30 34 42 30
12 Gomel Gomel 30 16 36 28
13 Luch Minsk Luch Minsk 30 24 44 24
14 Torpedo Minsk Torpedo 30 20 41 24
15 Smolevichy Smolevichy 30 21 39 24
16 Dnepr Mogilev Dnepr 30 17 53 16
TEMPORADA 2016/2017
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Luch Minsk Luch Minsk 30 73 22 73
2 Smolevichy Smolevichy 30 46 22 58
3 Torpedo Minsk Torpedo 30 57 29 55
4 Lokomotiv Gomel Lokomotiv 29 45 37 51
5 Belshina Bobruisk Belshina 30 56 30 49
6 Granit Mikashevichi Granit 30 42 37 46
7 Energetik-BGU Energetik-BG 30 39 27 45
8 Volna Pinsk Volna Pinsk 30 48 48 43
9 FK Orsha FK Orsha 30 48 48 37
10 Khimik Svetlogorsk Khimik 30 35 42 37
11 FC Slonim FC Slonim 30 33 46 37
12 Baranovichi Baranovichi 29 34 44 31
13 FK Smorgon FK Smorgon 30 34 50 29
14 FK Lida FK Lida 30 28 39 28
15 Osipovichy Osipovichy 30 30 62 25
16 Kronon Kronon 30 28 93 16
TEMPORADA 2015/2016
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dnepr Mogilev Dnepr 26 61 19 64
2 Gomel Gomel 26 48 11 63
3 Luch Minsk Luch Minsk 26 44 29 45
4 Lokomotiv Gomel Lokomotiv 26 31 27 41
5 FK Smorgon FK Smorgon 26 40 39 38
6 FK Lida FK Lida 26 26 33 38
7 FK Orsha FK Orsha 26 43 34 37
8 Smolevichy Smolevichy 26 38 29 34
9 Torpedo Minsk Torpedo 26 35 36 33
10 Energetik-BGU Energetik-BG 26 33 41 33
11 FC Slonim FC Slonim 26 36 49 24
12 Khimik Svetlogorsk Khimik 26 26 49 23
13 Baranovichi Baranovichi 26 33 52 20
14 Oshmyany Oshmyany 26 19 65 9
TEMPORADA 2014/2015
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Isloch Isloch 30 76 24 69
2 FK Gorodeya FK Gorodeya 30 73 25 68
3 Krumkachy Krumkachy 30 67 45 60
4 Dnepr Mogilev Dnepr 30 48 21 56
5 FK Smorgon FK Smorgon 30 60 41 53
6 FK Lida FK Lida 30 60 53 50
7 Smolevichy Smolevichy 30 47 37 47
8 Lokomotiv Gomel Lokomotiv 30 45 39 44
9 FC Slonim FC Slonim 30 41 55 41
10 Energetik-BGU Energetik-BG 30 47 47 40
11 Byaroza Byaroza 30 39 43 34
12 Khimik Svetlogorsk Khimik 30 42 50 34
13 Baranovichi Baranovichi 30 36 49 32
14 FK Orsha FK Orsha 30 24 70 17
15 FC Kobrin FC Kobrin 30 23 77 15
16 Rechytsa Rechytsa 30 14 66 11
TEMPORADA 2013/2014
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Granit Mikashevichi Granit 30 46 16 64
2 Slavia Mozyr Slavia Mozyr 30 55 38 60
3 Vitebsk Vitebsk 30 44 30 50
4 FK Smorgon FK Smorgon 30 42 32 46
5 Rechytsa Rechytsa 30 41 36 46
6 FK Gorodeya FK Gorodeya 30 42 26 45
7 Isloch Isloch 30 39 35 45
8 Khimik Svetlogorsk Khimik 30 34 36 43
9 Energetik-BGU Energetik-BG 30 50 48 40
10 Smolevichy Smolevichy 30 37 41 40
11 Lokomotiv Gomel Lokomotiv 30 33 38 36
12 Minsk II Minsk II 30 41 45 33
13 Byaroza Byaroza 30 37 48 33
14 FK Lida FK Lida 30 46 64 31
15 FC Slonim FC Slonim 30 32 50 30
16 Volna Pinsk Volna Pinsk 30 26 62 20
TEMPORADA 2012/2013
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slutsk Slutsk 30 54 19 66
2 FK Gorodeya FK Gorodeya 30 68 32 60
3 Vitebsk Vitebsk 30 40 29 55
4 FK Lida FK Lida 30 53 38 52
5 FC Bereza 2010 Bereza 2010 30 44 30 50
6 FK Smorgon FK Smorgon 30 45 35 46
7 Granit Mikashevichi Granit 30 42 31 45
8 Smolevichy Smolevichy 30 50 37 44
9 Isloch Isloch 30 39 37 41
10 Khimik Svetlogorsk Khimik 30 37 36 41
11 Rechytsa Rechytsa 30 47 36 39
12 Volna Pinsk Volna Pinsk 30 30 41 39
13 FC Slonim FC Slonim 30 38 45 34
14 Dinamo Minsk II Dinamo Minsk 30 32 49 26
15 SKVICH Minsk SKVICH Minsk 30 21 63 12
16 Polotsk Polotsk 30 10 92 10
TEMPORADA 2011/2012
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Smolevichy Smolevichy 36 113 22 87
2 Beltransgaz Beltransgaz 36 95 35 78
3 Isloch Isloch 36 61 30 70
4 Lokomotiv Gomel Lokomotiv 36 64 27 69
5 Minsk II Minsk II 36 60 33 68
6 Dinamo Minsk II Dinamo Minsk 36 52 44 60
7 Energetik-BGU Energetik-BG 36 54 41 58
8 FC Slonim FC Slonim 36 61 55 55
9 BelCard Grodno BelCard 36 54 45 53
10 Zhlobin Zhlobin 36 53 66 51
11 Neman Mosty Neman Mosty 36 50 54 46
12 Dnepr Mogilev II Dnepr 36 49 60 43
13 Baranovichi Baranovichi 36 33 42 40
14 Krutogorye Dzerzhinsk Krutogorye 36 47 72 39
15 Molodechno Molodechno 36 45 86 38
16 Miory Miory 36 47 82 35
17 FK Orsha FK Orsha 36 30 72 35
18 Osipovichy Osipovichy 36 47 74 33
19 Vitebsk II Vitebsk II 36 24 99 10
20 Klechesk Klechesk 0 0 0 0
TEMPORADA 2010/2011
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Byaroza Byaroza 30 77 28 73
2 FK Lida FK Lida 30 60 21 73
3 Beltransgaz Beltransgaz 30 84 29 64
4 Molodechno Molodechno 30 58 38 58
5 FC Slonim FC Slonim 30 51 27 54
6 Lokomotiv Gomel Lokomotiv 30 49 28 51
7 Energetik-BGU Energetik-BG 30 40 32 42
8 Krutogorye Dzerzhinsk Krutogorye 30 35 39 42
9 Neman Mosty Neman Mosty 30 31 54 37
10 Partizan Minsk II Partizan 30 54 56 35
11 Smolevichy Smolevichy 30 45 48 32
12 Dinamo Minsk II Dinamo Minsk 30 45 58 32
13 Zhlobin Zhlobin 30 38 74 24
14 Vertykal Vertykal 30 27 61 22
15 FK Orsha FK Orsha 30 31 86 21
16 Osipovichy Osipovichy 30 39 85 20
TEMPORADA 2009/2010
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 FK Gorodeya FK Gorodeya 34 112 29 84
2 Slutsk Slutsk 34 79 30 81
3 Klechesk Klechesk 34 91 35 76
4 Molodechno Molodechno 34 69 52 57
5 Energetik-BGU Energetik-BG 34 76 47 55
6 Byaroza Byaroza 34 57 55 54
7 Lokomotiv Gomel Lokomotiv 34 63 58 52
8 Osipovichy Osipovichy 34 51 64 50
9 Neman Mosty Neman Mosty 34 54 50 48
10 Spartak Shklov Spartak 33 52 58 45
11 Smolevichy Smolevichy 34 32 41 41
12 Beltransgaz Beltransgaz 34 46 55 40
13 Gomel II Gomel II 33 36 46 36
14 Zhlobin Zhlobin 34 48 74 34
15 FK Orsha FK Orsha 34 40 75 33
16 Vertykal Vertykal 34 42 67 32
17 Krutogorye Dzerzhinsk Krutogorye 34 25 81 21
18 DSK Gomel II Gomel 34 19 75 17

  USO DE MEMORIA  
6,657,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.0524
Total Execution Time  1.0537
  CADENA URL  
/historico/Smolevichy
  GET DATOS  
$_GET['/historico/Smolevichy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (62)  
0.0151  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 = 'Smolevichy' 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.0171  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 = 'Smolevichy' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=13134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0156  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 = 62622
0.0156  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 = 64640
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13134 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1758 AND type_rel = 3
0.0153  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 = '13134' ORDER BY l.year DESC,cat.coefficient DESC
0.0165  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 = '13134' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0167  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 = '13134' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = '13134' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = 64640 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=13134 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (64640,62733,55492,49506) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 55492 AND teamId = 13134
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 64640 AND teamId = 13134
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 62733 AND teamId = 13134
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 13134
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 62622 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '13134' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13134' and rp.type = 4
0.0146  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 = '13134' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2021 e ON e.player_id = p.id AND e.league_id = 62622 WHERE rp.league_id = 62622 AND rp.teamId = 13134 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.0146  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 events2021 e ON e.player_id = p.id AND e.league_id = 62622 WHERE rp.league_id = 62622 AND rp.teamId = 13134 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2021 e ON e.player_id = p.id AND e.league_id = 62622 WHERE rp.league_id = 62622 AND rp.teamId = 13134 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 13134 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0155  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 62622 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 55492 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.0156  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 = 49429 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 42965 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 38085 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 23627 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 12778 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 4168 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 2830 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 16296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2011` 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 = 16294 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 16295 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC