4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Meiendorfer SV
TEMPORADA 2022/2023
LANDESLIGA GRUPO 20
Equipo PJ GF GC Puntos
1 ETSV Hamburg ETSV Hamburg 30 128 31 78
2 Düneberger SV Düneberger 30 121 42 77
3 Voran Ohe Voran Ohe 30 67 56 54
4 Rahlstedter SC Rahlstedter 30 84 51 52
5 SC V/W Billstedt Billstedt 30 89 66 50
6 Lohbrügge Lohbrügge 30 72 57 49
7 Condor Hamburg Condor 30 76 70 49
8 Bramfelder SV Bramfelder 30 80 50 48
9 SV Altengamme Altengamme 30 65 49 41
10 Ahrensburger TSV Ahrensburger 30 68 70 40
11 ASV Hamburg ASV Hamburg 30 69 75 38
12 HT 16 Hamburg Hamburg 30 70 60 36
13 Oststeinbeker SV Oststeinbeke 30 50 87 32
14 Kosova Kosova 30 40 57 28
15 TSV Sasel II Sasel 30 34 122 9
16 Meiendorfer SV Meiendorfer 30 22 192 3
TEMPORADA 2021/2022
OBERLIGA GRUPO 20
Equipo PJ GF GC Puntos
1 Tus Osdorf Tus Osdorf 10 35 7 40
2 Süderelbe Süderelbe 10 33 15 40
3 Rugenbergen Rugenbergen 10 34 6 38
4  Hamburger SV III Hamburger 10 43 15 37
5 Union Tornesch Union 10 24 19 30
6 Hamm United FC Hamm United 10 17 23 20
7 Lohbrügge Lohbrügge 10 13 29 18
8 Barmbek-Uhlenhorst Barmbek-Uhle 10 9 35 15
9 Bramfelder SV Bramfelder 10 14 35 14
10 Meiendorfer SV Meiendorfer 10 9 47 8
TEMPORADA 2020/2021
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Dassendorf Dassendorf 6 16 4 14
2 Victoria Hamburg Victoria 6 15 10 12
3 Wandsbeker Concordia Wandsbeker 5 15 12 12
4 TSV Buchholz 08 Buchholz 6 15 6 11
5 Hamm United FC Hamm United 6 13 10 10
6 Barmbek-Uhlenhorst Barmbek-Uhle 5 12 8 9
7 HEBC Hamburg HEBC Hamburg 6 10 7 8
8 TSV Sasel TSV Sasel 4 10 7 8
9 Paloma Hamburg Paloma 4 8 4 7
10 Curslack-Neuengamme Curslack-Neu 5 13 11 7
11 Rugenbergen Rugenbergen 5 13 12 7
12 Niendorfer TSV Niendorfer 5 8 8 7
13 Bramfelder SV Bramfelder 6 8 10 7
14  Hamburger SV III Hamburger 6 16 20 7
15 Süderelbe Süderelbe 6 11 19 7
16 Lohbrügge Lohbrügge 5 5 7 4
17 Tus Osdorf Tus Osdorf 5 8 13 3
18 Meiendorfer SV Meiendorfer 5 10 24 3
19 Union Tornesch Union 6 9 23 0
TEMPORADA 2019/2020
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Dassendorf Dassendorf 25 68 19 66
2 Teutonia Ottensen Teutonia 25 64 28 57
3 Barmbek-Uhlenhorst Barmbek-Uhle 25 71 36 55
4 Victoria Hamburg Victoria 25 74 36 50
5 TSV Sasel TSV Sasel 25 64 31 48
6 Niendorfer TSV Niendorfer 25 49 34 46
7  Hamburger SV III Hamburger 24 65 56 36
8 Tus Osdorf Tus Osdorf 25 56 53 33
9 Curslack-Neuengamme Curslack-Neu 25 49 52 29
10 Wandsbeker Concordia Wandsbeker 24 43 53 29
11 Süderelbe Süderelbe 25 45 70 29
12 Hamm United FC Hamm United 23 34 55 27
13 Paloma Hamburg Paloma 24 46 48 25
14 Rugenbergen Rugenbergen 23 33 56 24
15 Union Tornesch Union 24 33 60 23
16 TSV Buchholz 08 Buchholz 23 39 69 17
17 Meiendorfer SV Meiendorfer 25 31 70 12
18 Bramfelder SV Bramfelder 25 31 69 10
TEMPORADA 2018/2019
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Altona 93 Altona 93 34 72 24 78
2 Teutonia Ottensen Teutonia 34 79 33 76
3 Dassendorf Dassendorf 34 92 30 71
4 Victoria Hamburg Victoria 34 100 46 71
5 Niendorfer TSV Niendorfer 34 81 39 64
6 TSV Sasel TSV Sasel 35 90 53 62
7 Barmbek-Uhlenhorst Barmbek-Uhle 34 88 58 60
8 Tus Osdorf Tus Osdorf 34 68 69 50
9 TSV Buchholz 08 Buchholz 34 73 66 49
10 Süderelbe Süderelbe 34 68 70 46
11 Curslack-Neuengamme Curslack-Neu 34 61 59 44
12 Rugenbergen Rugenbergen 34 63 67 40
13 Wandsbeker Concordia Wandsbeker 34 56 76 37
14 Meiendorfer SV Meiendorfer 34 44 71 36
15 Wedeler TSV Wedeler TSV 34 51 68 33
16 HEBC Hamburg HEBC Hamburg 34 55 99 29
17 Condor Hamburg Condor 35 60 95 28
18 Pinneberg Pinneberg 34 21 199 3
TEMPORADA 2017/2018
LANDESLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Meiendorfer SV Meiendorfer 30 83 21 72
2 Bramfelder SV Bramfelder 30 77 55 59
3 Dersimspor Hamburg Dersimspor 30 65 47 55
4 SV Altengamme Altengamme 30 86 57 53
5 Voran Ohe Voran Ohe 30 59 48 50
6 SV Nettelnburg/Allermöhe Nettelnburg/ 30 74 67 49
7 BSV Buxtehude Buxtehude 30 78 64 47
8 Lohbrügge Lohbrügge 30 79 65 46
9 SV Bergstedt Bergstedt 30 52 55 44
10 Rahlstedter SC Rahlstedter 30 62 57 41
11 TuS Berne TuS Berne 30 65 68 41
12 Kosova Kosova 30 46 76 33
13 FC Elazig Spor Elazig Spor 30 43 70 29
14 Juventude do Minho Juventude 30 46 86 27
15 Bergedorf 85 Bergedorf 30 39 79 23
16 Condor Hamburg II Condor 30 51 90 18
TEMPORADA 2016/2017
LANDESLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 TSV Sasel TSV Sasel 30 90 34 63
2 Vorwärts-Wacker 04 Vorwärts-Wa 30 71 39 62
3 Bramfelder SV Bramfelder 30 81 38 59
4 Dersimspor Hamburg Dersimspor 30 71 48 59
5 Meiendorfer SV Meiendorfer 30 73 52 53
6 Voran Ohe Voran Ohe 30 63 50 49
7 SV Nettelnburg/Allermöhe Nettelnburg/ 30 59 56 46
8 Paloma Hamburg Paloma 30 60 46 43
9 Condor Hamburg II Condor 30 60 65 39
10 Bergedorf 85 Bergedorf 30 56 80 37
11 FC Elazig Spor Elazig Spor 30 43 55 32
12 Lohbrügge Lohbrügge 30 51 62 31
13 SV Altengamme Altengamme 30 33 55 31
14 Hamm United FC Hamm United 30 39 55 26
15 Barsbütteler SV Barsbüttele 30 30 55 23
16 SC Schwarzenbek Schwarzenbek 30 26 116 13
TEMPORADA 2015/2016
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Dassendorf Dassendorf 34 80 22 72
2 Barmbek-Uhlenhorst Barmbek-Uhle 34 75 34 71
3 Victoria Hamburg Victoria 34 79 43 63
4 Süderelbe Süderelbe 34 95 34 60
5 TSV Buchholz 08 Buchholz 34 73 37 60
6 Altona 93 Altona 93 34 65 41 57
7 Condor Hamburg Condor 34 73 56 54
8 Rugenbergen Rugenbergen 34 67 52 51
9 Curslack-Neuengamme Curslack-Neu 34 72 50 50
10 Halstenbek-Rellingen Halstenbek-R 34 60 44 49
11 WTSV Concordia WTSV 34 82 61 47
12 Niendorfer TSV Niendorfer 34 56 39 46
13 Pinneberg Pinneberg 34 48 43 44
14 Türkiye Türkiye 34 56 73 40
15 BSV Buxtehude Buxtehude 34 51 72 39
16 Meiendorfer SV Meiendorfer 34 48 77 35
17 Paloma Hamburg Paloma 34 42 105 17
18 SV Lurup SV Lurup 34 13 252 1
TEMPORADA 2014/2015
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Dassendorf Dassendorf 32 82 30 68
2 Victoria Hamburg Victoria 32 72 40 64
3 Barmbek-Uhlenhorst Barmbek-Uhle 32 60 35 61
4 Pinneberg Pinneberg 32 54 38 56
5 Halstenbek-Rellingen Halstenbek-R 32 80 49 54
6 TSV Buchholz 08 Buchholz 32 55 37 52
7 Altona 93 Altona 93 32 61 38 51
8 Niendorfer TSV Niendorfer 32 56 50 50
9 Rugenbergen Rugenbergen 32 44 41 49
10 Meiendorfer SV Meiendorfer 32 47 51 49
11 Condor Hamburg Condor 32 62 59 43
12 Süderelbe Süderelbe 32 47 49 41
13 Curslack-Neuengamme Curslack-Neu 32 51 57 40
14 Paloma Hamburg Paloma 32 41 69 36
15 BSV Buxtehude Buxtehude 32 35 71 23
16 SC Vier- und Marschlande Vier- 32 38 92 16
17 Germania Schnelsen Germania 32 26 105 9
18 Elmshorn Elmshorn 0 0 0 0
TEMPORADA 2013/2014
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Dassendorf Dassendorf 34 68 30 75
2 Curslack-Neuengamme Curslack-Neu 34 83 39 64
3 Altona 93 Altona 93 34 78 43 64
4 Pinneberg Pinneberg 34 66 46 61
5 TSV Buchholz 08 Buchholz 34 67 38 60
6 Condor Hamburg Condor 34 61 39 58
7 Niendorfer TSV Niendorfer 34 44 30 55
8 Rugenbergen Rugenbergen 34 74 62 55
9 Elmshorn Elmshorn 34 57 50 51
10 Halstenbek-Rellingen Halstenbek-R 34 52 47 49
11 Oststeinbeker SV Oststeinbeke 34 53 51 46
12 Meiendorfer SV Meiendorfer 34 45 58 45
13 Barmbek-Uhlenhorst Barmbek-Uhle 34 52 52 40
14 Germania Schnelsen Germania 34 55 81 36
15 SC Vier- und Marschlande Vier- 34 48 66 35
16 Alstertal-Langenhorn Alstertal-La 34 45 87 27
17 Blankenese Blankenese 34 38 102 18
18 Bramfelder SV Bramfelder 34 30 95 13
TEMPORADA 2012/2013
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Elmshorn Elmshorn 34 76 29 76
2 Altona 93 Altona 93 34 74 50 67
3 TSV Buchholz 08 Buchholz 34 79 38 65
4 Eintracht Norderstedt Eintracht 34 76 37 64
5 Condor Hamburg Condor 34 75 48 58
6 Curslack-Neuengamme Curslack-Neu 34 67 48 58
7 Halstenbek-Rellingen Halstenbek-R 34 51 46 50
8 Germania Schnelsen Germania 34 50 54 47
9 Meiendorfer SV Meiendorfer 34 61 62 45
10 Rugenbergen Rugenbergen 34 54 55 45
11 Barmbek-Uhlenhorst Barmbek-Uhle 34 44 51 44
12 SC Vier- und Marschlande Vier- 34 45 55 41
13 Niendorfer TSV Niendorfer 34 44 63 41
14 Pinneberg Pinneberg 34 50 59 39
15 Bramfelder SV Bramfelder 34 43 56 38
16 Paloma Hamburg Paloma 34 41 49 36
17 SV Lurup SV Lurup 34 28 87 17
18 Bergedorf 85 Bergedorf 34 35 106 15
TEMPORADA 2011/2012
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Victoria Hamburg Victoria 34 73 36 71
2 Bergedorf 85 Bergedorf 34 73 51 65
3 Curslack-Neuengamme Curslack-Neu 34 63 41 64
4 Germania Schnelsen Germania 34 66 49 60
5 TSV Buchholz 08 Buchholz 34 55 39 59
6 Eintracht Norderstedt Eintracht 34 62 37 58
7 Condor Hamburg Condor 34 54 44 57
8 Niendorfer TSV Niendorfer 34 62 51 55
9 Altona 93 Altona 93 34 52 51 50
10 Pinneberg Pinneberg 34 57 55 49
11 Halstenbek-Rellingen Halstenbek-R 34 46 52 46
12 Meiendorfer SV Meiendorfer 34 56 57 42
13 SC Vier- und Marschlande Vier- 34 55 70 40
14 Rugenbergen Rugenbergen 34 51 62 38
15 Paloma Hamburg Paloma 34 38 58 38
16 Oststeinbeker SV Oststeinbeke 34 39 55 37
17 Vorwärts-Wacker 04 Vorwärts-Wa 34 45 77 22
18 TSV Sasel TSV Sasel 34 38 100 10
TEMPORADA 2010/2011
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 St. Pauli II Pauli 34 103 36 83
2 TSV Buchholz 08 Buchholz 34 56 33 68
3 Curslack-Neuengamme Curslack-Neu 34 55 43 62
4 Condor Hamburg Condor 34 55 43 57
5 Altona 93 Altona 93 34 63 46 54
6 Eintracht Norderstedt Eintracht 34 55 44 52
7 Bergedorf 85 Bergedorf 34 67 69 52
8 Meiendorfer SV Meiendorfer 34 55 48 51
9 Victoria Hamburg Victoria 34 58 51 50
10 Germania Schnelsen Germania 34 55 47 45
11 Rugenbergen Rugenbergen 34 46 47 45
12 Niendorfer TSV Niendorfer 34 55 63 40
13 Oststeinbeker SV Oststeinbeke 34 59 67 39
14 Paloma Hamburg Paloma 34 39 57 32
15 Barmbek-Uhlenhorst Barmbek-Uhle 34 46 68 32
16 Wedeler TSV Wedeler TSV 34 43 71 32
17 WTSV Concordia WTSV 34 37 71 31
18 Bramfelder SV Bramfelder 34 41 84 24
TEMPORADA 2009/2010
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Victoria Hamburg Victoria 34 78 40 68
2 TSV Buchholz 08 Buchholz 34 60 28 68
3 Altona 93 Altona 93 34 73 36 66
4 Curslack-Neuengamme Curslack-Neu 34 64 46 62
5 Meiendorfer SV Meiendorfer 34 64 42 56
6 Oststeinbeker SV Oststeinbeke 34 62 51 54
7 Paloma Hamburg Paloma 34 53 44 49
8 Bergedorf 85 Bergedorf 34 58 50 49
9 Condor Hamburg Condor 34 50 58 45
10 Eintracht Norderstedt Eintracht 34 52 47 44
11 Niendorfer TSV Niendorfer 34 43 43 42
12 Wedeler TSV Wedeler TSV 34 57 63 40
13 Barmbek-Uhlenhorst Barmbek-Uhle 34 39 56 40
14 WTSV Concordia WTSV 34 43 61 40
15 SV Lurup SV Lurup 34 40 57 39
16 Halstenbek-Rellingen Halstenbek-R 34 40 73 32
17 Lohbrügge Lohbrügge 34 33 72 26
18 Uetersen Uetersen 34 38 80 25
TEMPORADA 2008/2009
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Victoria Hamburg Victoria 34 83 37 74
2 Meiendorfer SV Meiendorfer 34 68 38 67
3 Bergedorf 85 Bergedorf 34 67 39 67
4 TSV Buchholz 08 Buchholz 34 56 29 66
5 St. Pauli II Pauli 34 78 36 60
6 Curslack-Neuengamme Curslack-Neu 34 71 55 58
7 Barmbek-Uhlenhorst Barmbek-Uhle 34 54 58 50
8 Eintracht Norderstedt Eintracht 34 61 60 49
9 SV Lurup SV Lurup 34 46 48 49
10 Condor Hamburg Condor 34 51 47 46
11 Paloma Hamburg Paloma 34 46 42 43
12 Niendorfer TSV Niendorfer 34 45 48 42
13 Concordia Hamburg Concordia 34 42 51 40
14 Halstenbek-Rellingen Halstenbek-R 34 35 56 40
15 Hamburg 93 Hamburg 93 34 43 75 30
16 Vorwärts-Wacker 04 Vorwärts-Wa 34 39 66 27
17 Egenbuttel Egenbuttel 34 39 91 21
18 Voran Ohe Voran Ohe 34 43 91 20
TEMPORADA 2005/2006
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 Wilhelmshaven SV Wilhelmshave 34 91 39 79
2 Cloppenburg Cloppenburg 34 75 34 75
3 Wolfsburg II Wolfsburg 34 73 32 70
4 Eintracht Nordhorn Eintracht 34 68 40 67
5 Hannover 96 II Hannover 34 58 27 64
6 Holstein Kiel II Holstein 34 67 53 56
7 Altona 93 Altona 93 34 61 52 48
8 SV Meppen SV Meppen 34 51 47 46
9 Arminia Hannover Arminia 34 63 64 45
10 St. Pauli II Pauli 34 47 56 44
11 Bergedorf 85 Bergedorf 34 45 50 41
12 Eintracht Braunschweig II Eintracht 34 51 61 41
13 Osnabrück II Osnabrück 34 49 65 39
14 VfR Neumunster Neumunster 34 39 69 33
15 Kropp Kropp 34 43 83 31
16 Eider Büdelsdorf Eider 34 54 85 30
17 Meiendorfer SV Meiendorfer 34 38 75 24
18 Brinkumer SV Brinkumer 34 38 79 23
TEMPORADA 2004/2005
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 BSV Kickers Emden Kickers 34 64 18 81
2 Wilhelmshaven SV Wilhelmshave 34 85 33 75
3 SV Meppen SV Meppen 34 64 25 74
4 Eintracht Nordhorn Eintracht 34 79 33 65
5 VfR Neumunster Neumunster 34 55 39 58
6 Cloppenburg Cloppenburg 34 62 48 54
7 Holstein Kiel II Holstein 34 67 56 54
8 St. Pauli II Pauli 34 50 53 54
9 Arminia Hannover Arminia 34 42 50 49
10 Bergedorf 85 Bergedorf 34 61 55 44
11 Hannover 96 II Hannover 34 41 47 43
12 Altona 93 Altona 93 34 49 55 42
13 Meiendorfer SV Meiendorfer 34 51 63 37
14 Eider Büdelsdorf Eider 34 57 75 37
15 Barmbek-Uhlenhorst Barmbek-Uhle 34 32 74 31
16 Concordia Hamburg Concordia 34 38 65 27
17 VfB Lübeck II Lübeck 34 35 85 20
18 Victoria Hamburg Victoria 34 32 90 16

  USO DE MEMORIA  
7,069,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1417
Total Execution Time  0.1432
  CADENA URL  
/historico/Meiendorfer-Sv
  GET DATOS  
$_GET['/historico/Meiendorfer-Sv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0033  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 = 'Meiendorfer-Sv' 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=17105 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=17105 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=17105 AND type_rel = 2
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 = '17105' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '17105' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '17105' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = '17105' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=17105 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72026,71432) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72026 AND teamId = 17105
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17105
0.0024  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 = '17105' 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 = '17105' and rp.type = 4
0.0020  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 = '17105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17105 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.0022  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17105 AND (e.action = 4 or e.action = 5) 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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17105 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 = 17105 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72026 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 = 63361 AND t.round = 18 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 = 66923 AND t.round = 5 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 `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 = 58731 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50424 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 44074 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 46651 AND t.round = 30 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 `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 = 46821 AND t.round = 30 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 `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 = 15538 AND t.round = 34 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 `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 = 4247 AND t.round = 34 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 `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 = 3538 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 `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 = 19808 AND t.round = 34 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 `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 = 19821 AND t.round = 34 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 `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 = 19833 AND t.round = 34 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 = 19844 AND t.round = 34 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 `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 = 19858 AND t.round = 34 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 `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 = 19892 AND t.round = 34 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 `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 = 28304 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC