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

                   LEFT 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;