query-1db4e3912b469e8da6be05934fc14097

rq turtle/ttl

articles i categories d'estudiants i universitats SELECT DISTINCT ?persona ?personaLabel ?uni ?uniLabel ?article ?cat ?categoria 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/. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ca,en,es" . } }

Use at

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#>
# articles i categories d'estudiants i universitats
SELECT DISTINCT ?persona ?personaLabel ?uni ?uniLabel ?article ?cat ?categoria
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/>.
  }
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ca,en,es" . } 
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?article"):::projected v4("?cat"):::projected v5("?categoria"):::projected v1("?persona"):::projected v2("?uni"):::projected c7(["bd:serviceParam"]):::iri c4([https://ca.wikipedia.org/]):::iri c9(["#91;AUTO_LANGUAGE#93;,ca,en,es"]):::literal v1 --"wdt:P69"--> v2 v3 --"schema:about"--> v1 v3 --"schema:isPartOf"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P3876".-> v4 v5 --"schema:about"--> v4 v5 --"schema:isPartOf"--> c4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end