SQL
AخA
USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')
FROM revision AS r1 JOIN page AS p1 ON r1.rev_page = p1.page_id
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND NOT EXISTS (
SELECT null
FROM revision AS r2 JOIN page AS p2 ON r2.rev_page = p2.page_id
WHERE p2.page_namespace = 0
AND p2.page_is_redirect = 0
AND p1.page_id = p2.page_id
AND r1.rev_actor <> r2.rev_actor
);
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.