4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sinđelić Beograd
TEMPORADA 2023/2024
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Zemun Zemun 25 55 20 58
2 Teleoptik Teleoptik 25 52 20 57
3 Zvezdara Zvezdara 26 38 25 46
4 Radnički Obrenovac Radnički 25 36 32 39
5 Studentski Grad Studentski 26 31 43 35
6 Stepojevac Vaga Stepojevac 26 34 31 34
7 Budućnost Dobanovci Budućnost 25 32 37 34
8 FK Brodarac FK Brodarac 26 34 31 33
9 Jedinstvo Surcin Jedinstvo 26 29 31 33
10 Sinđelić Beograd Sinđelić 25 29 32 30
11 Padinska Skela Padinska 25 25 40 30
12 BASK BASK 26 27 21 28
13 Dorćol Dorćol 25 21 26 28
14 Prva Iskra Prva Iskra 26 37 37 27
15 Torlak Torlak 25 19 41 17
16 Rad Beograd Rad Beograd 26 20 52 10
TEMPORADA 2022/2023
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 OFK Beograd OFK Beograd 30 57 16 67
2 Zemun Zemun 30 43 17 67
3 Teleoptik Teleoptik 30 51 24 52
4 Zvezdara Zvezdara 30 39 35 44
5 FK Brodarac FK Brodarac 30 37 40 44
6 Budućnost Dobanovci Budućnost 30 37 28 43
7 Jedinstvo Surcin Jedinstvo 30 21 23 42
8 BASK BASK 30 40 38 40
9 Sinđelić Beograd Sinđelić 30 28 30 38
10 Prva Iskra Prva Iskra 30 33 31 36
11 Radnički Obrenovac Radnički 30 40 39 36
12 Torlak Torlak 30 40 45 36
13 Stepojevac Vaga Stepojevac 30 26 37 35
14 Studentski Grad Studentski 30 34 50 33
15 BSK Borča BSK Borča 30 27 33 32
16 Borac Lazarevac Borac 30 18 85 12
TEMPORADA 2019/2020
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 FK Zlatibor Cajetina Zlatibor 30 33 18 54
2 Grafičar Grafičar 30 49 27 54
3 Bačka Palanka Bačka 30 40 26 53
4 Metalac GM Metalac GM 30 41 34 53
5 Kolubara Kolubara 30 35 25 47
6 Radnički Pirot Radnički 30 34 33 43
7 Kabel Novi Sad Kabel Novi 30 31 20 42
8 Radnički Kragujevac Radnički 30 31 26 42
9 Novi Pazar Novi Pazar 30 32 31 40
10 Žarkovo Žarkovo 30 35 36 40
11 Dinamo Vranje Dinamo 30 34 38 37
12 Zemun Zemun 30 25 29 33
13 Trajal Krusevac Trajal 30 21 30 31
14 Sinđelić Beograd Sinđelić 30 27 55 25
15 Semendrija 1924 Semendrija 30 27 47 22
16 Budućnost Dobanovci Budućnost 30 21 41 22
TEMPORADA 2018/2019
SEGUNDA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK TSC FK TSC 7 16 8 53
2 Javor Ivanjica Javor 7 17 10 46
3 Inđija Inđija 7 9 8 39
4 Radnički Kragujevac Radnički 7 6 4 35
5 Metalac GM Metalac GM 7 6 3 33
6 FK Zlatibor Cajetina Zlatibor 7 7 12 32
7 Bežanija Bežanija 7 8 12 28
8 Sinđelić Beograd Sinđelić 7 7 19 24
TEMPORADA 2017/2018
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Proleter Novi Sad Proleter 30 63 25 65
2 Dinamo Vranje Dinamo 30 47 24 63
3 Metalac GM Metalac GM 30 43 21 57
4 FK TSC FK TSC 30 49 22 54
5 Inđija Inđija 30 30 25 45
6 Sinđelić Beograd Sinđelić 30 31 32 45
7 Bežanija Bežanija 30 35 32 44
8 Teleoptik Teleoptik 30 39 32 40
9 Novi Pazar Novi Pazar 30 28 33 40
10 Budućnost Dobanovci Budućnost 30 33 33 38
11 Radnički Kragujevac Radnički 30 32 39 36
12 Sloboda Uzice Sloboda 30 23 35 34
13 Radnički Pirot Radnički 30 28 39 31
14 Temnic 1924 Temnic 1924 30 24 47 26
15 Pivara Pivara 30 30 53 22
16 Jagodina Jagodina 30 16 59 10
TEMPORADA 2016/2017
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Mačva Šabac Mačva 30 49 26 62
2 Zemun Zemun 30 44 18 61
3 Sloboda Uzice Sloboda 30 43 28 54
4 Bežanija Bežanija 30 36 22 48
5 Inđija Inđija 30 34 30 48
6 Radnički Pirot Radnički 30 30 31 43
7 Jagodina Jagodina 30 39 35 41
8 Budućnost Dobanovci Budućnost 31 33 43 40
9 Dinamo Vranje Dinamo 30 33 43 39
10 Sinđelić Beograd Sinđelić 30 32 31 37
11 Proleter Novi Sad Proleter 30 34 40 36
12 Pivara Pivara 30 31 32 35
13 BSK Borča BSK Borča 30 27 39 33
14 Kolubara Kolubara 31 28 36 32
15 OFK Odzaci OFK Odzaci 30 24 35 26
16 OFK Beograd OFK Beograd 30 25 53 18
TEMPORADA 2015/2016
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Napredak Krusevac Napredak 30 48 26 68
2 Bačka Palanka Bačka 30 52 30 56
3 Pivara Pivara 30 28 19 48
4 Inđija Inđija 30 46 28 45
5 Bežanija Bežanija 30 35 27 43
6 Sinđelić Beograd Sinđelić 30 32 25 42
7 Kolubara Kolubara 30 29 28 42
8 Proleter Novi Sad Proleter 30 32 29 40
9 BSK Borča BSK Borča 30 32 38 40
10 Sloga Petrovac na Mlavi Sloga 30 34 36 39
11 Zemun Zemun 30 29 33 39
12 Dinamo Vranje Dinamo 30 27 38 38
13 Sloboda Uzice Sloboda 30 35 34 35
14 Donji Srem Donji Srem 30 24 38 34
15 Loznica Loznica 30 21 35 31
16 Radnički Kragujevac Radnički 30 23 63 12
TEMPORADA 2014/2015
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Radnik Surdulica Radnik 30 41 14 64
2 Javor Ivanjica Javor 30 47 19 61
3 Metalac GM Metalac GM 30 43 29 52
4 Bačka Palanka Bačka 30 37 30 48
5 Inđija Inđija 30 39 31 46
6 Sinđelić Beograd Sinđelić 30 40 39 40
7 Proleter Novi Sad Proleter 30 33 32 40
8 Sloga Petrovac na Mlavi Sloga 30 37 37 40
9 Bežanija Bežanija 30 25 27 40
10 BSK Borča BSK Borča 30 31 33 38
11 Kolubara Kolubara 30 34 43 38
12 Sloboda Uzice Sloboda 30 24 28 36
13 Moravac Mrštane Moravac 30 32 41 35
14 Jedinstvo Putevi Jedinstvo 30 23 36 29
15 Sloga Kraljevo Sloga 30 22 56 26
16 Mačva Šabac Mačva 30 23 36 25
TEMPORADA 2013/2014
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Mladost Lučani Mladost 30 42 20 60
2 Metalac GM Metalac GM 30 34 14 52
3 Borac Čačak Borac 30 28 19 52
4 Bežanija Bežanija 30 34 26 45
5 BSK Borča BSK Borča 30 37 39 43
6 Sloga Petrovac na Mlavi Sloga 30 35 40 43
7 Sloga Kraljevo Sloga 30 35 31 42
8 Jedinstvo Putevi Jedinstvo 30 30 37 41
9 Proleter Novi Sad Proleter 30 42 36 39
10 Radnik Surdulica Radnik 30 31 36 38
11 Sinđelić Beograd Sinđelić 30 32 36 37
12 Inđija Inđija 30 32 41 37
13 Timok Timok 30 26 35 34
14 Dolina Padina Dolina 30 31 42 34
15 Teleoptik Teleoptik 30 35 40 31
16 Smederevo Smederevo 30 26 38 31
TEMPORADA 2012/2013
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sinđelić Beograd Sinđelić 30 58 26 62
2 Radnički Obrenovac Radnički 30 50 24 58
3 Šumadija Jagnjilo Šumadija 30 45 28 58
4 Zemun Zemun 30 48 33 51
5 Železnik Železnik 30 39 36 43
6 Srem Jakovo Srem Jakovo 30 39 37 43
7 Budućnost Dobanovci Budućnost 30 50 46 42
8 BASK BASK 30 32 31 39
9 Sopot Sopot 30 28 35 39
10 Hajduk Beograd Hajduk 30 40 52 39
11 Žarkovo Žarkovo 30 35 49 34
12 Turbina Vreoci Turbina 30 34 51 34
13 Dorćol Dorćol 30 32 52 34
14 Kovačevac Kovačevac 30 29 38 33
15 Padinska Skela Padinska 30 32 41 30
16 Balkan Mirijevo Balkan 30 25 37 28
TEMPORADA 2011/2012
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 FK Vozdovac FK Vozdovac 30 60 17 66
2 Radnički Obrenovac Radnički 30 42 23 59
3 Zemun Zemun 30 39 30 54
4 Žarkovo Žarkovo 30 37 26 47
5 Šumadija Jagnjilo Šumadija 30 61 41 46
6 Sopot Sopot 30 35 20 46
7 Hajduk Beograd Hajduk 30 32 43 41
8 Sinđelić Beograd Sinđelić 30 41 35 40
9 Kovačevac Kovačevac 30 34 41 38
10 Padinska Skela Padinska 30 29 29 37
11 Dorćol Dorćol 30 27 39 36
12 FK Beograd FK Beograd 30 28 43 36
13 BASK BASK 30 39 46 35
14 Srem Jakovo Srem Jakovo 30 28 45 34
15 Balkan Mirijevo Balkan 30 17 34 31
16 Slavija Beograd Slavija 30 17 54 22
TEMPORADA 2010/2011
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Mladenovac Mladenovac 29 54 16 66
2 Srem Jakovo Srem Jakovo 30 45 26 58
3 Šumadija Jagnjilo Šumadija 30 39 35 46
4 Sinđelić Beograd Sinđelić 29 46 31 42
5 Kovačevac Kovačevac 30 44 43 41
6 Sopot Sopot 30 32 27 40
7 Hajduk Beograd Hajduk 30 35 39 40
8 FK Vozdovac FK Vozdovac 30 27 41 40
9 Radnički Obrenovac Radnički 30 40 32 39
10 Balkan Mirijevo Balkan 30 38 38 39
11 Žarkovo Žarkovo 29 35 30 38
12 FK Beograd FK Beograd 29 32 35 38
13 Dorćol Dorćol 29 29 37 38
14 Palilulac Beograd Palilulac 29 28 27 37
15 Grafičar Grafičar 30 34 36 37
16 Resnik Resnik 30 15 80 12
TEMPORADA 2009/2010
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 BASK BASK 30 49 35 58
2 Radnički Obrenovac Radnički 30 56 28 57
3 Šumadija Jagnjilo Šumadija 30 45 20 56
4 Srem Jakovo Srem Jakovo 30 48 41 43
5 Sinđelić Beograd Sinđelić 30 42 42 40
6 FK Vozdovac FK Vozdovac 30 27 27 40
7 FK Beograd FK Beograd 30 30 31 40
8 Resnik Resnik 30 34 39 39
9 Kovačevac Kovačevac 30 46 52 39
10 Palilulac Beograd Palilulac 30 31 33 38
11 Dorćol Dorćol 30 34 36 36
12 Hajduk Beograd Hajduk 30 42 51 36
13 Mladenovac Mladenovac 30 28 38 35
14 Grafičar Grafičar 30 28 44 34
15 Sopot Sopot 30 28 33 33
16 Železničar Beograd Železničar 30 25 43 24
TEMPORADA 2008/2009
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Zemun Zemun 30 59 12 79
2 Teleoptik Teleoptik 30 54 13 71
3 Šumadija Jagnjilo Šumadija 30 33 19 54
4 Srem Jakovo Srem Jakovo 30 33 32 43
5 Sopot Sopot 30 30 30 39
6 FK Beograd FK Beograd 30 38 39 37
7 Železničar Beograd Železničar 30 26 29 37
8 Dorćol Dorćol 30 31 35 37
9 Radnički Obrenovac Radnički 30 29 34 37
10 Palilulac Beograd Palilulac 30 28 36 36
11 Sinđelić Beograd Sinđelić 30 25 35 35
12 BASK BASK 30 20 31 35
13 Mladenovac Mladenovac 30 24 37 35
14 Lisovic Lisovic 30 23 35 34
15 Padinska Skela Padinska 30 25 40 29
16 Radnicki Novi Beograd Radnicki 30 22 43 19
TEMPORADA 2007/2008
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Kolubara Kolubara 30 40 18 61
2 Radnički Obrenovac Radnički 30 42 26 57
3 Teleoptik Teleoptik 31 41 19 49
4 FK Beograd FK Beograd 30 36 22 49
5 Palilulac Beograd Palilulac 29 44 42 45
6 Srem Jakovo Srem Jakovo 30 32 31 44
7 Dorćol Dorćol 31 41 38 42
8 Šumadija Jagnjilo Šumadija 30 34 26 41
9 Sopot Sopot 29 35 33 41
10 Radnicki Novi Beograd Radnicki 29 35 36 39
11 Železničar Beograd Železničar 30 30 31 38
12 Sinđelić Beograd Sinđelić 29 36 38 38
13 BASK BASK 30 28 38 38
14 Lokomotiva Beograd Lokomotiva 30 39 46 35
15 Posavac Boljevci Posavac 29 26 44 24
16 FK Obilic FK Obilic 29 15 66 10
TEMPORADA 2006/2007
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Hajduk Beograd Hajduk 34 52 15 82
2 Kolubara Kolubara 34 74 29 78
3 Sopot Sopot 34 61 43 59
4 FK Beograd FK Beograd 34 45 29 57
5 Železničar Beograd Železničar 34 47 38 55
6 Radnički Obrenovac Radnički 34 43 31 52
7 Teleoptik Teleoptik 33 44 33 51
8 Palilulac Beograd Palilulac 33 38 41 46
9 Srem Jakovo Srem Jakovo 34 38 40 44
10 Radnicki Novi Beograd Radnicki 34 34 40 42
11 Dorćol Dorćol 34 36 43 42
12 Posavac Boljevci Posavac 34 35 46 42
13 Sinđelić Beograd Sinđelić 34 31 35 41
14 Padinska Skela Padinska 34 41 49 36
15 Milutinac Zemun Milutinac 34 27 43 36
16 Balkan Mirijevo Balkan 34 32 48 27
17 BPI Pekar BPI Pekar 34 21 57 24
18 Budućnost Dobanovci Budućnost 34 17 56 21
TEMPORADA 2005/2006
TERCERA SERBIA Y MONTENEGRO GRUPO 2
Equipo PJ GF GC Puntos
1 BSK Borča BSK Borča 38 86 18 94
2 FK Beograd FK Beograd 38 70 46 75
3 Sopot Sopot 38 65 45 63
4 Teleoptik Teleoptik 38 71 37 62
5 Kolubara Kolubara 38 53 54 60
6 Padinska Skela Padinska 38 42 33 54
7 Srem Jakovo Srem Jakovo 38 45 42 53
8 Železničar Beograd Železničar 38 52 49 52
9 Balkan Mirijevo Balkan 38 45 50 50
10 Sinđelić Beograd Sinđelić 38 41 41 49
11 Posavac Boljevci Posavac 38 55 70 49
12 Hajduk Beograd Hajduk 38 41 49 48
13 Dorćol Dorćol 38 43 50 47
14 BPI Pekar BPI Pekar 38 47 48 46
15 Radnicki Novi Beograd Radnicki 38 52 60 46
16 Radnički Obrenovac Radnički 38 45 56 46
17 Budućnost Dobanovci Budućnost 38 43 59 46
18 Žarkovo Žarkovo 38 30 48 45
19 Grafičar Grafičar 38 40 70 35
20 Jedinstvo Surcin Jedinstvo 38 38 79 33

  USO DE MEMORIA  
6,844,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5105
Total Execution Time  0.5117
  CADENA URL  
/historico/Sin-Elic-Beograd
  GET DATOS  
$_GET['/historico/Sin-Elic-Beograd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0117  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 = 'Sin-Elic-Beograd' 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.0106  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=17393 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=17393 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0214  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 = 73438
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17393 AND type_rel = 2
0.0113  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 = '17393' ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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 = '17393' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '17393' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 73438 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=17393 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (73438) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 73438 AND teamId = 17393
0.0109  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 = 73438 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '17393' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17393' and rp.type = 4
0.0107  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 = '17393' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0107  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 = 73438 WHERE rp.league_id = 73438 AND rp.teamId = 17393 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.0107  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 = 73438 WHERE rp.league_id = 73438 AND rp.teamId = 17393 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 73438 WHERE rp.league_id = 73438 AND rp.teamId = 17393 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 17393 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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 = 73438 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.0109  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 = 68874 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.0108  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 = 43971 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 49785 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 39255 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 33950 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 15515 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 3832 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 2855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 25182 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 25190 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 25201 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 25211 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 25224 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 28186 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 28192 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 14756 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC