SELECT s.*, u.`pass`
                                  FROM `pmf_session` AS s
                                       LEFT JOIN `pmf_user` AS u ON s.`user_id` = u.`id`
                                  WHERE MD5(CONCAT(s.`sess`, s.`browser`)) = 'e3697d8178d5d51156a7b7c894bf73c4' LIMIT 0,1

SELECT `sess`
                                  FROM `pmf_session`
                                  WHERE `user_id` = 0
	                                AND MD5(CONCAT(`ip`, `browser`)) = '7e7e3a564b7e0ed006c3a0434e9cea31' LIMIT 0,1

SELECT var.`name`, var.`typ`, val.`value`
                           FROM `pmf_group_var` AS var
                                LEFT JOIN `pmf_group_value` AS val ON var.`id` = val.`var_id`
                           WHERE val.`board_id` = 0
                             AND val.`group_id` IN (0,2)

SELECT u.`id`, u.`name`, g.`wio_color`, s.`last_action`, s.`site`
                       FROM `pmf_session` AS s
                            LEFT JOIN `pmf_user` AS u ON s.`user_id` = u.`id`
                            LEFT JOIN `pmf_group` AS g ON g.`id` = u.`group_id`
                       GROUP BY s.`sess`
                       ORDER BY s.`last_action`

SELECT `id`
                                        FROM `pmf_lang`
                                        WHERE `code` LIKE 'en' LIMIT 0,1

SELECT s.*, t.`typ`
                                            FROM `pmf_style` AS s,
                                                 `pmf_template_set` AS t
                                            WHERE s.`active` = 1
                                              AND t.`id` = s.`templateset` LIMIT 0,1

SELECT var.`name`, var.`default`, val.`replacement`
                               FROM `pmf_lang_var` AS var
                                    LEFT JOIN `pmf_lang_value` AS val ON (var.`id` = val.`var_id` AND val.`lang_id` = 0),
                                    `pmf_lang_index` AS i,
                                    `pmf_lang_file` AS f
                               WHERE f.`name` = 'errors'
                                 AND i.`file_id` = f.`id`
                                 AND var.`id` = i.`var_id`
                                 AND var.`name` IN ('error_access_logout','title_error')
                               GROUP BY var.`id`

SELECT s.id, s.templateset, s.variableset, t.typ
                                     FROM `pmf_style` AS s,
                                          `pmf_template_set` AS t
                                     WHERE s.templateset = 0
                                       AND t.id = s.templateset

REPLACE INTO `pmf_session` (`sess`,`ip`,`user_id`,`last_action`,`site`,`browser`)
                  VALUES ('aqo6aia3asfe129dsel5anugf7','38.107.179.218',0,1328446975,'8e','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')