query-8c70ea4326ca162c5a2a4df0ec7ee109

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Mitja dotzena de variables, enllaçades sense repeticions
SELECT DISTINCT ?item ?itemLabel ?detall  WHERE {
  ?item wdt:P17 wd:Q29.
  ?item wdt:P131+ wd:Q1765582.

  OPTIONAL {
  { { { { {
  ?item wdt:P84 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Arquitecte: ",?dadaNet) as ?detall)
  }
  UNION
    {
  ?item wdt:P170 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Creador: ",?dadaNet) as ?detall)
  } }
  UNION
  {
  ?item wdt:P149 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Estil: ",?dadaNet) as ?detall)
  } }  
  UNION
  {
  ?item wdt:P135 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Estil artístic: ",?dadaNet) as ?detall)
  } }  
  UNION
  {
  ?item wdt:P5816 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Estat: ",?dadaNet) as ?detall)
  } }
  UNION
  {
  ?item wdt:P10241 ?dada.
  ?dada rdfs:label ?dadaEtiq.
  FILTER(LANG(?dadaEtiq)="ca")
    OPTIONAL {  
      ?dadaLink schema:isPartOf <https://ca.wikipedia.org/>;
      schema:about ?dada.
      BIND (REPLACE(REPLACE(wikibase:decodeUri(STR(?dadaLink)), "https://ca.wikipedia.org/wiki/", "", "i"), "_", " ") as ?dadaEnll)
      BIND (CONCAT("[[",str(?dadaEnll),"]]") as ?dadaWiki)   
    }
    BIND(COALESCE(?dadaWiki, ?dadaEtiq) as ?dadaNet)
    BIND(CONCAT("Tàxon: ",?dadaNet) as ?detall)
  }    

  }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "ca,en" .}
}
ORDER BY ?itemLabel

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?dada") v10("?dadaEnll") v3("?dadaEtiq") v5("?dadaLink") v10("?dadaNet") v10("?dadaWiki") v10("?detall"):::projected v2("?item"):::projected v1("?itemLabel"):::projected c19(["ca,en"]):::literal c4(["wd:Q1765582"]):::iri c9([https://ca.wikipedia.org/]):::iri c2(["wd:Q29"]):::iri c17(["bd:serviceParam"]):::iri v2 --"wdt:P17"--> c2 v2 --"wdt:P131"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; f0[["?dadaEtiq = 'ca'"]] f0 --> v3 v2 -."wdt:P10241".-> v4 v4 --"rdfs:label"--> v3 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind1[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind1 bind1 --as--o v10 bind2[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind2 bind2 --as--o v10 end bind3[/"?dadaWiki?dadaEtiq"/] v10 --o bind3 v3 --o bind3 bind3 --as--o v10 bind4[/"concat('Tàxon: ',?dadaNet)"/] v10 --o bind4 bind4 --as--o v10 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; f5[["?dadaEtiq = 'ca'"]] f5 --> v3 v2 --"wdt:P5816"--> v4 v4 --"rdfs:label"--> v3 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind6[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind6 bind6 --as--o v10 bind7[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind7 bind7 --as--o v10 end bind8[/"?dadaWiki?dadaEtiq"/] v10 --o bind8 v3 --o bind8 bind8 --as--o v10 bind9[/"concat('Estat: ',?dadaNet)"/] v10 --o bind9 bind9 --as--o v10 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; f10[["?dadaEtiq = 'ca'"]] f10 --> v3 v2 --"wdt:P135"--> v4 v4 --"rdfs:label"--> v3 subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind11[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind11 bind11 --as--o v10 bind12[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind12 bind12 --as--o v10 end bind13[/"?dadaWiki?dadaEtiq"/] v10 --o bind13 v3 --o bind13 bind13 --as--o v10 bind14[/"concat('Estil artístic: ',?dadaNet)"/] v10 --o bind14 bind14 --as--o v10 end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; f15[["?dadaEtiq = 'ca'"]] f15 --> v3 v2 --"wdt:P149"--> v4 v4 --"rdfs:label"--> v3 subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind16[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind16 bind16 --as--o v10 bind17[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind17 bind17 --as--o v10 end bind18[/"?dadaWiki?dadaEtiq"/] v10 --o bind18 v3 --o bind18 bind18 --as--o v10 bind19[/"concat('Estil: ',?dadaNet)"/] v10 --o bind19 bind19 --as--o v10 end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; subgraph union4[" Union "] subgraph union4l[" "] style union4l fill:#abf,stroke-dasharray: 3 3; f20[["?dadaEtiq = 'ca'"]] f20 --> v3 v2 --"wdt:P170"--> v4 v4 --"rdfs:label"--> v3 subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind21[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind21 bind21 --as--o v10 bind22[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind22 bind22 --as--o v10 end bind23[/"?dadaWiki?dadaEtiq"/] v10 --o bind23 v3 --o bind23 bind23 --as--o v10 bind24[/"concat('Creador: ',?dadaNet)"/] v10 --o bind24 bind24 --as--o v10 end subgraph union4r[" "] style union4r fill:#abf,stroke-dasharray: 3 3; f25[["?dadaEtiq = 'ca'"]] f25 --> v3 v2 --"wdt:P84"--> v4 v4 --"rdfs:label"--> v3 subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:isPartOf".-> c9 v5 --"schema:about"--> v4 bind26[/"replace(replace(http://wikiba.se/ontology#decodeUri(str(?dadaLink)),'https://ca.wikipedia.org/wiki/','','i'),'_',' ')"/] v5 --o bind26 bind26 --as--o v10 bind27[/"concat('#91;#91;',str(?dadaEnll),'#93;#93;')"/] v10 --o bind27 bind27 --as--o v10 end bind28[/"?dadaWiki?dadaEtiq"/] v10 --o bind28 v3 --o bind28 bind28 --as--o v10 bind29[/"concat('Arquitecte: ',?dadaNet)"/] v10 --o bind29 bind29 --as--o v10 end union4r <== or ==> union4l end end union3r <== or ==> union3l end end union2r <== or ==> union2l end end union1r <== or ==> union1l end end union0r <== or ==> union0l end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c19 end