SELECT settings_data FROM mb_settings LIMIT 1

SELECT m.*, s.skin_dir, g.group_perms FROM mb_users m, mb_skins s,
mb_groups g WHERE m.user_id=1 AND s.skin_dir=m.user_skin AND
g.group_id=m.user_group

SELECT template_name, template_html FROM mb_templates WHERE
template_skin='default' AND (template_set='Main' OR template_set='board')

REPLACE INTO mb_active (active_id, active_action, active_time, active_ip,
active_user_agent, active_session) VALUES (1, 'board', 1283904091,
'38.107.191.114', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
'5f00d14e02e627206fbe100575049566')

SELECT
    f.forum_id, f.forum_parent, f.forum_name, f.forum_position,
f.forum_description, f.forum_topics, f.forum_replies, f.forum_lastpost,
    t.topic_id as LastTopicID, t.topic_title as user_lastpost,
t.topic_edited as LastTime, t.topic_replies,
m.user_name as user_lastposter, m.user_id as user_lastposterID
FROM mb_forums f
LEFT JOIN mb_posts p ON p.post_id = f.forum_lastpost
LEFT JOIN mb_topics t ON t.topic_id = p.post_topic
LEFT JOIN mb_users m ON m.user_id = p.post_author
ORDER BY f.forum_parent, f.forum_position

SELECT user_id, user_name, user_birthday FROM mb_users WHERE user_birthday
LIKE '%-09-08'

SELECT
  a.*, u.user_name, u.user_active, g.group_format
FROM
  mb_active a, mb_groups g, mb_users u
WHERE
  a.active_id = u.user_id AND
  u.user_group = g.group_id
ORDER BY
  a.active_time DESC