Failed attempt at scanning GeographBot's uploads for copyvios, using ChatGPT's code.

SQL

SELECT
  page_title
FROM
  page
JOIN
  image
  ON page_id = img_name
WHERE
  page_namespace = 6 -- Namespace 6 is File namespace on Commons
  AND page_title LIKE '%mural%' -- Searches for "mural" in the file title
  AND page_id IN (SELECT page_id FROM revision WHERE rev_user_text = 'GeographBot') -- Restricts to files uploaded by GeographBot
UNION
SELECT
  page_title
FROM
  page
JOIN
  image
  ON page_id = img_name
WHERE
  page_namespace = 6
  AND img_description LIKE '%mural%' -- Searches for "mural" in the file description
  AND page_id IN (SELECT page_id FROM revision WHERE rev_user_text = 'GeographBot')

SQL

Checking query status...