Changes

Jump to navigation Jump to search
767 bytes added ,  5 years ago
no edit summary
Line 1: Line 1: −
{{SPARQL|state=collapsed
+
{{SPARQL|label=items pointing to POD
|label=items pointing to POD
+
|query=select ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
|query=select ?s ?sLabel ?p ?pLabel ?date {
   
   ?s ?pd pdio:Q351 .
 
   ?s ?pd pdio:Q351 .
 
   ?p wikibase:directClaim ?pd .
 
   ?p wikibase:directClaim ?pd .
 
   OPTIONAL {?s pdiot:P100 ?date}.
 
   OPTIONAL {?s pdiot:P100 ?date}.
 +
  OPTIONAL {?s pdiot:P15 ?official}.
 +
  OPTIONAL {?s pdiot:P33 ?reference}.
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
+
} ORDER BY (UCASE(str(?date)))
 
}}
 
}}
      −
{{SPARQL|state=collapsed
+
{{SPARQL|label=items pointing to PDIO
|label=items pointing to PDIO
+
|query=select ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
|query=select ?s ?sLabel ?p ?pLabel ?date {
   
   ?s ?pd pdio:Q182 .
 
   ?s ?pd pdio:Q182 .
 
   ?p wikibase:directClaim ?pd .
 
   ?p wikibase:directClaim ?pd .
 
   OPTIONAL {?s pdiot:P100 ?date}.
 
   OPTIONAL {?s pdiot:P100 ?date}.
 +
  OPTIONAL {?s pdiot:P15 ?official}.
 +
  OPTIONAL {?s pdiot:P33 ?reference}.
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
+
} ORDER BY (UCASE(str(?date)))
 +
}}
 +
 
 +
 
 +
 
 +
{{SPARQL|label=items pointing to either PDIO or POD
 +
|query=select ?targetLabel ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
 +
  ?s ?pd ?target .
 +
  VALUES ?target {
 +
      pdio:Q182            # PDIO
 +
      pdio:Q351            # POD
 +
  }
 +
  MINUS {?s pdiot:P229 ?_}  # not data subject
 +
  ?p wikibase:directClaim ?pd .
 +
  OPTIONAL {?s pdiot:P100 ?date}.
 +
  OPTIONAL {?s pdiot:P15 ?official}.
 +
  OPTIONAL {?s pdiot:P33 ?reference}.
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 +
} ORDER BY (UCASE(str(?date)))
 
}}
 
}}

Navigation menu