vcmp7.1 red links in villages articles excluding "فهرست_روستاهای" and english characters

SQL

/* get most used red links referred to from village articles */
USE fawiki_p;
/* pl_title represents the title of red links inside village articles */
/* page_id is the referrer */
SELECT pl_title, count(pl_title)
/* join the referrer to each pl_title */
FROM pagelinks LEFT JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
AND page_namespace = 0
AND NOT pl_title REGEXP '[A-Za-z]'
AND NOT pl_title LIKE 'فهرست_روستاهای%'

/* pl_title is a red link */
AND NOT EXISTS (
    SELECT NULL
    FROM page
    WHERE page_namespace = 0
    AND page_title = pl_title
)
/* the referrer is a village article */
AND EXISTS (
    SELECT cl_from
    FROM categorylinks
    WHERE cl_from = page_id
    AND cl_to LIKE "روستاهای_%"
)
GROUP BY pl_title
ORDER BY count(pl_title) DESC
LIMIT 500;

SQL

Checking query status...