Wikidata labels with parenthesis (cswiki)

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 cswiki_p.page AS cs
JOIN page AS other USING (page_title, page_namespace)
LEFT JOIN cswiki_p.page_props AS cs_props
	ON cs_props.pp_propname = 'wikibase_item' AND cs_props.pp_page = cs.page_id
LEFT JOIN page_props AS other_props
	ON other_props.pp_propname = 'wikibase_item' AND other_props.pp_page = other.page_id
WHERE cs.page_title LIKE 'Wikidata%'
AND cs.page_namespace = 828
AND (cs_props.pp_value IS NULL OR other_props.pp_value IS NULL OR cs_props.pp_value <> other_props.pp_value);
SQL

Checking query status...
