4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VVOG
TEMPORADA 2023/2024
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 AZSV AZSV 0 0 0 0
2 Be Quick 1887 Quick 1887 0 0 0 0
3 Berkum Berkum 0 0 0 0
4 Buitenpost Buitenpost 0 0 0 0
5 DETO Twenterand DETO 0 0 0 0
6 Excelsior .31 Excelsior 0 0 0 0
7 Heino Heino 0 0 0 0
8 LONGA '30 LONGA '30 0 0 0 0
9 MASV MASV 0 0 0 0
10 Pelikaan Pelikaan 0 0 0 0
11 Quick '20 Quick '20 0 0 0 0
12 ROHDA Raalte ROHDA Raalte 0 0 0 0
13 SDV Barneveld Barneveld 0 0 0 0
14 TVC '28 TVC '28 0 0 0 0
15 VV Scherpenzeel Scherpenzeel 0 0 0 0
16 VVOG VVOG 0 0 0 0
TEMPORADA 2022/2023
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 ACV Assen ACV Assen 34 71 33 75
2 GVVV GVVV 34 77 40 69
3 BVV Barendrecht Barendrecht 34 71 54 59
4 SteDoCo SteDoCo 34 59 42 58
5 Rijnvogels Rijnvogels 34 64 55 56
6 Sportlust 46 Sportlust 34 52 50 53
7 DVS'33 DVS'33 34 54 43 52
8 Sparta Nijkerk Sparta 34 45 45 50
9 Hoek Hoek 34 71 72 50
10 DOVO DOVO 34 51 56 48
11 Staphorst Staphorst 34 38 41 45
12 Urk Urk 34 62 76 42
13 Harkemase Boys Harkemase 34 52 56 38
14 RKAV Volendam RKAV 34 52 72 36
15 VVOG VVOG 34 49 71 35
16 Excelsior .31 Excelsior 34 47 58 33
17 Ter Leede Ter Leede 34 50 65 33
18 ASWH Ido-Ambacht ASWH 34 25 61 27
TEMPORADA 2021/2022
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Lisse Lisse 34 70 38 70
2 Sparta Nijkerk Sparta 34 65 38 64
3 Sportlust 46 Sportlust 34 63 40 58
4 DVS'33 DVS'33 34 61 41 58
5 Hoek Hoek 34 53 49 55
6 ACV Assen ACV Assen 34 50 42 51
7 Excelsior .31 Excelsior 34 53 47 51
8 BVV Barendrecht Barendrecht 34 72 57 50
9 SteDoCo SteDoCo 34 49 48 45
10 Staphorst Staphorst 34 54 56 45
11 Ter Leede Ter Leede 34 49 67 44
12 Harkemase Boys Harkemase 34 63 62 42
13 DOVO DOVO 34 43 57 38
14 VVSB VVSB 34 50 66 38
15 ODIN '59 ODIN '59 34 52 68 37
16 VVOG VVOG 34 61 82 37
17 Ajax Amateurs Ajax 34 38 54 36
18 GOES GOES 34 44 78 28
TEMPORADA 2020/2021
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 6 13 5 13
2 Lisse Lisse 5 11 7 10
3 Sparta Nijkerk Sparta 5 9 5 10
4 Excelsior .31 Excelsior 5 8 5 10
5 VVSB VVSB 5 10 7 9
6 Sportlust 46 Sportlust 5 6 5 9
7 Hoek Hoek 6 11 9 8
8 BVV Barendrecht Barendrecht 5 7 8 8
9 DOVO DOVO 5 16 8 7
10 Harkemase Boys Harkemase 3 5 2 7
11 ODIN '59 ODIN '59 4 6 6 6
12 Staphorst Staphorst 6 12 14 6
13 Ajax Amateurs Ajax 5 11 21 6
14 DVS'33 DVS'33 5 9 10 4
15 VVOG VVOG 4 1 3 4
16 Ter Leede Ter Leede 5 6 9 4
17 ACV Assen ACV Assen 4 1 8 2
18 GOES GOES 5 2 12 0
TEMPORADA 2019/2020
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Nijkerk Sparta 22 58 27 52
2 ODIN '59 ODIN '59 22 63 30 47
3 Harkemase Boys Harkemase 22 43 34 42
4 DVS'33 DVS'33 23 39 30 42
5 Lisse Lisse 23 44 33 38
6 Hoek Hoek 23 54 42 34
7 BVV Barendrecht Barendrecht 23 37 38 34
8 Ajax Amateurs Ajax 22 31 38 31
9 Excelsior .31 Excelsior 23 50 40 31
10 Jong Almere City Jong Almere 23 54 48 31
11 GOES GOES 23 33 44 31
12 VVSB VVSB 22 47 48 28
13 SteDoCo SteDoCo 22 41 42 28
14 Ter Leede Ter Leede 23 36 53 27
15 DOVO DOVO 23 45 55 22
16 ONS Sneek ONS Sneek 23 32 72 12
17 VVOG VVOG 22 26 59 11
TEMPORADA 2018/2019
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 VV Noordwijk Noordwijk 34 94 41 80
2 Quick Boys Quick Boys 34 84 41 72
3 DVS'33 DVS'33 34 102 47 68
4 Hoek Hoek 34 82 55 64
5 Groningen Sub 21 Groningen 34 66 39 58
6 Harkemase Boys Harkemase 34 68 59 57
7 ASWH ASWH 34 75 54 55
8 SteDoCo SteDoCo 34 65 56 55
9 ODIN '59 ODIN '59 34 71 66 54
10 Lisse Lisse 34 62 64 51
11 DOVO DOVO 34 76 66 48
12 Ajax Amateurs Ajax 34 52 61 41
13 ONS Sneek ONS Sneek 34 57 58 39
14 VVOG VVOG 34 41 72 35
15 Eemdijk Eemdijk 34 51 87 29
16 SJC Noordwijk Noordwijk 34 50 105 26
17 Achilles 29 Achilles 29 34 44 107 20
18 De Dijk De Dijk 34 49 111 19
TEMPORADA 2017/2018
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 34 68 32 71
2 Scheveningen Scheveningen 34 68 44 65
3 DVS'33 DVS'33 34 74 37 62
4 Jong Almere City Jong Almere 34 73 54 61
5 Groningen Sub 21 Groningen 34 72 34 58
6 Quick Boys Quick Boys 34 63 45 58
7 Jong Volendam Jong 34 60 48 56
8 ODIN '59 ODIN '59 34 56 51 49
9 DOVO DOVO 34 54 52 49
10 Twente Sub 21 Twente 34 52 45 48
11 ASWH ASWH 34 52 51 47
12 Harkemase Boys Harkemase 34 55 56 46
13 VVOG VVOG 34 36 51 42
14 ONS Sneek ONS Sneek 34 62 88 37
15 Capelle Capelle 34 44 57 35
16 Spijkenisse Spijkenisse 34 56 83 33
17 ACV Assen ACV Assen 34 57 83 32
18 Magreb 90 Magreb 90 34 31 122 10
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 3
Equipo PJ GF GC Puntos
1 Harkemase Boys Harkemase 26 73 27 58
2 Staphorst Staphorst 26 60 32 56
3 ACV Assen ACV Assen 26 42 38 47
4 VVOG VVOG 26 62 40 44
5 AZSV AZSV 26 47 41 41
6 Flevo Boys Flevo Boys 26 46 43 39
7 Excelsior .31 Excelsior 26 53 44 38
8 Apeldoorn CSV Apeldoorn 26 48 48 37
9 Urk Urk 26 36 37 31
10 Genemuiden Genemuiden 26 38 40 31
11 SVZW SVZW 26 44 54 29
12 HZVV HZVV 26 31 52 23
13 DOS 37 DOS 37 26 31 71 19
14 Drachtster Boys Drachtster 26 24 68 10
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 DVS'33 DVS'33 26 68 29 55
2 Excelsior .31 Excelsior 26 65 26 53
3 Harkemase Boys Harkemase 26 62 33 52
4 SVZW SVZW 26 52 43 44
5 ACV Assen ACV Assen 26 50 40 43
6 Flevo Boys Flevo Boys 26 47 46 39
7 Apeldoorn CSV Apeldoorn 26 37 46 37
8 VVOG VVOG 26 38 39 36
9 AZSV AZSV 26 35 36 32
10 Drachtster Boys Drachtster 26 31 36 32
11 Urk Urk 26 39 53 32
12 Staphorst Staphorst 26 33 48 26
13 WHC WHC 26 28 67 20
14 WVF WVF 26 15 58 10
TEMPORADA 2013/2014
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 Genemuiden Genemuiden 26 60 39 51
2 Harkemase Boys Harkemase 26 56 38 50
3 Staphorst Staphorst 26 59 35 49
4 Flevo Boys Flevo Boys 26 62 45 48
5 ACV Assen ACV Assen 26 46 34 45
6 SVZW SVZW 26 45 33 37
7 Apeldoorn CSV Apeldoorn 26 39 44 35
8 Drachtster Boys Drachtster 26 29 35 32
9 AZSV AZSV 26 38 45 31
10 VVOG VVOG 26 44 52 28
11 WHC WHC 26 39 66 28
12 DETO Twenterand DETO 26 31 46 26
13 Go Ahead Go Ahead 26 39 60 25
14 Berkum Berkum 26 33 48 24
TEMPORADA 2012/2013
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 ONS Sneek ONS Sneek 26 57 31 51
2 Staphorst Staphorst 26 48 26 46
3 SVZW SVZW 26 67 33 43
4 ACV Assen ACV Assen 26 41 27 42
5 Berkum Berkum 26 52 41 40
6 Sparta Nijkerk Sparta 26 54 44 39
7 DVS'33 DVS'33 26 47 48 36
8 VVOG VVOG 26 47 43 35
9 Harkemase Boys Harkemase 26 41 44 33
10 WHC WHC 26 42 40 31
11 HZVV HZVV 26 36 62 31
12 Flevo Boys Flevo Boys 26 38 63 26
13 Nunspeet Nunspeet 26 28 54 24
14 NSC NSC 26 32 74 21
TEMPORADA 2011/2012
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 WHC WHC 26 59 31 49
2 DETO Twenterand DETO 26 42 34 49
3 Apeldoorn CSV Apeldoorn 26 52 32 48
4 ONS Sneek ONS Sneek 26 51 31 43
5 ACV Assen ACV Assen 26 37 23 43
6 DVS'33 DVS'33 26 52 46 40
7 Flevo Boys Flevo Boys 26 55 42 36
8 Berkum Berkum 26 35 37 36
9 Nunspeet Nunspeet 26 40 52 35
10 Staphorst Staphorst 26 49 48 32
11 VVOG VVOG 26 29 36 28
12 Urk Urk 26 40 54 24
13 Oranje Nassau Oranje 26 31 67 21
14 Drachtster Boys Drachtster 26 24 63 13
TEMPORADA 2010/2011
EERSTE KLASSE ZATERDAG GRUPO 4
Equipo PJ GF GC Puntos
1 Bennekom Bennekom 26 77 18 62
2 SDV Barneveld Barneveld 26 58 25 60
3 VVOG VVOG 26 53 28 48
4 FC Zutphen FC Zutphen 26 47 41 43
5 Go Ahead Go Ahead 26 48 50 38
6 DZC '68 DZC '68 26 38 39 36
7 DOS 37 DOS 37 26 38 45 30
8 Zwart Wit '63 Zwart 26 28 37 30
9 Be Quick .28 Quick 26 35 45 30
10 WVF WVF 26 40 54 30
11 ASV Dronten ASV Dronten 26 44 46 27
12 DOS Kampen DOS Kampen 26 43 61 26
13 AVW '66 AVW '66 26 23 48 24
14 Horst Horst 26 24 59 17
TEMPORADA 2009/2010
EERSTE KLASSE ZATERDAG GRUPO 4
Equipo PJ GF GC Puntos
1 SVZW SVZW 22 42 19 49
2 DETO Twenterand DETO 22 45 26 44
3 DVS'33 DVS'33 22 47 24 39
4 NSC NSC 22 36 32 38
5 SDV Barneveld Barneveld 22 29 23 37
6 DTS Ede DTS Ede 22 34 24 36
7 VVOG VVOG 22 31 33 29
8 FC Zutphen FC Zutphen 22 34 35 27
9 Urk Urk 22 36 35 24
10 DOS Kampen DOS Kampen 22 29 50 18
11 Oranje Nassau Almelo Oranje 22 24 47 17
12 VSCO 61 VSCO 61 22 15 54 8
TEMPORADA 2008/2009
EERSTE KLASSE ZATERDAG GRUPO 4
Equipo PJ GF GC Puntos
1 Apeldoorn CSV Apeldoorn 22 52 23 42
2 DETO Twenterand DETO 22 39 19 41
3 SVZW SVZW 22 39 25 41
4 VVOG VVOG 22 37 23 38
5 DOS Kampen DOS Kampen 22 36 28 32
6 SDV Barneveld Barneveld 22 32 49 27
7 DTS Ede DTS Ede 22 31 32 26
8 FC Zutphen FC Zutphen 22 27 31 26
9 DVS'33 DVS'33 22 26 30 25
10 Veensche Boys Veensche 22 27 40 24
11 DOS 37 DOS 37 22 30 51 19
12 ASV Dronten ASV Dronten 22 16 41 14
TEMPORADA 2007/2008
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 HHC Hardenberg Hardenberg 26 69 30 60
2 Be Quick .28 Quick 26 51 22 55
3 ONS Sneek ONS Sneek 26 42 36 41
4 Excelsior .31 Excelsior 26 44 41 41
5 Flevo Boys Flevo Boys 26 41 34 35
6 Genemuiden Genemuiden 26 44 39 34
7 WHC WHC 26 41 40 34
8 Go Ahead Go Ahead 26 35 38 32
9 Staphorst Staphorst 26 38 47 32
10 PKC .83 PKC .83 26 46 56 32
11 Oranje Nassau Oranje 26 30 48 31
12 VVOG VVOG 26 32 56 30
13 ACV Assen ACV Assen 26 34 40 26
14 DOS Kampen DOS Kampen 26 28 48 23
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 2005/2006
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 58 25 57
2 ASWH ASWH 26 45 23 45
3 Sparta Nijkerk Sparta 26 48 37 44
4 GVVV GVVV 26 41 35 43
5 Spakenburg Spakenburg 26 51 42 42
6 Bennekom Bennekom 26 48 41 41
7 VVOG VVOG 26 42 38 37
8 SHO SHO 26 43 54 34
9 Kozakken Boys Kozakken 26 37 38 32
10 SV Geinoord SV Geinoord 25 40 43 32
11 Heerjansdam Heerjansdam 26 32 52 32
12 DOVO DOVO 26 39 46 28
13 Deltasport Deltasport 26 34 57 27
14 SDC Putten SDC Putten 25 27 54 14
TEMPORADA 2004/2005
HOOFDKLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 Excelsior .31 Excelsior 27 64 39 49
2 Harkemase Boys Harkemase 26 69 44 48
3 Be Quick .28 Quick 27 61 46 46
4 ACV Assen ACV Assen 27 54 46 44
5 Urk Urk 27 55 49 44
6 WHC WHC 25 51 35 41
7 VVOG VVOG 26 47 43 41
8 ONS Sneek ONS Sneek 25 55 52 34
9 Genemuiden Genemuiden 25 44 47 33
10 HHC Hardenberg Hardenberg 25 41 51 30
11 SDC Putten SDC Putten 26 34 39 29
12 DOS Kampen DOS Kampen 26 35 50 25
13 Nunspeet Nunspeet 26 30 61 23
14 ASV Dronten ASV Dronten 26 32 70 21

  USO DE MEMORIA  
7,095,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.7633
Total Execution Time  0.7647
  CADENA URL  
/historico/Vvog
  GET DATOS  
$_GET['/historico/Vvog']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0154  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 = 'Vvog' 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.0145  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=7182 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=7182 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7182 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 227 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (711277) ORDER BY n.cover_points DESC, update_date DESC
0.0173  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 = '7182' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0168  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=7182 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  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 (72974,71881,68342,68212,67320) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 68212 AND teamId = 7182
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72974 AND teamId = 7182
0.0176  SELECT count(id) as num_players from rel_players WHERE league_id = 68342 AND teamId = 7182
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 71881 AND teamId = 7182
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 7182
0.0158  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 = '7182' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7182' and rp.type = 4
0.0148  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 = '7182' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7182 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.0152  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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7182 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7182 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 7182 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0159  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 = 72974 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0311  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 = 68212 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 63259 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 57889 AND t.round = 6 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 `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 = 50980 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 44605 AND t.round = 34 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 `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 = 38963 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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.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 = 15937 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 `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 = 9392 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 `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 = 9395 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 `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 = 2191 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 `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 = 1715 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 `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 = 20432 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 `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 = 20437 AND t.round = 22 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 `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 = 20442 AND t.round = 22 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 `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 = 20388 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 `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.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 `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 = 20393 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 `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 = 20397 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC