Details
- Details
-
Kategorie: Aktive
-
Veröffentlicht am Donnerstag, 31. März 2022 07:17
-
Geschrieben von Autor Verein
-
Zugriffe: 1205
TSV Altdorf vs. TSV Grötzingen 1:2
Am vergangenen Sonntag gastierten die abstiegsbedrohten Grötzinger auf dem Altdorfer Wasen. Bei herrlichem Sonnenschein entwickelte sich jedoch eher ein müder Sommerkick. Die Schrade/Novak Schützlinge hatten zwar mehr vom Spiel, jedoch wurde es in den ersten 30 Spielminuten in keinem den beiden Strafräumen gefährlich. Nach einer Halbenstunde die überraschende Gäste-Führung. Nach einem schnellen Gegenzug wurde Gästeakteur Hoffmann freigespielt, dieser Traf überlegt aus 11 Metern ins Eck. Auch danach hatten die Altdorfer zwar mehr Spielanteile, Chancen wurden jedoch nicht kreiert und so ging es mit einer 0:1 Gästeführung in die Halbzeit. Aus dieser kamen die Altdorfer etwas entschlossener und man versuchte den Rückstand wettzumachen. Nach einiger Halbchancen und vermeintlichen Abseitssituationen gelang diese auch in der 65. Spielminute. Massimo Tardanico traff volley von der Sechzehnerkante zum 1:1. In den folgenden Spielminuten hatte man das Gefühl die Altdorfer drehten nun komplett das Spiel, so konnte man auch in dieser Zeit ein deutliches Chancenplus verbuchen. Jedoch war dies leider nicht so, die Grötzinger markierten vom Elfmeterpunkt die erneute Führung, erneut traf Hoffmann. Vorrausgegangen war ein mehr als fragwürdiger Elfmeterpfiff des Unparteiischen. So rannte man in der Folgezeit zwar an, jedoch ohne Erfolg. So stand am Ende zwar eine sehr unglückliche, aber nicht ganz unverdiente Niederlage zu Buche.
TSV Altdorf II vs. TSV Grötzingen II 1:0
Die zweite Mannschaft machte es mal wieder der ersten Mannschaft vor und zeigte wie man ein Spiel gewinnt. Matchwinner war der Traumtorschütze Alexander Klopfer.
Nächsten Partien:
So. 03.04
FV 09 Nürtingen vs. TSV Altdorf I 15:30 Uhr
FV09 Nürtingen II vs. TSV Altdorf II 13:00 Uhr
Joomla!-Debug-Konsole
password_clear ⇒
groups ⇒
8.24 MB (8,642,280 Bytes)
21 ausgeführte Abfragen
SELECT `data`
FROM `fzv24_session`
WHERE `session_id` = 'de295fd3fedaf00f3f14a4d200563a92'
DELETE
FROM `fzv24_session`
WHERE `time` < '1715110563'
SELECT `session_id`
FROM `fzv24_session`
WHERE `session_id` = 'de295fd3fedaf00f3f14a4d200563a92'
LIMIT 0, 1
INSERT INTO `fzv24_session`
(`session_id`, `client_id`, `time`)
VALUES
('de295fd3fedaf00f3f14a4d200563a92', 0, '1715111463')
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=836
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 = 836
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 = 836
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-07 19:51:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-07 19:51:03')
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 = 836
UPDATE `fzv24_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715111463;s:18:\"session.timer.last\";i:1715111463;s:17:\"session.timer.now\";i:1715111463;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` = '1715111463'
WHERE `session_id` = 'de295fd3fedaf00f3f14a4d200563a92'
18 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:1715111463;s:18:\"session.timer.last\";i:1715111463;s:17:\"session.timer.now\";i:1715111463;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` = '1715111463'
1 × UPDATE fzv24_content
SET hits = hits + 1
1 × INSERT INTO `fzv24_session` (`session_id`, `client_id`, `time`)
VALUES ('de295fd3fedaf00f3f14a4d200563a92', 0, '1715111463'
1 × DELETE
FROM `fzv24_session`