Difference between revisions of "Item talk:Q2369"

From Wikibase Personal data
Jump to navigation Jump to search
Line 7: Line 7:
 
(GROUP_CONCAT(DISTINCT ?wikidata;separator=", ") AS ?wikidataID)  
 
(GROUP_CONCAT(DISTINCT ?wikidata;separator=", ") AS ?wikidataID)  
 
(GROUP_CONCAT(DISTINCT ?portal;separator=", ") AS ?portals)  
 
(GROUP_CONCAT(DISTINCT ?portal;separator=", ") AS ?portals)  
 
 
WHERE {
 
WHERE {
 
   pdio:Q2369 pdiot:P6 ?item.
 
   pdio:Q2369 pdiot:P6 ?item.
Line 17: Line 16:
 
             ?portal_statement pdiops:P144 pdio:Q188.
 
             ?portal_statement pdiops:P144 pdio:Q188.
 
             ?portal_statement pdiopq:P15 ?portal}.  
 
             ?portal_statement pdiopq:P15 ?portal}.  
 
 
   SERVICE wikibase:label {
 
   SERVICE wikibase:label {
 
     ?compliance rdfs:label ?complianceName.
 
     ?compliance rdfs:label ?complianceName.

Revision as of 10:55, 9 December 2019

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)