Skip to content

Instantly share code, notes, and snippets.

@propertyhive

propertyhive/gist:f3e31b81e9ebbb9206703368eae8691d

Created March 3, 2025 10:59
Show Gist options
  • Save propertyhive/f3e31b81e9ebbb9206703368eae8691d to your computer and use it in GitHub Desktop.
Save propertyhive/f3e31b81e9ebbb9206703368eae8691d to your computer and use it in GitHub Desktop.
Download ZIP
Get list of unsubscribed contacts
Raw
gistfile1.txt
SELECT p.ID AS contact_id,
p.post_title AS contact_name,
pm.meta_value AS email_address,
c.comment_date
FROM wp_posts p
INNER JOIN wp_comments c ON p.ID = c.comment_post_ID
LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = '_email_address'
WHERE p.post_type = 'contact'
AND c.comment_type = 'propertyhive_note'
AND c.comment_content LIKE '%unsubscribe%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment