Untitled query #70285

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_Earth_2022_in_South_West_Nigeria" AND
    catlink0.cl_type = "subcat" AND
	catlink1.cl_to = "Images_from_Wiki_Loves_Earth_2022_in_South_West_Nigeria" AND
    catlink1.cl_type = "file" AND
    img_img.img_timestamp > 20220101000000
SQL

Checking query status...
