صور موجودة في ويكيبيديا العربية بنفس الاسم في كومنز

SQL

use arwiki_p;
select concat("# [[:File:",page_title,"]]")
from page
where page_namespace = 6
and page_is_redirect = 0
and page_title in (select commonswiki_p.page.page_title from commonswiki_p.page where commonswiki_p.page.page_title = page_title
                  and commonswiki_p.page.page_is_redirect = 0
                  and commonswiki_p.page.page_namespace = 6)
and page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 6 and tl_title like "صورة_مختارة");
#and page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 6 and tl_title like "الآن_كومنز");

SQL

Checking query status...