Category-less pages on cswiki

SQL

SELECT page_title, IF(tl_title IS NULL, 0, 1) AS has_template
FROM page AS pages
LEFT JOIN templatelinks ON page_id = tl_from AND tl_namespace = 10 AND tl_title = "Kategorizovat"
WHERE pages.page_namespace = 0
AND pages.page_is_redirect = 0
AND NOT EXISTS (
  SELECT 1 FROM categorylinks
  LEFT JOIN page AS categories ON categories.page_title = cl_to AND categories.page_namespace = 14
  LEFT JOIN page_props ON pp_page = categories.page_id AND pp_propname = 'hiddencat'
  WHERE cl_from = pages.page_id AND (pp_propname IS NULL OR categories.page_title IS NULL)
);
SQL

Checking query status...
