DELETE pm
FROM smf_personal_messages pm
WHERE pm.id_member_from = xxxxx;

DELETE FROM smf_pm_recipients
WHERE id_pm NOT IN (SELECT id_pm FROM smf_personal_messages);

DELETE FROM smf_pm_labeled_messages
WHERE id_pm NOT IN (SELECT id_pm FROM smf_personal_messages);