Retrieve all articles in Wikiproject X which are in French Wiki

SQL

SELECT  frpage.page_title, frpage.page_id
FROM page enpage
INNER JOIN page article
ON enpage.page_title=article.page_title
INNER JOIN categorylinks  ON   cl_from = enpage.page_id
AND   categorylinks.cl_to = "WikiProject_Media_articles"
INNER JOIN wikidatawiki_p.wb_items_per_site wikidata
ON wikidata.ips_item_id IN ( SELECT ips_item_id from wikidatawiki_p.wb_items_per_site wikien WHERE ips_site_page=REPLACE(enpage.page_title,'_',' ')
                                                    AND wikien.ips_site_id="enwiki")
AND  wikidata.ips_site_id IN ("frwiki") 
INNER JOIN frwiki_p.page frpage
ON frpage.page_title= REPLACE(wikidata.ips_site_page,' ','_')
WHERE enpage.page_namespace = 1 
AND frpage.page_namespace=0
AND article.page_namespace = 0

SQL

Checking query status...