seremtan wrote:what's needed right now is an admin to confirm this extravagant claim
Code: Select all
SELECT p1.`privmsgs_subject` , u1.`username` , u2.`username` , p2.`privmsgs_text`
FROM rawbert_privmsgs p1, rawbert_privmsgs_text p2, rawbert_users u1, rawbert_users u2
WHERE (
(
p1.`privmsgs_from_userid` =138
AND p1.`privmsgs_to_userid` =30
)
OR (
p1.`privmsgs_from_userid` =30
AND p1.`privmsgs_to_userid` =138
)
)
AND p2.`privmsgs_text_id` = p1.`privmsgs_id`
AND u1.`user_id` = p1.`privmsgs_from_userid`
AND u2.`user_id` = p1.`privmsgs_to_userid`
ORDER BY p1.`privmsgs_date` ASC
