pages having only category آثار ملی ایران

SQL

USE fawiki_p;
SELECT page_title
FROM page JOIN categorylinks AS frst ON cl_from = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND frst.cl_to = 'آثار_ملی_ایران'

/*AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks AS scnd
  WHERE scnd.cl_to <> frst.cl_to
)*/
and exists (
  select null from page as catpage
  where catpage.page_title = cl_to
  and catpage.page_namespace = 14
  and not exists (
    select null
    from page_props as catprops
    where catprops.pp_page = catpage.page_id
    and catprops.pp_propname = 'hiddencat'
  )
)

ORDER BY page_title;

SQL

Checking query status...