روابط شقيقة

SQL

use arwiki_p;
select count(page_title) from  
page
where page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 0 and tl_title like "%كومنز%")
and page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 0 and tl_title like "%شقيق%")
and page_id not in (select cl_from from categorylinks where cl_to like "%صفحات_توضيح%" and cl_from = page_id)
and page_namespace =0 
and page_is_redirect = 0
and page_id in (select iwl_from from iwlinks  where page_id = iwl_from and iwl_prefix = "commons");
SQL

Checking query status...
