SELECT settings_data FROM meg_settings LIMIT 1

SELECT m.*, s.skin_dir, g.group_perms, g.group_name FROM meg_users m,
meg_skins s, meg_groups g WHERE m.user_id=1 AND s.skin_dir=m.user_skin AND
g.group_id=m.user_group LIMIT 1

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

REPLACE INTO meg_active (active_id, active_action, active_item,
active_time, active_ip, active_user_agent, active_session) VALUES (1,
'board', 0, 1284126778, '38.107.191.92', 'CCBot/1.0
(+http://www.commoncrawl.org/bot.html)',
'571ad78ecb2518056f72569a5ef17acb')

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 meg_forums f
LEFT JOIN meg_posts p ON p.post_id = f.forum_lastpost
LEFT JOIN meg_topics t ON t.topic_id = p.post_topic
LEFT JOIN meg_users m ON m.user_id = p.post_author
ORDER BY f.forum_parent, f.forum_position

SELECT * FROM meg_replacements ORDER BY LENGTH(replacement_search) DESC

SELECT user_id, user_name, user_birthday FROM meg_users WHERE user_birthday
LIKE '%-09-10'

SELECT
  a.*, u.user_name, u.user_active, g.group_format
FROM
  (meg_active a, meg_groups g, meg_users u)
WHERE
  a.active_id = u.user_id AND
  u.user_group = g.group_id
ORDER BY
  a.active_time DESC

UPDATE meg_users SET user_lastvisit=1284125878 WHERE user_id=646 OR
user_id=1 OR user_id=1 OR user_id=1

DELETE FROM meg_active WHERE active_time < 1284125878