579
edits
Project:SPARQL/examples: Difference between revisions
m
→What external IDs are available in Wikidata for women in the BN database?
| Line 1,439: | Line 1,439: | ||
?person bnp:P117 ?wikidata_ID . # wikidata ID | ?person bnp:P117 ?wikidata_ID . # wikidata ID | ||
?wikidata_ID bnpq:P14 ?wikidata_url . | ?wikidata_ID bnpq:P14 ?wikidata_url . | ||
BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?wikidata ) | BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata ) | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?wikidata ?p ?s . | ?wikidata ?p ?s . | ||
?prop wikibase:claim ?p; | ?prop wikibase:claim ?p; | ||
wikibase:propertyType ?prop_type; # property type | |||
wikibase:propertyType ?prop_type | rdfs:label ?prop_label. filter(lang(?prop_label)="en") . | ||
# filter by property type | # filter by property type | ||
| Line 1,453: | Line 1,452: | ||
} | } | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, en-gb". } | ||
} | } | ||
group by ?p ?prop_label | group by ?p ?prop_label | ||