960901 mp1 # of redirected links to DAB pages (pages)

SQL

USE fawiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
#AND page_title REGEXP '[۰-۹]'
#AND page_title REGEXP '[۰۱۲۳۴۵۶۷۸۹]+'
AND (
  page_title LIKE '%۱%'
  OR page_title LIKE '%۲%'
  OR page_title LIKE '%۳%'
  OR page_title LIKE '%۴%'
  OR page_title LIKE '%۵%'
  OR page_title LIKE '%۶%'
  OR page_title LIKE '%۷%'
  OR page_title LIKE '%۸%'
  OR page_title LIKE '%۹%'
  OR page_title LIKE '%۰%'
)

AND page_title NOT LIKE 'سیارک%'
AND page_title NOT LIKE 'نصف‌النهار_%_درجه%'
AND page_title NOT LIKE 'مدار_%_درجه%'

AND page_title NOT LIKE '%پیش_از_میلاد%'

AND page_title NOT LIKE '%قمری%'
AND page_title NOT LIKE '%فیلم%'

#AND page_title LIKE '%خورشیدگرفتگی%'
#AND page_title LIKE '%میلادی%'
AND page_title LIKE '%۱۳%'


#LIMIT 100
;
SQL

Checking query status...
