4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Shakhtyor Soligorsk

Shakhtyor Soligorsk

Entrenador: Stanislav Suvorov

Temporada 2020/2021
TEMPORADA 2020/2021
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 30 62 18 75
2 BATE Borisov BATE Borisov 30 61 27 65
3 Dinamo Minsk Dinamo Minsk 30 55 20 62
4 Gomel Gomel 30 57 23 59
5 Rukh Brest Rukh Brest 30 52 28 58
6 Dinamo Brest Dinamo Brest 30 32 32 38
7 Vitebsk Vitebsk 30 37 41 37
8 Torpedo Zhodino Torpedo 30 38 43 36
9 Slutsk Slutsk 30 36 44 35
10 Isloch Isloch 30 38 47 34
11 Neman Grodno Neman Grodno 30 36 36 34
12 Minsk Minsk 30 32 52 33
13 Energetik-BGU Energetik-BG 30 35 42 33
14 Slavia Mozyr Slavia Mozyr 30 42 50 32
15 FK Smorgon FK Smorgon 30 26 66 21
16 Sputnik Rechitsa Sputnik 30 12 82 7
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
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dinamo Brest Dinamo Brest 30 70 22 75
2 BATE Borisov BATE Borisov 30 61 21 70
3 Shakhtyor Soligorsk Shakhtyor 30 59 21 65
4 Dinamo Minsk Dinamo Minsk 30 43 39 50
5 Isloch Isloch 30 42 36 47
6 Torpedo Zhodino Torpedo 30 41 36 45
7 FK Gorodeya FK Gorodeya 30 31 29 44
8 Slavia Mozyr Slavia Mozyr 30 35 40 37
9 Minsk Minsk 30 36 44 36
10 Neman Grodno Neman Grodno 30 28 37 36
11 Slutsk Slutsk 30 29 46 34
12 Energetik-BGU Energetik-BG 30 52 66 33
13 Vitebsk Vitebsk 30 24 39 31
14 Dnyapro Dnyapro 30 32 42 30
15 Gomel Gomel 30 44 50 29
16 Torpedo Minsk Torpedo 30 4 63 6
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
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 61 19 68
2 Dinamo Minsk Dinamo Minsk 30 46 15 68
3 Shakhtyor Soligorsk Shakhtyor 30 52 22 65
4 Dinamo Brest Dinamo Brest 30 47 26 51
5 Torpedo Zhodino Torpedo 30 43 27 51
6 Neman Grodno Neman Grodno 30 42 32 49
7 Slutsk Slutsk 30 30 34 44
8 Vitebsk Vitebsk 30 35 38 43
9 FK Gorodeya FK Gorodeya 30 37 35 38
10 Gomel Gomel 30 24 25 35
11 Isloch Isloch 30 27 46 27
12 Dnepr Mogilev Dnepr 30 27 48 26
13 Krumkachy Krumkachy 30 26 47 25
14 Minsk Minsk 30 19 39 23
15 Slavia Mozyr Slavia Mozyr 30 26 50 20
16 Naftan Novopolotsk Naftan 30 18 57 13
TEMPORADA 2015/2016
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 73 25 70
2 Shakhtyor Soligorsk Shakhtyor 30 46 20 59
3 Dinamo Minsk Dinamo Minsk 30 46 28 55
4 Minsk Minsk 30 49 24 53
5 Torpedo Zhodino Torpedo 30 47 33 48
6 Vitebsk Vitebsk 30 30 26 42
7 Isloch Isloch 30 35 40 41
8 Dinamo Brest Dinamo Brest 30 39 40 40
9 FK Gorodeya FK Gorodeya 30 36 39 38
10 Slavia Mozyr Slavia Mozyr 30 33 49 35
11 Krumkachy Krumkachy 30 24 39 33
12 Slutsk Slutsk 30 22 34 30
13 Neman Grodno Neman Grodno 30 21 36 29
14 Naftan Novopolotsk Naftan 30 25 46 29
15 Belshina Bobruisk Belshina 30 34 45 25
16 Granit Mikashevichi Granit 30 20 56 25
TEMPORADA 2014/2015
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 26 44 11 65
2 Dinamo Minsk Dinamo Minsk 26 36 13 53
3 Shakhtyor Soligorsk Shakhtyor 26 47 27 49
4 Belshina Bobruisk Belshina 26 39 19 43
5 Granit Mikashevichi Granit 26 30 32 42
6 Minsk Minsk 26 29 28 40
7 Torpedo Zhodino Torpedo 26 31 29 36
8 Neman Grodno Neman Grodno 26 21 32 32
9 Naftan Novopolotsk Naftan 26 34 35 30
10 Slavia Mozyr Slavia Mozyr 26 33 50 26
11 Slutsk Slutsk 26 26 30 25
12 Dinamo Brest Dinamo Brest 26 23 42 24
13 Vitebsk Vitebsk 26 21 47 21
14 Gomel Gomel 26 22 41 18
TEMPORADA 2013/2014
LIGA BIELORRUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 22 46 12 51
2 Dinamo Minsk Dinamo Minsk 22 33 8 49
3 Naftan Novopolotsk Naftan 22 30 20 37
4 Gomel Gomel 22 21 21 32
5 Shakhtyor Soligorsk Shakhtyor 22 20 20 32
6 Torpedo Zhodino Torpedo 22 21 20 31
7 Neman Grodno Neman Grodno 22 25 24 27
8 Minsk Minsk 22 23 26 26
9 Slutsk Slutsk 22 15 26 25
10 Dinamo Brest Dinamo Brest 22 23 52 22
11 Belshina Bobruisk Belshina 22 28 38 18
12 Dnepr Mogilev Dnepr 22 11 29 12
TEMPORADA 2012/2013
LIGA BIELORRUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 22 35 13 49
2 BATE Borisov BATE Borisov 22 46 17 48
3 Gomel Gomel 22 25 20 34
4 Dinamo Minsk Dinamo Minsk 22 30 26 34
5 Neman Grodno Neman Grodno 22 23 23 30
6 Torpedo Zhodino Torpedo 22 26 28 28
7 Belshina Bobruisk Belshina 22 24 28 28
8 Minsk Minsk 22 21 27 25
9 Dinamo Brest Dinamo Brest 22 18 30 24
10 Dnepr Mogilev Dnepr 22 20 29 23
11 Naftan Novopolotsk Naftan 22 19 29 21
12 Slavia Mozyr Slavia Mozyr 22 16 33 16
TEMPORADA 2011/2012
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 51 16 68
2 Shakhtyor Soligorsk Shakhtyor 30 59 24 61
3 Dinamo Minsk Dinamo Minsk 30 37 19 56
4 Gomel Gomel 30 39 24 50
5 Neman Grodno Neman Grodno 30 43 36 41
6 Minsk Minsk 30 36 46 39
7 Belshina Bobruisk Belshina 30 26 40 30
8 Dinamo Brest Dinamo Brest 30 27 38 29
9 Naftan Novopolotsk Naftan 30 23 40 29
10 Slavia Mozyr Slavia Mozyr 30 22 58 27
11 Torpedo Zhodino Torpedo 30 17 39 24
TEMPORADA 2010/2011
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 33 53 20 66
2 Shakhtyor Soligorsk Shakhtyor 33 46 24 61
3 Gomel Gomel 33 36 24 54
4 Dinamo Minsk Dinamo Minsk 33 50 43 49
5 Belshina Bobruisk Belshina 33 41 35 48
6 Torpedo Zhodino Torpedo 33 37 41 41
7 Naftan Novopolotsk Naftan 33 35 45 37
8 Neman Grodno Neman Grodno 33 33 45 37
9 Minsk Minsk 33 33 40 35
10 Dinamo Brest Dinamo Brest 33 38 46 35
11 Vitebsk Vitebsk 33 29 46 32
12 Dnepr Mogilev Dnepr 33 29 51 32
TEMPORADA 2009/2010
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 33 64 18 72
2 Shakhtyor Soligorsk Shakhtyor 33 51 23 66
3 Minsk Minsk 33 59 32 60
4 Dinamo Minsk Dinamo Minsk 33 49 34 56
5 Dinamo Brest Dinamo Brest 33 48 40 46
6 Belshina Bobruisk Belshina 33 31 42 45
7 Naftan Novopolotsk Naftan 33 41 34 44
8 Dnepr Mogilev Dnepr 33 40 53 40
9 Vitebsk Vitebsk 33 31 52 32
10 Neman Grodno Neman Grodno 33 27 42 31
11 Torpedo Zhodino Torpedo 33 33 58 28
12 Partizan Minsk Partizan 33 24 70 23
TEMPORADA 2008/2009
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 26 55 16 62
2 Dinamo Minsk Dinamo Minsk 26 38 18 50
3 Dnepr Mogilev Dnepr 26 31 26 40
4 Dinamo Brest Dinamo Brest 26 30 24 38
5 Shakhtyor Soligorsk Shakhtyor 26 33 28 38
6 Naftan Novopolotsk Naftan 26 28 39 38
7 Torpedo Zhodino Torpedo 26 31 22 37
8 Neman Grodno Neman Grodno 26 23 31 37
9 Minsk Minsk 26 33 26 36
10 Vitebsk Vitebsk 26 26 37 32
11 Partizan Minsk Partizan 26 34 38 30
12 Gomel Gomel 26 31 47 29
13 Granit Mikashevichi Granit 26 27 39 25
14 FK Smorgon FK Smorgon 26 17 46 15
TEMPORADA 2007/2008
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 54 20 67
2 Dinamo Minsk Dinamo Minsk 30 49 29 62
3 Partizan Minsk Partizan 30 65 38 57
4 Shakhtyor Soligorsk Shakhtyor 30 50 35 51
5 Vitebsk Vitebsk 30 39 26 51
6 Dinamo Brest Dinamo Brest 30 40 34 47
7 Naftan Novopolotsk Naftan 30 41 35 46
8 FK Smorgon FK Smorgon 30 26 39 39
9 Dnepr Mogilev Dnepr 30 45 42 38
10 Granit Mikashevichi Granit 30 35 34 36
11 Neman Grodno Neman Grodno 30 36 40 33
12 Gomel Gomel 30 36 47 33
13 Torpedo Zhodino Torpedo 30 25 36 31
14 SKVICH Minsk SKVICH Minsk 30 28 50 25
15 Savit Mogilev Savit 30 28 61 21
16 Darida Darida 30 25 56 19
TEMPORADA 2006/2007
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 26 49 26 56
2 Gomel Gomel 26 49 28 44
3 Shakhtyor Soligorsk Shakhtyor 26 41 27 44
4 Torpedo Zhodino Torpedo 26 28 21 43
5 Partizan Minsk Partizan 26 32 25 42
6 Neman Grodno Neman Grodno 26 23 22 36
7 Naftan Novopolotsk Naftan 26 28 30 36
8 Dinamo Minsk Dinamo Minsk 26 28 27 35
9 Vitebsk Vitebsk 26 25 28 35
10 FK Smorgon FK Smorgon 26 15 29 26
11 Dinamo Brest Dinamo Brest 26 23 31 25
12 Darida Darida 26 27 46 25
13 Dnepr Mogilev Dnepr 26 21 33 23
14 Minsk Minsk 26 18 34 21
TEMPORADA 2005/2006
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 26 47 27 54
2 Dinamo Minsk Dinamo Minsk 26 44 22 52
3 Partizan Minsk Partizan 26 54 24 51
4 Shakhtyor Soligorsk Shakhtyor 26 50 31 51
5 Gomel Gomel 26 33 32 42
6 Vitebsk Vitebsk 26 21 18 38
7 Naftan Novopolotsk Naftan 26 45 42 37
8 Darida Darida 26 23 21 37
9 Dinamo Brest Dinamo Brest 26 17 31 31
10 Torpedo Zhodino Torpedo 26 21 27 30
11 Neman Grodno Neman Grodno 26 23 31 27
12 Dnepr Mogilev Dnepr 26 29 47 23
13 SKVICH Minsk SKVICH Minsk 26 27 51 22
14 Belshina Bobruisk Belshina 26 16 46 9
TEMPORADA 2004/2005
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 26 59 14 63
2 Dinamo Minsk Dinamo Minsk 26 50 26 50
3 Partizan Minsk Partizan 26 43 30 49
4 BATE Borisov BATE Borisov 26 42 27 47
5 Torpedo Zhodino Torpedo 26 40 25 47
6 Dnepr Mogilev Dnepr 26 48 36 43
7 Gomel Gomel 26 34 32 39
8 Dinamo Brest Dinamo Brest 26 39 33 36
9 Naftan Novopolotsk Naftan 26 43 44 33
10 Darida Darida 26 30 36 29
11 SKVICH Minsk SKVICH Minsk 26 30 43 26
12 Neman Grodno Neman Grodno 26 20 50 24
13 Energetik-BGU Energetik-BG 26 24 60 14
14 FC Mozyr FC Mozyr 26 14 60 11
TEMPORADA 2003/2004
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dinamo Minsk Dinamo Minsk 30 64 18 75
2 BATE Borisov BATE Borisov 30 59 25 70
3 Shakhtyor Soligorsk Shakhtyor 30 55 21 65
4 Torpedo Zhodino Torpedo 30 57 28 59
5 Torpedo Minsk Torpedo 30 37 31 46
6 Gomel Gomel 30 42 41 46
7 Neman Grodno Neman Grodno 30 37 33 40
8 Dinamo Brest Dinamo Brest 30 39 41 39
9 Dnepr Mogilev Dnepr 30 29 37 37
10 Naftan Novopolotsk Naftan 30 45 50 35
11 Darida Darida 30 38 48 35
12 FC Mozyr FC Mozyr 30 32 51 31
13 Energetik-BGU Energetik-BG 30 31 56 29
14 Vitebsk Vitebsk 30 34 54 27
15 Partizan Minsk Partizan 30 32 56 27
16 Belshina Bobruisk Belshina 30 21 62 12

  USO DE MEMORIA  
7,648,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1891
Total Execution Time  0.1907
  CADENA URL  
/historico/Shakhtyor/2021
  GET DATOS  
$_GET['/historico/Shakhtyor/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (55)  
0.0050  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 = 'Shakhtyor' AND l.year = 2021 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.0020  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=5775 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=5775 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=5775 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=5775 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=5775 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=5775 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 61109
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 56461
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 61139
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5775 AND type_rel = 2
0.0033  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 = '5775' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '5775' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '5775' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 56461 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61109 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=5775 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (66797,65910,62807,62733,62626,62615,58149) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 66797 AND teamId = 5775
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 62626 AND teamId = 5775
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 58149 AND teamId = 5775
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 62615 AND teamId = 5775
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 62733 AND teamId = 5775
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 65910 AND teamId = 5775
0.0102  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 5775
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 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 = 61109 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '5775' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5775' 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 = '5775' 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 events2021 e ON e.player_id = p.id AND e.league_id = 61109 WHERE rp.league_id = 61109 AND rp.teamId = 5775 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.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 events2021 e ON e.player_id = p.id AND e.league_id = 61109 WHERE rp.league_id = 61109 AND rp.teamId = 5775 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 61109 WHERE rp.league_id = 61109 AND rp.teamId = 5775 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 5775 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 61109 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 `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.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 `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 = 49072 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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 = 37943 AND t.round = 30 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 `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 = 21241 AND t.round = 30 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 `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 = 9814 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 `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 = 10161 AND t.round = 10 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 = 3639 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 10167 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2335 AND t.round = 22 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 `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 = 1618 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1376 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 8985 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 8984 AND t.round = 26 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 `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 = 8983 AND t.round = 30 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 `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 = 8980 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 `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 = 8978 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 8976 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 8974 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 61109 ORDER BY nameShow LIMIT 100