USE cswiki_p;

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 = "Ακατηγοριοποίητο"

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)

);