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

[John McKerrell]

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.

John

>
> I didn't think that would work because it will always link to
> moderators if there's any available but I've realised that so long as
> I put the DISTINCT bit in to make sure that it's not weighted towards
> photos that are already part moderated, I should be ok. Anyone else
> like to confirm or disagree? I did another version of the query using
> subselects that I thought would be slower, and does appear to be. That
> query is getting slightly fewer results which is a little confusing
> but it's probably something simple:
>
> 	SELECT DISTINCT p.id FROM photos p WHERE status = 'moderation' AND id
> NOT IN ( SELECT photo_id FROM moderators WHERE status = 'pending' AND
> user_id = 1 );
>
> John
>
> On 31 Oct 2009, at 09:40, malenki wrote:
>
>> Right now as I lowered my counter to ~260 images quite often I get  
>> the
>> message mentioned in subject.
>> Also mostly I am served 1-3 pictures instead of the ~10 it used to  
>> be.
>> Is this just for having enlonged the fun to moderate the
>> photographs? ;)
>>
>> regards
>> malenki
>>
>>
>> _______________________________________________
>> Photos mailing list
>> Photos at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/photos
>
>
> _______________________________________________
> Photos mailing list
> Photos at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/photos

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/photos/attachments/20091031/265969cd/attachment.html>