Untitled query #19934

SQL

SELECT csp.pp_value AS cs_item, COALESCE(frp.pp_value, CONCAT('Sfrwikisource\t"', fr.page_title, '"')) 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)
AND (csp.pp_value IS NULL OR frp.pp_value IS NULL OR csp.pp_value <> frp.pp_value);
SQL

Checking query status...
