วิเคราะปัญหา เพาะใช้ 3 ตารางใหญ่
Code: Select all
SELECT pm.subject, pm.body, pm.msgtime, pm.ID_MEMBER_FROM, IFNULL(m.realName, pm.fromName) AS senderName
FROM ({$db_prefix}personal_messages AS pm, {$db_prefix}pm_recipients AS pmr)
LEFT JOIN {$db_prefix}members AS m ON (m.ID_MEMBER = pm.ID_MEMBER_FROM)
WHERE pm.ID_PM = $context[pm_id]
AND pmr.ID_PM = pm.ID_PM
AND pmr.ID_MEMBER = $ID_MEMBER
AND pmr.deleted = 0
LIMIT 1