Fork of
sqwiki orpahned talk pages
by Xaosflux
This query is marked as a draft
This query has been published
by Xaosflux.
SQL
AخA
USE sqwikiquote_p;
SELECT page_namespace, page_title, page_len, page_is_redirect, page_is_new FROM page AS p1
WHERE
p1.page_namespace % 2 = 1
AND (SELECT COUNT(*) FROM page AS p2 WHERE p1.page_title = p2.page_title AND p2.page_namespace = (p1.page_namespace - 1)) = 0
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.