Ranking articles by citations needed

SQL

SELECT page_title, COUNT(*) AS citation_needed_count
FROM 
  (SELECT page_title,
          REGEXP_REPLACE(
            REPLACE(REPLACE(rev_text.old_text, '{{citation needed', '{{Citation needed'), '{{Citation needed', '{{Citation needed}}'),
            '[^{]+', 
            ''
          ) AS content
   FROM page
   JOIN revision ON page_id = rev_page
   JOIN text rev_text ON rev_text_id = rev_text.old_id
   JOIN categorylinks ON page_id = cl_from
   WHERE cl_to = 'All_articles_with_unsourced_statements'
   AND rev_id = page_latest) AS sub
WHERE content LIKE '%{{Citation needed%'
GROUP BY page_title
ORDER BY citation_needed_count DESC
SQL

Checking query status...
