USE huwiki_p;

SELECT page_title FROM page

  LEFT JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Kat-redir'

  LEFT JOIN langlinks ON ll_from = page_id

WHERE page_namespace = 14

  AND NOT page_title LIKE 'Csonkok_%'

  AND NOT page_title LIKE 'Figyelmet_igénylő_lapok_%'

  AND page_is_redirect = 0

  AND tl_from IS NULL

  AND ll_from IS NULL;