4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Wittenhorst Wittenhorst 26 82 34 62
2 Volharding Volharding 26 44 40 43
3 EFC EFC 26 46 37 40
4 Someren Someren 26 46 39 39
5 BSV Limburgia Limburgia 26 41 36 37
6 Chevremont Chevremont 26 55 57 36
7 De Ster De Ster 26 48 41 35
8 Susteren Susteren 26 64 48 34
9 Deurne Deurne 26 44 45 32
10 RKSV Minor RKSV Minor 26 34 39 32
11 EHC Hoensbroek Hoensbroek 25 37 53 32
12 Venlosche Boys Venlosche 26 37 48 29
13 Schaesberg Schaesberg 26 39 66 28
14 ZSV ZSV 25 23 57 20
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 HVCH HVCH 26 69 29 55
2 Eindhoven AV Eindhoven 25 60 38 48
3 Nemelaer Nemelaer 25 59 37 45
4 RKVV Best Vooruit RKVV Best V. 25 56 36 45
5 Alverna Alverna 26 51 39 42
6 EFC EFC 25 49 38 40
7 TOP Oss Amateurs Amateurs 25 61 52 40
8 RKVV Erp RKVV Erp 26 58 47 38
9 Leones Leones 25 46 40 35
10 Berghem Sport Berghem 25 36 57 25
11 Woezik Woezik 25 30 48 22
12 Brabantia Brabantia 25 31 51 17
13 RKSV Rhode RKSV Rhode 25 32 74 16
14 SC NEC SC NEC 16 11 63 6
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 SC NEC SC NEC 4 10 2 8
2 Leones Leones 4 13 9 7
3 RKVV Best Vooruit RKVV Best V. 3 13 9 5
4 EFC EFC 4 8 8 5
5 RKSV Rhode RKSV Rhode 4 5 7 5
6 Alverna Alverna 2 4 0 4
7 HVCH HVCH 2 4 2 4
8 Eindhoven AV Eindhoven 4 8 8 4
9 Nemelaer Nemelaer 3 6 9 4
10 Woezik Woezik 4 8 11 3
11 TOP Oss Amateurs Amateurs 2 3 3 2
12 RKVV Erp RKVV Erp 3 7 8 2
13 Brabantia Brabantia 3 6 10 2
14 Berghem Sport Berghem 2 4 13 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Alverna Alverna 16 30 21 30
2 Brabantia Brabantia 17 38 25 28
3 TOP Oss Amateurs Amateurs 17 38 36 27
4 Eindhoven AV Eindhoven 15 24 15 26
5 SC NEC SC NEC 16 34 26 26
6 Nemelaer Nemelaer 15 30 25 24
7 Unitas 30 Unitas 30 17 31 39 23
8 Leones Leones 15 28 27 22
9 Woezik Woezik 16 23 26 22
10 HVCH HVCH 15 23 26 18
11 RKVV Erp RKVV Erp 14 20 25 17
12 t Zand t Zand 15 24 30 17
13 RKVV Best Vooruit RKVV Best V. 17 25 36 14
14 RKSV Rhode RKSV Rhode 17 25 36 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Juliana 31 Juliana 31 26 64 30 57
2 TOP Oss Amateurs Amateurs 26 59 33 53
3 Nemelaer Nemelaer 26 61 43 45
4 Leones Leones 26 49 39 41
5 Alverna Alverna 26 51 44 38
6 Woezik Woezik 26 46 45 38
7 RKSV Rhode RKSV Rhode 26 38 43 37
8 t Zand t Zand 26 41 50 33
9 RKVV Best Vooruit RKVV Best V. 26 49 52 32
10 HVCH HVCH 26 36 43 31
11 Brabantia Brabantia 26 36 47 30
12 Oirschot Vooruit Oirschot 26 37 49 25
13 Tilburg Tilburg 26 39 59 23
14 Prinses Irene Prinses 26 24 53 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 AWC AWC 23 46 29 46
2 HVCH HVCH 24 43 38 41
3 TOP Oss Amateurs Amateurs 24 47 42 40
4 Rood-Wit-Willebrord Rood-Wit-Wil 24 44 32 38
5 Nemelaer Nemelaer 24 41 35 36
6 t Zand t Zand 24 35 39 34
7 RKVV Best Vooruit RKVV Best V. 23 32 34 33
8 Oirschot Vooruit Oirschot 24 35 36 33
9 Brabantia Brabantia 24 39 41 32
10 DOSKO DOSKO 24 49 39 30
11 Alverna Alverna 23 26 29 26
12 Tilburg Tilburg 24 25 37 26
13 Gestel Gestel 23 37 68 16
14 DESO DESO 0 0 0 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Baronie Baronie 25 65 16 65
2 GOES GOES 25 57 35 50
3 Nemelaer Nemelaer 25 38 35 36
4 HVCH HVCH 25 43 41 36
5 Brabantia Brabantia 25 40 34 35
6 t Zand t Zand 25 40 33 34
7 TOP Oss Amateurs Amateurs 25 33 41 34
8 RKTVV RKTVV 25 34 34 33
9 SC NEC SC NEC 25 34 40 32
10 AWC AWC 25 39 46 31
11 Beerse Boys Beerse Boys 25 36 50 29
12 Moerse Boys Moerse Boys 25 27 37 24
13 MOC '17 MOC '17 25 35 54 22
14 Marvilde Marvilde 25 37 62 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 RKSV Nuenen RKSV Nuenen 26 61 31 56
2 HVCH HVCH 26 61 28 55
3 t Zand t Zand 26 51 35 48
4 GOES GOES 26 66 39 46
5 Beerse Boys Beerse Boys 26 50 34 44
6 Nemelaer Nemelaer 26 38 37 40
7 Moerse Boys Moerse Boys 26 38 43 37
8 Brabantia Brabantia 26 39 37 36
9 MOC '17 MOC '17 26 39 40 36
10 Geldrop Geldrop 26 40 41 35
11 WSC WSC 26 39 62 30
12 Zeelandia Zeelandia 26 36 61 21
13 RKVV Roosendaal RKVV 26 23 47 18
14 Schijndel Schijndel 26 29 75 12
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Halsteren Halsteren 26 70 25 60
2 Gestel Gestel 26 80 43 54
3 DESO DESO 26 47 23 52
4 Beerse Boys Beerse Boys 26 48 41 41
5 Brabantia Brabantia 26 49 48 41
6 HVCH HVCH 26 49 42 40
7 RKSV Nuenen RKSV Nuenen 26 70 47 39
8 Nemelaer Nemelaer 26 37 45 35
9 RKVV Roosendaal RKVV 26 44 45 34
10 Moerse Boys Moerse Boys 26 33 44 32
11 RKVV Erp RKVV Erp 26 38 51 30
12 DESK DESK 26 29 55 25
13 EFC EFC 26 35 59 19
14 LONGA LONGA 26 19 80 15
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Vlissingen Vlissingen 26 61 17 62
2 SV TEC Tiel SV TEC Tiel 26 61 22 61
3 OSS '20 OSS '20 26 60 20 56
4 LONGA LONGA 26 46 35 39
5 DESK DESK 26 35 39 35
6 Moerse Boys Moerse Boys 26 32 37 35
7 EFC EFC 26 34 40 35
8 Geldrop Geldrop 26 39 36 34
9 RKVV Roosendaal RKVV 26 31 39 34
10 Brabantia Brabantia 26 35 35 32
11 RKVV Best Vooruit RKVV Best V. 26 45 58 29
12 Nieuw Woensel Nieuw 26 35 70 28
13 TSC TSC 26 30 61 15
14 BVV Den Bosch Bosch 26 24 59 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 De Valk De Valk 26 54 22 62
2 DOSKO DOSKO 26 58 40 46
3 RKVV Best Vooruit RKVV Best V. 26 55 45 41
4 DESK DESK 26 47 41 41
5 Vlissingen Vlissingen 26 48 39 40
6 LONGA LONGA 26 43 50 36
7 EFC EFC 26 38 46 35
8 Geldrop Geldrop 26 50 52 33
9 BVV Den Bosch Bosch 26 45 63 33
10 TSC TSC 26 39 57 33
11 Halsteren Halsteren 26 49 37 32
12 IFC IFC 26 46 62 29
13 Nemelaer Nemelaer 26 37 45 26
14 JEKA JEKA 26 44 54 25
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Brabantia Brabantia 26 63 39 53
2 Nemelaer Nemelaer 26 57 31 52
3 EFC EFC 26 38 31 44
4 Vlissingen Vlissingen 26 53 36 42
5 LONGA LONGA 26 32 36 41
6 GOES GOES 26 49 30 40
7 Geldrop Geldrop 26 45 44 40
8 JEKA JEKA 26 43 37 38
9 IFC IFC 26 50 50 35
10 RKVV Best Vooruit RKVV Best V. 26 49 51 31
11 PSV Amateurs Amateurs 26 37 53 31
12 WSC WSC 26 48 63 29
13 Terneuzen Terneuzen 26 30 61 20
14 Rood Wit V Rood Wit V 26 34 66 19
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 RKSV Nuenen RKSV Nuenen 26 53 33 50
2 Vlissingen Vlissingen 26 41 34 47
3 Brabantia Brabantia 26 56 50 46
4 Geldrop Geldrop 26 43 33 39
5 WSC WSC 26 35 34 36
6 JEKA JEKA 26 41 40 35
7 RKVV Best Vooruit RKVV Best V. 26 42 39 34
8 Nemelaer Nemelaer 26 35 34 34
9 LONGA LONGA 26 40 38 33
10 EFC EFC 26 34 34 32
11 RKJVV RKJVV 26 58 71 30
12 RCS RCS 26 39 54 30
13 Nulandia Nulandia 26 37 53 30
14 TSV Theole TSV Theole 26 38 45 29
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Dongen Dongen 22 57 31 47
2 De Valk De Valk 22 49 24 47
3 IFC IFC 22 50 36 41
4 Vlissingen Vlissingen 22 44 31 38
5 Geldrop Geldrop 22 58 40 35
6 RCS RCS 22 49 45 31
7 RKSV Nuenen RKSV Nuenen 22 47 42 28
8 LONGA LONGA 22 40 40 27
9 RKVV Best Vooruit RKVV Best V. 22 29 37 23
10 WSC WSC 22 40 52 22
11 GVV Unitas GVV Unitas 22 31 62 16
12 Unitas 30 Unitas 30 22 12 66 6
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 OSS '20 OSS '20 22 46 18 49
2 RKVV Best Vooruit RKVV Best V. 22 43 21 48
3 RKSV Nuenen RKSV Nuenen 22 52 24 45
4 RCS RCS 22 60 41 37
5 GVV Unitas GVV Unitas 22 50 52 32
6 WSC WSC 22 38 42 30
7 Geldrop Geldrop 22 35 40 29
8 Dongen Dongen 22 27 34 27
9 Unitas 30 Unitas 30 22 23 32 23
10 PSV Amateurs Amateurs 22 32 51 22
11 TSV Theole TSV Theole 22 18 43 16
12 Internos Internos 22 31 57 16

  USO DE MEMORIA  
6,378,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1541
Total Execution Time  0.1574
  CADENA URL  
/eerste_klasse_zondag_liga_holanda2023/grupo3/historico
  GET DATOS  
$_GET['/eerste_klasse_zondag_liga_holanda2023/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0018  SELECT type FROM routes WHERE alias = 'eerste_klasse_zondag_liga_holanda2023'
0.0063  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'eerste_klasse_zondag_liga_holanda' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0093  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=229 AND type_rel = 3
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=229 ORDER BY order_id ASC
0.0053  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 = 70702 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0057  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 229 AND group_code = 3 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 70702 AND t.round = 26 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 `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 = 64434 AND t.round = 26 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 `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 = 59821 AND t.round = 4 ORDER BY team.conference ASC,t.position 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 `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 = 51227 AND t.round = 17 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 = 45037 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39759 AND t.round = 26 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 `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 = 33984 AND t.round = 25 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 `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 = 16017 AND t.round = 26 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 `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 = 9401 AND t.round = 26 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 `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 = 9421 AND t.round = 26 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 `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 = 2221 AND t.round = 26 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 `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 = 1726 AND t.round = 26 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 `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 = 20462 AND t.round = 26 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 `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 = 20468 AND t.round = 22 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 `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 = 20474 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:55:59' 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=2 AND last_update > '2024-04-27 15:55:59' 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=4 AND last_update > '2024-04-27 15:55:59' 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 15:55:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'eerste_klasse_zondag_liga_holanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2023 e ON e.player_id = p.id AND e.league_id = 70702 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70702 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.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 70702 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70702 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 70702 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70702 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 70702 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC