[OSM-Photos] "There are no pictures to moderate"?

[John McKerrell]

On 31 Oct 2009, at 12:02, John McKerrell wrote:

>
> On 31 Oct 2009, at 10:53, John McKerrell wrote:
>>
>> 	SELECT DISTINCT p.id FROM photos p LEFT OUTER JOIN moderators m ON
>> m.photo_id = p.id WHERE p.status = 'moderation' AND ( m.id IS NULL OR
>> m.user_id <> ?)
>
> I've just realised this isn't going to work, if someone else has  
> moderated a photo then it will be offered back to you, I'll need to  
> use the version below. Doesn't seem too slow right now, might get  
> that way when there's more  users but should be fine for now.

Ok, that's done, you are guaranteed* to always have 10 photos to  
moderate.

John

* by which I mean, it'll probably work this time
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/photos/attachments/20091031/82d0ffc9/attachment.html>