Untitled query #45150

SQL

        SELECT img_width,
               img_height,
               img_name,
               img_major_mime,
               img_minor_mime,
               IFNULL(oi.actor_user, ci.actor_user) AS img_user,
               IFNULL(oi.actor_name, ci.actor_name) AS img_user_text,
               IFNULL(oi_timestamp, img_timestamp) AS img_timestamp,
               img_timestamp AS rec_img_timestamp,
               ci.actor_user AS rec_img_user,
               ci.actor_name AS rec_img_text,
               oi.oi_archive_name AS oi_archive_name
        FROM commonswiki_p.image AS i
        LEFT JOIN commonswiki_p.actor AS ci ON img_actor=ci.actor_id
        LEFT JOIN (SELECT oi_name,
                          oi_actor,
                          actor_user,
                          actor_name,
                          oi_timestamp,
                          oi_archive_name
                   FROM commonswiki_p.oldimage
                   JOIN commonswiki_p.actor ON oi_actor=actor.actor_id) AS oi ON img_name=oi.oi_name
        JOIN commonswiki_p.page ON page_namespace = 6
        AND page_title = img_name
        JOIN commonswiki_p.categorylinks ON cl_from = page_id
        AND cl_type = 'file'
        AND cl_to = "National finalists for the Wildlife and nature category from Wiki Science Competition 2019"
        GROUP BY img_name
        ORDER BY oi_timestamp ASC;
SQL

Checking query status...
