All Good/Featured articles in enwiki matching Good articles in frwiki

SQL

SELECT  enpage.page_title, fritems.ips_site_page,fritems.ips_item_id
FROM enwiki_p.page enpage
JOIN enwiki_p.categorylinks encat
JOIN wikidatawiki_p.wb_items_per_site fritems
JOIN wikidatawiki_p.wb_items_per_site enitems
FROM frwiki_p.page frpage
JOIN frwiki_p.categorylinks frcat
ON fritems.ips_item_id =enitems.ips_item_id #IN ( S1ELECT ips_item_id from wikidatawiki_p.wb_items_per_site 
AND enitems.ips_site_page=REPLACE(enpage.page_title,'_',' ')
AND encat.cl_from = enpage.page_id
AND fritems.ips_site_page=REPLACE(frpage.page_title,'_',' ')
AND frcat.cl_from = frpage.page_id
WHERE enitems.ips_site_id="enwiki"
#AND  wikidatawiki_p.wb_items_per_site.ips_site_id IN ("frwiki")    
AND  fritems.ips_site_id = "frwiki"           
AND enpage.page_namespace = 0
AND enpage.page_is_redirect=0
AND   encat.cl_to in ("Featured_articles", "Good_articles")
AND   frcat.cl_to in ("Article_de_qualité", "Bon_article")         
AND frpage.page_namespace = 0
AND frpage.page_is_redirect=0


#FROM wb_items_per_site WHERE ips_site_id="enwiki" AND ips_item_id IN (SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_page LIKE ("'$title'") AND ips_site_id="'$lan'")'
SQL

Checking query status...
