User:Pierre Tribhou/queries

Pascal

Wikipedia articles about works

The following query uses these:

• Items: Blaise Pascal (Q1290)   

• Properties: author (P50)   , publication date (P577)   

  SELECT ?work ?title ?year ?english ?french WHERE {
    ?work wdt:P50 wd:Q1290
  OPTIONAL{?work wdt:P577 ?pubdate}
  BIND(YEAR(?pubdate) as ?year)
  OPTIONAL{ ?english schema:about ?work ; schema:isPartOf <https://en.wikipedia.org/> }
  OPTIONAL{ ?french schema:about ?work ; schema:isPartOf <https://fr.wikipedia.org/> }
  #OPTIONAL{ ?german schema:about ?work ; schema:isPartOf <https://de.wikipedia.org/> }
  OPTIONAL{ ?work rdfs:label ?title filter(lang(?title) = "fr") }
  }
  

Try it!

Map of artworks depicting Blaise Pascal

• SPARQL Query: https://w.wiki/6Gpf

People interested in Blaise Pascal

• SPARQL Query: https://w.wiki/9Sud

Clermont-Ferrand

Lieux de Clermont-ferrand avec un article sur la Wikipédia en français https://w.wiki/7BNU

Overnia

The following query uses these:

• Properties: Overnia ID (P9845)   

  SELECT ?item ?itemLabel ?groupLabel ?imageLabel ?collection ?collectionLabel WHERE {
    ?item wdt:P9845 ?group .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Biblissima

The following query uses these:

• Items: Rare book library of Clermont Auvergne Métropole (Q85821952)   

• Properties: collection (P195)   , image (P18)   , inventory number (P217)   , Biblissima authority ID (P11493)   

  SELECT ?item ?cote ?biblissima ?itemLabel ?pic WHERE {
    ?item wdt:P195 wd:Q85821952.
    ?item p:P217 ?statement1.
    ?statement1 (ps:P217) _:anyValueP217.
    ?item p:P11493 ?statement2.
    ?statement2 (ps:P11493) _:anyValueP11493
    OPTIONAL {
      ?item wdt:P18 ?pic.
     ?item wdt:P217 ?cote.
    ?item wdt:P11493 ?biblissima.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }
  }
  

Try it!