query-fb19036b138027da33276ee2def193a1

rq turtle/ttl

Wikiprojects maintained by the KB SELECT ?project ?projectLabelEN ?projectLabelNL ?WDprojectpage ?projectbanner (GROUP_CONCAT(DISTINCT ?subjectLabelEN ; separator = " * ") as ?projectAboutEN) (GROUP_CONCAT(DISTINCT ?subjectLabelNL ; separator = " * ") as ?projectAboutNL) ?projectTopicMainCat ?projectTopicMainCatLabelEN

?commonscat

?commonscatURL ?WPNLurl WHERE { ?project wdt:P31 wd:Q16695773; wdt:P126 wd:Q1526131. OPTIONAL {?project wdt:P18 ?projectbanner.} OPTIONAL {?project rdfs:label ?projectLabelEN FILTER(LANG(?projectLabelEN)='en').} OPTIONAL {?project rdfs:label ?projectLabelNL FILTER(LANG(?projectLabelNL)='nl').} OPTIONAL {?WDprojectpage schema:about ?project . ?WDprojectpage schema:isPartOf https://www.wikidata.org/.}

OPTIONAL {?project wdt:P921 ?subject. ?subject rdfs:label ?subjectLabelEN. FILTER(LANG(?subjectLabelEN)='en').} OPTIONAL {?project wdt:P921 ?subject. ?subject rdfs:label ?subjectLabelNL. FILTER(LANG(?subjectLabelNL)='nl')}

OPTIONAL {?project wdt:P910 ?projectTopicMainCat. ?projectTopicMainCat rdfs:label ?projectTopicMainCatLabelEN. FILTER(LANG(?projectTopicMainCatLabelEN)='en'). ?commonscatURL schema:about ?projectTopicMainCat . ?commonscatURL schema:isPartOf https://commons.wikimedia.org/.}

OPTIONAL {?project wdt:P910 ?projectTopicMainCat2. ?WPNLurl schema:about ?projectTopicMainCat2 . ?WPNLurl schema:isPartOf https://nl.wikipedia.org/.}

} GROUP BY ?project ?projectLabelEN ?projectLabelNL ?WDprojectpage ?projectbanner ?projectTopicMainCat ?projectTopicMainCatLabelEN ?commonscatURL ?WPNLurl #?commonscat

Use at

• https://query.wikidata.org/sparql

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#>
#Wikiprojects maintained by the KB
SELECT ?project 
?projectLabelEN 
?projectLabelNL 
?WDprojectpage ?projectbanner 
(GROUP_CONCAT(DISTINCT ?subjectLabelEN ; separator = " **** ") as ?projectAboutEN) 
(GROUP_CONCAT(DISTINCT ?subjectLabelNL ; separator = " **** ") as ?projectAboutNL)
?projectTopicMainCat ?projectTopicMainCatLabelEN
#?commonscat 
?commonscatURL 
?WPNLurl
WHERE 
{
  ?project wdt:P31 wd:Q16695773; wdt:P126 wd:Q1526131.
  OPTIONAL {?project wdt:P18 ?projectbanner.}
  OPTIONAL {?project rdfs:label ?projectLabelEN FILTER(LANG(?projectLabelEN)='en').}
  OPTIONAL {?project rdfs:label ?projectLabelNL FILTER(LANG(?projectLabelNL)='nl').}
  OPTIONAL {?WDprojectpage schema:about ?project .
     ?WDprojectpage schema:isPartOf <https://www.wikidata.org/>.}  

  OPTIONAL {?project wdt:P921 ?subject.
     ?subject rdfs:label ?subjectLabelEN. FILTER(LANG(?subjectLabelEN)='en').}
  OPTIONAL {?project wdt:P921 ?subject.
     ?subject rdfs:label ?subjectLabelNL. FILTER(LANG(?subjectLabelNL)='nl')}

  OPTIONAL {?project wdt:P910 ?projectTopicMainCat.
     ?projectTopicMainCat rdfs:label ?projectTopicMainCatLabelEN. FILTER(LANG(?projectTopicMainCatLabelEN)='en').
     ?commonscatURL schema:about ?projectTopicMainCat .
     ?commonscatURL schema:isPartOf <https://commons.wikimedia.org/>.}

   OPTIONAL {?project wdt:P910 ?projectTopicMainCat2.
     ?WPNLurl schema:about ?projectTopicMainCat2 .
     ?WPNLurl schema:isPartOf <https://nl.wikipedia.org/>.}

} GROUP BY ?project  ?projectLabelEN ?projectLabelNL ?WDprojectpage ?projectbanner ?projectTopicMainCat ?projectTopicMainCatLabelEN ?commonscatURL ?WPNLurl #?commonscat

Query found at

• https://www.wikidata.org/wiki/Wikidata:GLAM/Koninklijke_Bibliotheek_Nederland/maintained_by