SQL
AخA
USE zhwikibooks_p;
SELECT page_namespace, page_title
FROM page
LEFT JOIN user ON
IF(INSTR(page_title, '/'),
MID(page_title, 1, INSTR(page_title, '/')-1),
page_title) = REPLACE(user_name, ' ', '_')
WHERE
page_namespace IN (2, 3) AND
page_is_redirect = 0 AND
INET_ATON(page_title) IS NULL AND
INET6_ATON(page_title) IS NULL AND
user_name IS NULL
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.