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

Naftan Novopolotsk

Entrenador: Albert Rybak

Temporada 2019/2020
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
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
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slavia Mozyr Slavia Mozyr 28 69 13 70
2 Energetik-BGU Energetik-BG 28 70 20 70
3 Belshina Bobruisk Belshina 28 59 23 59
4 FK Lida FK Lida 28 42 19 55
5 Naftan Novopolotsk Naftan 28 28 24 41
6 Lokomotiv Gomel Lokomotiv 28 44 29 40
7 FC Slonim FC Slonim 28 37 37 36
8 Granit Mikashevichi Granit 28 28 34 35
9 Khimik Svetlogorsk Khimik 28 32 40 32
10 Yua-Stroy Yua-Stroy 28 23 38 28
11 FK Smorgon FK Smorgon 28 19 44 28
12 FK Orsha FK Orsha 28 33 53 27
13 Volna Pinsk Volna Pinsk 28 23 49 25
14 Baranovichi Baranovichi 28 17 42 19
15 Čist́ Čist́ 28 30 89 10
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 Naftan Novopolotsk Naftan 30 25 46 29
14 Neman Grodno Neman Grodno 30 21 36 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 3
Equipo PJ GF GC Puntos
1 Belshina Bobruisk Belshina 32 42 38 53
2 Minsk Minsk 32 45 39 47
3 Dinamo Brest Dinamo Brest 32 32 41 40
4 Naftan Novopolotsk Naftan 32 29 41 37
5 Dnepr Mogilev Dnepr 32 28 42 33
6 Slavia Mozyr Slavia Mozyr 32 24 47 23
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 Torpedo Zhodino Torpedo 26 40 25 47
5 BATE Borisov BATE Borisov 26 42 27 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 Gomel Gomel 30 42 41 46
6 Torpedo Minsk Torpedo 30 37 31 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
TEMPORADA 2002/2003
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Gomel Gomel 30 56 12 74
2 BATE Borisov BATE Borisov 30 70 21 66
3 Dinamo Minsk Dinamo Minsk 30 62 24 64
4 Torpedo Minsk Torpedo 30 54 20 64
5 Shakhtyor Soligorsk Shakhtyor 30 60 23 64
6 Torpedo Zhodino Torpedo 30 44 25 49
7 Neman Grodno Neman Grodno 30 24 35 39
8 Naftan Novopolotsk Naftan 30 39 49 35
9 Dnepr Mogilev Dnepr 30 38 46 34
10 Belshina Bobruisk Belshina 30 44 50 32
11 Dinamo Brest Dinamo Brest 30 21 49 27
12 Energetik-BGU Energetik-BG 30 23 64 25
13 Darida Darida 30 22 45 25
14 FC Mozyr FC Mozyr 30 29 64 25
15 SKVICH Minsk SKVICH Minsk 30 16 42 24
16 Molodechno Molodechno 30 19 52 16

  USO DE MEMORIA  
7,112,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7539
Total Execution Time  0.7551
  CADENA URL  
/historico/Naftan/2020
  GET DATOS  
$_GET['/historico/Naftan/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0136  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 = 'Naftan' AND l.year = 2020 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=4047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=4047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=4047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=4047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258  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 = 55676
0.0152  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 = 49899
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4047 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=363 AND type_rel = 3
0.0169  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 = '4047' ORDER BY l.year DESC,cat.coefficient DESC
0.0164  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 = '4047' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '4047' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 49899 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 55676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=4047 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (62163,56461,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 62163 AND teamId = 4047
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 56461 AND teamId = 4047
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 4047
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '4047' 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 = '4047' and rp.type = 4
0.0131  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 = '4047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2020 e ON e.player_id = p.id AND e.league_id = 55676 WHERE rp.league_id = 55676 AND rp.teamId = 4047 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.0180  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 events2020 e ON e.player_id = p.id AND e.league_id = 55676 WHERE rp.league_id = 55676 AND rp.teamId = 4047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 events2020 e ON e.player_id = p.id AND e.league_id = 55676 WHERE rp.league_id = 55676 AND rp.teamId = 4047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 4047 AND l.year <= 2020 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 `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.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 `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.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 `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 = 43238 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.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 `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.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 `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.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 = 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.0135  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.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 `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.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 = 10166 AND t.round = 10 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 `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.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 `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 = 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.0133  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.0132  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.0133  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.0135  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.0136  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.0137  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.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 `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 = 8971 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC