Images from Wiki Loves Africa 2014

SQL

USE commonswiki_p;

SELECT /* SLOW_OK */ page.page_title, image.img_timestamp, oldimage.oi_timestamp
FROM image
CROSS JOIN page ON image.img_name = page.page_title
CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
LEFT JOIN oldimage ON image.img_name = oldimage.oi_name AND oldimage.oi_timestamp = (SELECT MIN(o.oi_timestamp) FROM oldimage o WHERE o.oi_name = image.img_name)
WHERE
categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2014"
AND IF(oldimage.oi_timestamp IS NULL, img_timestamp, oldimage.oi_timestamp) BETWEEN 20140930000000 AND 20141202000000
ORDER BY img_timestamp ASC;
SQL

Checking query status...
