SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.posted_msg_count, u.topics_per_page, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc FROM fud30_ses s INNER JOIN fud30_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) LEFT OUTER JOIN fud30_themes t ON t.id=u.theme WHERE s.sys_id= '554bae1bd60d1a3a0d99bae0c34b669e' AND s.ip_addr='3.16.157.168' AND s.useragent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; C'

SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.posted_msg_count, u.topics_per_page, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc FROM fud30_ses s INNER JOIN fud30_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) LEFT OUTER JOIN fud30_themes t ON t.id=u.theme WHERE s.id=384

SELECT m.subject, m.id, m.post_stamp, u.id, u.alias, f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.url_redirect, f.post_count, f.thread_count, 0,0,g1.group_cache_opt, c.cat_opt FROM fud30_fc_view v INNER JOIN fud30_cat c ON c.id=v.c INNER JOIN fud30_forum f ON f.id=v.f INNER JOIN fud30_group_cache g1 ON g1.user_id=0 AND g1.resource_id=f.id LEFT JOIN fud30_msg m ON f.last_post_id=m.id LEFT JOIN fud30_users u ON u.id=m.poster_id WHERE f.parent = 0 AND (g1.group_cache_opt & 1 > 0) ORDER BY v.id

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=0, time_sec=1745959657, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='' WHERE id=384

SELECT sc.*, m.subject AS last_msg_subject, u.alias AS last_user_alias FROM fud30_stats_cache sc INNER JOIN fud30_users u ON u.id=sc.last_user_id LEFT JOIN fud30_msg m ON m.id=4 WHERE sc.cache_age>1745959057

SELECT MAX(id), count(*)-1 FROM fud30_users

SELECT count(*) FROM fud30_ses s WHERE time_sec>1745959357 AND user_id>2000000000

SELECT count(*) FROM fud30_ses s INNER JOIN fud30_users u ON u.id=s.user_id WHERE s.time_sec>1745959357 AND u.users_opt & 32768>0

SELECT count(*) FROM fud30_ses s INNER JOIN fud30_users u ON u.id=s.user_id WHERE s.time_sec>1745959357 AND u.users_opt & 32768=0

SELECT u.id, u.alias, u.users_opt, u.custom_color FROM fud30_ses s INNER JOIN fud30_users u ON u.id=s.user_id WHERE s.time_sec>1745959357 AND u.users_opt & 32768=0 ORDER BY s.time_sec DESC LIMIT 25 OFFSET 0

UPDATE fud30_stats_cache SET cache_age=1745959657, last_user_id=6, user_count=5, online_users_anon=2, online_users_hidden=0, online_users_reg=0, online_users_text='a:0:{}'

SELECT alias FROM fud30_users WHERE id=6

SELECT subject FROM fud30_msg WHERE id=4

SELECT most_online, most_online_time FROM fud30_stats_cache