........ - Quarry

SQL

USE fawiki_p;
SELECT REPLACE(concat('# [[',MID(p1.page_title,1,LOCATE('(',p1.page_title)-2),']]'),'_',' '),REPLACE(concat('# [[',p1.page_title,']]'),'_',' '),REPLACE(concat('# [[',p2.page_title,']]'),'_',' ')
FROM page AS p1
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title LIKE "%(%"

AND p1.page_title NOT LIKE "%میلاد%"
AND p1.page_title NOT LIKE "%قمر%"
AND p1.page_title NOT LIKE "%عدد%"

AND p1.page_title NOT LIKE "(%"
AND page_title LIKE "%)"
AND p1.page_title NOT LIKE "%(ابهام‌زدایی)%"
AND p1.page_title NOT LIKE "%I%"
AND p1.page_title NOT LIKE "%V%"
AND p1.page_title NOT LIKE "زمین‌لرزه%"
AND p1.page_title NOT LIKE "انتخابات%"
AND MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) NOT IN (
  SELECT page_title
  FROM page
  WHERE page_namespace = 0
  AND page_title NOT LIKE "%(%"
#  AND page_is_redirect = 0
  )
AND MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) IN (
  SELECT MID(p2.page_title,1,LOCATE('(',p2.page_title)-2)
  FROM page AS p2
  WHERE p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  AND p2.page_title NOT LIKE p1.page_title
  )
AND NOT EXISTS (
  SELECT null
  FROM categorylinks
  WHERE cl_from=p1.page_id
  AND cl_to LIKE "مقاله‌های_خرد_کشتی_یا_قایق"
  )
LIMIT 20;
SQL

Checking query status...
