| 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 . |
| Line 8: |
Line 7: |
| | OPTIONAL {?s pdiot:P33 ?reference}. | | 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 . |
| Line 21: |
Line 19: |
| | OPTIONAL {?s pdiot:P33 ?reference}. | | 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))) |
| | }} | | }} |