Untitled query #82439

SQL

SELECT CONCAT("File:", img_name) AS curr_title,
	CONCAT("File:", REPLACE(REPLACE(img_name, "%_29", ")") ,"%_28", "(")) AS suggested_title,
    CONCAT("https://commons.wikimedia.org/w/index.php?title=Special:MovePage",
           "&wpOldTitle=File%3A", img_name, "&wpNewTitle=",
           CONCAT("File%3A", REPLACE(REPLACE(img_name, "%_29", ")") ,"%_28", "(")),
           "&wpReason=%5B%5BCommons%3AFile_renaming%23FR6%7CCriterion 6%5D%5D%3A fixing character handling issue%28s%29")
           AS link
FROM image
WHERE img_name LIKE "%\%_28%"
AND img_name NOT IN
	(
      SELECT gil_to
      FROM globalimagelinks
      WHERE gil_to = img_name
	)
AND img_name NOT IN
	(
      SELECT il_to
      FROM imagelinks
      WHERE il_to = img_name
    )
AND img_name NOT IN
	(
      SELECT lt_title
      FROM linktarget
      WHERE lt_namespace = 6
      AND lt_title = img_name
    )
LIMIT 5;
SQL

Checking query status...
