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='15a1b2363750e46bcf9e6413d20f20f7'

SELECT id FROM fud30_users WHERE users_opt & 131072=0 AND join_date<1745375328 AND posted_msg_count=0 AND last_visit<1745375328 AND id!=1 AND users_opt & 1048576=0

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=0, time_sec=1745980128, action='Login Form', returnto=returnto WHERE id=417

DELETE FROM fud30_ses WHERE time_sec<1745375328 OR (user_id>2000000000 AND time_sec<1745893728)