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 2023/2024
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slavia Mozyr Slavia Mozyr 5 11 5 13
2 Dinamo Brest Dinamo Brest 6 15 5 12
3 Neman Grodno Neman Grodno 5 8 4 12
4 Torpedo Zhodino Torpedo 5 4 1 10
5 Vitebsk Vitebsk 6 7 5 10
6 Dinamo Minsk Dinamo Minsk 5 8 2 9
7 Arsenal Dzyarzhynsk Arsenal 5 5 2 8
8 Gomel Gomel 5 8 8 5
9 Naftan Novopolotsk Naftan 6 7 8 5
10 Isloch Isloch 5 5 6 5
11 Dnepr Mogilev Dnepr 5 2 5 5
12 BATE Borisov BATE Borisov 6 3 7 5
13 FK Smorgon FK Smorgon 5 7 14 5
14 Minsk Minsk 5 3 8 2
15 Slutsk Slutsk 5 2 8 1
16 Shakhtyor Soligorsk Shakhtyor 5 2 9 -16
TEMPORADA 2022/2023
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dinamo Minsk Dinamo Minsk 28 72 21 69
2 Neman Grodno Neman Grodno 28 60 22 62
3 Torpedo Zhodino Torpedo 28 33 18 49
4 Isloch Isloch 28 40 29 47
5 BATE Borisov BATE Borisov 28 49 32 47
6 Gomel Gomel 28 45 48 41
7 Slavia Mozyr Slavia Mozyr 28 32 30 40
8 Slutsk Slutsk 28 38 40 35
9 Minsk Minsk 28 21 26 33
10 Dinamo Brest Dinamo Brest 28 33 50 30
11 FK Smorgon FK Smorgon 28 28 59 24
12 Naftan Novopolotsk Naftan 28 28 57 23
13 Shakhtyor Soligorsk Shakhtyor 28 50 40 9
14 Energetik-BGU Energetik-BG 28 25 42 4
15 Belshina Bobruisk Belshina 28 21 61 3
TEMPORADA 2021/2022
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Naftan Novopolotsk Naftan 24 55 19 53
2 FK Smorgon FK Smorgon 24 46 27 52
3 Shakhtyor Petrikov Shakhtyor 24 69 20 45
4 Maxline Vitebsk Maxline 24 45 34 41
5 Ostrovets Ostrovets 24 42 34 40
6 Lokomotiv Gomel Lokomotiv 24 39 24 39
7 Volna Pinsk Volna Pinsk 24 44 35 36
8 Molodechno Molodechno 24 30 45 29
9 FK Orsha FK Orsha 24 33 52 27
10 FK Lida FK Lida 24 35 43 26
11 FC Slonim FC Slonim 24 24 53 18
12 Osipovichy Osipovichy 24 21 53 13
13 Baranovichi Baranovichi 24 25 69 12
TEMPORADA 2020/2021
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Arsenal Dzyarzhynsk Arsenal 33 59 22 68
2 Belshina Bobruisk Belshina 33 69 42 63
3 Krumkachy Krumkachy 33 58 31 60
4 Volna Pinsk Volna Pinsk 33 49 39 56
5 Dnepr Mogilev Dnepr 33 58 38 55
6 Lokomotiv Gomel Lokomotiv 33 56 39 54
7 Shakhtyor Petrikov Shakhtyor 33 50 56 46
8 Naftan Novopolotsk Naftan 33 44 46 44
9 FK Orsha FK Orsha 33 41 60 34
10 Baranovichi Baranovichi 33 38 72 28
11 FK Lida FK Lida 33 33 75 21
12 FC Slonim FC Slonim 33 27 62 16
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 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 2
Equipo PJ GF GC Puntos
1 Dinamo Minsk Dinamo Minsk 10 15 13 47
2 Belshina Bobruisk Belshina 10 18 10 25
3 Dinamo Brest Dinamo Brest 10 14 11 16
4 Naftan Novopolotsk Naftan 10 10 12 16
5 Dnepr Mogilev Dnepr 10 8 13 10
6 Slavia Mozyr Slavia Mozyr 10 8 14 7
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

  USO DE MEMORIA  
7,016,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7004
Total Execution Time  0.7016
  CADENA URL  
/historico/Naftan
  GET DATOS  
$_GET['/historico/Naftan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0174  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 = 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.0131  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.0132  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.0131  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.0130  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.0274  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 = 74849
0.0134  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 = 71518
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4047 AND type_rel = 2
0.0137  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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.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 = 74849 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (74849,71518,71432) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 74849 AND teamId = 4047
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 71518 AND teamId = 4047
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4047
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 FROM `tables2024` 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 = 74849 AND t.round = 6 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 = '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.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 = '4047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 events2024 e ON e.player_id = p.id AND e.league_id = 74849 WHERE rp.league_id = 74849 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.0133  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 events2024 e ON e.player_id = p.id AND e.league_id = 74849 WHERE rp.league_id = 74849 AND rp.teamId = 4047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2024 e ON e.player_id = p.id AND e.league_id = 74849 WHERE rp.league_id = 74849 AND rp.teamId = 4047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 74849 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 70895 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 `tables2022` 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 = 67261 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 `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 = 62163 AND t.round = 33 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.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 = 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.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 = 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.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.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 `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.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 = 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.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.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.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 `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.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 `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.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 `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