gward2

I’ve also tried this:

mysql -ppassword_of_user -u user_name -e
'SELECT a.ID, a.post_title, a.post_type, a.post_status
FROM wp_posts AS a
   INNER JOIN (
      SELECT post_title, MIN( id ) AS min_id
      FROM wp_posts
      WHERE post_type = 'post'
      AND post_status = 'publish'
      GROUP BY post_title
      HAVING COUNT( * ) > 1
   ) AS b ON b.post_title = a.post_title
AND b.min_id <> a.id
AND a.post_type = 'post'
AND a.post_status = 'publish''
database_name

Thanks! That did the trick.

Hello,

Yes I’m trying to display the category of the posts in the top 10 post list. For example this is a music related website, each post is a song and the categories are the artists, the artist must be included with the song or it doesn’t make much sense. Is this functionality already included (2.4)? From the code at github it seems like it was included in 2.2. If not where do I need to put that bit of code? Thanks!