ملفات عربية في كومنز

SQL

use commonswiki_p;
select page_title, concat ("[[:commons:",page_title,"]]") from page
inner join revision
on rev_page = page_id
where ((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  "%خ%"
      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  "%ل%"
      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  "%ء%"
      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 not like "%ۀ%"))
and rev_timestamp > NOW() - INTERVAL 1 DAY
and rev_parent_id = 0
and page_namespace = 6
limit 500;
SQL

Checking query status...
