Title: custom comments query
Last modified: August 20, 2016

---

# custom comments query

 *  [shansta](https://wordpress.org/support/users/shansta/)
 * (@shansta)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/custom-comments-query/)
 * I hoping someone can help me. I am trying to create a authors profile page which
   also displays a users recent comments. Problem is the query keeps showing the
   same comments in every post when I do a query on the database.
 * `SELECT comment_ID, comment_post_ID, comment_content, post_title FROMwp_posts,
   wp_comments WHERE comment_author_email = 'email@email.com'`
 * So the result is its showing the comments but with the wrong post title.
 * Here is my author.php
    [http://pastebin.com/pMPnvpFR](http://pastebin.com/pMPnvpFR)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/custom-comments-query/#post-2479397)
 * I have not tested it, but I believe that you need to add this to your WHERE clause:
 * `AND comment_post_ID = ID`
 *  Thread Starter [shansta](https://wordpress.org/support/users/shansta/)
 * (@shansta)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/custom-comments-query/#post-2479409)
 * Thanks. I worked it out and yeh that solved the problem.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘custom comments query’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)
 * [post title](https://wordpress.org/support/topic-tag/post-title/)
 * [query](https://wordpress.org/support/topic-tag/query/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [shansta](https://wordpress.org/support/users/shansta/)
 * Last activity: [14 years, 5 months ago](https://wordpress.org/support/topic/custom-comments-query/#post-2479409)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics