query-50d7c0257171e4449998eab9233fa9ce

rq turtle/ttl

Unique value constraint report for P2639: report listing each item SELECT DISTINCT ?item1 ?item2 ?wde ?item1Label ?item2Label ?gnd1 ?gnd2 ?geb1 ?geb2 ?isni1 ?isni2 ?viaf1 ?viaf2 ?dnb1 ?dnb2 ?filmportal WHERE { ?item1 wdt:P2639 ?filmportal. ?item2 wdt:P2639 ?filmportal. ?wde schema:about ?item1; schema:inLanguage "de". FILTER((?item1 != ?item2) && ((STR(?item1)) < (STR(?item2)))) OPTIONAL { ?item1 wdt:P227 ?gnd1. } OPTIONAL { ?item2 wdt:P227 ?gnd2. } OPTIONAL { ?item1 wdt:P213 ?isni1. } OPTIONAL { ?item2 wdt:P213 ?isni2. } OPTIONAL { ?item1 wdt:P214 ?viaf1. } OPTIONAL { ?item2 wdt:P214 ?viaf2. } OPTIONAL { ?item1 wdt:P7902 ?dnb1. } OPTIONAL { ?item2 wdt:P7902 ?dnb2. } OPTIONAL { ?item1 wdt:P569 ?geb1. } OPTIONAL { ?item2 wdt:P569 ?geb2. } FILTER((xsd:integer(SUBSTR(STR(?item2), 33 ))) >= 95000000 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". } } ORDER BY (xsd:integer(SUBSTR(STR(?item2), 33 )))

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Unique value constraint report for P2639: report listing each item
SELECT DISTINCT ?item1 ?item2 ?wde ?item1Label ?item2Label ?gnd1 ?gnd2 ?geb1 ?geb2 ?isni1 ?isni2 ?viaf1 ?viaf2 ?dnb1 ?dnb2 ?filmportal WHERE {
  ?item1 wdt:P2639 ?filmportal.
  ?item2 wdt:P2639 ?filmportal.
  ?wde schema:about ?item1;
    schema:inLanguage "de".
  FILTER((?item1 != ?item2) && ((STR(?item1)) < (STR(?item2))))
  OPTIONAL { ?item1 wdt:P227 ?gnd1. }
  OPTIONAL { ?item2 wdt:P227 ?gnd2. }
  OPTIONAL { ?item1 wdt:P213 ?isni1. }
  OPTIONAL { ?item2 wdt:P213 ?isni2. }
  OPTIONAL { ?item1 wdt:P214 ?viaf1. }
  OPTIONAL { ?item2 wdt:P214 ?viaf2. }
  OPTIONAL { ?item1 wdt:P7902 ?dnb1. }
  OPTIONAL { ?item2 wdt:P7902 ?dnb2. }
  OPTIONAL { ?item1 wdt:P569 ?geb1. }
  OPTIONAL { ?item2 wdt:P569 ?geb2. }
  FILTER((xsd:integer(SUBSTR(STR(?item2), 33 ))) >= 95000000 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
} ORDER BY (xsd:integer(SUBSTR(STR(?item2), 33 )))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v11("?dnb1"):::projected v12("?dnb2"):::projected v3("?filmportal"):::projected v13("?geb1"):::projected v14("?geb2"):::projected v5("?gnd1"):::projected v6("?gnd2"):::projected v7("?isni1"):::projected v8("?isni2"):::projected v2("?item1"):::projected v1("?item2"):::projected v9("?viaf1"):::projected v10("?viaf2"):::projected v4("?wde"):::projected c6(["de"]):::literal c13(["bd:serviceParam"]):::iri c15(["de,en"]):::literal f0[["http://www.w3.org/2001/XMLSchema#integer(substring(str(?item2),'33^^xsd:integer')) >= '95000000^^xsd:integer'"]] f0 --> v1 f1[["?item1 != ?item2str(?item1) < str(?item2)"]] f1 --> v2 f1 --> v1 v2 --"wdt:P2639"--> v3 v1 --"wdt:P2639"--> v3 v4 --"schema:about"--> v2 v4 --"schema:inLanguage"--> c6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P227".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P227".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P213".-> v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P213".-> v8 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P214".-> v9 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P214".-> v10 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P7902".-> v11 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P7902".-> v12 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P569".-> v13 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P569".-> v14 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end