vcmp7.2.1 titles like فهرست_روستاهای receiving links from villages articles (red), all

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(concat('# [[',page_title,']]'),'_',' '),MID(page_title,1,LOCATE('(',page_title)-2)
FROM page
WHERE page_namespace=0
AND page_is_redirect=0
AND page_title LIKE "%(%"
AND page_title NOT LIKE "(%"
AND page_title LIKE "%)"
AND page_title NOT LIKE "%(ابهام‌زدایی)"
AND page_title NOT LIKE "%I%"
AND page_title NOT LIKE "%V%"
AND page_title NOT LIKE "زمین‌لرزه%"
AND page_title NOT LIKE "انتخابات%"
AND page_title NOT LIKE "%(فیلم%"

AND MID(page_title,1,LOCATE('(',page_title)-2) NOT IN (
  SELECT page_title
  FROM page
  WHERE page_title NOT LIKE "%(%"
  AND page_namespace = 0
#  AND page_is_redirect = 0
)

AND NOT EXISTS (
  SELECT null
  FROM categorylinks
  WHERE cl_from=page_id
  AND (cl_to LIKE "مقاله‌های_خرد_کشتی_یا_قایق"
       OR cl_to LIKE "%روستاهای_شهرستان%"
       OR cl_to LIKE "%افراد%"

       )
)

ORDER BY page_title;

SQL

Checking query status...