SQL
AخA
USE itwiki_p;
SELECT CONCAT('[[', page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN
(SELECT pl_from
FROM pagelinks
WHERE pl_namespace = 0
AND pl_title IN
(SELECT page_title FROM page
WHERE page_namespace = 0)
AND pl_title NOT IN
(SELECT page_title
FROM categorylinks, pagelinks, page
WHERE cl_to = pl_title
AND cl_from = page_id
AND pl_namespace = 14
AND pl_from = 4195411)) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
AND page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
AND page_id NOT IN
(SELECT pr_page
FROM page_restrictions)
ORDER BY 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.