Project:SPARQL/examples: Difference between revisions

Line 510: Line 510:
</sparql>
</sparql>


==Categories==
==Tools for batch processing==


===All people (by assigned gender)===
===All people (by assigned gender), filtering out those already listed as instance of human===


<sparql tryit="1">
<sparql tryit="1">
# All people (by assigned gender)
# All people (by assigned gender), filtering out those already listed as instance of human


PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
Line 530: Line 530:
WHERE {   
WHERE {   
   ?person bnwdt:P3 ?assigned_gender .                        #select person
   ?person bnwdt:P3 ?assigned_gender .                        #select person
   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}            #filter out project team
   FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q2137 .}        #filter out people already listed as instance of human
  FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q12 .}            #filter out project team
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }  
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }  
}
}