Finding all 'year' articles

SQL

SELECT
  page.page_title AS article_title,
  page.page_namespace AS article_namespace,
  categorylinks.cl_to AS category
FROM
  page
JOIN
  categorylinks ON page.page_id = categorylinks.cl_from
WHERE
  page.page_is_redirect = 0
  AND page.page_namespace = 0
  AND (
     -- Numerical only titles
     (CAST(page.page_title AS UNSIGNED) > 0 AND CAST(page.page_title AS UNSIGNED) < 10000)
     OR
     -- Titles ending with " AD"
     (SUBSTR(page.page_title, LENGTH(page.page_title) - 2, 3) = ' AD')
  )
  AND (
    categorylinks.cl_to = 'Years'
    OR categorylinks.cl_to LIKE 'Years of the %st century'
    OR categorylinks.cl_to LIKE 'Years of the %nd century'
    OR categorylinks.cl_to LIKE 'Years of the %rd century'
    OR categorylinks.cl_to LIKE 'Years of the %th century'
    OR categorylinks.cl_to = page.page_title
  );
SQL

Checking query status...
