Super dirty subquery trick for my friend Lodewijk

SQL

SELECT
    maincat.page_title AS maincat_title,
    img_img.img_name AS img_name,
    catlink1.cl_from AS file_id,
    img_img.img_timestamp,
    actor.actor_name AS uploader,
    oldimage_uploader.actor_name AS uploader_old
FROM
  page AS maincat
INNER JOIN categorylinks AS catlink0 ON catlink0.cl_from = maincat.page_id
INNER JOIN categorylinks AS catlink1 ON catlink1.cl_to = maincat.page_title
INNER JOIN page AS img_file ON img_file.page_id = catlink1.cl_from
INNER JOIN image AS img_img ON img_img.img_name = img_file.page_title
INNER JOIN actor ON actor.actor_id = img_img.img_actor
LEFT JOIN oldimage ON img_img.img_name = oldimage.oi_name
LEFT JOIN actor AS oldimage_uploader ON oldimage.oi_actor = oldimage_uploader.actor_id
WHERE
    catlink0.cl_to = "Images_from_Wiki_Loves_Monuments" AND
    catlink0.cl_type = "subcat" AND
    catlink1.cl_to = "Images_from_Wiki_Loves_Monuments_2010" AND
    catlink1.cl_type = "file" AND
    oldimage.oi_timestamp = (
        -- Where the timestamp is the latest available for that image
      	SELECT MIN(oldimage2.oi_timestamp)
        FROM oldimage AS oldimage2
        WHERE oldimage.oi_name = oldimage2.oi_name
    )
ORDER BY img_name
LIMIT 3000000
SQL

Checking query status...
