An Error Was Encountered

Error Number: 1062

Duplicate entry '575650' for key 'group_key'

SELECT STRAIGHT_JOIN items.id, items.title, items.link as link, items.description as description, items.timestamp as pubdate, items.blog_id, items.comment_feed, items.status, blogs.name AS blog_name, blog_languages.language_id, COUNT(comments.item_id) as commentsum, COUNT(votes.vote) as votesum, blogs.icon_url, blog_users.user_id AS user_id FROM items INNER JOIN blogs ON (blogs.id = items.blog_id) INNER JOIN blog_status ON (blogs.status_id = blog_status.id) LEFT JOIN blog_users ON (blog_users.blog_id = items.blog_id) LEFT JOIN comments ON (comments.item_id = items.id) LEFT JOIN blog_languages ON (blog_languages.blog_id = blogs.id) LEFT JOIN votes ON (votes.item_id = items.id) WHERE (blog_status.name = 'active') AND (items.timestamp > FROM_UNIXTIME(1341812597)) AND (items.timestamp < FROM_UNIXTIME(1344404597)) AND (blogs.type_id <> 9) AND (items.status >= 0) GROUP BY items.id ORDER BY items.timestamp DESC LIMIT 50,50