Untitled query #21430

SQL

use commonswiki_p;
SELECT
 DISTINCT (user.user_name) as name,
 COALESCE(user_registration, 20000000000000) as user_registration,
 (CASE WHEN COALESCE(user_registration, 20000000000000) <= 20170901000000 THEN 0 ELSE 1 END) as newbie
 FROM (SELECT
   cl_to,
   cl_from
   FROM categorylinks
   WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2017_in_France" 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 user ON user.user_id = COALESCE(oldimage.oi_user, image.img_user)
 WHERE img_timestamp <= 20170908000000
SQL

Checking query status...
