Untitled query #10363

SQL

USE commonswiki_p_STOP;
SELECT
img_name AS file,
img_metadata AS metadata,
img_description AS upload_summary,
img_user_text AS uploader_text,
img_user AS uploader_userid,
img_sha1 AS sha1,
user_editcount AS editcount,
 IF(img_user_text IN (
  SELECT log_title
  FROM logging
  WHERE log_type = "block"
 ), "1", "0") AS blocked_prev,
 user_editcount AS editcount,
 IF(img_user_text IN (
  SELECT fa_user_text
  FROM filearchive
  WHERE fa_storage_group = "deleted"
  AND fa_deleted_reason REGEXP "([Cc]opyvio|[Cc]opyright|[Pp]ermission|[Ll]icense|COM/:LL|NETCOPYRIGHT|COM/:L)"
 ), "1", "0") AS deleted_copyvio
FROM image
INNER JOIN user
 ON img_user = user_id
WHERE user_editcount < 900
LIMIT 1;
SQL

Checking query status...
