Cross-wiki same templates/modules

SQL

USE cswikiversity_p; # zaměnit za jiný projekt
SELECT cs.page_title AS pg1, cs.page_namespace AS ns1, cs_props.pp_value AS item1,
	other.page_title AS pg2, other.page_namespace AS ns2, other_props.pp_value AS item2
FROM (SELECT * FROM cswiki_p.page WHERE page_namespace IN (10, 828)) AS cs
JOIN (SELECT * FROM page WHERE page_namespace IN (10, 828)) AS other USING (page_title, page_namespace)
LEFT JOIN cswiki_p.page_props AS cs_props
	ON cs_props.pp_page = cs.page_id AND cs_props.pp_propname = 'wikibase_item'
LEFT JOIN page_props AS other_props
	ON other_props.pp_page = other.page_id AND other_props.pp_propname = 'wikibase_item'
WHERE (
  cs_props.pp_value IS NULL xor other_props.pp_value IS NULL
) OR (
  cs_props.pp_value IS NOT NULL AND other_props.pp_value IS NOT NULL AND cs_props.pp_value <> other_props.pp_value
);
SQL

Checking query status...
