SQL
AخA
USE etwiki_p;
SELECT CONCAT('[[',page_title,']]') AS page_title, page_namespace, CONCAT('[[',rd_title,']]') AS rd_title
FROM page
INNER JOIN redirect ON rd_from = page_id
AND NOT EXISTS (SELECT * FROM page AS p1 WHERE p1.page_title = rd_title AND p1.page_namespace = rd_namespace)
AND page_namespace NOT IN (2,3)
AND rd_namespace NOT IN (2,3)
AND p1.page_title NOT LIKE 'VisualEditor/Tagasiside' OR p1.page_title NOT LIKE 'AWB'
LIMIT 25;
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.