查看xoops私人訊息語法

select a.msg_id,FROM_UNIXTIME(a.msg_time) as 時間, a.subject, b.name, c.name ,a.msg_text
from (`xoops_priv_msgs` a left outer join `xoops_users` b on a.from_userid=b.uid)
left outer join `xoops_users` c on a.to_userid=c.uid
order by a.msg_id;