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='18.220.9.180' 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=396

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=0, time_sec=1745962713, action='Viewing the list of users who were on the forum today.', returnto='t=online_today' WHERE id=396

SELECT u.alias AS login, u.users_opt, u.id, u.last_visit, u.custom_color, m.id AS mid, m.subject, m.post_stamp, t.forum_id, mm.id, COALESCE(g2.group_cache_opt, g1.group_cache_opt) AS gco FROM fud30_users u 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 mm ON mm.forum_id=t.forum_id AND mm.user_id=0 LEFT JOIN fud30_group_cache g1 ON g1.user_id=0 AND g1.resource_id=t.forum_id LEFT JOIN fud30_group_cache g2 ON g2.user_id=0 AND g2.resource_id=t.forum_id WHERE u.last_visit>1745884800 AND u.users_opt & 32768=0 AND u.id!=0 ORDER BY u.last_visit DESC