SQL
AخA
USE fawiki_p;
SELECT CONCAT('# [[',frst.page_title,']]')
FROM page frst
WHERE frst.page_namespace=0
AND frst.page_is_redirect=0
AND (frst.page_title LIKE "%•%"
OR frst.page_title LIKE "%\_%")
AND EXISTS (
SELECT null
FROM page scnd
WHERE scnd.page_namespace=0
AND scnd.page_is_redirect=0
AND REPLACE(REPLACE(scnd.page_title,'•',''),'_','') = REPLACE(REPLACE(frst.page_title,'•',''),'_','')
);
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.