إضافة بوابات للتصنيفات

SQL

use arwiki_p;
select page_title, SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_في_', 2), '_في_', -1)
from page
where page_namespace = 14
and page_is_redirect = 0
and page_title like "%_في_%"
and SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_في_', 2), '_في_', -1) in (select page_title from page where page_namespace = 100)
and page_id not in (select tl_from 
						from templatelinks 
                        where tl_from = page_id 
                        and tl_from_namespace = 14 and tl_namespace = 10
                        and (tl_title in ("شريط_بوابات","بوابة")))
limit 1000;

SQL

Checking query status...