How many records do you have in the table downloads? I'm terrible at queries (I hate joins!), but if I understand the query correctly, you should have one record for each download. Looking at the second entry (the one that shouldn't be there), you'll notice that each image has a different id - 4 and 5. So my guess is you have two records in the table downloads for that image.

EDIT: Wrong info.

Downloads has 2 records, screenshots have 2 records, both of the screenshots goes to the first record of downloads.

They each have seperate id's so that they can be viewed in a bigger view. I'm pulling by id of download to match file_id in screenshots. So I don't know whats going on.

If you have two screenshots for the same record, are they supposed to show as different 'posts' (two posts like post 1 only each with a single screenshot) or in a single 'post' (like post 2)?

In a single post, so record 1 should show 2 screenshots, record 2 should show none.

--------------- Added [DATE]1239490519[/DATE] at [TIME]1239490519[/TIME] ---------------

Got it all sorted thanks to Enigma from here.