Project:SPARQL/examples: Difference between revisions

Line 2,873: Line 2,873:
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>


SELECT distinct ?item ?itemLabel WHERE {
SELECT distinct ?item ?itemLabel  
   ?item ?b ?c ;
WHERE {
  FILTER NOT EXISTS {?item bnwdt:P12 ?anything .}
   ?item ?b ?c .
      ?prop wikibase:claim ?b;  
            wikibase:statementProperty ?ps;
            wikibase:propertyType wikibase:WikibaseItem. # limit to P & Q Items. more manageable!


## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/Q")) . # limit results to "Q" entities
  FILTER NOT EXISTS {?item bnwdt:P12 ?instance .}
## FILTER(REGEX(STR(?item), "^https://beyond-notability.wikibase.cloud/entity/[PQ]")) . # or to Ps and Qs
 
## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/P")) . # uncomment to limit to P Properties
## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/Q")) . # or limit to Q items


   SERVICE wikibase:label {
   SERVICE wikibase:label {
586

edits