USE fawiki_p;

SELECT page_title

FROM page JOIN categorylinks ON cl_from = page_id

WHERE page_namespace = 0

AND page_is_redirect = 0

AND cl_to LIKE 'قنات•های_شهرستان%'

AND page_id IN (

  SELECT rev_page

  FROM revision

  WHERE rev_user_text NOT LIKE '%Bot%'

  AND rev_user_text NOT LIKE '%bot%'

  AND rev_user_text NOT LIKE 'Fatranslator'

  AND rev_comment NOT LIKE '%منتقل_کرد%'

  )

ORDER BY page_len DESC;