.......... - Quarry

SQL

USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(pl_title,'_',' '),']] |'), count(pl_title)
FROM pagelinks INNER JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
AND page_namespace = 0
AND pl_title LIKE 'فهرست_روستاهای%'
AND NOT EXISTS ( # red links
#AND EXISTS ( # blue links
    SELECT NULL
    FROM page
    WHERE page_namespace = 0
    AND page_title = pl_title
)
AND page_id IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to LIKE "روستاهای_%"
  )
GROUP BY pl_title
ORDER BY count(pl_title) DESC;
SQL

Checking query status...
