تصانيف بحاجة لقوالب شقيقة

SQL

use arwiki_p;
select count(page_title) from  
page
where page_id not in (select arwiki_p.categorylinks.cl_from from arwiki_p.categorylinks where arwiki_p.categorylinks.cl_from = arwiki_p.page.page_id and arwiki_p.categorylinks.cl_to like "%كومنز%")
and page_title not in (select wikidatawiki_p.wb_items_per_site.ips_site_page from wikidatawiki_p.wb_items_per_site
                       where wikidatawiki_p.wb_items_per_site.ips_site_page = page_title
                      and page_namespace = 0
                      and page_is_redirect = 0
                      and wikidatawiki_p.wb_items_per_site.ips_site_id like "%commonswiki%")
                      and page_namespace = 0
                      and page_is_redirect = 0;
SQL

Checking query status...
