I have the following query:

SELECT SQL_CACHE wpblog_posts.post_title, post_content
FROM wpblog_posts
INNER JOIN wpblog_term_relationships ON wpblog_posts.id = wpblog_term_relationships.object_id
WHERE wpblog_term_relationships.term_taxonomy_id =4
GROUP BY wpblog_posts.post_title
HAVING count( wpblog_posts.post_title ) >1

Which, currently, returns 2 records:

But it should return 4 records.. the dupes... any suggestions?