ويكيبيديا_طلبات_استبدال_القوالب

SQL

select page.page_title as "prt_title",page.page_namespace as "prt_namespace" from templatelinks 
inner join page on page.page_id = templatelinks.tl_from
inner join linktarget on linktarget.lt_id = templatelinks.tl_target_id 
where linktarget.lt_title in (select page_title from page where page_id in (902357)) and linktarget.lt_namespace = 10 and page.page_namespace in (0,14,6,10) 
and page.page_id in (	
    select cl_from from categorylinks
    where cl_to in (select page_title from page where page_id in (555535) and page_namespace in (14)) and cl_type = "page"
)
and page.page_is_redirect = 0

SQL

Checking query status...