Difference between revisions of "Item talk:Q2369"
Jump to navigation
Jump to search
(Created page with "[https://query.personaldata.io/index.html#PREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fp...") |
|||
| Line 1: | Line 1: | ||
[https://query.personaldata.io/index.html#PREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3FitemLabel%20%3Finstance%20%3Femail%20%3Fcompliance%20%3Fwikidata%20%3Fportal%20WHERE%20%7B%0A%20%20pdio%3AQ2369%20%3Fpred%20%3Fitem.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP3%20%3Finstance%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP17%20%3Femail%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP32%20%3Fcompliance%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP103%20%3Fwikidata%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiop%3AP144%20%3Fportal_statement.%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fportal_statement%20pdiops%3AP144%20pdio%3AQ188.%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fportal_statement%20pdiopq%3AP15%20%3Fportal%7D.%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%0A%20%20%0A%7D%0ALIMIT%20100 Status list] | [https://query.personaldata.io/index.html#PREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3FitemLabel%20%3Finstance%20%3Femail%20%3Fcompliance%20%3Fwikidata%20%3Fportal%20WHERE%20%7B%0A%20%20pdio%3AQ2369%20%3Fpred%20%3Fitem.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP3%20%3Finstance%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP17%20%3Femail%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP32%20%3Fcompliance%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiot%3AP103%20%3Fwikidata%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20pdiop%3AP144%20%3Fportal_statement.%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fportal_statement%20pdiops%3AP144%20pdio%3AQ188.%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fportal_statement%20pdiopq%3AP15%20%3Fportal%7D.%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%0A%20%20%0A%7D%0ALIMIT%20100 Status list] | ||
| + | |||
| + | {{SPARQL|query=SELECT ?item ?itemLabel | ||
| + | (GROUP_CONCAT(DISTINCT ?instanceLabel;separator=", ") AS ?instances) | ||
| + | (GROUP_CONCAT(DISTINCT ?complianceName;separator=", ") AS ?compliances) | ||
| + | (GROUP_CONCAT(DISTINCT ?email;separator=", ") AS ?emails) | ||
| + | (GROUP_CONCAT(DISTINCT ?wikidata;separator=", ") AS ?wikidataID) | ||
| + | (GROUP_CONCAT(DISTINCT ?portal;separator=", ") AS ?portals) | ||
| + | |||
| + | WHERE { | ||
| + | pdio:Q2369 pdiot:P6 ?item. | ||
| + | OPTIONAL {?item pdiot:P3 ?instance}. | ||
| + | OPTIONAL {?item pdiot:P17 ?email}. | ||
| + | OPTIONAL {?item pdiot:P32 ?compliance}. | ||
| + | OPTIONAL {?item pdiot:P103 ?wikidata}. | ||
| + | OPTIONAL {?item pdiop:P144 ?portal_statement. | ||
| + | ?portal_statement pdiops:P144 pdio:Q188. | ||
| + | ?portal_statement pdiopq:P15 ?portal}. | ||
| + | |||
| + | SERVICE wikibase:label { | ||
| + | ?compliance rdfs:label ?complianceName. | ||
| + | ?item rdfs:label ?itemLabel. | ||
| + | ?instance rdfs:label ?instanceLabel. | ||
| + | bd:serviceParam wikibase:language "en" . | ||
| + | } | ||
| + | } GROUP BY ?item ?itemLabel}} | ||
Revision as of 10:54, 9 December 2019
PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel
(GROUP_CONCAT(DISTINCT ?instanceLabel;separator=", ") AS ?instances)
(GROUP_CONCAT(DISTINCT ?complianceName;separator=", ") AS ?compliances)
(GROUP_CONCAT(DISTINCT ?email;separator=", ") AS ?emails)
(GROUP_CONCAT(DISTINCT ?wikidata;separator=", ") AS ?wikidataID)
(GROUP_CONCAT(DISTINCT ?portal;separator=", ") AS ?portals)
WHERE {
pdio:Q2369 pdiot:P6 ?item.
OPTIONAL {?item pdiot:P3 ?instance}.
OPTIONAL {?item pdiot:P17 ?email}.
OPTIONAL {?item pdiot:P32 ?compliance}.
OPTIONAL {?item pdiot:P103 ?wikidata}.
OPTIONAL {?item pdiop:P144 ?portal_statement.
?portal_statement pdiops:P144 pdio:Q188.
?portal_statement pdiopq:P15 ?portal}.
SERVICE wikibase:label {
?compliance rdfs:label ?complianceName.
?item rdfs:label ?itemLabel.
?instance rdfs:label ?instanceLabel.
bd:serviceParam wikibase:language "en" .
}
} GROUP BY ?item ?itemLabel