Untitled query #91417 - Quarry

This query is marked as a draft This query has been published by Hadithfajri.

SQL

SELECT page_title AS "Page Title"
FROM page
LEFT JOIN categorylinks ON page_id = cl_from
WHERE    page_namespace = 0       -- Main namespace (articles/texts)    
AND page_is_redirect = 0 -- Exclude redirects    
AND cl_from IS NULL      -- Pages with no category links
LIMIT 5000;                  -- Adjust limit as needed

AخA
 
SELECT page_title AS "Page Title"FROM pageLEFT JOIN categorylinks ON page_id = cl_fromWHERE    page_namespace = 0       -- Main namespace (articles/texts)    AND page_is_redirect = 0 -- Exclude redirects    AND cl_from IS NULL      -- Pages with no category linksLIMIT 5000;                  -- Adjust limit as needed

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...