665
edits
Project:SPARQL/examples: Difference between revisions
From Beyond Notability
→Women with publications listed in indexes of archaeological papers circa 1870 - 1907
| Line 453: | Line 453: | ||
</sparql> | </sparql> | ||
===Women with publications listed in | ===Women with publications listed in Indexes of Archaeological Papers c.1870-1907 === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
| Line 466: | Line 466: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?person ? | SELECT distinct ?personLabel ?inLabel ?in ?person ?s | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P76 bnwd:Q419 . # select people with publications listed in indexes of archaeological papers | ?person bnwdt:P76 bnwd:Q419 . # select people with publications listed in indexes of archaeological papers | ||
?person bnp:P76 ?s . | |||
# titles of journals published in | |||
?s bnpq:P101 ?in . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ?personLabel | ORDER BY ?personLabel ?inLabel | ||
</sparql> | </sparql> | ||
