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 Weymouth Wales Weymouth 12 30 8 31
2 Kick Start FC Kick Start 11 19 4 26
3 UWI Blackbirds Blackbirds 11 21 12 26
4 Paradise Paradise 11 19 17 17
5 Wotton Wotton 11 16 15 15
6 Brittons Hill Brittons 12 16 16 14
7 Ellerton Ellerton 11 11 18 9
8 Deacons Deacons 9 7 15 8
9 Empire Club Empire Club 12 14 27 7
10 Barbados Soccer Academy Barbados 10 9 30 3
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 20 73 18 52
2 Paradise Paradise 21 56 31 44
3 Ellerton Ellerton 19 51 25 39
4 Brittons Hill Brittons 19 39 23 38
5 UWI Blackbirds Blackbirds 18 50 25 34
6 Wotton Wotton 19 43 38 32
7 St. Andrews Lions Andrews 21 41 54 24
8 Empire Club Empire Club 19 30 37 23
9 Deacons Deacons 20 34 50 20
10 BDF BDF 19 29 60 16
11 Notre Dame Notre Dame 20 37 64 10
12 Silver Sands Silver Sands 21 20 78 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 7 16 4 16
2 BDF BDF 7 19 8 15
3 Paradise Paradise 7 13 8 11
4 Notre Dame Notre Dame 7 12 13 11
5 Empire Club Empire Club 7 13 10 10
6 Deacons Deacons 7 10 11 10
7 Wotton Wotton 7 9 12 9
8 UWI Blackbirds Blackbirds 7 12 13 7
9 Ellerton Ellerton 7 10 12 7
10 St. Andrews Lions Andrews 7 10 13 7
11 Silver Sands Silver Sands 7 7 19 6
12 Brittons Hill Brittons 7 3 11 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 24 61 19 49
2 UWI Blackbirds Blackbirds 24 77 31 42
3 Notre Dame Notre Dame 24 45 83 28
4 Brittons Hill Brittons 24 42 45 23
5 Porey Springs Porey 24 27 83 15
6 Barbados Soccer Academy Barbados 24 19 76 12
7 BDF BDF 24 78 18 58
8 Empire Club Empire Club 23 47 26 51
9 Paradise Paradise 24 81 24 50
10 Ellerton Ellerton 25 46 33 40
11 St. Andrews Lions Andrews 24 36 39 30
12 Youth Milan Youth Milan 24 14 96 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 16 50 6 44
2 Paradise Paradise 16 42 16 32
3 Brittons Hill Brittons 16 27 15 29
4 Empire Club Empire Club 16 35 30 26
5 Notre Dame Notre Dame 16 28 30 24
6 Silver Sands Silver Sands 16 17 53 11
7 BDF BDF 16 39 10 35
8 UWI Blackbirds Blackbirds 16 40 14 30
9 Ellerton Ellerton 16 30 22 21
10 Porey Springs Porey 16 22 50 9
11 Rendezvous Rendezvous 16 22 67 7
12 Waterford Compton Waterford 16 16 55 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 18 51 13 43
2 BDF BDF 18 46 21 38
3 Rendezvous Rendezvous 18 44 29 34
4 Paradise Paradise 18 28 17 30
5 Notre Dame Notre Dame 18 29 29 29
6 UWI Blackbirds Blackbirds 18 33 23 24
7 Ellerton Ellerton 18 22 35 20
8 Brittons Hill Brittons 18 16 31 12
9 Waterford Compton Waterford 18 18 69 11
10 Belfield Belfield 18 21 41 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 UWI Blackbirds Blackbirds 18 80 19 45
2 BDF BDF 18 59 13 44
3 Weymouth Wales Weymouth 18 34 19 34
4 Paradise Paradise 18 37 25 34
5 Rendezvous Rendezvous 18 36 53 22
6 Notre Dame Notre Dame 18 27 43 21
7 Brittons Hill Brittons 18 25 32 20
8 Belfield Belfield 18 31 43 20
9 Empire Club Empire Club 18 28 45 15
10 Pinelands United Pinelands 18 20 85 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 BDF BDF 18 48 15 38
2 Rendezvous Rendezvous 18 43 20 38
3 UWI Blackbirds Blackbirds 18 38 17 34
4 Weymouth Wales Weymouth 18 36 17 31
5 Brittons Hill Brittons 18 33 30 30
6 Paradise Paradise 18 29 31 23
7 Notre Dame Notre Dame 18 24 38 19
8 Pinelands United Pinelands 18 27 63 18
9 Pride of Gall Hill Pride Gall. 18 17 34 13
10 Silver Sands Silver Sands 18 17 47 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 BDF BDF 18 54 21 41
2 Brittons Hill Brittons 18 40 7 39
3 Pride of Gall Hill Pride Gall. 18 34 21 36
4 Weymouth Wales Weymouth 18 31 21 32
5 Paradise Paradise 18 30 30 27
6 Notre Dame Notre Dame 18 27 27 27
7 Pinelands United Pinelands 18 40 37 23
8 Silver Sands Silver Sands 18 21 45 16
9 Cosmos FC Cosmos FC 18 12 29 11
10 Dayrells Road Dayrells 18 11 62 6
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 BDF BDF 18 51 12 43
2 Brittons Hill Brittons 18 44 21 35
3 Weymouth Wales Weymouth 18 37 19 32
4 Pride of Gall Hill Pride Gall. 18 40 25 31
5 Notre Dame Notre Dame 18 33 26 30
6 Paradise Paradise 18 20 26 25
7 Cosmos FC Cosmos FC 18 23 31 18
8 Dayrells Road Dayrells 18 22 49 18
9 Saint John´s Sonnets Saint 18 13 52 11
10 Youth Milan Youth Milan 18 21 43 9
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Weymouth Wales Weymouth 18 40 10 40
2 Brittons Hill Brittons 18 26 9 38
3 BDF BDF 18 31 17 38
4 Pride of Gall Hill Pride Gall. 18 26 21 27
5 Youth Milan Youth Milan 18 27 28 25
6 Notre Dame Notre Dame 18 32 25 24
7 Paradise Paradise 18 17 20 22
8 Dayrells Road Dayrells 18 22 23 21
9 Bagatelle Bagatelle 18 19 38 13
10 Pinelands United Pinelands 18 20 69 5
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Youth Milan Youth Milan 17 35 12 38
2 Brittons Hill Brittons 19 29 21 34
3 Notre Dame Notre Dame 18 40 20 33
4 Weymouth Wales Weymouth 19 27 19 33
5 Pinelands United Pinelands 18 28 22 30
6 Paradise Paradise 18 35 21 28
7 Pride of Gall Hill Pride Gall. 17 27 30 18
8 Bagatelle Bagatelle 18 19 35 18
9 Saint John´s Sonnets Saint 18 20 39 14
10 Ellerton Ellerton 18 14 55 9
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Notre Dame Notre Dame 17 32 11 41
2 Brittons Hill Brittons 17 28 12 35
3 Youth Milan Youth Milan 17 33 19 32
4 Weymouth Wales Weymouth 17 25 15 28
5 Pride of Gall Hill Pride Gall. 17 18 12 27
6 Paradise Paradise 17 14 16 17
7 Ellerton Ellerton 17 20 31 16
8 Pinelands United Pinelands 17 16 30 14
9 Silver Sands Silver Sands 17 16 37 10
10 BDF BDF 9 3 22 4
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Brittons Hill Brittons 18 37 15 38
2 BDF BDF 18 48 17 37
3 Pride of Gall Hill Pride Gall. 18 28 15 31
4 Silver Sands Silver Sands 18 25 21 31
5 Notre Dame Notre Dame 18 32 26 29
6 Paradise Paradise 18 32 20 27
7 Weymouth Wales Weymouth 18 22 22 27
8 Eden Stars Eden Stars 18 37 33 23
9 Youth Milan Youth Milan 18 23 21 23
10 Technico Technico 19 11 40 11
11 Maxwell Maxwell 19 8 73 4
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Notre Dame Notre Dame 19 50 16 38
2 Brittons Hill Brittons 19 48 22 37
3 BDF BDF 19 43 17 37
4 Pride of Gall Hill Pride Gall. 18 28 21 25
5 Haggatt Hall FC Haggatt Hall 19 41 40 24
6 Maxwell Maxwell 18 28 32 24
7 Technico Technico 18 23 24 23
8 Paradise Paradise 17 40 28 22
9 Silver Sands Silver Sands 18 22 27 22
10 Youth Milan Youth Milan 17 24 31 20
11 Tudor Bridge Tudor Bridge 18 12 101 7
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 BDF BDF 18 44 24 34
2 Pride of Gall Hill Pride Gall. 18 31 25 32
3 Brittons Hill Brittons 18 33 14 31
4 Silver Sands Silver Sands 18 34 24 30
5 Notre Dame Notre Dame 18 39 21 29
6 Youth Milan Youth Milan 18 38 43 28
7 Technico Technico 18 24 20 26
8 Tudor Bridge Tudor Bridge 18 17 40 19
9 Haggatt Hall FC Haggatt Hall 18 19 37 18
10 Eden Stars Eden Stars 18 17 48 6
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Youth Milan Youth Milan 18 33 20 37
2 Notre Dame Notre Dame 18 32 13 36
3 Silver Sands Silver Sands 18 33 21 30
4 BDF BDF 18 23 23 27
5 Brittons Hill Brittons 18 24 29 23
6 Eden Stars Eden Stars 18 29 34 21
7 Pride of Gall Hill Pride Gall. 18 21 26 20
8 Tudor Bridge Tudor Bridge 18 14 24 20
9 Beverley Hills Beverley 18 35 37 19
10 Paradise Paradise 18 13 30 10

  USO DE MEMORIA  
5,992,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5476
Total Execution Time  0.5496
  CADENA URL  
/premier_division_barbados2024/grupo1/historico
  GET DATOS  
$_GET['/premier_division_barbados2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0125  SELECT type FROM routes WHERE alias = 'premier_division_barbados2024'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_division_barbados' 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.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=423 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=423 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 423 GROUP BY l.categoryId
0.0126  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=423 GROUP BY l.year ORDER BY l.year DESC
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 = 75191 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 423 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 75191 AND t.round = 9 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 `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 = 70990 AND t.round = 8 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 `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 = 55353 AND t.round = 5 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 = 48394 AND t.round = 14 ORDER BY team.conference 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 `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 = 43807 AND t.round = 12 ORDER BY team.conference 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 `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 = 43881 AND t.round = 9 ORDER BY team.conference 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 `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 = 23135 AND t.round = 18 ORDER BY team.conference 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 `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 = 9504 AND t.round = 9 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 = 8949 AND t.round = 18 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 `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 = 3308 AND t.round = 18 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 `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 = 8948 AND t.round = 18 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 = 8947 AND t.round = 18 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 = 8946 AND t.round = 17 ORDER BY team.conference 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 `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 = 8944 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 8942 AND t.round = 20 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 `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 = 8940 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 8938 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 13:57:33' 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=2 AND last_update > '2024-04-30 13:57:33' 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-30 13:57:33' 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=3 AND last_update > '2024-04-30 13:57:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_division_barbados' 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 = 75191 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75191 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.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 = 75191 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75191 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  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 = 75191 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75191 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 75191 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC