query-09fc8cc3e6def98abf86721295d0e8ac

rq turtle/ttl

articles d'estudiants de centres educatius sense categoria per centre educatiu SELECT DISTINCT ?persona ?personaLabel ?uni ?uniLabel ?article ?cat WHERE { ?persona wdt:P69 ?uni. ?article schema:about ?persona. ?article schema:isPartOf https://ca.wikipedia.org/. OPTIONAL { ?uni wdt:P3876 ?cat. ?categoria schema:about ?cat. ?categoria schema:isPartOf https://ca.wikipedia.org/. } FILTER (!bound(?categoria)) }

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
# articles d'estudiants de centres educatius sense categoria per centre educatiu
SELECT DISTINCT ?persona ?personaLabel ?uni ?uniLabel ?article ?cat
WHERE {
  ?persona wdt:P69 ?uni.
  ?article schema:about ?persona.
  ?article schema:isPartOf <https://ca.wikipedia.org/>.
  OPTIONAL {
    ?uni wdt:P3876 ?cat.
    ?categoria schema:about ?cat.
    ?categoria schema:isPartOf <https://ca.wikipedia.org/>.
  } FILTER (!bound(?categoria))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article"):::projected v5("?cat"):::projected v1("?categoria") v2("?persona"):::projected v3("?uni"):::projected c4([https://ca.wikipedia.org/]):::iri f0[["not bound(?categoria)"]] f0 --> v1 v2 --"wdt:P69"--> v3 v4 --"schema:about"--> v2 v4 --"schema:isPartOf"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P3876".-> v5 v1 --"schema:about"--> v5 v1 --"schema:isPartOf"--> c4 end