Category-less pages on cswiki

SQL

SELECT page_title, IF(tl_target_id IS NULL, 0, 1) AS has_template, page_latest, page_id
FROM page AS pages
LEFT JOIN templatelinks
  ON page_id = tl_from
  AND tl_target_id IN (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_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...
