返回重复结果SQL？

Question

I have the following query:

SELECT DISTINCT
SQL_CALC_FOUND_ROWS 
    unr.RequestID, 
    unr.UnRead, 
    unr.FilterID, 
    r.GroupID, 
    r.Year, 
    rv.Bounty 
FROM (users_notify_requests as unr, requests_votes as rv) 
    JOIN requests AS r ON r.ID = unr.RequestID
WHERE unr.UserID = 1 ORDER BY unr.RequestID DESC LIMIT 50

This should return only 2 rows, as there are only two requests where unr.UserID = 1, however it returns 10. 5 versions of the first, and 5 versions of the second, completely identical (respectively). Any idea as to why this might be happening?

EDIT: MySQL version 5.5.29, as requested.

EDIT 2: The print_r() dump: http://pastebin.com/BXujnEpx. The result has incorrect bounty for the given IDs, so something is pretty off with the query.

Answer 1

You're not joining on rv with any criteria, so every row in that table will be returned: It could be that this is the cause of your extra rows.

You probably need a line such as the following (guessing at column names as I don't have your schema):

INNER JOIN request_votes rv ON rv.requestId = r.id