Fork of
Voci orfane per dimensioni (senza page_len)
by Mess
This query is marked as a draft
This query has been published
by Xaosflux.
SQL
AخA
USE sqwiki_p;
SELECT
p1.page_namespace,
p1.page_title
FROM page AS p1
WHERE p1.page_title NOT LIKE"%/%"
AND p1.page_namespace % 2 != 0
AND p1.page_namespace != 3
AND p1.page_namespace != 9
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = p1.page_namespace - 1 AND p1.page_title = p2.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.