nolicense - Quarry

SQL

SELECT
  p0.page_namespace,
  p0.page_title,
  CONCAT("User talk:", actor_name)
FROM
  categorylinks
  JOIN page p0 ON cl_from = p0.page_id
  JOIN logging_logindex
    ON log_page = p0.page_id AND log_type = "upload"
  JOIN actor_logging ON log_actor = actor_id
WHERE
  cl_to = "Files_with_no_machine-readable_license"
  AND log_timestamp > 20220811000000
  AND "Deletion_template_tag" NOT IN (
    SELECT lt_title
    FROM templatelinks
    JOIN linktarget ON lt_id = tl_target_id
    WHERE
      lt_namespace = 10
      AND tl_from = p0.page_id
  )
  AND (
    log_action = "upload"
    OR actor_id IN (
      SELECT log_actor
      FROM logging_logindex
      WHERE
        log_page = p0.page_id
        AND log_type = "upload"
        AND log_action = "upload"
    )
  )
GROUP BY page_id
ORDER BY actor_id
SQL

Checking query status...
