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

Radnicki Nis

Entrenador: Dejan Joksimović

TEMPORADA 2018/2019
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 7 17 4 60
2 Radnicki Nis Radnicki 7 13 13 48
3 Partizan Belgrade Partizan 7 13 8 42
4 FK Cukaricki Cukaricki 7 15 11 39
5 Mladost Lučani Mladost 7 10 8 34
6 Napredak Krusevac Napredak 7 14 15 28
7 Vojvodina Novi Sad Vojvodina 7 3 17 22
8 Proleter Novi Sad Proleter 7 3 12 22
TEMPORADA 2017/2018
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 7 21 4 60
2 Partizan Belgrade Partizan 7 12 10 43
3 Radnicki Nis Radnicki 7 17 11 37
4 FK Spartak Subotica Spartak 7 7 10 37
5 FK Vozdovac FK Vozdovac 7 7 13 33
6 FK Cukaricki Cukaricki 7 11 18 32
7 Napredak Krusevac Napredak 7 8 13 30
8 Vojvodina Novi Sad Vojvodina 7 10 14 28
TEMPORADA 2016/2017
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 7 19 5 58
2 Crvena Zvezda Crvena 7 18 8 55
3 Vojvodina Novi Sad Vojvodina 7 7 5 43
4 Mladost Lučani Mladost 7 11 15 36
5 Radnicki Nis Radnicki 7 10 10 32
6 Napredak Krusevac Napredak 7 9 13 30
7 FK Vozdovac FK Vozdovac 7 6 13 27
8 Javor Ivanjica Javor 7 2 13 22
TEMPORADA 2015/2016
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 7 15 8 54
2 Partizan Belgrade Partizan 7 13 7 40
3 FK Cukaricki Cukaricki 7 11 13 39
4 Vojvodina Novi Sad Vojvodina 7 13 6 36
5 Radnicki Nis Radnicki 7 14 12 35
6 Borac Čačak Borac 7 9 14 30
7 FK Vozdovac FK Vozdovac 7 4 7 25
8 Radnik Surdulica Radnik 7 7 19 25
TEMPORADA 2014/2015
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 67 22 71
2 Crvena Zvezda Crvena 30 46 20 64
3 FK Cukaricki Cukaricki 30 48 24 57
4 Vojvodina Novi Sad Vojvodina 30 44 36 52
5 Novi Pazar Novi Pazar 30 39 28 47
6 Rad Beograd Rad Beograd 30 33 38 43
7 Mladost Lučani Mladost 30 41 47 40
8 OFK Beograd OFK Beograd 30 35 43 39
9 Radnicki Nis Radnicki 30 25 31 37
10 Jagodina Jagodina 30 38 45 35
11 FK Spartak Subotica Spartak 30 23 33 34
12 FK Vozdovac FK Vozdovac 30 24 37 34
13 Borac Čačak Borac 30 29 35 33
14 Napredak Krusevac Napredak 30 23 34 31
15 Donji Srem Donji Srem 30 25 42 26
16 Radnički Kragujevac Radnički 30 17 42 19
TEMPORADA 2013/2014
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 30 66 27 72
2 Partizan Belgrade Partizan 30 64 20 71
3 Jagodina Jagodina 30 40 30 48
4 Vojvodina Novi Sad Vojvodina 30 38 32 45
5 FK Cukaricki Cukaricki 30 30 31 44
6 Radnicki Nis Radnicki 30 28 22 43
7 FK Vozdovac FK Vozdovac 30 34 35 42
8 Novi Pazar Novi Pazar 30 32 34 39
9 Napredak Krusevac Napredak 30 42 44 35
10 FK Spartak Subotica Spartak 30 24 37 34
11 OFK Beograd OFK Beograd 30 31 43 33
12 Donji Srem Donji Srem 30 29 40 32
13 Radnički Kragujevac Radnički 30 30 49 32
14 Rad Beograd Rad Beograd 30 19 37 29
15 Javor Ivanjica Javor 30 29 38 29
16 Sloboda Uzice Sloboda 30 21 38 28
TEMPORADA 2012/2013
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 71 16 73
2 Crvena Zvezda Crvena 30 55 35 62
3 Vojvodina Novi Sad Vojvodina 30 40 20 61
4 Jagodina Jagodina 30 35 26 50
5 Sloboda Uzice Sloboda 30 39 37 45
6 OFK Beograd OFK Beograd 30 34 32 45
7 Rad Beograd Rad Beograd 30 32 30 44
8 Hajduk Kula Hajduk Kula 30 36 32 38
9 FK Spartak Subotica Spartak 30 36 39 36
10 Javor Ivanjica Javor 30 38 40 34
11 Donji Srem Donji Srem 30 26 34 34
12 Radnicki Nis Radnicki 30 30 44 34
13 Radnički Kragujevac Radnički 30 25 35 31
14 Novi Pazar Novi Pazar 30 29 40 30
15 BSK Borča BSK Borča 30 26 57 30
16 Smederevo Smederevo 30 18 53 15
TEMPORADA 2011/2012
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Radnicki Nis Radnicki 34 52 28 67
2 Donji Srem Donji Srem 34 34 15 61
3 Mladost Lučani Mladost 34 42 27 53
4 Bežanija Bežanija 34 33 15 52
5 Inđija Inđija 34 35 32 52
6 Napredak Krusevac Napredak 34 39 29 51
7 Sloga Kraljevo Sloga 34 33 33 50
8 Teleoptik Teleoptik 34 45 26 49
9 Proleter Novi Sad Proleter 34 33 34 49
10 RFK Novi Sad Novi 34 37 42 43
11 Mladenovac Mladenovac 34 46 52 43
12 Kolubara Kolubara 34 35 43 43
13 Banat Zrenjanin Banat 34 35 41 41
14 FK Cukaricki Cukaricki 34 31 39 41
15 Radnički Sombor Radnički 34 25 34 41
16 Mladi Radnik Mladi Radnik 34 29 38 36
17 Sinđelić Niš Sinđelić 34 34 50 31
18 Srem Sremska Srem Sremska 34 27 67 20
TEMPORADA 2010/2011
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Radnicki Nis Radnicki 30 55 21 63
2 Radnički Pirot Radnički 30 51 33 52
3 Radnik Surdulica Radnik 30 43 36 46
4 Radnički Svilajnac Radnički 30 43 44 46
5 Vlasina Vlasina 30 33 33 45
6 Car Konstantin Konstantin 30 50 41 44
7 Sloga Despotovac Sloga 30 49 50 43
8 Svrljig Svrljig 30 40 42 43
9 Kopaonik Kopaonik 30 28 32 43
10 Timok Timok 30 39 34 42
11 Žitorađa Žitorađa 30 46 43 42
12 Trstenik PPT Trstenik 30 31 33 42
13 Hajduk Veljko Hajduk 30 41 44 42
14 Dubočica Dubočica 30 37 36 37
15 Jedinstvo Paraćin Jedinstvo 30 37 51 31
16 Rudar Alpos Rudar Alpos 30 20 70 18
TEMPORADA 2009/2010
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Inđija Inđija 34 47 26 60
2 Sloboda Uzice Sloboda 34 40 24 58
3 Kolubara Kolubara 34 37 31 56
4 Bežanija Bežanija 34 34 28 53
5 RFK Novi Sad Novi 34 34 29 51
6 Teleoptik Teleoptik 34 38 31 50
7 Proleter Novi Sad Proleter 34 41 35 46
8 Srem Sremska Srem Sremska 34 34 37 46
9 Novi Pazar Novi Pazar 34 33 38 46
10 Banat Zrenjanin Banat 34 31 28 45
11 Radnički Sombor Radnički 34 30 32 45
12 Zemun Zemun 34 39 36 43
13 Dinamo Vranje Dinamo 34 32 38 43
14 Mladost Lučani Mladost 34 33 31 42
15 Radnicki Nis Radnicki 34 33 35 41
16 Sloga Kraljevo Sloga 34 28 32 39
17 Pivara Pivara 34 32 48 32
18 Mladost Apatin Mladost 34 24 61 28
TEMPORADA 2008/2009
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Radnicki Nis Radnicki 28 59 16 69
2 Timok Timok 28 44 14 57
3 Hajduk Veljko Hajduk 28 39 26 50
4 Dubočica Dubočica 28 38 27 47
5 Sinđelić Niš Sinđelić 28 31 24 43
6 Balkanski Balkanski 28 34 32 38
7 Car Konstantin Konstantin 28 34 35 34
8 Kopaonik Kopaonik 28 30 33 33
9 Svrljig Svrljig 28 27 34 33
10 Radnički Pirot Radnički 28 22 30 32
11 Jedinstvo Paraćin Jedinstvo 28 29 46 32
12 Radnik Surdulica Radnik 28 31 35 31
13 Župa Župa 28 22 40 30
14 Vlasina Vlasina 28 33 51 28
15 Toplicanin Prokuplje Toplicanin 28 21 51 23
TEMPORADA 2007/2008
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Javor Ivanjica Javor 34 38 12 70
2 Jagodina Jagodina 34 37 19 58
3 BSK Borča BSK Borča 34 38 21 58
4 Rad Beograd Rad Beograd 34 50 34 57
5 FK Vozdovac FK Vozdovac 34 37 27 57
6 Metalac GM Metalac GM 34 33 26 49
7 Srem Sremska Srem Sremska 34 43 41 47
8 Mladost Apatin Mladost 34 30 31 47
9 Pivara Pivara 34 34 29 46
10 RFK Novi Sad Novi 34 31 30 46
11 Sloboda Uzice Sloboda 34 34 34 45
12 Novi Pazar Novi Pazar 34 29 39 45
13 Hajduk Beograd Hajduk 34 28 33 44
14 Radnicki Nis Radnicki 34 29 31 43
15 Zemun Zemun 34 28 38 42
16 Vlasina Vlasina 34 35 47 37
17 Mladenovac Mladenovac 34 28 51 30
18 Radnički Pirot Radnički 34 16 55 9
TEMPORADA 2006/2007
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Mladost Lučani Mladost 38 49 19 82
2 FK Cukaricki Cukaricki 38 42 15 70
3 Napredak Krusevac Napredak 38 52 38 65
4 BSK Borča BSK Borča 38 55 36 62
5 Rad Beograd Rad Beograd 38 53 34 62
6 Radnički Pirot Radnički 38 52 36 59
7 Sloboda Uzice Sloboda 38 47 42 59
8 Pivara Pivara 38 38 26 56
9 Vlasina Vlasina 38 38 37 56
10 Mladenovac Mladenovac 38 55 44 55
11 Radnicki Nis Radnicki 38 45 35 55
12 Javor Ivanjica Javor 38 35 42 54
13 Novi Pazar Novi Pazar 38 45 51 53
14 Srem Sremska Srem Sremska 38 39 47 48
15 Inđija Inđija 38 42 51 46
16 Dinamo Vranje Dinamo 38 33 37 45
17 Mačva Šabac Mačva 38 27 49 41
18 BASK BASK 38 32 46 35
19 Spartak Sub Spartak Sub 38 35 64 26
20 FK Obilic FK Obilic 38 16 81 6
TEMPORADA 2005/2006
SEGUNDA SERBIA Y MONTENEGRO GRUPO 2
Equipo PJ GF GC Puntos
1 Bežanija Bežanija 38 69 25 82
2 Mladost Apatin Mladost 38 56 18 78
3 Pivara Pivara 38 59 28 76
4 FK Cukaricki Cukaricki 38 64 29 75
5 Srem Sremska Srem Sremska 38 46 41 59
6 Napredak Krusevac Napredak 38 49 43 58
7 Mačva Šabac Mačva 38 54 55 55
8 Sloboda Uzice Sloboda 38 44 42 52
9 FK Spartak Subotica Spartak 38 43 41 51
10 Radnicki Nis Radnicki 38 37 40 51
11 BASK BASK 38 47 54 50
12 Mladenovac Mladenovac 38 36 46 47
13 Radnički Pirot Radnički 38 50 52 46
14 Vlasina Vlasina 38 37 46 44
15 Novi Pazar Novi Pazar 38 34 54 44
16 PSK Pancevo PSK Pancevo 38 47 58 40
17 Jedinstvo Ub Jedinstvo 38 37 54 40
18 Radnički Kragujevac Radnički 38 36 59 39
19 RFK Novi Sad Novi 38 31 53 35
20 OFK Nis OFK Nis 38 26 64 27
TEMPORADA 2004/2005
SEGUNDA SERBIA Y MONTENEGRO GRUPO 2
Equipo PJ GF GC Puntos
1 Buducnost BD Buducnost 38 69 34 76
2 Javor Ivanjica Javor 38 44 30 74
3 Rad Beograd Rad Beograd 38 64 30 71
4 Mladost Apatin Mladost 38 50 30 63
5 Bežanija Bežanija 38 58 53 58
6 Napredak Krusevac Napredak 38 46 37 55
7 Jedinstvo Ub Jedinstvo 38 44 35 53
8 FK Spartak Subotica Spartak 38 53 44 52
9 Srem Sremska Srem Sremska 38 50 48 52
10 Novi Pazar Novi Pazar 38 37 39 52
11 Mačva Šabac Mačva 38 44 51 52
12 FK Vozdovac FK Vozdovac 38 46 37 51
13 RFK Novi Sad Novi 38 43 40 51
14 OFK Nis OFK Nis 38 39 46 50
15 Radnicki Nis Radnicki 38 40 44 49
16 Vlasina Vlasina 38 45 53 48
17 Radnički Obrenovac Radnički 38 26 50 43
18 Proleter Zrenjanin Proleter 38 38 58 40
19 Kosanica Kosanica 38 20 64 29
20 Mladost Lučani Mladost 38 27 60 26
TEMPORADA 2002/2003
SERBIA Y MONTENEGRO
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 34 88 36 89
2 Crvena Zvezda Crvena 34 68 26 70
3 OFK Beograd OFK Beograd 34 57 36 63
4 Železnik Železnik 34 56 37 62
5 Sutjeska Sutjeska 34 43 32 62
6 Vojvodina Novi Sad Vojvodina 34 48 36 56
7 FK Obilic FK Obilic 34 45 35 51
8 Zeta Zeta 34 51 43 51
9 Hajduk Kula Hajduk Kula 34 39 29 48
10 Zemun Zemun 34 42 39 47
11 Smederevo Smederevo 34 44 44 45
12 Radnički Obrenovac Radnički 34 35 41 44
13 Rad Beograd Rad Beograd 34 39 43 43
14 FK Cukaricki Cukaricki 34 42 56 37
15 Javor Ivanjica Javor 34 21 44 34
16 Mogren Mogren 34 33 76 21
17 FK Rudar Pljevlja Rudar 34 19 62 18
18 Radnicki Nis Radnicki 34 23 78 11

  USO DE MEMORIA  
7,478,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1867
Total Execution Time  0.1879
  CADENA URL  
/historico/Radnicki-N/2019
  GET DATOS  
$_GET['/historico/Radnicki-N/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0037  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 = 'Radnicki-N' AND l.year = 2019 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.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=13464 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=13464 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=13464 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=13464 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=13464 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=13464 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=13464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 43962
0.0028  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 = 49452
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 = 45283
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13464 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13464 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (428130,428725,660234,870256,974051) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '13464' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '13464' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 45283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 43956 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 49452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=13464 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (51367,50131,49967,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 49967 AND teamId = 13464
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 50131 AND teamId = 13464
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 51367 AND teamId = 13464
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 13464
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 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 = 43962 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0043  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 events2019 e ON e.player_id = p.id AND e.league_id = 43962 WHERE rp.league_id = 43962 AND rp.teamId = 13464 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.0043  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 events2019 e ON e.player_id = p.id AND e.league_id = 43962 WHERE rp.league_id = 43962 AND rp.teamId = 13464 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2019 e ON e.player_id = p.id AND e.league_id = 43962 WHERE rp.league_id = 43962 AND rp.teamId = 13464 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 13464 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 43962 AND t.round = 30 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 `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 = 49452 AND t.round = 7 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 `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 = 38794 AND t.round = 30 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 `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 = 43253 AND t.round = 7 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 = 33340 AND t.round = 30 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 `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 = 38288 AND t.round = 7 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 `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 = 15339 AND t.round = 30 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 `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 = 23658 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 3820 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 `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 = 2872 AND t.round = 30 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 `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 = 10480 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 14846 AND t.round = 34 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 = 25204 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 14848 AND t.round = 34 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 = 25228 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 14850 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 14851 AND t.round = 38 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 `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 = 14739 AND t.round = 38 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 `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 = 14741 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 14656 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC