Retrieve all articles in Wikiproject X which are in Italian Wiki

Fork of Retrieve all articles in Wikiproject medicine by Miriam (WMF)

This query is marked as a draft This query has been published by Miriam (WMF).

SQL

SELECT  itwiki_p.page.page_title, itwiki_.page.page_id
FROM page
INNER JOIN page article
ON page.page_title=article.page_title
INNER JOIN categorylinks  ON   cl_from = page.page_id
AND   categorylinks.cl_to = "All_WikiProject_Media_articles"
INNER JOIN wikidatawiki_p.wb_items_per_site
ON wikidatawiki_p.wb_items_per_site.ips_item_id IN ( SELECT ips_item_id from wikidatawiki_p.wb_items_per_site WHERE ips_site_page=REPLACE(page.page_title,'_',' ')
                                                    AND wikidatawiki_p.wb_items_per_site.ips_site_id="enwiki")
AND  wikidatawiki_p.wb_items_per_site.ips_site_id IN ("itwiki") 
INNER JOIN itwiki_p.page
ON itwiki_p.page_title= REPLACE(wikidatawiki_p.wb_items_per_site.ips_site_page,' ','_')
WHERE page.page_namespace = 1 
AND article.page_namespace = 0

SQL

Checking query status...