• View
• Edit
• History
• Print

Other

SELECT privmsgs_subject, ppfu.username, pptu.username, FROM_UNIXTIME(privmsgs_date), privmsgs_text FROM `phpbb_privmsgs` pp inner join phpbb_privmsgs_text ppt on pp.privmsgs_id = ppt.privmsgs_text_id inner join phpbb_users ppfu on pp.privmsgs_from_userid = ppfu.user_id inner join phpbb_users pptu on pp.privmsgs_to_userid = pptu.user_id order by privmsgs_date desc