(empty) - Quarry

SQL

use nlwiki_p;

SELECT page.page_id, page.page_title, catlink.cl_from, catlink.cl_to
FROM page
LEFT OUTER JOIN categorylinks catlink ON catlink.cl_from = page.page_id AND (
  catlink.cl_to NOT LIKE 'Wikipedia:%' # OR catlink.cl_to LIKE 'Wikipedia:Nog te categoriseren%'
)
#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
#AND catlink.cl_to NOT LIKE 'Wikipedia:Nog te categoriseren%'
AND page.page_id NOT IN(
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)

LIMIT 600
SQL

Checking query status...
