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

SQL

use arwiki_p;
select (page_title) from  
page
inner join page_props
on pp_page = page_id
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 pp_propname like "%wikibase_item%"
and TRIM(LEADING 'Q' FROM pp_value) in (select wikidatawiki_p.wb_items_per_site.ips_item_id
                                                   from wikidatawiki_p.wb_items_per_site
                                                   where wikidatawiki_p.wb_items_per_site.ips_item_id = TRIM(LEADING 'Q' FROM pp_value)
                                                   and wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwiki%"
                                                   )
and TRIM(LEADING 'Q' FROM pp_value) in (select wikidatawiki_p.wb_items_per_site.ips_item_id
                                                   from wikidatawiki_p.wb_items_per_site
                                                   where wikidatawiki_p.wb_items_per_site.ips_item_id = TRIM(LEADING 'Q' FROM pp_value)
                                                   and (wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwikinews%"
                                                       or
                                                       wikidatawiki_p.wb_items_per_site.ips_site_id like "%commonswiki%"
                                                       or
                                                       wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwikisource%"
                                                       or
                                                       wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwikiquote%"
                                                       or
                                                       wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwikibook%"
                                                       or
                                                       wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwiktionary%"
                                                       )
                                                   ) 
                                                   and page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 14 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 =14
                                                   and page_is_redirect = 0;
SQL

Checking query status...
