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

Inđija

Entrenador: Jovan Golic

TEMPORADA 2023/2024
SEGUNDA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 OFK Beograd OFK Beograd 32 58 27 68
2 Jedinstvo Ub Jedinstvo 32 40 33 53
3 Tekstilac Odžaci Tekstilac 32 39 23 51
4 Inđija Inđija 32 38 27 51
5 Smederevo Smederevo 32 36 25 51
6 Mačva Šabac Mačva 32 31 25 45
7 Grafičar Grafičar 32 45 45 45
8 Sremska Mitrovica Sremska 32 28 28 45
TEMPORADA 2022/2023
SEGUNDA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 IMT Novi Beograd Novi Beograd 30 45 27 61
2 Železničar Pancevo Železničar 30 47 25 57
3 Grafičar Grafičar 30 57 38 50
4 Sremska Mitrovica Sremska 30 30 26 45
5 Jedinstvo Ub Jedinstvo 30 32 26 44
6 Inđija Inđija 30 38 30 43
7 RFK Novi Sad Novi 30 34 31 43
8 Radnicki Novi Beograd Radnicki 30 27 35 40
9 Sloboda Uzice Sloboda 30 33 34 37
10 Mačva Šabac Mačva 30 28 31 37
11 OFK Vršac OFK Vršac 30 28 33 37
12 Metalac GM Metalac GM 30 29 36 35
13 Trajal Krusevac Trajal 30 29 37 35
14 Loznica Loznica 30 28 45 31
15 Rad Beograd Rad Beograd 30 32 46 28
16 FK Zlatibor Cajetina Zlatibor 30 26 43 23
TEMPORADA 2021/2022
SEGUNDA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Mladost GAT Mladost GAT 37 48 24 72
2 Javor Ivanjica Javor 37 57 30 69
3 Železničar Pancevo Železničar 37 54 36 68
4 IMT Novi Beograd Novi Beograd 37 69 37 67
5 Inđija Inđija 37 55 38 64
6 Žarkovo Žarkovo 37 40 41 49
7 Sremska Mitrovica Sremska 37 42 45 48
8 Loznica Loznica 37 31 38 45
TEMPORADA 2020/2021
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 38 114 20 108
2 Partizan Belgrade Partizan 38 95 20 95
3 FK Cukaricki Cukaricki 38 69 34 74
4 Vojvodina Novi Sad Vojvodina 38 62 41 71
5 FK TSC FK TSC 38 68 50 58
6 Radnik Surdulica Radnik 38 55 49 55
7 Mladost Lučani Mladost 38 43 59 54
8 Proleter Novi Sad Proleter 38 40 47 53
9 FK Spartak Subotica Spartak 38 54 53 52
10 Metalac GM Metalac GM 38 48 53 52
11 Napredak Krusevac Napredak 38 44 51 50
12 Novi Pazar Novi Pazar 38 50 60 49
13 Radnicki Nis Radnicki 38 37 39 49
14 FK Vozdovac FK Vozdovac 38 49 59 48
15 Rad Beograd Rad Beograd 38 44 57 48
16 Javor Ivanjica Javor 38 45 53 46
17 Inđija Inđija 38 29 66 35
18 FK Zlatibor Cajetina Zlatibor 38 28 64 29
19 Mačva Šabac Mačva 38 26 81 25
20 Bačka Palanka Bačka 38 24 68 16
TEMPORADA 2019/2020
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 30 68 18 78
2 Partizan Belgrade Partizan 30 69 25 64
3 Vojvodina Novi Sad Vojvodina 30 47 27 62
4 FK TSC FK TSC 30 59 34 59
5 Radnicki Nis Radnicki 30 51 37 52
6 FK Cukaricki Cukaricki 30 42 36 51
7 FK Spartak Subotica Spartak 30 46 48 46
8 FK Vozdovac FK Vozdovac 30 45 41 45
9 Mladost Lučani Mladost 30 31 40 43
10 Napredak Krusevac Napredak 30 33 41 33
11 Radnik Surdulica Radnik 30 34 50 31
12 Proleter Novi Sad Proleter 30 30 42 30
13 Javor Ivanjica Javor 30 43 62 28
14 Inđija Inđija 30 26 48 25
15 Rad Beograd Rad Beograd 30 23 63 15
16 Mačva Šabac Mačva 30 18 53 13
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
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Napredak Krusevac Napredak 34 74 25 80
2 FK Cukaricki Cukaricki 34 52 26 67
3 FK Vozdovac FK Vozdovac 34 49 22 63
4 Proleter Novi Sad Proleter 34 53 43 57
5 Metalac GM Metalac GM 34 48 32 56
6 Jedinstvo Putevi Jedinstvo 34 40 32 56
7 Borac Čačak Borac 34 47 25 54
8 Bežanija Bežanija 34 41 32 44
9 Mladost Lučani Mladost 34 31 35 43
10 Sloga Kraljevo Sloga 34 32 39 43
11 Timok Timok 34 37 48 43
12 Inđija Inđija 34 27 35 42
13 Teleoptik Teleoptik 34 25 43 36
14 Radnički Nova Pazova Radnički 34 35 44 35
15 Banat Zrenjanin Banat 34 29 47 35
16 Mladenovac Mladenovac 34 21 41 32
17 Kolubara Kolubara 34 30 48 27
18 RFK Novi Sad Novi 34 17 71 21
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
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 75 21 76
2 Crvena Zvezda Crvena 30 52 18 70
3 Vojvodina Novi Sad Vojvodina 30 44 14 67
4 Rad Beograd Rad Beograd 30 38 21 52
5 FK Spartak Subotica Spartak 30 34 27 43
6 Sloboda Uzice Sloboda 30 34 35 43
7 OFK Beograd OFK Beograd 30 27 26 42
8 Javor Ivanjica Javor 30 21 24 41
9 Borac Čačak Borac 30 22 31 36
10 Smederevo Smederevo 30 24 31 35
11 BSK Borča BSK Borča 30 23 37 33
12 Jagodina Jagodina 30 26 33 32
13 Hajduk Kula Hajduk Kula 30 25 37 29
14 Metalac GM Metalac GM 30 21 38 29
15 Inđija Inđija 30 29 47 26
16 FK Cukaricki Cukaricki 30 10 65 5
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
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 BSK Borča BSK Borča 34 44 17 70
2 Smederevo Smederevo 34 48 23 66
3 Mladi Radnik Mladi Radnik 34 37 24 62
4 FK Spartak Subotica Spartak 34 46 27 60
5 Inđija Inđija 34 49 34 55
6 Metalac GM Metalac GM 34 38 30 55
7 Sloboda Uzice Sloboda 34 53 37 51
8 Pivara Pivara 34 31 35 50
9 Srem Sremska Srem Sremska 34 33 35 44
10 Mladost Apatin Mladost 34 29 30 43
11 RFK Novi Sad Novi 34 41 42 42
12 Kolubara Kolubara 34 33 36 42
13 Dinamo Vranje Dinamo 34 36 39 39
14 Mladost Lučani Mladost 34 25 43 38
15 Bežanija Bežanija 34 34 40 37
16 Novi Pazar Novi Pazar 34 33 47 36
17 FK Vozdovac FK Vozdovac 34 32 43 32
18 Hajduk Beograd Hajduk 34 20 80 10

  USO DE MEMORIA  
6,942,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.7670
Total Execution Time  0.7692
  CADENA URL  
/historico/In-Ija
  GET DATOS  
$_GET['/historico/In-Ija']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0139  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 = 'In-Ija' 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.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=17387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17387 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=17387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75864
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17387 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17387 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (677086,842203) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '17387' ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '17387' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '17387' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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=17387 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75864,74071,71897,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.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 75864 AND teamId = 17387
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 74071 AND teamId = 17387
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71897 AND teamId = 17387
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17387
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 `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 = 75864 AND t.round = 2 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 = '17387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17387' and rp.type = 4
0.0127  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 = '17387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0172  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 = 75864 WHERE rp.league_id = 75864 AND rp.teamId = 17387 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.0147  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 = 75864 WHERE rp.league_id = 75864 AND rp.teamId = 17387 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 75864 WHERE rp.league_id = 75864 AND rp.teamId = 17387 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 17387 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73280 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 `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 = 75864 AND t.round = 2 ORDER BY team.conference ASC,t.position 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 `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 = 71493 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 `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 = 67938 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.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 `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 = 63193 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.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 `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 = 67313 AND t.round = 7 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 `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 = 56989 AND t.round = 38 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 `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 = 49967 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.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 = 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.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 `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.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 `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.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 = 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.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 = 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.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 `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.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 `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.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 `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 = 14845 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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.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 `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 = 10484 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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.0146  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 = 14849 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75864 ORDER BY nameShow LIMIT 100