970101 mp1 # of DAB pages

SQL

/* get most used red links referred to from village articles */
USE fawiki_p;
/* pl_title represent the title of red links inside village articles */
/* page_id is the referrer */
SELECT pl_title, count(pl_title)
/* join the linking page to each pl_title */
FROM pagelinks LEFT JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
#and pl_title = 'Ab_Gushtukan'
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;
SQL

Checking query status...
