TV-Westfalia 07 Epe

GET:

• month => 8
• name => Stories_Archive
• year => 2014

1. SELECT group_id,module_id FROM {prefix}_groups_modules
2. SELECT * FROM `{prefix}_modules`
3. SELECT sesskey, expiry FROM {prefix}_sys_session WHERE sesskey = '47a5c03730ad5e4d4e1ad6d34c475cb2'
4. DELETE FROM {prefix}_sys_session WHERE expiry < 1702052668
5. DELETE FROM {prefix}_sys_session WHERE expiry < 1702052668
6. OPTIMIZE TABLE {prefix}_sys_session
7. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.hooks'
8. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.themes'
9. SELECT * FROM {prefix}_plugins ORDER BY type, position ASC
10. SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='34.228.52.21'
11. SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='Stories_Archive'
12. SELECT COUNT(sid) FROM {prefix}_stories AS s WHERE s.`time` <= now() AND YEAR(s.`time`)=2014 AND MONTH(s.`time`)=8 AND `alanguage` IN('german','')
13. select main_module from {prefix}_main
14. 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
15. SELECT s.sid, s.title, s.hometext, UNIX_TIMESTAMP(s.`time`) AS tstamp, s.comments, s.counter, s.topic, s.alanguage, s.score, s.ratings, sc.title AS cat_title, sc.catid FROM {prefix}_stories AS s LEFT JOIN {prefix}_stories_cat AS sc ON s.catid = sc.catid WHERE s.`time` <= now() AND YEAR(s.`time`)=2014 AND MONTH(s.`time`)=8 AND `alanguage` IN('german','') ORDER BY s.`time` DESC, s.`sid` DESC LIMIT 0,15
16. SELECT DISTINCT YEAR(`time`) AS y, MONTH(`time`) AS m, COUNT(`sid`) as c FROM {prefix}_stories WHERE `time` <= now() AND `alanguage` IN('german','') GROUP BY y, m ORDER BY y DESC
17. SELECT * FROM {prefix}_blocks WHERE (active=1) AND (blanguage LIKE 'german%' OR blanguage = '') AND (position <> 'r') 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
18. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='wkadm'
19. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
20. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
21. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
22. 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
23. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
24. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
25. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
26. 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
27. SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_one'
28. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.seo'
29. SELECT * FROM {prefix}_blocks WHERE blockfile='block-Menu.php' AND title='{TVE_MENU}' ORDER BY title ASC
30. SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=20 ORDER BY pid,weight,id ASC