Fork of
Topic:Tmmqsao639cs6en4
by XXN
This query is marked as a draft
This query has been published
by Mess.
SQL
AخA
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title IN (
SELECT pl_title
FROM pagelinks
WHERE pl_from_namespace = 0
AND pl_namespace = 0
AND pl_title = page_title
AND pl_from NOT IN (SELECT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411)
AND pl_from NOT IN (SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Prenomi%')
AND pl_from NOT IN (SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Cognomi%')
AND pl_from NOT IN (SELECT page_id
FROM page
WHERE page_is_redirect = 1)
AND pl_from NOT IN (SELECT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN ('U'))
AND pl_from NOT IN (SELECT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN ('Nota_disambigua'))
)
AND page_id IN (SELECT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN ('O'))
ORDER BY page_len DESC;
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.