4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Huizen
TEMPORADA 2023/2024
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Huizen Huizen 26 50 21 55
2 Ajax Amateurs Ajax 26 59 29 51
3 JOS Watergraafsmeer Watergraafsm 26 49 35 50
4 AFC '34 AFC '34 26 46 35 47
5 HBC HBC 26 61 33 45
6 Hollandia Hollandia 26 47 34 42
7 Ter Leede Ter Leede 25 65 48 37
8 Purmersteijn Purmersteijn 26 44 29 37
9 Hoogland Hoogland 26 35 40 34
10 Swift Swift 26 36 43 33
11 SJC Noordwijk Noordwijk 26 46 61 32
12 ARC Alphense Alphense 26 35 48 28
13 DHSC DHSC 26 29 63 28
14 BOL BOL 25 29 49 26
15 WV-HEDW WV-HEDW 26 48 65 23
16 Alphense Boys Alphense 26 30 76 17
TEMPORADA 2022/2023
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Eemdijk Eemdijk 30 83 39 66
2 Swift Swift 30 58 39 57
3 Genemuiden Genemuiden 30 57 41 54
4 AZSV AZSV 30 49 38 48
5 DETO Twenterand DETO 30 60 45 47
6 Huizen Huizen 30 59 45 43
7 DHSC DHSC 29 52 53 43
8 Berkum Berkum 30 45 37 41
9 Ajax Amateurs Ajax 30 41 37 41
10 WV-HEDW WV-HEDW 29 47 54 40
11 SDV Barneveld Barneveld 30 40 47 37
12 Buitenpost Buitenpost 29 26 52 32
13 Flevo Boys Flevo Boys 30 41 59 30
14 Olde Veste .54 Olde Veste 30 39 61 29
15 Apeldoorn CSV Apeldoorn 29 34 56 29
16 HZVV HZVV 30 31 59 24
TEMPORADA 2021/2022
EERSTE KLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 Huizen Huizen 25 77 21 66
2 Zuidvogels Zuidvogels 25 58 24 58
3 Sliedrecht Sliedrecht 25 51 36 50
4 WNC WNC 25 58 41 48
5 Roda'46 Roda'46 25 56 40 38
6 Nivo Sparta Nivo Sparta 25 51 40 36
7 LRC LRC 25 34 40 30
8 Montfoort Montfoort 25 41 51 30
9 De Bilt De Bilt 25 36 47 26
10 SVL SVL 25 34 49 24
11 Almkerk Almkerk 25 35 54 24
12 Breukelen Breukelen 25 28 53 20
13 Woudenberg Woudenberg 25 25 54 20
14 GRC 14 GRC 14 25 25 59 17
TEMPORADA 2020/2021
EERSTE KLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 WNC WNC 3 10 3 9
2 Nivo Sparta Nivo Sparta 4 11 5 9
3 Sliedrecht Sliedrecht 4 9 6 9
4 SVL SVL 4 6 3 8
5 Huizen Huizen 4 8 5 7
6 Almkerk Almkerk 4 5 4 7
7 Breukelen Breukelen 4 7 6 6
8 GRC 14 GRC 14 3 5 7 6
9 Zuidvogels Zuidvogels 4 8 6 5
10 De Bilt De Bilt 2 3 3 2
11 Roda'46 Roda'46 2 1 4 0
12 LRC LRC 3 2 7 0
13 Woudenberg Woudenberg 3 4 12 0
14 Montfoort Montfoort 4 3 11 0
TEMPORADA 2019/2020
EERSTE KLASSE ZATERDAG GRUPO 1
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
TEMPORADA 2018/2019
EERSTE KLASSE ZATERDAG GRUPO 1
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
TEMPORADA 2017/2018
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Eemdijk Eemdijk 30 63 33 58
2 Berkum Berkum 30 52 36 56
3 Genemuiden Genemuiden 30 74 45 54
4 Ajax Amateurs Ajax 30 69 45 54
5 Staphorst Staphorst 30 55 44 46
6 Urk Urk 30 47 44 43
7 AZSV AZSV 30 38 39 42
8 Door Fusie Sterk Door Fusie. 30 47 43 41
9 Excelsior .31 Excelsior 30 40 45 41
10 SDC Putten SDC Putten 30 40 50 41
11 Sparta Nijkerk Sparta 30 47 37 40
12 Apeldoorn CSV Apeldoorn 30 51 61 36
13 HZVV HZVV 30 37 54 32
14 Huizen Huizen 30 47 65 26
15 Zuidvogels Zuidvogels 30 40 70 26
16 NSC NSC 30 46 82 26
TEMPORADA 2016/2017
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 34 74 36 70
2 Lisse Lisse 34 55 38 65
3 Rijnsburgse Boys Rijnsburgse 34 84 62 61
4 ASWH ASWH 34 64 53 58
5 Scheveningen Scheveningen 34 54 48 56
6 Jong Volendam Jong 34 60 56 56
7 DVS'33 DVS'33 34 54 49 48
8 Harkemase Boys Harkemase 34 55 60 46
9 Groningen Sub 21 Groningen 34 48 46 45
10 VVOG VVOG 34 49 55 44
11 Quick Boys Quick Boys 34 47 54 43
12 Capelle Capelle 34 42 52 41
13 ONS Sneek ONS Sneek 34 51 60 40
14 Jong Almere City Jong Almere 34 63 61 38
15 ODIN '59 ODIN '59 34 58 63 36
16 SteDoCo SteDoCo 34 46 69 35
17 Huizen Huizen 34 38 57 33
18 Rijnvogels Rijnvogels 34 55 78 33
TEMPORADA 2015/2016
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 ODIN '59 ODIN '59 24 57 32 51
2 Huizen Huizen 24 54 26 48
3 DOVO DOVO 24 47 29 44
4 Achilles Veen Achilles 24 46 30 43
5 Eemdijk Eemdijk 24 34 28 40
6 Ajax Amateurs Ajax 24 42 38 35
7 Sparta Nijkerk Sparta 24 38 38 33
8 SDC Putten SDC Putten 24 35 35 32
9 Swift Swift 24 31 44 30
10 NSC NSC 24 31 46 28
11 Bennekom Bennekom 24 28 43 24
12 SVL SVL 24 40 63 20
13 LRC LRC 24 20 51 14
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 26 50 30 51
2 ODIN '59 ODIN '59 26 45 38 46
3 DOVO DOVO 26 39 30 40
4 Achilles Veen Achilles 26 43 39 40
5 VVA .71 VVA .71 26 44 33 39
6 Jodan Boys Jodan Boys 26 46 35 35
7 SDC Putten SDC Putten 26 38 39 34
8 NSC NSC 26 44 51 34
9 Breukelen Breukelen 26 47 60 32
10 Bennekom Bennekom 26 32 36 31
11 Huizen Huizen 26 37 32 30
12 Door Fusie Sterk Door Fusie. 26 32 46 29
13 Montfoort Montfoort 26 30 40 24
14 RKAV Volendam RKAV 26 46 64 24
TEMPORADA 2013/2014
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Nijkerk Sparta 26 61 31 60
2 Ajax Amateurs Ajax 26 59 28 53
3 Quick Boys Quick Boys 26 51 37 50
4 DVS'33 DVS'33 26 49 38 43
5 Huizen Huizen 26 52 44 37
6 Bennekom Bennekom 26 41 38 35
7 ODIN '59 ODIN '59 26 41 43 34
8 SDC Putten SDC Putten 26 46 51 32
9 RKAV Volendam RKAV 26 43 56 32
10 VVA .71 VVA .71 26 38 49 30
11 DOVO DOVO 26 36 45 29
12 Montfoort Montfoort 26 38 55 26
13 Sportlust 46 Sportlust 26 26 38 23
14 SDV Barneveld Barneveld 26 23 51 19
TEMPORADA 2012/2013
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Ter Leede Ter Leede 26 56 20 54
2 DOVO DOVO 26 39 29 46
3 Ajax Amateurs Ajax 26 53 27 42
4 ODIN '59 ODIN '59 26 43 32 40
5 VVA .71 VVA .71 26 42 43 40
6 Montfoort Montfoort 26 37 43 40
7 Huizen Huizen 26 57 42 38
8 Quick Boys Quick Boys 26 54 40 37
9 Bennekom Bennekom 26 43 41 37
10 Sportlust 46 Sportlust 26 32 44 34
11 Apeldoorn CSV Apeldoorn 26 39 47 29
12 ARC Alphense Alphense 26 43 65 26
13 RKAV Volendam RKAV 26 35 58 26
14 DTS Ede DTS Ede 26 27 69 13
TEMPORADA 2011/2012
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Jodan Boys Jodan Boys 24 41 23 49
2 Ter Leede Ter Leede 24 46 30 42
3 Quick Boys Quick Boys 24 41 34 41
4 Huizen Huizen 23 37 34 39
5 Sparta Nijkerk Sparta 24 39 34 34
6 Bennekom Bennekom 24 35 33 34
7 RKAV Volendam RKAV 24 39 49 34
8 DOVO DOVO 24 35 38 33
9 Sportlust 46 Sportlust 24 44 51 33
10 Voorschoten .97 Voorschoten 24 49 41 32
11 ODIN '59 ODIN '59 23 35 34 31
12 Zwaluwen .30 Zwaluwen 24 32 45 24
13 SDC Putten SDC Putten 24 30 57 18
TEMPORADA 2010/2011
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 64 25 58
2 VV Noordwijk Noordwijk 26 57 24 58
3 Young Boys Young Boys 26 58 34 51
4 Scheveningen Scheveningen 26 47 28 46
5 Excelsior Maassluis Excelsior 26 51 39 45
6 ODIN '59 ODIN '59 26 40 29 44
7 RKAV Volendam RKAV 26 52 54 34
8 Voorschoten .97 Voorschoten 26 32 49 32
9 Ter Leede Ter Leede 26 28 51 30
10 Jodan Boys Jodan Boys 26 35 45 29
11 Zwaluwen .30 Zwaluwen 26 36 45 27
12 Huizen Huizen 26 38 54 23
13 Vitesse Delft Vitesse 26 28 53 18
14 Swift Swift 26 28 64 17
TEMPORADA 2009/2010
EERSTE KLASSE ZATERDAG GRUPO 1
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
TEMPORADA 2008/2009
EERSTE KLASSE ZATERDAG GRUPO 1
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
TEMPORADA 2006/2007
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 65 29 59
2 Sparta Nijkerk Sparta 25 59 34 49
3 Quick Boys Quick Boys 25 56 32 48
4 Nunspeet Nunspeet 26 49 37 44
5 Spakenburg Spakenburg 26 47 35 42
6 GVVV GVVV 26 48 35 40
7 Hoek Hoek 26 57 48 39
8 Ajax Amateurs Ajax 26 34 41 31
9 Bennekom Bennekom 26 43 51 30
10 Kloetinge Kloetinge 26 29 42 29
11 SV Geinoord SV Geinoord 26 31 49 29
12 Huizen Huizen 26 26 41 23
13 VVOG VVOG 26 27 50 23
14 GOES GOES 26 21 68 5
TEMPORADA 2004/2005
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 46 31 52
2 Capelle Capelle 26 45 35 48
3 Quick Boys Quick Boys 26 60 45 47
4 Rijnsburgse Boys Rijnsburgse 26 53 36 42
5 Spakenburg Spakenburg 26 52 42 40
6 SHO SHO 26 39 36 37
7 Sparta Nijkerk Sparta 26 40 41 37
8 Scheveningen Scheveningen 26 41 42 36
9 Excelsior Maassluis Excelsior 26 42 45 32
10 Deltasport Deltasport 26 38 33 31
11 Katwijk Katwijk 26 39 46 31
12 TOGR TOGR 26 34 55 25
13 Huizen Huizen 26 37 48 24
14 Voorschoten .97 Voorschoten 26 25 56 15

  USO DE MEMORIA  
6,718,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1555
Total Execution Time  0.1569
  CADENA URL  
/historico/Huizen
  GET DATOS  
$_GET['/historico/Huizen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0038  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Huizen' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72976
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7163 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=226 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 226 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (859778,183993,112119,50354,49516) ORDER BY n.cover_points DESC, update_date DESC
0.0033  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '7163' ORDER BY l.year DESC,cat.coefficient DESC
0.0030  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '7163' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '7163' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72976 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=7163 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72976) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72976 AND teamId = 7163
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72976 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7163' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7163' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7163' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7163 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7163 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7163 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 7163 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72976 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.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 = 70054 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 64429 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 = 59812 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.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 `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.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 `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.0033  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 = 39747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 33929 AND t.round = 34 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 `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 = 20351 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 `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 = 9387 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 9393 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 `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 = 2189 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 `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 = 1713 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 20374 AND t.round = 26 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 `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.0031  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.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 `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 = 20390 AND t.round = 26 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 `tables2005` 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 = 20396 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC