ويكيبيديا:طلبات استبدال الصور

SQL

# Note: The page ID of the image is 9147981.

/**
select  page.page_title as "prt_title",page.page_namespace as "prt_namespace"
from imagelinks 
inner join page on page.page_id = imagelinks.il_from
where il_to in (
	select page_title from page where page_id in (9147981) and page_namespace in (6)
)
and il_from_namespace in (0,14,10) 
**/

select  page.page_title as "prt_title",page.page_namespace as "prt_namespace"
from imagelinks 
inner join page on page.page_id = imagelinks.il_from
where il_to in (
	select page_title from page where page_title like "Meisje met de parel.jpg" and page_namespace in (6)
)
and il_from_namespace in (0,14,10)

SQL

Checking query status...