Problem constructing a query [SOLVED]

[eluser]JayTee[/eluser]
I made the assumption that the id field in your 'votes' table corresponds to a photo's id field:

Code:

SELECT photos.id
FROM photos
WHERE NOT EXISTS (
  SELECT *
  FROM votes
  WHERE
    votes.id = photos.id
    AND username = 'username'
)