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 PHC Zebras PHC Zebras 18 40 14 44
2 North Village Rams North 18 47 20 42
3 Devonshire Cougars Devonshire 18 54 30 34
4 Hamilton Parish Hamilton 18 37 30 26
5 Paget CC Paget CC 18 32 32 25
6 St. George.s Colts George.s 18 31 34 23
7 Dandy Town Hornets Dandy Town. 18 30 39 20
8 YMSC YMSC 18 25 43 18
9 Somerset Trojans Somerset 18 24 39 15
10 X-Roads Warriors X-Roads 18 19 58 7
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 PHC Zebras PHC Zebras 18 66 17 45
2 Devonshire Cougars Devonshire 18 50 17 42
3 St. George.s Colts George.s 18 55 24 37
4 North Village Rams North 18 38 16 37
5 Hamilton Parish Hamilton 18 32 30 25
6 Dandy Town Hornets Dandy Town. 18 23 32 23
7 X-Roads Warriors X-Roads 18 33 49 20
8 Somerset Trojans Somerset 18 23 43 17
9 Boulevard Blazers Boulevard 18 23 58 12
10 Robin Hood Robin Hood 18 10 67 1
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Dandy Town Hornets Dandy Town. 20 59 15 55
2 PHC Zebras PHC Zebras 20 83 23 48
3 Devonshire Cougars Devonshire 20 40 18 38
4 North Village Rams North 20 47 21 31
5 Somerset Trojans Somerset 20 38 29 29
6 Robin Hood Robin Hood 20 41 36 28
7 St. George.s Colts George.s 20 32 32 26
8 X-Roads Warriors X-Roads 20 29 62 22
9 Colts Devonshire Colts 20 21 43 16
10 Southampton Rangers Southampton 20 20 82 11
11 Somerset Eagles Somerset 20 24 73 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Robin Hood Robin Hood 8 26 5 22
2 Devonshire Cougars Devonshire 9 17 7 17
3 PHC Zebras PHC Zebras 9 17 14 17
4 Dandy Town Hornets Dandy Town. 8 15 9 15
5 Somerset Trojans Somerset 8 8 8 14
6 North Village Rams North 8 10 12 11
7 Colts Devonshire Colts 8 15 13 8
8 Southampton Rangers Southampton 8 8 12 8
9 St. George.s Colts George.s 9 5 13 5
10 X-Roads Warriors X-Roads 8 7 17 5
11 SBRC SBRC 7 6 24 3
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 North Village Rams North 18 39 15 40
2 Dandy Town Hornets Dandy Town. 18 40 25 35
3 Robin Hood Robin Hood 18 43 17 32
4 PHC Zebras PHC Zebras 18 40 31 31
5 Southampton Rangers Southampton 18 23 23 24
6 Devonshire Cougars Devonshire 18 24 33 21
7 X-Roads Warriors X-Roads 18 38 38 20
8 Somerset Trojans Somerset 18 25 36 20
9 SBRC SBRC 18 25 33 19
10 Boulevard Blazers Boulevard 18 10 56 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 PHC Zebras PHC Zebras 18 43 14 43
2 Robin Hood Robin Hood 18 55 22 39
3 Dandy Town Hornets Dandy Town. 18 48 34 35
4 Devonshire Cougars Devonshire 18 31 28 26
5 X-Roads Warriors X-Roads 18 47 37 25
6 BAA Wanderers Wanderers 18 39 55 23
7 Boulevard Blazers Boulevard 18 36 53 21
8 North Village Rams North 18 27 35 18
9 Somerset Trojans Somerset 18 27 47 11
10 Paget CC Paget CC 18 22 50 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 PHC Zebras PHC Zebras 18 72 14 42
2 Robin Hood Robin Hood 18 67 24 39
3 Dandy Town Hornets Dandy Town. 18 52 25 36
4 Devonshire Cougars Devonshire 18 34 28 29
5 North Village Rams North 18 35 31 29
6 Somerset Trojans Somerset 18 32 46 22
7 Boulevard Blazers Boulevard 18 33 55 22
8 X-Roads Warriors X-Roads 18 34 43 20
9 Flanagan's Onions Flanagan's 18 26 61 12
10 YMSC YMSC 18 17 75 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Robin Hood Robin Hood 18 40 9 41
2 PHC Zebras PHC Zebras 18 40 16 41
3 North Village Rams North 18 32 20 39
4 Devonshire Cougars Devonshire 18 22 21 27
5 Somerset Trojans Somerset 18 25 25 25
6 Boulevard Blazers Boulevard 18 28 32 23
7 Dandy Town Hornets Dandy Town. 18 36 35 21
8 Flanagan's Onions Flanagan's 18 21 34 16
9 SBRC SBRC 18 20 37 12
10 Colts Devonshire Colts 18 19 54 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Dandy Town Hornets Dandy Town. 18 59 19 44
2 Robin Hood Robin Hood 18 37 26 32
3 PHC Zebras PHC Zebras 18 36 28 27
4 North Village Rams North 18 29 23 27
5 Boulevard Blazers Boulevard 18 34 33 24
6 Devonshire Cougars Devonshire 18 24 27 23
7 Somerset Trojans Somerset 18 27 33 22
8 Colts Devonshire Colts 18 32 42 19
9 Southampton Rangers Southampton 18 25 46 17
10 Hamilton Parish Hamilton 18 23 49 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Somerset Trojans Somerset 18 27 18 34
2 Dandy Town Hornets Dandy Town. 18 43 35 31
3 PHC Zebras PHC Zebras 18 34 24 30
4 Robin Hood Robin Hood 18 31 27 25
5 Hamilton Parish Hamilton 18 23 24 24
6 Devonshire Cougars Devonshire 18 20 24 24
7 North Village Rams North 18 31 28 23
8 Southampton Rangers Southampton 18 19 27 20
9 Flanagan's Onions Flanagan's 18 32 45 19
10 St. George.s Colts George.s 18 19 27 18
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Dandy Town Hornets Dandy Town. 18 49 24 37
2 North Village Rams North 18 43 23 32
3 Flanagan's Onions Flanagan's 18 31 30 29
4 Somerset Trojans Somerset 18 28 30 27
5 Devonshire Cougars Devonshire 18 36 34 26
6 Hamilton Parish Hamilton 18 30 35 25
7 PHC Zebras PHC Zebras 18 33 38 22
8 Southampton Rangers Southampton 18 32 35 18
9 St. David's Warriors David's 18 22 44 17
10 Wolves Sports Club Wolves 18 32 43 16
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Devonshire Cougars Devonshire 18 46 22 41
2 PHC Zebras PHC Zebras 18 44 24 33
3 North Village Rams North 18 36 26 31
4 Somerset Trojans Somerset 18 33 29 30
5 Dandy Town Hornets Dandy Town. 18 40 29 27
6 Southampton Rangers Southampton 18 35 37 24
7 Wolves Sports Club Wolves 18 33 42 22
8 Flanagan's Onions Flanagan's 18 21 44 17
9 St. George.s Colts George.s 18 16 30 14
10 Robin Hood Robin Hood 18 22 43 14
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Dandy Town Hornets Dandy Town. 18 49 26 40
2 North Village Rams North 18 55 28 38
3 Devonshire Cougars Devonshire 18 35 25 37
4 PHC Zebras PHC Zebras 18 43 28 32
5 St. George.s Colts George.s 18 38 35 29
6 Somerset Trojans Somerset 18 43 42 29
7 Robin Hood Robin Hood 18 22 29 20
8 Southampton Rangers Southampton 18 20 41 12
9 Boulevard Blazers Boulevard 18 20 48 12
10 St. Davids St. Davids 18 18 41 8
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 North Village Rams North 18 48 17 41
2 PHC Zebras PHC Zebras 18 37 25 40
3 Dandy Town Hornets Dandy Town. 18 38 26 36
4 Devonshire Cougars Devonshire 18 46 23 33
5 St. George.s Colts George.s 18 30 21 26
6 Southampton Rangers Southampton 18 24 30 21
7 Boulevard Blazers Boulevard 18 27 37 20
8 St. Davids St. Davids 18 23 49 18
9 Somerset Eagles Somerset 18 30 40 16
10 Colts Devonshire Colts 18 15 50 6
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Dandy Town Hornets Dandy Town. 18 55 31 40
2 North Village Rams North 18 46 18 39
3 PHC Zebras PHC Zebras 18 34 27 31
4 Devonshire Cougars Devonshire 18 43 29 30
5 Boulevard Blazers Boulevard 18 37 30 29
6 Somerset Eagles Somerset 18 29 29 27
7 Southampton Rangers Southampton 18 20 30 18
8 Colts Devonshire Colts 18 26 39 17
9 Hamilton Parish Hamilton 18 20 58 14
10 Somerset Trojans Somerset 18 17 36 12
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Devonshire Cougars Devonshire 13 26 10 28
2 Boulevard Blazers Boulevard 14 23 12 28
3 Dandy Town Hornets Dandy Town. 14 24 16 27
4 North Village Rams North 13 23 14 20
5 PHC Zebras PHC Zebras 14 15 15 15
6 Southampton Rangers Southampton 13 17 20 14
7 Hamilton Parish Hamilton 13 13 27 14
8 Colts Devonshire Colts 14 7 34 2
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 PHC Zebras PHC Zebras 14 30 12 30
2 North Village Rams North 14 35 18 29
3 Devonshire Cougars Devonshire 14 32 11 24
4 Boulevard Blazers Boulevard 14 20 21 16
5 Dandy Town Hornets Dandy Town. 14 18 23 15
6 Colts Devonshire Colts 14 22 31 15
7 Somerset Trojans Somerset 14 13 29 14
8 Ireland Rangers Ireland 14 16 41 9
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Devonshire Cougars Devonshire 14 37 15 30
2 North Village Rams North 14 40 18 28
3 Boulevard Blazers Boulevard 14 31 18 25
4 Somerset Trojans Somerset 14 24 20 22
5 Dandy Town Hornets Dandy Town. 14 31 20 18
6 PHC Zebras PHC Zebras 14 21 25 16
7 Paget CC Paget CC 14 15 66 8
8 St. David's Warriors David's 14 18 35 6

  USO DE MEMORIA  
5,960,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1224
Total Execution Time  0.1243
  CADENA URL  
/bermudas2024/grupo1/historico
  GET DATOS  
$_GET['/bermudas2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0018  SELECT type FROM routes WHERE alias = 'bermudas2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bermudas' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=168 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=168 ORDER BY order_id ASC
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 168 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 74237 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.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 = 69774 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.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 = 65513 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.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 `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 = 58878 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.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 `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 = 51324 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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 45911 AND t.round = 18 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 = 42095 AND t.round = 18 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 `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 = 37152 AND t.round = 18 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 = 15728 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 4827 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 3572 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2230 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1649 AND t.round = 18 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 `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 = 1607 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0209  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 = 1274 AND t.round = 18 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 `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 = 8963 AND t.round = 14 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 = 8962 AND t.round = 14 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 = 8959 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:57:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 12:57:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 12:57:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 12:57:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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 = 74237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74237 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.0020  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 = 74237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74237 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 74237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74237 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 74237 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