7,354
edits
Project:SPARQL/examples: Difference between revisions
→Tools for batch processing and quality assurance work
| Line 651: | Line 651: | ||
} | } | ||
} | } | ||
</sparql> | |||
===Get all items (with 'instance of' statement) for duplicate checking in OpenRefine=== | |||
<sparql tryit="1"> | |||
# Get all items (with 'instance of' statement) for duplicate checking in OpenRefine | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
SELECT ?item ?itemLabel WHERE { | |||
?item bnwdt:P12 ?anything . | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} | |||
ORDER BY ?itemLabel | |||
</sparql> | </sparql> | ||