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 BOL BOL 26 54 28 58
2 Montfoort Montfoort 26 51 35 54
3 Zuidvogels Zuidvogels 26 79 41 52
4 SDC Putten SDC Putten 26 49 36 38
5 Roda'46 Roda'46 26 54 47 38
6 De Meern De Meern 26 53 50 38
7 NSC NSC 26 46 54 38
8 ZOB ZOB 26 43 51 37
9 SV Argon SV Argon 26 44 45 36
10 De Bilt De Bilt 26 38 42 33
11 Nunspeet Nunspeet 26 44 53 32
12 HBOK HBOK 26 44 60 26
13 FC Olympia FC Olympia 26 34 55 19
14 VV Monnickendam Monnickendam 26 32 68 18
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 WV-HEDW WV-HEDW 26 67 29 60
2 Nootdorp Nootdorp 26 62 44 46
3 Voorschoten .97 Voorschoten 26 55 47 41
4 BOL BOL 26 50 50 41
5 Honselersdijk Honselersdij 26 49 46 39
6 VELO VELO 26 60 53 38
7 Forum Sport Forum Sport 26 46 42 37
8 Valken '68 Valken '68 26 45 45 35
9 SV Argon SV Argon 26 46 53 32
10 VV Monnickendam Monnickendam 26 32 49 31
11 ZOB ZOB 25 39 39 30
12 Die Haghe Die Haghe 26 27 38 27
13 Zwaluwen .30 Zwaluwen 26 32 61 24
14 AFC II AFC II 25 31 45 23
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Forum Sport Forum Sport 4 10 4 9
2 AFC II AFC II 4 7 4 7
3 Voorschoten .97 Voorschoten 4 8 6 7
4 Zwaluwen .30 Zwaluwen 4 4 2 7
5 VELO VELO 4 6 5 7
6 SV Argon SV Argon 4 4 4 7
7 Valken '68 Valken '68 4 6 7 7
8 ZOB ZOB 4 9 6 6
9 Die Haghe Die Haghe 4 6 5 5
10 WV-HEDW WV-HEDW 4 12 6 4
11 BOL BOL 4 5 8 4
12 Nootdorp Nootdorp 4 5 8 4
13 Honselersdijk Honselersdij 4 8 12 3
14 VV Monnickendam Monnickendam 4 3 16 1
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 VV Scherpenzeel Scherpenzeel 17 43 18 36
2 WV-HEDW WV-HEDW 17 46 21 35
3 Roda'46 Roda'46 17 39 23 32
4 Huizen Huizen 17 25 15 30
5 Zuidvogels Zuidvogels 17 34 18 29
6 AFC II AFC II 17 31 28 29
7 Breukelen Breukelen 17 32 31 28
8 Zwaluwen .30 Zwaluwen 17 36 40 22
9 SV Argon SV Argon 17 26 36 20
10 ZOB ZOB 17 25 31 19
11 BOL BOL 17 20 38 18
12 Woudenberg Woudenberg 17 18 39 14
13 VV Monnickendam Monnickendam 17 26 46 13
14 De Bilt De Bilt 17 18 35 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 DHSC DHSC 26 71 33 55
2 ARC Alphense Alphense 26 59 39 50
3 AFC II AFC II 26 48 38 49
4 Zwaluwen .30 Zwaluwen 26 52 40 44
5 BOL BOL 26 53 45 41
6 SV Argon SV Argon 26 46 45 41
7 Huizen Huizen 26 52 38 39
8 Roda'46 Roda'46 26 55 52 38
9 Breukelen Breukelen 26 43 49 31
10 WV-HEDW WV-HEDW 26 57 59 30
11 Zuidvogels Zuidvogels 26 37 41 30
12 Aalsmeer Aalsmeer 26 36 53 29
13 CSW CSW 26 34 44 24
14 Victoria Hilversum Victoria 26 30 97 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 RKAV Volendam RKAV 26 86 37 62
2 ARC Alphense Alphense 26 58 24 59
3 Xerxes DZB Xerxes DZB 26 64 37 51
4 Sportlust 46 Sportlust 26 56 27 50
5 Forum Sport Forum Sport 26 57 36 47
6 WV-HEDW WV-HEDW 26 56 37 44
7 CSW CSW 26 49 63 36
8 Aalsmeer Aalsmeer 26 33 30 32
9 Zwaluwen .30 Zwaluwen 26 41 59 31
10 Westlandia B Westlandia 26 41 61 28
11 Breukelen Breukelen 26 38 61 27
12 Te Werve Te Werve 26 49 63 26
13 Vitesse Delft Vitesse 26 32 71 17
14 Marken Marken 26 33 87 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 AFC '34 AFC '34 26 58 41 52
2 RKAV Volendam RKAV 26 47 28 51
3 Zuidvogels Zuidvogels 26 53 32 48
4 Montfoort Montfoort 26 44 38 43
5 DTS Ede DTS Ede 26 46 32 42
6 SVL SVL 26 52 47 41
7 Aalsmeer Aalsmeer 26 35 35 37
8 Woudenberg Woudenberg 26 32 35 36
9 Zwaluwen .30 Zwaluwen 26 43 41 35
10 De Merino.s De Merino.s 26 45 52 34
11 SV Geinoord SV Geinoord 26 36 47 28
12 Roda'46 Roda'46 26 39 47 25
13 JSV JSV 26 29 50 23
14 VVZ .49 VVZ .49 26 29 63 14
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Door Fusie Sterk Door Fusie. 26 86 40 58
2 Sliedrecht Sliedrecht 26 58 37 56
3 Breukelen Breukelen 26 52 44 44
4 Roda'46 Roda'46 26 61 46 42
5 De Merino.s De Merino.s 26 52 38 40
6 JSV JSV 26 47 39 40
7 Zuidvogels Zuidvogels 26 47 38 39
8 SV Geinoord SV Geinoord 26 45 47 36
9 VVZ .49 VVZ .49 26 62 64 35
10 Woudenberg Woudenberg 26 38 48 34
11 Montfoort Montfoort 26 37 53 31
12 WNC WNC 26 42 63 27
13 GDC GDC 26 28 56 18
14 Roda Boys Roda Boys 26 30 72 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 SVL SVL 26 70 41 58
2 Eemdijk Eemdijk 26 50 30 51
3 LRC LRC 26 60 34 46
4 JSV JSV 26 52 31 46
5 Zuidvogels Zuidvogels 26 73 49 41
6 WNC WNC 26 54 44 40
7 Roda'46 Roda'46 26 54 41 38
8 DTS Ede DTS Ede 26 45 45 34
9 Roda Boys Roda Boys 26 42 46 33
10 VVZ .49 VVZ .49 26 61 60 30
11 Almkerk Almkerk 26 36 43 29
12 Benschop Benschop 26 40 55 28
13 De Meern Zaterdag Meern 26 36 61 19
14 Lienden Zaterdag Lienden 26 38 131 19
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Breukelen Breukelen 26 99 39 62
2 LRC LRC 26 61 28 60
3 ARC Alphense Alphense 26 61 35 50
4 VVZ .49 VVZ .49 26 59 52 49
5 SVL SVL 26 68 49 42
6 Zuidvogels Zuidvogels 26 55 51 42
7 Eemdijk Eemdijk 26 51 37 38
8 De Meern Zaterdag Meern 26 40 45 32
9 Roda'46 Roda'46 26 31 57 29
10 ASC Nieuwland Nieuwland 26 47 64 28
11 Almkerk Almkerk 26 35 63 22
12 Nivo Sparta Nivo Sparta 26 42 63 21
13 CSW CSW 26 35 59 21
14 Leerdam Sport '55 Leerdam 26 31 73 18
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 SDV Barneveld Barneveld 26 80 25 56
2 Breukelen Breukelen 26 65 37 49
3 Swift Swift 26 48 30 43
4 Zwaluwen .30 Zwaluwen 26 47 29 43
5 Eemdijk Eemdijk 26 40 35 43
6 SVL SVL 26 44 36 37
7 VVZ .49 VVZ .49 26 60 61 35
8 Zuidvogels Zuidvogels 26 36 42 35
9 Roda'46 Roda'46 26 40 40 34
10 CSW CSW 26 39 41 33
11 Marken Marken 26 53 68 31
12 De Merino.s De Merino.s 26 40 56 31
13 de Valleivogels Valleivogels 26 32 51 20
14 Castricum Castricum 26 25 98 7
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Ajax Amateurs Ajax 26 77 33 53
2 VVZ .49 VVZ .49 26 61 40 49
3 Zuidvogels Zuidvogels 26 59 42 47
4 Swift Swift 25 49 37 44
5 SVL SVL 26 48 41 42
6 VVA .71 VVA .71 26 37 31 40
7 Roda'46 Roda'46 26 41 46 39
8 Eemdijk Eemdijk 26 36 51 36
9 CSW CSW 26 46 54 32
10 De Merino.s De Merino.s 25 33 38 29
11 Marken Marken 26 50 64 28
12 Lelystad .67 Lelystad 26 37 49 26
13 HBOK HBOK 26 31 52 21
14 DVVA DVVA 26 29 56 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 DOVO DOVO 26 77 26 67
2 HBOK HBOK 26 58 38 47
3 Zuidvogels Zuidvogels 26 43 35 42
4 VVZ .49 VVZ .49 26 62 46 41
5 VVA .71 VVA .71 26 37 27 41
6 De Merino.s De Merino.s 26 46 47 37
7 Ajax Amateurs Ajax 26 55 40 36
8 Eemdijk Eemdijk 26 35 43 35
9 CSW CSW 26 36 43 34
10 Marken Marken 26 38 52 34
11 Breukelen Breukelen 26 33 40 32
12 SV Geinoord SV Geinoord 26 29 55 25
13 SVL SVL 26 34 51 22
14 Veensche Boys Veensche 26 18 58 14
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 22 59 15 52
2 Huizen Huizen 22 47 23 49
3 Montfoort Montfoort 22 33 23 36
4 Swift Swift 22 38 29 36
5 VVZ .49 VVZ .49 22 30 36 36
6 Sportlust 46 Sportlust 22 41 33 35
7 Ajax Amateurs Ajax 22 34 31 32
8 SV Geinoord II Geinoord 22 30 37 24
9 Zuidvogels Zuidvogels 22 29 44 23
10 De Merino.s De Merino.s 22 33 43 22
11 Roda'46 Roda'46 22 18 47 18
12 De Beursbengels Beursbengels 22 20 51 8
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 22 52 11 53
2 ODIN '59 ODIN '59 21 43 16 51
3 Sportlust 46 Sportlust 23 62 32 50
4 Rijnvogels Rijnvogels 23 54 24 45
5 Zuidvogels Zuidvogels 23 42 43 36
6 Huizen Huizen 22 40 30 34
7 De Beursbengels Beursbengels 21 29 38 24
8 Roda'46 Roda'46 22 28 36 21
9 De Merino.s De Merino.s 22 23 40 21
10 Montfoort Montfoort 21 24 39 20
11 Gouda Gouda 21 25 59 9
12 Voorland Voorland 23 23 77 6

  USO DE MEMORIA  
6,311,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5576
Total Execution Time  0.5594
  CADENA URL  
/eerste_klasse_zaterdag_liga_holanda2023/grupo1/historico
  GET DATOS  
$_GET['/eerste_klasse_zaterdag_liga_holanda2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0147  SELECT type FROM routes WHERE alias = 'eerste_klasse_zaterdag_liga_holanda2023'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'eerste_klasse_zaterdag_liga_holanda' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=228 AND type_rel = 3
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 228 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0153  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 (169221) ORDER BY n.cover_points DESC, update_date DESC
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=228 ORDER BY order_id ASC
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 228 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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 = 70694 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.0149  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 = 64427 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.0147  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 = 59810 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.0147  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 = 51167 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.0149  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 = 45028 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 39752 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 33962 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 9418 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 9410 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 9405 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 2225 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 1719 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 20429 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 20434 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 20439 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 03:59:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 03:59:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 03:59:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 03:59:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 = 70694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70694 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.0146  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 = 70694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70694 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 = 70694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70694 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10