Title: SQL to dump all comments
Last modified: November 2, 2021

---

# SQL to dump all comments

 *  Resolved [duhblow7](https://wordpress.org/support/users/duhblow7/)
 * (@duhblow7)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-to-dump-all-comments/)
 *     ```
       SELECT *
       FROM <code>wpm3_posts</code> p 
       JOIN wpm3_users u ON p.post_author = u.ID 
       JOIN wpm3_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = 'website_id'
       JOIN wpm3_posts p1 ON pm.meta_value = p1.ID
       WHERE p.post_type = 'phw_comment_loc';
       ```
   
 *     ```
       SELECT p.post_date, p.post_title, u.display_name, p1.post_title, p.comment_count
       FROM <code>wpm3_posts</code> p 
       JOIN wpm3_users u ON p.post_author = u.ID 
       JOIN wpm3_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = 'website_id'
       JOIN wpm3_posts p1 ON pm.meta_value = p1.ID
       WHERE p.post_type = 'phw_comment_loc';
       ```
   
    -  This topic was modified 4 years, 6 months ago by [duhblow7](https://wordpress.org/support/users/duhblow7/).

The topic ‘SQL to dump all comments’ is closed to new replies.

 * ![](https://ps.w.org/projecthuddle-child-site/assets/icon.svg?rev=2784546)
 * [SureFeedback Client Site](https://wordpress.org/plugins/projecthuddle-child-site/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/projecthuddle-child-site/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/projecthuddle-child-site/)
 * [Active Topics](https://wordpress.org/support/plugin/projecthuddle-child-site/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/projecthuddle-child-site/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/projecthuddle-child-site/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [duhblow7](https://wordpress.org/support/users/duhblow7/)
 * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/sql-to-dump-all-comments/)
 * Status: resolved