SQL
x
USE etwiki_p;
SELECT page_title, pl_namespace, pl_title
FROM page, pagelinks
WHERE pl_from_namespace = 14
AND page_id = pl_from
AND page_title NOT LIKE 'Leonardo_da_Vinci%'
AND page_title NOT LIKE 'Surnud_%'
AND page_title NOT LIKE 'Sündinud_%'
/*AND page_title NOT LIKE '%eKr'
AND page_title NOT LIKE '%eKr'
AND page_title NOT LIKE '____'
AND page_title NOT RLIKE 'd{4}'
AND page_title NOT LIKE '2%sajand'*/
AND (SELECT COUNT(*)
FROM page
WHERE page_title = pl_title
AND page_namespace = pl_namespace
AND pl_namespace <>15)= 0
LIMIT 9999;
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.