09.09.2011 Europameisterschaft Stegersbach
Alle Fotos zu den Spieltagen der Tigers sind auch auf Facebook
09.09.2011 Europameisterschaft Stegersbach
Alle Fotos zu den Spieltagen der Tigers sind auch auf Facebook
ISV Stegersbach
Stadion:
Postadresse:
Frauenberg 24
7551 Stegersbach
SELECT `data`
FROM `y68qt_session`
WHERE `session_id` = 'es0v7carc8cemlrj6dg40vf7d6'
SELECT `session_id`
FROM `y68qt_session`
WHERE `session_id` = 'es0v7carc8cemlrj6dg40vf7d6'
LIMIT 0, 1
INSERT INTO `y68qt_session` (`session_id`, `client_id`, `time`)
VALUES ('es0v7carc8cemlrj6dg40vf7d6', 0, '1537361746')
SELECT b.id
FROM y68qt_usergroups AS a
LEFT JOIN y68qt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
SELECT id, rules
FROM `y68qt_viewlevels`
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 y68qt_menu AS m
LEFT JOIN y68qt_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
UPDATE `y68qt_extensions`
SET `params` = '{\"mediaversion\":\"0a7e4e0a71792b6861778fff0b7e64ba\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
SELECT a.rules
FROM y68qt_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM y68qt_assets AS a
LEFT JOIN y68qt_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.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 y68qt_content AS a
LEFT JOIN y68qt_categories AS c
on c.id = a.catid
LEFT JOIN y68qt_users AS u
on u.id = a.created_by
LEFT JOIN y68qt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y68qt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM y68qt_categories AS cat JOIN y68qt_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 = 105
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-19 12:55:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-19 12:55:46')
AND (a.state = 1 OR a.state =2)
SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM y68qt_categories as c
LEFT JOIN y68qt_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 y68qt_categories AS cat JOIN y68qt_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,5)
AND c.published = 1
AND s.id=50
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, c.version
ORDER BY c.lft
SELECT `m`.`tag_id`,`t`.*
FROM `y68qt_contentitem_tag_map` AS m
INNER JOIN `y68qt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 105
AND `t`.`published` = 1
AND t.access IN (1,1,5)
SHOW FULL COLUMNS
FROM `y68qt_content`
SELECT *
FROM y68qt_content
WHERE `id` = '105'
UPDATE y68qt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '105'
SELECT template
FROM y68qt_template_styles
WHERE client_id = 1
AND home = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM y68qt_modules AS m
LEFT JOIN y68qt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN y68qt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-09-19 12:55:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-09-19 12:55:46')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 295 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 y68qt_content AS a
LEFT JOIN y68qt_categories AS c
on c.id = a.catid
LEFT JOIN y68qt_users AS u
on u.id = a.created_by
LEFT JOIN y68qt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y68qt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM y68qt_categories AS cat JOIN y68qt_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 = 73
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-19 12:55:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-19 12:55:46')
SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM y68qt_categories as c
LEFT JOIN y68qt_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 y68qt_categories AS cat JOIN y68qt_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,5)
AND c.published = 1
AND s.id=2
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, c.version
ORDER BY c.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 y68qt_content AS a
LEFT JOIN y68qt_categories AS c
on c.id = a.catid
LEFT JOIN y68qt_users AS u
on u.id = a.created_by
LEFT JOIN y68qt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y68qt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM y68qt_categories AS cat JOIN y68qt_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 = 72
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-19 12:55:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-19 12:55:46')
3 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 y68qt_content AS a
LEFT JOIN y68qt_categories AS c
on c.id = a.catid
LEFT JOIN y68qt_users AS u
on u.id = a.created_by
LEFT JOIN y68qt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y68qt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM y68qt_categories AS cat JOIN y68qt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM y68qt_categories as c
LEFT JOIN y68qt_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 y68qt_categories AS cat JOIN y68qt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `m`.`tag_id`,`t`.*
FROM `y68qt_contentitem_tag_map` AS m
INNER JOIN `y68qt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT template
FROM y68qt_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM y68qt_modules AS m
LEFT JOIN y68qt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN y68qt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM y68qt_content
1 × SELECT b.rules
FROM y68qt_assets AS a
LEFT JOIN y68qt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT b.id
FROM y68qt_usergroups AS a
LEFT JOIN y68qt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `y68qt_session`
1 × SELECT id, rules
FROM `y68qt_viewlevels
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 y68qt_menu AS m
LEFT JOIN y68qt_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.rules
FROM y68qt_assets AS a
1 × SELECT `data`
FROM `y68qt_session`
1 × UPDATE y68qt_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `y68qt_content
1 × UPDATE `y68qt_extensions`
SET `params` = '{\"mediaversion\":\"0a7e4e0a71792b6861778fff0b7e64ba\"}'
1 × INSERT INTO `y68qt_session` (`session_id`, `client_id`, `time`)
VALUES ('es0v7carc8cemlrj6dg40vf7d6', 0, '1537361746'