Am Ende waren die Gronauer und Eper Starter beim „Challenge Roth“ nach insgesamt 226 anstrengenden Kilometer einfach nur froh, das Ziel erreicht zu haben. Andre Winkelhorst vom TV Westfalia Epe gelang dies sogar in persönlicher Bestzeit.
Nach 3,8 km Schwimmen, 180 Radfahren und dem Marathonlauf über 42,2 km kam der 41-Jährige nach 10:06:42 Std. ins Ziel. Heiko Kaack vom TV Gronau überlief die Ziellinie nach 11:36:52 Std. und sein Vereinskamerad Joachim Flüthmann nach 12:01:57 Std. Die Staffel des TV Gronau mit Edgar Teuber, Steve Figur und Andreas Kwekkeboom verfehlte in 10:02:45 Std. die 10-Stunden-Grenze nur knapp.
SELECT group_id,module_id FROM {prefix}_groups_modules
SELECT * FROM `{prefix}_modules`
SELECT sesskey, expiry FROM {prefix}_sys_session WHERE sesskey = '12ed4fa21362d5e8c4431c9cbc67fe5d'
DELETE FROM {prefix}_sys_session WHERE expiry < 1702207763
SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.hooks'
SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.themes'
SELECT * FROM {prefix}_plugins ORDER BY type, position ASC
SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='35.172.165.64'
SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='News'
SELECT s.*,
s.sid AS s_sid,
c.title AS cattitle,
t.topicname,
t.topicimage,
t.topictext
FROM ({prefix}_stories AS s
LEFT JOIN {prefix}_stories_cat AS c ON s.catid = c.catid)
LEFT JOIN {prefix}_topics AS t ON s.topic = t.topicid
WHERE s.sid=108 AND s.time <= now()
UPDATE {prefix}_stories SET counter=counter+1 where sid=108
select main_module from {prefix}_main
SELECT m.title
FROM `{prefix}_modules` AS m LEFT JOIN {prefix}_groups_modules AS g
ON m.mid = g.module_id
WHERE ((m.title = 'News') OR (m.view = 0 AND m.active=1) OR (m.view = 3 AND m.active=1))
ORDER BY m.title ASC
SELECT * FROM {prefix}_blocks
WHERE (active=1) AND (blanguage LIKE 'german%' OR blanguage = '') AND (position NOT IN('c','d')) AND NOT (position='r' AND (blockfile NOT LIKE('block-vkp_News_%')) AND module<>'News') AND ((view = 0) OR (view = 3)) and position >''
ORDER BY position, weight ASC
SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='wkadm'
SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
SELECT datum, zeit, nr, bez, comments, erglst_art, erg_erfasst, link2album, vid FROM `{prefix}_wka_veranstaltung` where link_datum='2023-09-24' and link_zeit = '10:00:00' and link_nr = '01' ORDER BY datum, zeit, nr
SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
SELECT datum, zeit, nr, bez, comments, erglst_art, erg_erfasst, link2album, vid FROM `{prefix}_wka_veranstaltung` where link_datum='2023-09-24' and link_zeit = '10:00:00' and link_nr = '01' ORDER BY datum, zeit, nr
SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_one'
SELECT sid, title FROM {prefix}_stories WHERE time < 1702207763 AND sid !='108' AND (alanguage LIKE 'german%' OR alanguage = '') ORDER BY time DESC, sid DESC LIMIT 5
SELECT pollID
FROM {prefix}_poll_desc
WHERE artid = 108
AND pollactive > 0
ORDER BY pollID DESC
LIMIT 1
SELECT sid, title
FROM {prefix}_stories
WHERE topic=2 AND time <= now() AND (alanguage LIKE 'german%' OR alanguage = '')
ORDER BY counter desc
LIMIT 1
SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.seo'
SELECT u.uid, u.uname, u.email, c.sid, c.tid, c.reply_date, c.host_name, c.subject, c.comment, c.name AS postername
FROM {prefix}_comments AS c LEFT JOIN {prefix}_users AS u ON c.uid = u.uid
WHERE (((c.sid)=108) AND ((c.modul_name)='News'))
ORDER BY reply_date DESC
SHOW TABLES LIKE '{prefix}_content%'
SHOW COLUMNS FROM {prefix}_content
SELECT * FROM {prefix}_content WHERE module_name='Documents' AND leftID=1 LIMIT 1
SELECT id FROM {prefix}_content where module_name='Documents' and id=1
SET sql_mode=(SELECT REPLACE (@@sql_mode,'ONLY_FULL_GROUP_BY',''))
SELECT s.id, s.title, s.text1, s.leftID,
count(*)+(s.leftID >1) As level,
FLOOR((s.rightID-s.leftID)/2) as childs ,
((min(v.rightID)-s.rightID-(s.leftID >1))/2) > 0 AS lower,
(((s.leftID-max(v.leftID)>1))) AS upper ,
((min(v.leftID)>s.rightID)) AS upperid
from {prefix}_content as n,
{prefix}_content as v,
{prefix}_content as s
WHERE s.module_name='Documents'
AND v.module_name='Documents'
AND n.module_name='Documents'
AND n.id='1'
AND s.leftID >'1'
AND s.leftID BETWEEN v.leftID AND v.rightID
AND s.leftID BETWEEN n.leftID AND n.rightID
AND (v.id != s.id OR s.leftID = 1)
AND s.publish=1
GROUP BY s.leftID
ORDER by s.leftID
SELECT * FROM {prefix}_blocks WHERE blockfile='block-Menu.php' AND title='{TVE_MENU}' ORDER BY title ASC
SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=20 ORDER BY pid,weight,id ASC
