query-e023f6351d5c79f5ed207dd77b63562f

rq turtle/ttl

list of item with a femal gender using P485 with as qualifier P217 (inventory number) and with a Wikipedia-ca page and in the same time a Wikipedia-fr page. SELECT DISTINCT ?item ?itemLabel ?itemDescription (GROUP_CONCAT(DISTINCT(?noLabel); separator=", ") as ?nosLabel) WHERE { ?item wdt:P21 wd:Q6581072. ?item p:P485 ?statement. ?statement ps:P485 ?archives. #option avoir déposé ses archives dans une institution ?statement pq:P217 ?no. FILTER (?article1 schema:about ?item. ?article1 schema:isPartOf https://ca.wikipedia.org/.) FILTER (?article2 schema:about ?item. ?article2 schema:isPartOf https://fr.wikipedia.org/.) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,it,de,nl,en". ?item rdfs:label ?itemLabel; schema:description ?itemDescription. ?no rdfs:label ?noLabel. } } GROUP BY ?item ?itemLabel ?itemDescription ?nosLabel ORDER BY ?itemDescription ?itemLabel LIMIT 100

Use at

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#list of item with a femal gender using P485 with as qualifier P217 (inventory number) and with a Wikipedia-ca page and in the same time a Wikipedia-fr page.
SELECT DISTINCT ?item ?itemLabel ?itemDescription (GROUP_CONCAT(DISTINCT(?noLabel); separator=", ") as ?nosLabel)
WHERE {
  ?item wdt:P21 wd:Q6581072.
?item p:P485 ?statement. 
?statement ps:P485 ?archives. #option avoir déposé ses archives dans une institution
?statement pq:P217 ?no.
    FILTER (?article1 schema:about ?item.
   ?article1 schema:isPartOf <https://ca.wikipedia.org/>.)
    FILTER (?article2 schema:about ?item.
            ?article2 schema:isPartOf <https://fr.wikipedia.org/>.)
  SERVICE wikibase:label 
          {
  bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,it,de,nl,en".
  ?item rdfs:label ?itemLabel;
        schema:description ?itemDescription.
  ?no rdfs:label ?noLabel.
          }
      }
GROUP BY ?item ?itemLabel ?itemDescription ?nosLabel
ORDER BY ?itemDescription ?itemLabel
LIMIT 100

Query found at