Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

954 bytes added , 5 months ago

614

edits

@@ Line 3,703: / Line 3,703: @@
 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>