USE lvwiki_p;

SELECT page_title FROM page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND page_id NOT IN (

SELECT p.page_id FROM page p

INNER JOIN categorylinks cl ON cl.cl_from = p.page_id

INNER JOIN page p2 ON cl.cl_to = p2.page_title AND p2.page_namespace = 14 # 14 = Category

LEFT JOIN page_props pp ON pp.pp_page = p2.page_id AND pp.pp_propname = 'hiddencat'

WHERE pp.pp_page IS NULL

  )

and page_id not in (select cl_from

                            from categorylinks

                            where cl_to="Nekategorizētie_raksti")