SELECT group_id,module_id FROM {prefix}_groups_modules
SELECT * FROM `{prefix}_modules`
SELECT sesskey, expiry FROM {prefix}_sys_session WHERE sesskey = '747ddf27dbe6166d4946987352a73fdd'
DELETE FROM {prefix}_sys_session WHERE expiry < 1702050166
DELETE FROM {prefix}_sys_session WHERE expiry < 1702050166
OPTIMIZE TABLE {prefix}_sys_session
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='34.228.52.21'
SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='WKAdm'
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=2014092801
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='2014-09-28' and link_zeit = '10:00:00' and link_nr = '01' ORDER BY datum, zeit, nr
SELECT * FROM `{prefix}_wka_mannschaftswertung` as m LEFT OUTER JOIN `{prefix}_wka_startnummern` as s ON s_vid = m.mw_vid AND s_nr = m.mw_nr LEFT OUTER JOIN `{prefix}_wka_teilnehmer` as t ON s_t_id = t_id LEFT OUTER JOIN `{prefix}_wka_verein` as v ON v_id = mw_verein WHERE mw_vid = 2014092801 AND mw_art = 'M' AND ( t_name LIKE '%%' OR t_vorname LIKE '%%' OR mw_w_kurzbez LIKE '%%' OR mw_verein LIKE '%%' ) ORDER BY mw_w_kurzbez, mw_wertung, mw_platz_wkges, mw_verein, mw_vereinnr, mw_satzart
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 LIKE('block-vkp_News_%') AND module='News') AND ((view = 0) OR (view = 3)) and position >''
ORDER BY position, weight ASC
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 pollID
FROM `{prefix}_poll_desc`
WHERE `artid` = 0
AND `pollactive` = 1
AND (planguage LIKE 'german%' OR planguage = '')
ORDER BY `pollID` DESC
LIMIT 1
SELECT *
FROM `{prefix}_poll_desc`
WHERE `pollID` = 1
SELECT optionText, optionCount, barcolor, voteID
FROM `{prefix}_poll_data`
WHERE `pollID` =1
AND `optionText` <> ''
AND NOT ISNULL(`optionText`)
ORDER BY voteID
SELECT COUNT(pollID)
FROM `{prefix}_pollcomments`
WHERE `pollID`=1
SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.seo'
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
