SQL
x
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 LIKE '%۱۳%'
AND page_title LIKE '%نبرد%'
#LIMIT 100
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.