Wikiloves Images_from_Wiki_Loves_Earth_2019_in_Brazil

SQL

use commonswiki_p;
SELECT
 img_name,
 img_timestamp,
 img_name IN (SELECT DISTINCT gil_to FROM globalimagelinks) AS image_in_use,
 user.user_name as name,
 user.user_email as email,
 user.user_email_authenticated as email2,
 image.img_actor,
 oldimage.oi_actor,
 COALESCE(user_registration, "20050101000000") as user_registration
 FROM (SELECT
   cl_to,
   cl_from
   FROM categorylinks
   WHERE cl_to = 'Images_from_Wiki_Loves_Earth_2019_in_Brazil' AND cl_type = 'file') cats
 INNER JOIN page ON cl_from = page_id
 INNER JOIN image ON page_title = img_name
 LEFT JOIN oldimage ON image.img_name = oldimage.oi_name AND oldimage.oi_timestamp = (SELECT MIN(o.oi_timestamp) FROM oldimage o WHERE o.oi_name = image.img_name)
 LEFT JOIN actor ON actor.actor_id = COALESCE(oldimage.oi_actor, image.img_actor)
 LEFT JOIN user ON user.user_id = actor.actor_user
SQL

Checking query status...
