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='04346c9b2a877472f950f114106023bb'

SELECT /* USE MASTER */ count(*) FROM fud30_msg WHERE thread_id=1 AND id<=2 AND apr=1

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.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

UPDATE fud30_ses SET sys_id='554bae1bd60d1a3a0d99bae0c34b669e', forum_id=1, time_sec=1745977343, action='Browsing topic <a href=\"index.php?t=msg&amp;th=1\">Welcome to FUDforum</a>', returnto='goto=2&t=msg&th=1' WHERE id=406

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.users_opt, u.last_visit AS time_sec, u.karma, 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, karma.id AS cant_karma, 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_karma_rate_track karma ON karma.msg_id=m.id AND karma.user_id=0 LEFT JOIN fud30_poll p ON m.poll_id=p.id WHERE m.thread_id=1 AND m.apr=1 ORDER BY m.id ASC LIMIT 40 OFFSET 0

SELECT data FROM fud30_msg_store WHERE id=1

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)

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