Commons Image Category Load with User and File Info

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 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 oldimage                                                                                                        
                   LEFT JOIN actor ON oi_actor=actor.actor_id) AS oi ON img_name=oi.oi_name                                             
        JOIN page ON page_namespace = 6                                                                                                 
        AND page_title = img_name                                                                                                       
        JOIN categorylinks ON cl_from = page_id                                                                                         
        AND cl_type = 'file'                                                                                                            
        AND cl_to = "National finalists for the Microscopy category from Wiki Science Competition 2019"                                                                                                                  
        GROUP BY img_name                                                                                                               
        ORDER BY oi_timestamp ASC;
SQL

Checking query status...
