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)

);