Untitled query #19934

SQL

SELECT cs.page_title AS cs_title, fr.page_title AS fr_title, csp.pp_propvalue AS cs_item, frp.pp_propvalue AS fr_item
FROM cswikisource_p.page AS cs
JOIN frwikisource_p.page AS fr
LEFT JOIN cswikisource_p.page_props AS csp ON cs.page_id = csp.pp_page AND csp.pp_propname = 'wikibase_item'
LEFT JOIN frwikisource_p.page_props AS frp ON fr.page_id = frp.pp_page AND frp.pp_propname = 'wikibase_item'
WHERE cs.page_namespace = 14 AND cs.page_title LIKE 'Články&_z&_roku&_%' ESCAPE '&'
AND fr.page_namespace AND fr.page_title LIKE 'Articles&_de&_%' ESCAPE '&'
AND SUBSTRING_INDEX(cs.page_title, '_', -1) = SUBSTRING_INDEX(fr.page_title, '_', -1);
SQL

Checking query status...
