4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Glostrup FK Glostrup FK 18 41 20 39
2 Frederikssund IK Frederikssun 18 37 27 31
3 Hørsholm-Usserød Hørsholm-Us 18 48 31 30
4 Karlslunde Karlslunde 18 28 24 28
5 Skjold Skjold 18 21 29 26
6 Ledøje-Smørum Fodbold Ledøje-Smø 18 37 33 25
7 Ringsted Ringsted 18 30 34 22
8 B 1908 B 1908 18 20 29 18
9 Slagelse B&I Slagelse 18 24 36 18
10 VB 1968 VB 1968 18 22 45 11
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Avarta Avarta 18 39 16 40
2 Frederikssund IK Frederikssun 18 34 16 37
3 Ledøje-Smørum Fodbold Ledøje-Smø 18 34 33 26
4 Slagelse B&I Slagelse 18 35 34 25
5 Skjold Skjold 18 23 22 25
6 Næstved II Næstved II 18 37 39 25
7 Allerød Allerød 18 32 27 24
8 Herlev Herlev 18 28 39 19
9 Vaerebro BK 1968 Vaerebro 18 25 39 18
10 KFUM KFUM 18 18 40 14
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 AB Tårnby AB Tårnby 27 58 31 60
2 Tårnby FF Tårnby FF 27 52 30 51
3 Holbæk Holbæk 27 58 36 45
4 KFUM KFUM 27 41 40 43
5 B 1908 B 1908 27 40 38 34
6 GVI GVI 27 41 44 34
7 Ledøje-Smørum Fodbold Ledøje-Smø 27 34 39 34
8 Køge Nord Køge Nord 27 36 62 29
9 Skovshoved Skovshoved 27 28 40 26
10 Ringsted Ringsted 27 32 60 17
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Herlev Herlev 19 29 12 40
2 Ledøje-Smørum Fodbold Ledøje-Smø 20 47 25 37
3 GVI GVI 20 36 21 37
4 Allerød Allerød 20 35 25 35
5 B 1908 B 1908 20 35 24 34
6 Greve IF Greve IF 20 35 33 32
7 Taastrup FC Taastrup FC 20 22 33 25
8 Skjold Birkerød Skjold 20 29 48 22
9 Otterup Otterup 20 32 37 18
10 Vordingborg Vordingborg 20 25 42 17
11 RB 1906 RB 1906 19 16 41 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 AB Tårnby AB Tårnby 14 31 14 32
2 Karlslunde Karlslunde 14 28 12 31
3 B 1908 B 1908 14 24 14 29
4 Ishøj Ishøj 14 37 21 28
5 GVI GVI 14 15 21 18
6 KFUM KFUM 14 17 25 17
7 Frederikssund IK Frederikssun 14 17 23 14
8 Avedøre Avedøre 14 15 32 12
9 BK Union BK Union 14 23 33 10
10 Greve IF Greve IF 14 14 26 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 FA 2000 FA 2000 27 75 44 55
2 KFUM Roskilde KFUM 27 47 29 47
3 B 1908 B 1908 27 55 41 47
4 Ledøje-Smørum Fodbold Ledøje-Smø 27 52 29 46
5 Odsherred Odsherred 27 55 54 40
6 Allerød Allerød 27 44 52 32
7 BK Union BK Union 27 40 48 31
8 Fremad Valby Fremad Valby 27 40 57 28
9 Ishøj Ishøj 27 47 67 26
10 Kastrup Kastrup 27 30 64 19
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 GVI GVI 27 47 24 52
2 B 1908 B 1908 27 54 28 51
3 Vanløse Vanløse 27 47 19 49
4 AB Tårnby AB Tårnby 27 52 49 48
5 Fremad Valby Fremad Valby 27 43 30 44
6 Odsherred Odsherred 27 37 35 33
7 Skjold Birkerød Skjold 27 24 45 29
8 Avedøre Avedøre 27 32 57 26
9 KFUM Roskilde KFUM 27 30 50 23
10 Virum Sorgenfri Virum 27 26 55 22
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Skovshoved Skovshoved 27 67 25 57
2 Ledoeje-Smoerum Ledoeje-Smoe 27 68 38 52
3 GVI GVI 27 47 28 47
4 AB Tårnby AB Tårnby 27 61 39 46
5 B 1908 B 1908 27 40 39 36
6 Avedøre Avedøre 27 35 47 31
7 Fremad Valby Fremad Valby 27 42 63 30
8 Karlslunde Karlslunde 27 28 54 29
9 Rishøj Rishøj 27 34 55 24
10 Herlufsholm Herlufsholm 27 27 61 20
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sydvest Sydvest 26 71 35 62
2 Greve IF Greve IF 26 67 35 58
3 KFUM Roskilde KFUM 26 80 41 57
4 Sønderborg Sønderborg 26 57 52 41
5 Tarup-Paarup Tarup-Paarup 26 54 44 36
6 Rishøj Rishøj 26 40 47 36
7 Varde IF Elite Varde Elite 26 39 47 36
8 Kolding BK B Kolding 26 49 51 33
9 Ouere Skolrne Ouere 26 47 52 31
10 Kalundborg Kalundborg 26 44 58 31
11 Taastrup FC Taastrup FC 26 40 56 31
12 Boldklubben 1909 Boldklubben 26 25 44 26
13 Tuse IF Tuse IF 26 34 55 24
14 Marstal/Rise Marstal/Rise 26 27 57 20
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Sønderborg Sønderborg 16 35 19 32
2 Skanderborg Skanderborg 16 33 24 30
3 Ledoeje-Smoerum Ledoeje-Smoe 15 45 30 29
4 Dalum Dalum 16 30 16 29
5 Kalundborg Kalundborg 16 43 30 29
6 Boldklubben 1909 Boldklubben 16 37 26 29
7 Marstal/Rise Marstal/Rise 16 23 12 29
8 FA 2000 FA 2000 16 35 24 25
9 Otterup Otterup 16 18 23 20
10 Ringsted Ringsted 15 22 25 19
11 Døllefjelde-Musse Døllefjelde 16 25 35 13
12 Slagelse Slagelse 16 23 54 8
13 Næsby BK II Næsby 16 16 50 8
14 Næstved II Næstved II 16 20 37 7
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Kolding IF Kolding IF 26 95 28 66
2 Kolding BK B Kolding 26 58 39 50
3 Greve IF Greve IF 26 63 34 49
4 KFUM Roskilde KFUM 26 54 39 46
5 Marstal/Rise Marstal/Rise 26 43 43 44
6 Taastrup FC Taastrup FC 26 57 45 41
7 Ringsted Ringsted 26 47 36 41
8 Næsby BK II Næsby 26 47 49 36
9 Otterup Otterup 26 39 47 31
10 Slagelse Slagelse 26 40 45 29
11 Frem Sakskøbing Frem 26 37 71 23
12 Sydalliancen Sydalliancen 26 34 71 20
13 Aarup Aarup 26 43 71 19
14 Krarup/Espe SG & I Krarup/Espe 26 37 76 15
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 SC Egedal SC Egedal 25 79 23 58
2 GVI GVI 25 56 31 56
3 Ringsted Ringsted 25 59 28 55
4 Næsby BK II Næsby 25 62 42 43
5 Aarup Aarup 25 46 37 43
6 Hedensted Hedensted 25 52 40 42
7 Marstal/Rise Marstal/Rise 25 47 36 42
8 Greve IF Greve IF 25 49 45 36
9 Slagelse Slagelse 25 40 50 34
10 Frem Sakskøbing Frem 25 50 47 32
11 Næstved II Næstved II 25 34 41 30
12 Døllefjelde-Musse Døllefjelde 25 35 83 14
13 Nakskov Nakskov 25 30 79 9
14 Odense Kammeraternes SK Odense 25 27 84 6
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 26 89 33 59
2 Sydvest Sydvest 26 75 28 58
3 Næstved II Næstved II 26 62 40 51
4 Ringsted Ringsted 26 60 35 48
5 Kolding IF Kolding IF 26 62 41 43
6 Næsby BK II Næsby 26 62 55 43
7 Frem Sakskøbing Frem 26 44 38 39
8 Odense Kammeraternes SK Odense 26 47 48 33
9 Døllefjelde-Musse Døllefjelde 26 60 71 33
10 Herlufsholm Herlufsholm 26 48 56 32
11 Haderslev Haderslev 26 48 63 32
12 Sønderborg Sønderborg 26 38 67 27
13 Fjordager Fjordager 26 28 77 12
14 Korup Korup 26 21 92 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Marienlyst Marienlyst 26 84 38 62
2 Aarup Aarup 26 75 47 54
3 Frem Sakskøbing Frem 26 62 47 50
4 Sydvest Sydvest 26 62 37 49
5 Næstved II Næstved II 26 74 44 46
6 Odense Kammeraternes SK Odense 26 46 39 46
7 Haderslev Haderslev 26 71 57 41
8 Ringsted Ringsted 26 59 50 34
9 Næsby BK II Næsby 26 52 58 32
10 Kolding IF Kolding IF 26 39 59 25
11 Fjordager Fjordager 26 40 55 24
12 Tarup-Paarup Tarup-Paarup 26 37 72 21
13 B 1921 B 1921 26 35 73 15
14 B 1913 B 1913 26 23 83 10
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Rishøj Rishøj 25 71 36 51
2 Svebølle Svebølle 25 67 38 51
3 Middelfart Middelfart 25 52 32 51
4 Herlev Herlev 25 55 32 50
5 Næstved II Næstved II 25 52 37 47
6 Avedøre Avedøre 25 51 39 42
7 Skjold Birkerød Skjold 25 56 41 39
8 Marienlyst Marienlyst 25 56 51 37
9 Fjordager Fjordager 25 37 52 30
10 Kolding IF Kolding IF 25 31 38 28
11 Odense Kammeraternes SK Odense 25 22 54 23
12 B 1913 B 1913 25 26 52 22
13 Dalum Dalum 25 22 61 13
14 Boldklubben 1909 Boldklubben 25 18 53 10
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Otterup Otterup 26 82 37 61
2 Nordvest Nordvest 26 78 34 57
3 Næstved II Næstved II 26 71 36 51
4 Middelfart Middelfart 26 67 49 45
5 B 1921 B 1921 26 59 41 45
6 Svebølle Svebølle 26 57 53 40
7 Dalum Dalum 26 53 43 39
8 Herfølge BK II Herfølge 26 59 52 38
9 Boldklubben 1909 Boldklubben 26 58 57 38
10 B 1913 B 1913 25 34 50 31
11 Odense Kammeraternes SK Odense 26 44 59 29
12 Frem Sakskøbing Frem 25 54 59 25
13 Nakskov Nakskov 26 27 95 8
14 Køge BK II Køge BK II 26 4 82 3

  USO DE MEMORIA  
6,136,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.5165
Total Execution Time  0.5189
  CADENA URL  
/danmarksserien_dinamarca2024/grupo2/historico
  GET DATOS  
$_GET['/danmarksserien_dinamarca2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0125  SELECT type FROM routes WHERE alias = 'danmarksserien_dinamarca2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'danmarksserien_dinamarca' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=340 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72496 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 340 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 72496 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68397 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63284 AND t.round = 27 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 `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 = 58345 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50402 AND t.round = 14 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 `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 = 44327 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39095 AND t.round = 27 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 = 34073 AND t.round = 27 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 `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 = 15860 AND t.round = 26 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 `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 = 4227 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2773 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24316 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24323 AND t.round = 26 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 `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 = 24327 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24331 AND t.round = 26 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 `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 = 24336 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'danmarksserien_dinamarca' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72496 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72496 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72496 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 72496 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC