4,162
edits
Project:SPARQL/examples: Difference between revisions
→Maintenance queries
| Line 256: | Line 256: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | ||
} | |||
</SPARQL> | |||
== Items with non-unique Wikidata ID == | |||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
SELECT DISTINCT ?item1 ?item1Label ?item2 ?item2Label ?value WHERE { | |||
?item1 wbt:P1 ?value. | |||
?item2 wbt:P1 ?value. | |||
FILTER((?item1 != ?item2) && ((STR(?item1)) < (STR(?item2)))) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv". } | |||
} | } | ||
</SPARQL> | </SPARQL> | ||