Project:SPARQL/examples: Difference between revisions
From Beyond Notability
Line 3,722: | Line 3,722: | ||
} | } | ||
ORDER BY ?itemLabel | ORDER BY ?itemLabel | ||
</sparql> | |||
=== Wikidata URL is not a URL === | |||
<sparql tryit="1"> | |||
#title:check for wikidata URLs that don't start with http. could still be other problems! | |||
## all checked and fixed at 18/12/23 but adding the query in case of any recurring issues | |||
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_url | |||
WHERE { | |||
?item bnp:P117 ?ws . # wikidata id | |||
?ws bnpq:P14 ?wd_url . | |||
filter(!strstarts(str(?wd_url), "http")). | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?itemLabel | |||
</sparql> | </sparql> | ||