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.ses_id='b10fad0d87f96cb6f76e80dc00650af3'

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=0, time_sec=1749507106, action='Snooping on other people, just like you', returnto='rand=519672314&t=actions' WHERE id=618

SELECT resource_id, group_cache_opt FROM fud30_group_cache WHERE user_id=0

SELECT s.action, s.user_id, s.forum_id, u.alias, u.custom_color, s.time_sec, s.ip_addr, u.users_opt, m.id, m.subject, m.post_stamp, t.forum_id, mm1.id, mm2.id FROM fud30_ses s LEFT JOIN fud30_users u ON s.user_id=u.id LEFT JOIN fud30_msg m ON u.u_last_post_id=m.id LEFT JOIN fud30_thread t ON m.thread_id=t.id LEFT JOIN fud30_mod mm1 ON mm1.forum_id=t.forum_id AND mm1.user_id=0 LEFT JOIN fud30_mod mm2 ON mm2.forum_id=s.forum_id AND mm2.user_id=0 WHERE s.time_sec>1749506806 AND s.user_id!=0 ORDER BY u.alias DESC

UPDATE fud30_stats_cache SET most_online=1, most_online_time=1749507106 WHERE most_online < 1