Untitled query #49216

SQL

SELECT  enwiki_p.page.page_title, wb1.ips_site_page,wb1.ips_item_id
FROM page
JOIN categorylinks
JOIN wikidatawiki_p.wb_items_per_site wb1
JOIN wikidatawiki_p.wb_items_per_site enitems
ON wb1.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(page.page_title,'_',' ')
AND cl_from = page.page_id
WHERE enitems.ips_site_id="enwiki"
#AND  wikidatawiki_p.wb_items_per_site.ips_site_id IN ("frwiki")    
AND  wb1.ips_site_id = "frwiki"           
AND page.page_namespace = 0
AND page.page_is_redirect=0
AND   categorylinks.cl_to = "Featured_Articles"

#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...
