SQL
AخA
SELECT CONCAT("File:", img_name) AS curr_title,
CONCAT("File:", REPLACE(img_name, "%_20", "_")) AS suggested_title,
CONCAT("https://commons.wikimedia.org/w/index.php?title=Special:MovePage",
"&wpOldTitle=File%3A", img_name, "&wpNewTitle=",
CONCAT("File%3A", REPLACE(img_name, "%_20", "_")),
"&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 "%\%_20%"
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 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.