Item talk:Q2369

From Wikibase Personal data
Revision as of 10:55, 9 December 2019 by Podehaye (talk | contribs)
Jump to navigation Jump to search

Status list

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

Try it (embedded)