Project:SPARQL/examples: Difference between revisions
From Beyond Notability
Line 3,703: | Line 3,703: | ||
order by ?date | order by ?date | ||
</sparql> | |||
=== Wikidata ID is a URL === | |||
<sparql tryit="1"> | |||
#title:check for accidental use of URL instead of wikidata ID | |||
## all checked and fixed at 18/12/23 but adding the query in case it recurs | |||
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 distinct ?item ?itemLabel ?wd_http | |||
WHERE { | |||
?item bnwdt:P117 ?wd_http . # wikidata id | |||
filter(strstarts(str(?wd_http), "http")). | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?itemLabel | |||
</sparql> | </sparql> | ||