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.188.180.227' AND s.useragent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; C'

SELECT c.id AS cat_id, f.name, m.subject, t.tdescr, t.id, t.forum_id, t.replies, t.rating, t.n_rating, t.root_msg_id, t.moved_to, t.thread_opt, t.root_msg_id, t.last_post_date, 0 AS md, 1 AS cant_rate, m2.thread_id AS last_thread, g1.group_cache_opt FROM fud30_thread t INNER JOIN fud30_msg m ON m.id=t.root_msg_id INNER JOIN fud30_forum f ON f.id=t.forum_id INNER JOIN fud30_cat c ON f.cat_id=c.id INNER JOIN fud30_msg m2 ON f.last_post_id=m2.id INNER JOIN fud30_group_cache g1 ON g1.user_id=0 AND g1.resource_id=f.id WHERE t.id=1

SELECT m.*, COALESCE(m.flag_cc, u.flag_cc) AS disp_flag_cc, COALESCE(m.flag_country, u.flag_country) AS disp_flag_country, t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id, f.message_threshold, u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location, u.sig, u.custom_status, u.icq, u.jabber, u.affero, u.aim, u.msnm, u.yahoo, u.google, u.skype, u.twitter, u.last_visit AS time_sec, u.users_opt, l.name AS level_name, l.level_opt, l.img AS level_img, p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes, 1 AS cant_vote FROM fud30_msg m INNER JOIN fud30_thread t ON m.thread_id=t.id INNER JOIN fud30_forum f ON t.forum_id=f.id LEFT JOIN fud30_users u ON m.poster_id=u.id LEFT JOIN fud30_level l ON u.level_id=l.id LEFT JOIN fud30_poll p ON m.poll_id=p.id WHERE m.id=2 AND m.apr=1 AND m.thread_id=1

UPDATE fud30_thread SET views=views+1 WHERE id=1

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=1, time_sec=1747443610, action='Browsing topic (tree view) <a href=\"index.php?t=tree&amp;th=1&amp;\">Welcome to FUDforum</a>', returnto='mid=2&t=tree&th=1' WHERE id=422

SELECT m.poster_id, m.subject, m.reply_to, m.id, m.poll_id, m.attach_cnt, m.post_stamp, m.icon, m.file_id, m.length, m.foff, u.alias, u.last_visit FROM fud30_msg m INNER JOIN fud30_thread t ON m.thread_id=t.id LEFT JOIN fud30_users u ON m.poster_id=u.id WHERE m.thread_id=1 AND m.apr=1 ORDER BY m.reply_to ASC, m.id

SELECT seq FROM fud30_tv_1 WHERE thread_id=1

SELECT m.id, m.subject, tv.seq, t.moved_to FROM fud30_tv_1 tv INNER JOIN fud30_thread t ON tv.thread_id=t.id INNER JOIN fud30_msg m ON t.root_msg_id=m.id WHERE tv.seq IN(0, 2)