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

Gomel

Entrenador: Andrey Gorovtsov

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
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Sputnik Rechitsa Sputnik 26 50 18 61
2 Gomel Gomel 26 60 20 54
3 Krumkachy Krumkachy 26 46 28 52
4 Arsenal Dzyarzhynsk Arsenal 26 41 28 46
5 Lokomotiv Gomel Lokomotiv 26 56 38 45
6 FK Smorgon FK Smorgon 26 29 26 36
7 FK Lida FK Lida 26 37 42 31
8 FC Slonim FC Slonim 26 22 32 30
9 Volna Pinsk Volna Pinsk 26 41 52 27
10 Oshmyany Oshmyany 26 35 43 26
11 FK Orsha FK Orsha 26 30 42 24
12 Naftan Novopolotsk Naftan 26 36 43 21
13 Granit Mikashevichi Granit 26 21 52 17
14 Khimik Svetlogorsk Khimik 26 12 52 1
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
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
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 3
Equipo PJ GF GC Puntos
1 Dinamo Minsk Dinamo Minsk 10 14 7 20
2 BATE Borisov BATE Borisov 10 15 8 19
3 Neman Grodno Neman Grodno 10 11 7 17
4 Torpedo Zhodino Torpedo 10 7 10 14
5 Shakhtyor Soligorsk Shakhtyor 10 9 13 9
6 Gomel Gomel 10 9 20 6
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
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Gomel Gomel 30 80 16 82
2 SKVICH Minsk SKVICH Minsk 30 52 21 58
3 DSK Gomel DSK Gomel 30 52 26 58
4 Granit Mikashevichi Granit 30 52 23 56
5 FK Rudensk FK Rudensk 30 37 39 43
6 Baranovichi Baranovichi 30 31 37 43
7 Polotsk Polotsk 30 38 34 39
8 Khimik Svetlogorsk Khimik 30 37 44 37
9 Slavia Mozyr Slavia Mozyr 30 33 44 37
10 Veras Nesvizh Veras 30 31 39 35
11 Volna Pinsk Volna Pinsk 30 31 48 35
12 FK Smorgon FK Smorgon 30 33 43 32
13 BelCard Grodno BelCard 30 25 40 30
14 Rechytsa Rechytsa 30 29 46 30
15 FC Slonim FC Slonim 30 23 48 28
16 FK Lida FK Lida 30 23 59 19
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,217,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.8015
Total Execution Time  0.8028
  CADENA URL  
/historico/Gomel/2021
  GET DATOS  
$_GET['/historico/Gomel/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0183  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 = 'Gomel' 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.0126  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=5852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=5852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=5852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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.0256  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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5852 AND type_rel = 2
0.0149  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 = '5852' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '5852' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0143  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.0136  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.0171  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=5852 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0129  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,62807,62733,55676) 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.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 66797 AND teamId = 5852
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 55676 AND teamId = 5852
0.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 62733 AND teamId = 5852
0.0562  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 5852
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 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.0127  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 = '5852' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5852' and rp.type = 4
0.0126  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 = '5852' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 5852 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.0137  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 = 5852 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 5852 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 5852 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 55676 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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 = 8995 AND t.round = 30 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.0126  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