Details
- Details
-
Kategorie: Aktive
-
Veröffentlicht am Dienstag, 13. September 2022 12:06
-
Geschrieben von Autor Verein
-
Zugriffe: 1142
TSV Altdorf vs. VFB Neuffen 3:2
Nach dem blamablen Spiel gegen die neue SGM Höllbach zeigte der TSV am vergangenen Sonntag ein anderes Gesicht. Das Auftreten und die Moral, sowie der Kampf um den Ball waren wieder zurück.
Die Mannen um Trainergespann Schrade/Haußer legten zielstrebig los und verbuchten sich in den ersten 15min mehrere Hochkaräter. So war es einmal Alexander Bernhardt welcher schon zum Jubeln aufgelegt war, ehe er den auf der gegnerischen Torlinie positionierten Mitspieler anschoss und der Ball seinen Weg anstatt ins Tor, zum Gegner fand. So waren es abermals Hausser und Stutz, welchen das Quäntchen Glück für den Führungstreffer fehlten. Zudem musste der hervorragende Christian Müller (CM2) verletzungsbedingt ausgewechselt werden. Jedoch ließen auch die Neuffener nicht lange auf sich warten und scheiterten am gut aufgelegten Torspieler Lübeck, welcher seinen Kasten in Durchgang Eins sauber hielt.
In der zweiten Hälfte kamen die Gäste zwar besser in die Partie, jedoch waren die Hausherren effizienter. So war es Manuel Hausser vorbehalten den Führungstreffer in der 55. Minute zu erzielen. Nach einem starken Dribbling von Neuzugang Adrian (Wolle) Höhn, war es sein entscheidender Pass auf Hausser, welcher den Ball im linken unteren Eck versenkte. Mit breiter Brust verwandelte Kapitän Dominic Ruopp nach einer Hausser-Vorlage den Ball aus 12 Metern im Tor. Mit der Führung im Rücken, ließen die Altdorfer dann etwas nach. Somit drängte der VFB auf das Tor der Heimelf und erzielte durch Alan Fejzuli den folgerichtigen Anschlusstreffer. Der TSV geriet ins Schwimmen und bettelte förmlich um den Ausgleichstreffer. Jedoch konnten Marco Bayer und Dominic Ruopp den Ball auf der Linie klären. Nach einem Konter dann er scheinbar erlösende Treffer durch Dennis Stutz. Abermals war es Höhn welcher Stutz in Szene setzte und den Ball fulminant ins Tor bugsierte. Der sichergeglaubte Führungsaufbau in der 84. Minute wurde durch Kevin Rieke in der 89. Minute abermals verkürzt, sodass die Abwehrmannen des TSV´s nochmals alles reinwerfen mussten, um die drei Punkte in Altdorf zu behalten.
Im Nachgang kann man auf viele gute Aktionen und die geschlossene Mannschaftsleistung aufbauen. Es war ein wichtiger und richtiger Schritt mit der richtigen Einstellung. So wartet am nächsten Sonntag der Bezirksligaabsteiger aus Erkenbrechtsweiler. Die Mannschaft freut sich auf zahlreiche Unterstützung, um auch gehen die SGEH zu bestehen. Des Weiteren findet unter der Woche am 22.09 das Heimspiel gegen den Kreisliga B Aufsteiger FC Frickenhausen II statt.
TSV Altdorf II vs. SV 07 Aich 0:6
Nächsten Partien:
So. 18.09 SGEH vs. TSV Altdorf I 15:00 Uhr
So. 18.09 TSV Harthausen II vs. TSV Altdorf II 15:00 Uhr
Di. 20.09 TSV Altdorf II vs. TV Tischardt 19:30 Uhr
Do. 22.09 TSV Altdorf I vs. FC Frickenhausen II 19:30 Uhr
Joomla!-Debug-Konsole
password_clear ⇒
groups ⇒
8.25 MB (8,648,688 Bytes)
20 ausgeführte Abfragen
SELECT `data`
FROM `fzv24_session`
WHERE `session_id` = 'f0fc20f543a8f9ad1edcea28cee669c3'
SELECT `session_id`
FROM `fzv24_session`
WHERE `session_id` = 'f0fc20f543a8f9ad1edcea28cee669c3'
LIMIT 0, 1
INSERT INTO `fzv24_session`
(`session_id`, `client_id`, `time`)
VALUES
('f0fc20f543a8f9ad1edcea28cee669c3', 0, '1714148754')
SELECT extension_id AS id, element AS "option", params, enabled
FROM fzv24_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM fzv24_usergroups AS a
LEFT JOIN fzv24_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 16
SELECT id, rules
FROM `fzv24_viewlevels`
SELECT folder AS type, element AS name, params
FROM fzv24_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,7)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM fzv24_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fzv24_menu AS m
LEFT JOIN fzv24_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM fzv24_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM fzv24_categories as c
LEFT JOIN fzv24_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM fzv24_categories AS cat JOIN fzv24_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,7)
AND c.published = 1
AND s.id=887
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT alias, catid
FROM fzv24_content
WHERE id = 887
SELECT *
FROM fzv24_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM fzv24_template_styles as s
LEFT JOIN fzv24_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM fzv24_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM fzv24_assets AS a
LEFT JOIN fzv24_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM fzv24_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM fzv24_content AS a
LEFT JOIN fzv24_categories AS c
on c.id = a.catid
LEFT JOIN fzv24_users AS u
on u.id = a.created_by
LEFT JOIN fzv24_categories as parent
ON parent.id = c.parent_id
LEFT JOIN fzv24_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM fzv24_categories AS cat JOIN fzv24_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 887
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 16:25:54')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 16:25:54')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM fzv24_categories as c
LEFT JOIN fzv24_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM fzv24_categories AS cat JOIN fzv24_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,7)
AND c.published = 1
AND s.id=31
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
UPDATE fzv24_content
SET hits = hits + 1
WHERE id = 887
UPDATE `fzv24_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714148754;s:18:\"session.timer.last\";i:1714148754;s:17:\"session.timer.now\";i:1714148754;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:16;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:7;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1714148754'
WHERE `session_id` = 'f0fc20f543a8f9ad1edcea28cee669c3'
17 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fzv24_extensions
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM fzv24_categories as c
LEFT JOIN fzv24_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM fzv24_categories AS cat JOIN fzv24_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM fzv24_languages
1 × SELECT id, home, template, s.params
FROM fzv24_template_styles as s
LEFT JOIN fzv24_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.rules
FROM fzv24_assets AS a
LEFT JOIN fzv24_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM fzv24_contact_details AS contact
1 × SELECT alias, catid
FROM fzv24_content
1 × SELECT a.rules
FROM fzv24_assets AS a
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fzv24_menu AS m
LEFT JOIN fzv24_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `session_id`
FROM `fzv24_session`
1 × SELECT b.id
FROM fzv24_usergroups AS a
LEFT JOIN fzv24_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `fzv24_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM fzv24_extensions
1 × SELECT `data`
FROM `fzv24_session`
Andere Tabellen:
1 × UPDATE `fzv24_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714148754;s:18:\"session.timer.last\";i:1714148754;s:17:\"session.timer.now\";i:1714148754;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:16;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:7;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1714148754'
1 × UPDATE fzv24_content
SET hits = hits + 1
1 × INSERT INTO `fzv24_session` (`session_id`, `client_id`, `time`)
VALUES ('f0fc20f543a8f9ad1edcea28cee669c3', 0, '1714148754'