579
edits
Project:SPARQL/examples: Difference between revisions
→All external IDs on Wikidata for Women FSAs
| Line 1,369: | Line 1,369: | ||
</sparql> | </sparql> | ||
=== All external IDs on Wikidata for Women | === All external IDs on Wikidata for Women === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Query to fetch all available External IDs on Wikidata for FSAs | # Query to fetch all available External IDs on Wikidata for FSAs | ||
# NB this will take a while | # NB this will take a while, but it should finish. | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
| Line 1,388: | Line 1,388: | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
?person bnwdt:P75 bnwd:Q8. # limit to FSAs | #?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out. | ||
?person bnp:P117 ?wikidata_ID . #get wikidata ID | ?person bnp:P117 ?wikidata_ID . #get wikidata ID | ||
| Line 1,399: | Line 1,399: | ||
?prop wikibase:claim ?p; | ?prop wikibase:claim ?p; | ||
wikibase:statementProperty ?ps; # NB rather than statementValue | wikibase:statementProperty ?ps; # NB rather than statementValue | ||
wikibase:propertyType | wikibase:propertyType wikibase:ExternalId. # quicker than filter. | ||
?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name | ?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name | ||
| Line 1,406: | Line 1,406: | ||
# filter by property type | # filter by property type | ||
filter(?prop_type in (wikibase:ExternalId ) ) . | #filter(?prop_type in (wikibase:ExternalId ) ) . | ||
} | } | ||