especially for the dreadful Weather Bot on Commons

avarab wrote:

The query needed for getting the latest non-bot uploads is:

SELECT
img_size,img_name,img_user,ug_group,img_user_text,img_description,img_timestamp
FROM image LEFT OUTER JOIN user_groups ON img_user=ug_user AND ug_group='bot'
WHERE ug_group IS NULL LIMIT 49;

And the old query is:

SELECT img_size,img_name,img_user,img_user_text,img_description,img_timestamp
FROM image ORDER BY img_timestamp DESC LIMIT 49;

I can't be bothered to implement this now, maybe later.