Cross-wiki same templates/modules

SQL

USE skwiki_p; # zaměnit za jiný projekt
SELECT cs.page_title, cs.page_namespace, cs_props.pp_value, other.page_title, other.page_namespace, other_props.pp_value
FROM (SELECT * FROM page WHERE page_namespace IN (10, 828)) AS other
#FROM page AS other
JOIN cswiki_p.page AS cs
#	ON cs.page_namespace IN (10, 828) AND cs.page_title = other.page_title AND cs.page_namespace = other.page_namespace
	ON cs.page_title = other.page_title AND cs.page_namespace = other.page_namespace
LEFT JOIN page_props AS other_props
	ON other_props.pp_propname = 'wikibase_item' AND other_props.pp_page = other.page_id
LEFT JOIN cswiki_p.page_props AS cs_props
	ON cs_props.pp_propname = 'wikibase_item' AND cs_props.pp_page = cs.page_id
WHERE cs_props.pp_value <> other_props.pp_value
LIMIT 100;
SQL

Checking query status...
