4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Auersmacher
TEMPORADA 2023/2024
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Eintracht Trier Eintracht 32 100 26 88
2 FK Pirmasens Pirmasens 33 78 35 65
3 Gonsenheim Gonsenheim 32 80 41 64
4 Auersmacher Auersmacher 32 61 49 58
5 Wormatia Worms Wormatia 32 64 42 56
6 RW Koblenz RW Koblenz 33 60 53 52
7 Kaiserslautern II Kaiserslaute 32 68 57 50
8 Morlautern Morlautern 32 56 58 50
9 Diefflen Diefflen 33 66 70 50
10 Karbach Karbach 32 63 73 47
11 Engers 07 Engers 07 32 63 53 46
12 Mechtersheim Mechtersheim 33 56 48 42
13 Arminia Ludwigshafen Arminia 32 52 69 42
14 Dudenhofen Dudenhofen 32 50 52 39
15 Cosmos Koblenz Cosmos 32 55 63 36
16 Alemannia Waldalgesheim Alemannia 32 34 58 33
17 VfR Baumholder Baumholder 32 49 72 28
18 Pfeddersheim Pfeddersheim 33 44 83 27
19 SpVgg Quierschied SpVgg 33 29 73 22
20 FC Bitburg FC Bitburg 32 42 95 17
TEMPORADA 2022/2023
OBERLIGA GRUPO 15
Equipo PJ GF GC Puntos
1 Schott Mainz Schott Mainz 30 90 28 70
2 TuS Koblenz TuS Koblenz 30 59 20 69
3 FK Pirmasens Pirmasens 30 66 34 62
4 Gonsenheim Gonsenheim 30 70 38 53
5 Engers 07 Engers 07 30 57 36 52
6 Mechtersheim Mechtersheim 30 55 46 48
7 Kaiserslautern II Kaiserslaute 30 58 43 46
8 Diefflen Diefflen 30 60 63 46
9 Karbach Karbach 30 63 47 44
10 Auersmacher Auersmacher 30 57 52 42
TEMPORADA 2010/2011
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Idar-Oberstein Idar-Oberste 36 69 35 67
2 FK Pirmasens Pirmasens 36 51 40 63
3 Betzdorf Betzdorf 36 55 43 60
4 Hauenstein Hauenstein 36 61 53 58
5 SVN Zweibrücken Zweibrücken 36 49 32 55
6 Köllerbach Köllerbach 36 57 46 55
7 Borussia Neunkirchen Borussia 36 60 54 54
8 Mechtersheim Mechtersheim 36 62 52 53
9 SV 07 Elversberg II Elversberg 36 48 51 50
10 Eintracht Trier II Eintracht 36 53 59 47
11 Wirges Wirges 36 42 52 47
12 Alemannia Waldalgesheim Alemannia 36 58 65 46
13 Roßbach / Verscheid Roßbach 36 46 55 46
14 Saarbrücken II Saarbrücken 36 61 54 45
15 Gonsenheim Gonsenheim 36 57 62 45
16 Rot-Weiß Hasborn Rot-Weiß 36 47 52 44
17 Bad Breisig Bad Breisig 36 57 71 37
18 Auersmacher Auersmacher 36 44 79 36
19 Sportfreunde Eisbachtal Sportfreunde 36 36 58 33
TEMPORADA 2009/2010
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 FC 08 Homburg Homburg 34 53 32 64
2 FK Pirmasens Pirmasens 34 53 34 64
3 SVN Zweibrücken Zweibrücken 34 41 31 59
4 Idar-Oberstein Idar-Oberste 34 48 35 56
5 Auersmacher Auersmacher 34 75 69 55
6 Mechtersheim Mechtersheim 34 55 50 49
7 Sportfreunde Eisbachtal Sportfreunde 34 53 67 49
8 Alemannia Waldalgesheim Alemannia 34 54 61 48
9 Hauenstein Hauenstein 34 50 40 47
10 SV 07 Elversberg II Elversberg 34 60 51 46
11 Köllerbach Köllerbach 34 57 59 46
12 Borussia Neunkirchen Borussia 34 53 47 45
13 Betzdorf Betzdorf 34 51 49 45
14 Roßbach / Verscheid Roßbach 34 44 49 42
15 Rot-Weiß Hasborn Rot-Weiß 34 47 64 38
16 Wirges Wirges 34 36 51 32
17 TuS Mayen TuS Mayen 34 42 56 30
18 Hassia Bingen Hassia 34 44 71 30
TEMPORADA 1997/1998
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 SV Elversberg Elversberg 34 87 35 78
2 Sportfreunde Eisbachtal Sportfreunde 34 85 33 70
3 SC Halberg Brebach Halberg 34 69 53 68
4 Hamm / Sieg Hamm / Sieg 34 75 36 66
5 Idar-Oberstein Idar-Oberste 34 65 32 65
6 Borussia Neunkirchen Borussia 34 69 37 61
7 Hauenstein Hauenstein 34 80 41 59
8 FK Pirmasens Pirmasens 34 65 49 52
9 TuS Montabaur Montabaur 34 56 57 43
10 TuS Koblenz TuS Koblenz 34 42 45 43
11 FSG Schiffweiler Schiffweiler 34 46 60 41
12 Mettlach Mettlach 34 53 82 39
13 SV Prüm SV Prüm 34 46 66 32
14 Pfeddersheim Pfeddersheim 34 48 73 32
15 Hassia Bingen Hassia 34 39 64 30
16 Auersmacher Auersmacher 34 44 87 29
17 SSV Eintracht Überherrn Eintracht 34 53 98 25
18 VfL Trier VfL Trier 34 22 96 13
TEMPORADA 1996/1997
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Kaiserslautern II Kaiserslaute 34 82 24 79
2 Idar-Oberstein Idar-Oberste 34 75 37 67
3 Mettlach Mettlach 34 63 50 58
4 Hamm / Sieg Hamm / Sieg 34 55 35 57
5 Sportfreunde Eisbachtal Sportfreunde 34 58 49 53
6 VfL Trier VfL Trier 34 48 53 49
7 Borussia Neunkirchen Borussia 34 56 37 48
8 FSG Schiffweiler Schiffweiler 34 49 58 46
9 Hassia Bingen Hassia 34 53 54 45
10 Auersmacher Auersmacher 34 50 55 41
11 TuS Koblenz TuS Koblenz 34 30 40 39
12 Pfeddersheim Pfeddersheim 34 36 48 39
13 SV Prüm SV Prüm 34 36 49 39
14 SSV Eintracht Überherrn Eintracht 34 45 73 38
15 Saarbrücken II Saarbrücken 34 38 49 37
16 SV Wittlich SV Wittlich 34 33 50 37
17 RWO Alzey RWO Alzey 34 42 56 32
18 Betzdorf Betzdorf 34 42 74 25
TEMPORADA 1995/1996
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 SV Elversberg Elversberg 34 80 44 66
2 TuS Koblenz TuS Koblenz 34 52 23 63
3 Pfeddersheim Pfeddersheim 34 51 22 63
4 Hassia Bingen Hassia 34 60 37 59
5 Mettlach Mettlach 34 58 51 55
6 Auersmacher Auersmacher 34 50 42 53
7 Hamm / Sieg Hamm / Sieg 34 53 36 51
8 SV Wittlich SV Wittlich 34 56 44 50
9 Saarbrücken II Saarbrücken 34 54 46 50
10 Sportfreunde Eisbachtal Sportfreunde 34 59 47 48
11 Idar-Oberstein Idar-Oberste 34 67 55 47
12 VfL Trier VfL Trier 34 49 50 47
13 FSG Schiffweiler Schiffweiler 34 59 54 45
14 Betzdorf Betzdorf 34 53 55 45
15 SV Edenkoben Edenkoben 34 40 72 36
16 Wirges Wirges 34 28 65 28
17 SV Südwest Ludwigshafen Südwest 34 30 93 19
18 VfB Wissen VfB Wissen 34 11 74 6

  USO DE MEMORIA  
5,710,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0905
Total Execution Time  0.0917
  CADENA URL  
/historico/Sv-Auersmacher
  GET DATOS  
$_GET['/historico/Sv-Auersmacher']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83260 AND type_rel = 2
0.0023  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 = '83260' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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=83260 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 (72627,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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72627 AND teamId = 83260
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 83260
0.0041  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 = 72627 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '83260' 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 = '83260' 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 = '83260' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 83260 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.0027  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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 83260 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 83260 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 83260 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72627 AND t.round = 33 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 `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 = 68315 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 71185 AND t.round = 10 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 `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 = 19832 AND t.round = 38 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 `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 = 19845 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 `tables1998` 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 = 28346 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 `tables1997` 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 = 28363 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 `tables1996` 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 = 28373 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC