4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Jagodina
TEMPORADA 2023/2024
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Trajal Krusevac Trajal 23 59 12 69
2 Radnički Pirot Radnički 23 48 32 40
3 FK Mesevo FK Mesevo 23 42 33 40
4 Sinđelić Niš Sinđelić 23 36 31 40
5 Jedinstvo Krusevac 1936 Jedinstvo 23 30 23 37
6 SFS Borac SFS Borac 23 41 41 37
7 Radnički Svilajnac Radnički 23 54 32 36
8 Jagodina Jagodina 23 29 24 35
9 Dunav Prahovo Dunav 23 29 34 32
10 Budućnost Popovac Budućnost 23 39 39 31
11 Jedinstvo Paraćin Jedinstvo 23 26 39 28
12 Djerdap Kladovo Djerdap 23 26 43 27
13 Vlasina Vlasina 23 32 33 24
14 Pcinja Trgoviste Pcinja 23 30 48 22
15 Timočanin Timočanin 23 26 41 18
16 Žitorađa Žitorađa 23 18 60 11
TEMPORADA 2022/2023
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dubočica Dubočica 30 72 22 69
2 Radnički Pirot Radnički 30 66 27 67
3 Budućnost Popovac Budućnost 30 57 33 60
4 SFS Borac SFS Borac 30 43 37 47
5 Radnički Svilajnac Radnički 30 54 38 46
6 FK Mesevo FK Mesevo 30 50 45 45
7 Timočanin Timočanin 30 52 52 45
8 Jedinstvo Paraćin Jedinstvo 30 42 35 44
9 Jagodina Jagodina 30 44 38 41
10 Dunav Prahovo Dunav 30 41 39 40
11 Pcinja Trgoviste Pcinja 30 40 40 39
12 Vlasina Vlasina 30 34 47 36
13 Toplicanin Prokuplje Toplicanin 30 47 59 34
14 Brzi Brod Brzi Brod 30 31 65 32
15 Timok Timok 30 24 59 24
16 Car Konstantin Konstantin 30 22 83 4
TEMPORADA 2021/2022
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Trajal Krusevac Trajal 28 42 9 68
2 Budućnost Popovac Budućnost 28 43 24 54
3 Radnički Svilajnac Radnički 28 48 30 48
4 Radnički Pirot Radnički 28 62 31 47
5 Jagodina Jagodina 28 33 28 43
6 Dubočica Dubočica 28 48 34 42
7 Timočanin Timočanin 28 46 42 41
8 Vlasina Vlasina 28 38 40 40
9 Pcinja Trgoviste Pcinja 28 38 40 39
10 Jedinstvo Paraćin Jedinstvo 28 28 31 34
11 FK Mesevo FK Mesevo 28 31 40 34
12 Brzi Brod Brzi Brod 28 27 45 32
13 Hajduk Veljko Hajduk 28 24 42 31
14 Rembas Rembas 28 32 47 27
15 Sloga Leskovac Sloga 28 18 75 6
16 Dinamo Vranje Dinamo 0 0 0 0
TEMPORADA 2020/2021
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Radnički Kragujevac Radnički 34 52 26 69
2 Kolubara Kolubara 34 53 31 69
3 Kabel Novi Sad Kabel Novi 34 41 18 65
4 IMT Novi Beograd Novi Beograd 34 57 35 60
5 Loznica Loznica 34 57 42 54
6 Žarkovo Žarkovo 34 35 34 53
7 Grafičar Grafičar 34 46 34 51
8 Budućnost Dobanovci Budućnost 34 39 37 50
9 Sremska Mitrovica Sremska 34 37 31 45
10 Železničar Pancevo Železničar 34 38 43 44
11 Borac Čačak Borac 34 38 37 42
12 Dinamo Vranje Dinamo 34 40 51 39
13 Dubočica Dubočica 34 30 43 39
14 Radnički Pirot Radnički 34 32 46 39
15 Trajal Krusevac Trajal 34 31 44 35
16 Jagodina Jagodina 34 30 48 35
17 Zemun Zemun 34 24 51 27
18 Sloga Kraljevo Sloga 34 24 53 26
TEMPORADA 2019/2020
TERCERA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Jagodina Jagodina 17 32 11 39
2 Budućnost Popovac Budućnost 17 27 6 34
3 Sinđelić Niš Sinđelić 17 27 15 33
4 Toplicanin Prokuplje Toplicanin 17 23 14 31
5 SFS Borac SFS Borac 17 23 14 30
6 Vlasina Vlasina 17 28 16 29
7 Timočanin Timočanin 17 22 17 27
8 Radan Radan 17 29 18 25
9 Moravac Mrštane Moravac 17 21 22 24
10 Dunav Prahovo Dunav 17 21 17 23
11 Car Konstantin Konstantin 17 18 26 22
12 Dubočica Dubočica 17 22 22 19
13 Rembas Rembas 17 24 31 15
14 Jedinstvo Bosnjace Jedinstvo 17 15 29 14
15 Trstenik PPT Trstenik 17 15 46 4
16 Temnic 1924 Temnic 1924 17 9 52 3
TEMPORADA 2018/2019
TERCERA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Radnički Pirot Radnički 34 96 19 85
2 Temnic 1924 Temnic 1924 34 66 20 80
3 Budućnost Popovac Budućnost 34 74 36 64
4 Jagodina Jagodina 34 53 26 64
5 Car Konstantin Konstantin 34 64 39 60
6 Moravac Mrštane Moravac 34 60 37 59
7 Sinđelić Niš Sinđelić 34 53 41 51
8 Dunav Prahovo Dunav 34 54 54 45
9 Dubočica Dubočica 34 62 66 45
10 SFS Borac SFS Borac 34 37 44 45
11 Jedinstvo Bosnjace Jedinstvo 34 41 55 44
12 Trstenik PPT Trstenik 34 37 49 40
13 Zaplanjac Zaplanjac 34 38 63 38
14 Radan Radan 34 31 52 37
15 Jedinstvo Paraćin Jedinstvo 34 36 72 36
16 Rtanj Rtanj 34 45 62 34
17 Radnički Svilajnac Radnički 34 39 79 30
18 Pukovac Pukovac 34 29 101 16
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
LIGA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Mladost Lučani Mladost 7 9 6 31
2 FK Spartak Subotica Spartak 7 17 5 29
3 Metalac GM Metalac GM 7 12 13 28
4 Rad Beograd Rad Beograd 7 10 6 27
5 Javor Ivanjica Javor 7 4 5 26
6 Novi Pazar Novi Pazar 7 8 11 25
7 OFK Beograd OFK Beograd 7 11 14 18
8 Jagodina Jagodina 7 7 18 15
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 Javor Ivanjica Javor 30 29 38 29
15 Rad Beograd Rad Beograd 30 19 37 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
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 67 12 80
2 Crvena Zvezda Crvena 30 57 18 68
3 Vojvodina Novi Sad Vojvodina 30 44 26 52
4 Jagodina Jagodina 30 34 20 51
5 Sloboda Uzice Sloboda 30 42 35 51
6 Radnički Kragujevac Radnički 30 38 27 47
7 FK Spartak Subotica Spartak 30 31 31 43
8 OFK Beograd OFK Beograd 30 34 36 40
9 Javor Ivanjica Javor 30 28 32 39
10 Rad Beograd Rad Beograd 30 33 31 37
11 Hajduk Kula Hajduk Kula 30 28 44 33
12 BSK Borča BSK Borča 30 18 39 30
13 Smederevo Smederevo 30 22 42 29
14 Novi Pazar Novi Pazar 30 21 41 28
15 Borac Čačak Borac 30 16 45 19
16 Metalac GM Metalac GM 30 14 48 15
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
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 63 14 78
2 Crvena Zvezda Crvena 30 53 17 71
3 OFK Beograd OFK Beograd 30 38 33 50
4 FK Spartak Subotica Spartak 30 34 27 49
5 Vojvodina Novi Sad Vojvodina 30 51 30 45
6 Jagodina Jagodina 30 38 34 43
7 Javor Ivanjica Javor 30 22 23 38
8 Rad Beograd Rad Beograd 30 38 39 37
9 Metalac GM Metalac GM 30 24 39 35
10 Smederevo Smederevo 30 23 30 34
11 Borac Čačak Borac 30 21 34 34
12 BSK Borča BSK Borča 30 27 37 33
13 FK Cukaricki Cukaricki 30 25 46 32
14 Hajduk Kula Hajduk Kula 30 28 40 30
15 Napredak Krusevac Napredak 30 30 44 29
16 Mladi Radnik Mladi Radnik 30 19 47 25
TEMPORADA 2008/2009
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 33 63 15 80
2 Vojvodina Novi Sad Vojvodina 33 46 25 61
3 Crvena Zvezda Crvena 33 59 32 59
4 Javor Ivanjica Javor 33 39 27 53
5 Borac Čačak Borac 33 28 35 40
6 Napredak Krusevac Napredak 33 28 37 38
7 Hajduk Kula Hajduk Kula 33 23 34 38
8 Rad Beograd Rad Beograd 33 27 35 36
9 FK Cukaricki Cukaricki 33 30 39 35
10 Jagodina Jagodina 33 28 47 34
11 OFK Beograd OFK Beograd 33 28 54 33
12 Banat Zrenjanin Banat 33 21 40 31
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
TERCERA SERBIA GRUPO 4
Equipo PJ GF GC Puntos
1 Jagodina Jagodina 34 78 28 70
2 Železničar Niš Železničar 33 56 30 62
3 Sloga Leskovac Sloga 34 50 38 59
4 Trajal Krusevac Trajal 33 53 29 56
5 Sinđelić Niš Sinđelić 34 62 40 55
6 Svrljig Svrljig 34 51 41 52
7 Kopaonik Kopaonik 34 35 44 52
8 Dubočica Dubočica 34 55 51 51
9 Timok Timok 34 52 32 50
10 Morava Vladicin Han Morava 34 38 43 50
11 OFK Nis OFK Nis 34 55 52 49
12 Rudar Alpos Rudar Alpos 34 50 47 48
13 Jedinstvo Paraćin Jedinstvo 34 43 57 43
14 Bor Bor 34 41 42 42
15 Toplicanin Prokuplje Toplicanin 34 49 60 42
16 Car Konstantin Konstantin 34 50 66 34
17 Djerdap Kladovo Djerdap 34 40 76 24
18 Kosanica Kosanica 34 20 102 11

  USO DE MEMORIA  
6,971,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1336
Total Execution Time  0.1355
  CADENA URL  
/historico/Jagodina
  GET DATOS  
$_GET['/historico/Jagodina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0030  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 = 'Jagodina' 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.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=13451 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=13451 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73439
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13451 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1526 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1526 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  SELECT /*53 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 (1029868) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '13451' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73439 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=13451 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73439,69224) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73439 AND teamId = 13451
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 69224 AND teamId = 13451
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 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 = 73439 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = 73439 WHERE rp.league_id = 73439 AND rp.teamId = 13451 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.0019  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 = 73439 WHERE rp.league_id = 73439 AND rp.teamId = 13451 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73439 WHERE rp.league_id = 73439 AND rp.teamId = 13451 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 13451 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73439 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 68875 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.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 `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 = 63902 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.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 `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 = 51079 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.0030  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 = 44708 AND t.round = 34 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 = 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.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 = 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.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.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 `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 = 23659 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 `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.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 `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.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 `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 = 10481 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 `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.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 `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 = 10486 AND t.round = 30 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 = 10487 AND t.round = 33 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 `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.0027  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 = 28199 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC