4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Meerssen
TEMPORADA 2023/2024
DERDE DIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 30 64 28 61
2 BVV Barendrecht Barendrecht 30 66 32 61
3 Blauw Geel '38 Blauw Geel 30 57 33 57
4 SV TEC Tiel SV TEC Tiel 30 60 24 56
5 Meerssen Meerssen 30 64 47 50
6 Sportlust 46 Sportlust 30 45 33 49
7 Gemert Gemert 30 51 53 49
8 TOGB TOGB 30 45 40 46
9 Kloetinge Kloetinge 30 43 41 46
10 UNA UNA 30 47 41 44
11 HV & CV Quick Quick 30 58 57 43
12 Hoek Hoek 30 67 48 41
13 OSS '20 OSS '20 30 40 58 33
14 OJC Rosmalen Rosmalen 30 44 60 31
15 AWC AWC 30 24 57 29
16 Groene Ster Groene Ster 30 24 65 26
17 GVV Unitas GVV Unitas 30 31 55 23
18 Baronie Baronie 30 21 79 13
TEMPORADA 2022/2023
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 30 61 26 69
2 Kampong Kampong 30 56 27 54
3 Juliana 31 Juliana 31 30 64 44 50
4 Hoogland Hoogland 30 55 49 48
5 LONGA '30 LONGA '30 30 49 35 47
6 Venray Venray 30 64 58 46
7 Halsteren Halsteren 30 50 40 45
8 RKSV Nuenen RKSV Nuenen 30 40 36 45
9 HVCH HVCH 30 47 50 44
10 AWC AWC 29 51 55 44
11 SV Orion SV Orion 29 49 52 43
12 Unitas 30 Unitas 30 30 50 57 39
13 EVV EVV 30 38 40 37
14 Silvolde Silvolde 30 31 50 26
15 Moerse Boys Moerse Boys 30 47 72 24
16 RKZVC RKZVC 30 24 85 10
TEMPORADA 2021/2022
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Baronie Baronie 26 53 21 60
2 OJC Rosmalen Rosmalen 26 60 33 54
3 UDI '19 UDI '19 26 41 29 49
4 SV Orion SV Orion 26 51 35 47
5 Halsteren Halsteren 26 48 39 44
6 Juliana 31 Juliana 31 26 45 38 41
7 RKSV Nuenen RKSV Nuenen 26 36 31 37
8 AWC AWC 26 49 50 33
9 Meerssen Meerssen 26 40 45 33
10 Silvolde Silvolde 26 38 30 32
11 RKZVC RKZVC 26 25 44 27
12 Moerse Boys Moerse Boys 26 29 53 22
13 LONGA '30 LONGA '30 26 33 59 19
14 RKSV Minor RKSV Minor 26 27 68 14
15 EHC Hoensbroek Hoensbroek 0 0 0 0
TEMPORADA 2020/2021
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 6 11 5 14
2 Baronie Baronie 5 20 0 13
3 AWC AWC 5 9 10 10
4 Halsteren Halsteren 5 10 6 9
5 SV Orion SV Orion 4 7 5 9
6 OJC Rosmalen Rosmalen 5 9 8 8
7 EHC Hoensbroek Hoensbroek 6 8 15 8
8 IFC IFC 5 9 6 7
9 Moerse Boys Moerse Boys 6 9 12 7
10 UDI '19 UDI '19 5 7 10 6
11 TOGB TOGB 5 7 11 5
12 VOC VOC 6 7 12 4
13 Juliana 31 Juliana 31 2 4 3 3
14 RKSV Minor RKSV Minor 6 9 16 2
15 RKSV Nuenen RKSV Nuenen 5 6 13 1
16 Leonidas Leonidas 0 0 0 0
TEMPORADA 2019/2020
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 GVV Unitas GVV Unitas 20 35 12 47
2 Halsteren Halsteren 20 42 18 41
3 IFC IFC 20 46 25 35
4 Baronie Baronie 20 38 19 35
5 RKZVC RKZVC 20 40 25 34
6 Juliana 31 Juliana 31 20 48 33 31
7 OJC Rosmalen Rosmalen 20 36 33 30
8 UDI '19 UDI '19 19 28 22 29
9 AWC AWC 19 21 32 25
10 LONGA '30 LONGA '30 19 32 35 24
11 Meerssen Meerssen 19 20 29 22
12 Silvolde Silvolde 19 19 28 20
13 RKSV Minor RKSV Minor 19 21 46 19
14 Moerse Boys Moerse Boys 20 29 38 18
15 EHC Hoensbroek Hoensbroek 20 23 49 16
16 RKSV Nuenen RKSV Nuenen 20 10 44 10
TEMPORADA 2018/2019
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Groene Ster Groene Ster 28 61 27 64
2 Gemert Gemert 28 80 36 59
3 Halsteren Halsteren 28 57 22 57
4 Baronie Baronie 28 52 30 56
5 GVV Unitas GVV Unitas 28 59 42 53
6 RKSV Nuenen RKSV Nuenen 28 45 39 40
7 Meerssen Meerssen 28 39 44 38
8 Alphense Boys Alphense 28 51 47 36
9 UDI '19 UDI '19 28 36 42 34
10 RKSV Minor RKSV Minor 28 39 54 31
11 RKAVV RKAVV 28 33 42 29
12 IFC IFC 28 46 66 28
13 Leonidas Leonidas 28 38 65 28
14 Vlissingen Vlissingen 28 30 52 26
15 De Meern De Meern 28 25 83 10
16 Magreb 90 Magreb 90 0 0 0 0
TEMPORADA 2017/2018
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 OSS '20 OSS '20 30 72 30 64
2 GOES GOES 30 66 41 58
3 Halsteren Halsteren 30 48 31 55
4 Den Bosch II Bosch 30 63 44 49
5 UDI '19 UDI '19 30 60 50 47
6 Gemert Gemert 30 63 49 45
7 Meerssen Meerssen 30 56 46 45
8 IFC IFC 30 45 53 42
9 RKSV Nuenen RKSV Nuenen 30 49 62 41
10 Vlissingen Vlissingen 30 44 39 39
11 Groene Ster Groene Ster 30 45 51 39
12 Baronie Baronie 30 42 41 36
13 Juliana 31 Juliana 31 30 39 61 33
14 BVC '12 Beek Beek 30 43 62 30
15 EHC Hoensbroek Hoensbroek 30 41 72 29
16 Woezik Woezik 30 37 81 23
TEMPORADA 2016/2017
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 26 67 26 59
2 Susteren Susteren 26 59 32 48
3 Wittenhorst Wittenhorst 26 43 31 48
4 RKSV Bekkerveld RKSV 26 60 27 47
5 Schaesberg Schaesberg 26 48 49 41
6 Geldrop Geldrop 26 60 62 37
7 ZSV ZSV 26 43 46 35
8 Venray Venray 26 47 60 34
9 Deurne Deurne 26 40 43 33
10 RKSV Minor RKSV Minor 26 40 56 28
11 De Valk De Valk 26 41 50 27
12 Someren Someren 26 27 42 25
13 Volharding Volharding 26 40 71 23
14 SSS '18 SSS '18 26 37 57 19
TEMPORADA 2015/2016
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 Chevremont Chevremont 26 69 20 63
2 Meerssen Meerssen 26 53 23 51
3 RKSV Bekkerveld RKSV 26 55 36 44
4 Heidebloem Heidebloem 26 53 41 43
5 De Valk De Valk 26 54 53 42
6 RKSV Minor RKSV Minor 26 56 44 39
7 ZSV ZSV 26 57 49 38
8 Susteren Susteren 26 49 47 37
9 Wittenhorst Wittenhorst 26 49 37 36
10 Venray Venray 26 53 62 34
11 Deurne Deurne 26 49 54 32
12 SSS '18 SSS '18 26 39 57 27
13 Sporting Heerlen Sporting 26 30 74 17
14 RVU Rothem RVU Rothem 26 15 84 7
TEMPORADA 2014/2015
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 EHC Hoensbroek Hoensbroek 26 55 14 59
2 RKSV Bekkerveld RKSV 26 55 33 50
3 Wittenhorst Wittenhorst 26 44 22 47
4 Venray Venray 26 47 41 39
5 RVU Rothem RVU Rothem 26 35 41 39
6 Meerssen Meerssen 26 37 34 38
7 Geldrop Geldrop 26 42 35 35
8 Heidebloem Heidebloem 26 48 44 35
9 RKSV Minor RKSV Minor 26 36 40 32
10 Susteren Susteren 26 48 59 32
11 Wilhelmina 08 Wilhelmina 26 43 47 31
12 Someren Someren 26 24 34 28
13 BSV Limburgia Limburgia 26 34 70 23
14 NWC NWC 26 23 57 15
TEMPORADA 2013/2014
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 TOP Oss Amateurs Amateurs 26 54 22 55
2 DESO DESO 26 36 21 53
3 Heidebloem Heidebloem 26 49 33 47
4 Meerssen Meerssen 26 48 29 45
5 Someren Someren 26 49 32 45
6 HVCH HVCH 26 44 32 43
7 Susteren Susteren 26 38 36 36
8 BSV Limburgia Limburgia 26 38 49 31
9 RVU Rothem RVU Rothem 26 24 36 29
10 Wittenhorst Wittenhorst 26 26 37 28
11 SVC 2000 SVC 2000 26 34 46 24
12 Sparta '25 Sparta '25 26 34 62 24
13 Chevremont Chevremont 26 29 48 21
14 SSS '18 SSS '18 26 34 54 18
TEMPORADA 2012/2013
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 RKSV Bekkerveld RKSV 24 43 14 52
2 Wittenhorst Wittenhorst 24 42 29 49
3 Meerssen Meerssen 24 49 33 41
4 TOP Oss Amateurs Amateurs 24 42 32 41
5 OSS '20 OSS '20 24 43 27 36
6 BSV Limburgia Limburgia 24 39 36 36
7 Sparta '25 Sparta '25 24 40 39 31
8 RVU Rothem RVU Rothem 24 30 39 31
9 Heidebloem Heidebloem 24 37 43 30
10 HVCH HVCH 24 28 35 30
11 HVV Helmond HVV Helmond 24 27 39 28
12 GSV .28 GSV .28 24 31 47 26
13 Caesar Caesar 24 19 57 8
TEMPORADA 2011/2012
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Gemert Gemert 24 51 26 52
2 EHC Hoensbroek Hoensbroek 24 44 27 43
3 RKSV Nuenen RKSV Nuenen 24 45 33 39
4 OJC Rosmalen Rosmalen 24 44 31 38
5 Blauw Geel '38 Blauw Geel 24 42 33 38
6 Groene Ster Groene Ster 24 43 38 38
7 Dongen Dongen 24 44 40 38
8 Deurne Deurne 24 40 29 33
9 Baronie Baronie 24 35 33 32
10 Meerssen Meerssen 24 32 38 28
11 De Valk De Valk 24 40 54 26
12 Venray Venray 24 36 52 26
13 Dijkse Boys Dijkse Boys 24 30 55 26
14 DESK DESK 24 21 58 10
TEMPORADA 2010/2011
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 UNA UNA 26 55 24 54
2 EHC Hoensbroek Hoensbroek 26 53 49 42
3 Dongen Dongen 26 53 40 41
4 UDI '19 UDI '19 26 51 42 37
5 De Valk De Valk 26 43 47 37
6 Venray Venray 26 53 40 36
7 OJC Rosmalen Rosmalen 26 46 59 36
8 DESK DESK 26 37 52 36
9 Meerssen Meerssen 26 43 44 35
10 Blauw Geel '38 Blauw Geel 26 42 43 35
11 Juliana 31 Juliana 31 26 47 44 34
12 Deurne Deurne 26 37 45 33
13 Papendrecht Papendrecht 26 25 33 32
14 Schijndel Schijndel 26 32 55 17
TEMPORADA 2009/2010
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Gemert Gemert 26 48 27 54
2 Baronie Baronie 26 42 19 52
3 EVV EVV 26 43 33 46
4 JVC Cuijk JVC Cuijk 26 53 36 45
5 Dijkse Boys Dijkse Boys 26 53 40 43
6 Venray Venray 26 59 40 41
7 UNA UNA 26 45 38 37
8 Meerssen Meerssen 26 38 51 31
9 UDI '19 UDI '19 26 37 44 30
10 OJC Rosmalen Rosmalen 26 34 44 30
11 Papendrecht Papendrecht 26 40 59 30
12 Schijndel Schijndel 26 35 40 28
13 DESK DESK 26 33 61 26
14 OSS '20 OSS '20 26 27 55 13
TEMPORADA 2008/2009
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Baronie Baronie 26 47 28 53
2 Gemert Gemert 26 50 20 52
3 EVV EVV 25 39 23 48
4 UNA UNA 26 45 37 40
5 Dijkse Boys Dijkse Boys 26 39 31 40
6 DESK DESK 26 39 52 36
7 Meerssen Meerssen 26 40 46 35
8 Papendrecht Papendrecht 26 30 38 34
9 JVC Cuijk JVC Cuijk 26 41 39 33
10 Venray Venray 25 53 47 32
11 Schijndel Schijndel 26 29 31 31
12 Deurne Deurne 26 30 33 30
13 OJC Rosmalen Rosmalen 26 29 34 25
14 LONGA LONGA 26 25 77 10
TEMPORADA 2007/2008
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Deurne Deurne 26 45 22 51
2 UNA UNA 26 59 34 47
3 Papendrecht Papendrecht 26 43 30 45
4 Gemert Gemert 26 39 30 40
5 Baronie Baronie 26 43 38 40
6 Meerssen Meerssen 26 37 43 36
7 DESK DESK 26 44 52 36
8 EVV EVV 26 54 41 35
9 JVC Cuijk JVC Cuijk 26 40 38 34
10 Dijkse Boys Dijkse Boys 26 38 52 31
11 OJC Rosmalen Rosmalen 26 29 35 28
12 Schijndel Schijndel 26 28 35 25
13 UDI '19 UDI '19 26 26 46 22
14 Geldrop Geldrop 26 30 59 21
TEMPORADA 2006/2007
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 JVC Cuijk JVC Cuijk 26 60 25 51
2 EVV EVV 26 42 31 47
3 Baronie Baronie 26 43 30 44
4 Schijndel Schijndel 26 46 30 43
5 Gemert Gemert 26 51 36 42
6 UDI '19 UDI '19 26 39 31 42
7 Papendrecht Papendrecht 26 42 50 39
8 OJC Rosmalen Rosmalen 26 50 38 37
9 Meerssen Meerssen 26 43 39 37
10 UNA UNA 26 45 35 36
11 Geldrop Geldrop 26 37 34 33
12 Blauw Geel '38 Blauw Geel 26 29 43 30
13 Groene Ster Groene Ster 26 43 71 21
14 SV Triborgh SV Triborgh 26 17 94 5
TEMPORADA 2005/2006
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Schijndel Schijndel 26 59 28 59
2 Gemert Gemert 25 43 23 49
3 JVC Cuijk JVC Cuijk 25 49 30 47
4 Meerssen Meerssen 26 35 31 43
5 Geldrop Geldrop 26 45 38 40
6 EVV EVV 26 50 35 36
7 UNA UNA 26 33 29 36
8 UDI '19 UDI '19 26 39 41 34
9 Baronie Baronie 26 38 40 33
10 Papendrecht Papendrecht 26 34 36 32
11 SV Triborgh SV Triborgh 26 39 51 29
12 Deurne Deurne 25 31 43 27
13 TOP Oss Amateurs Amateurs 26 22 61 17
14 Panningen Panningen 25 28 59 16
TEMPORADA 2004/2005
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Schijndel Schijndel 26 67 27 58
2 Gemert Gemert 26 54 26 54
3 Baronie Baronie 26 50 35 46
4 EVV EVV 26 49 39 42
5 JVC Cuijk JVC Cuijk 26 44 42 40
6 Meerssen Meerssen 26 55 54 39
7 UDI '19 UDI '19 26 42 43 38
8 Geldrop Geldrop 25 47 35 36
9 Deurne Deurne 26 34 40 35
10 TOP Oss Amateurs Amateurs 26 49 55 28
11 UNA UNA 26 29 44 27
12 Internos Internos 26 31 49 25
13 Groene Ster Groene Ster 26 34 57 21
14 Vinkenslag Vinkenslag 25 30 69 17

  USO DE MEMORIA  
7,438,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1596
Total Execution Time  0.1608
  CADENA URL  
/historico/Meerssen
  GET DATOS  
$_GET['/historico/Meerssen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0031  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 = 'Meerssen' 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.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=7221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=7221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=7221 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=7221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7221 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=225 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 225 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (643398,640930,407176,308163,31304) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '7221' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '7221' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '7221' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=7221 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72700,72637,71432,70057) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72700 AND teamId = 7221
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 70057 AND teamId = 7221
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7221
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7221
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 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 = 72700 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '7221' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7221' and rp.type = 4
0.0022  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 = '7221' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7221 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.0028  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7221 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7221 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 7221 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72700 AND t.round = 31 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 = 70057 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.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 `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 = 63265 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.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 `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 = 58337 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.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 `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 = 50985 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 44703 AND t.round = 30 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 `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 = 39751 AND t.round = 30 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 `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 = 33991 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 `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 = 16018 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 `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 = 9402 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 = 9419 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 = 2390 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 = 1717 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 = 20401 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 `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 = 20404 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 `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 = 20407 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 `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 = 20410 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 `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 = 20413 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 `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 = 20416 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 `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 = 20420 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC