(empty) - Quarry

SQL

use nlwiki_p;

SELECT page.page_id, page.page_title, catlink.cl_from, catlink.cl_to, text.old_text
FROM page
INNER JOIN revision rev ON page.page_latest = rev.rev_id
INNER JOIN pagecontent text ON text.old_id = rev.rev_text_id
LEFT OUTER JOIN categorylinks catlink ON catlink.cl_from = page.page_id AND catlink.cl_to NOT LIKE 'Wikipedia:%'
#LEFT OUTER JOIN category cat ON cat.cat_id = catlink.cl_from AND cat.cat_title NOT LIKE 'Wikipedia:%'
WHERE page.page_namespace = 0 AND page.page_is_redirect = 0 AND catlink.cl_to IS NULL
LIMIT 1
SQL

Checking query status...
