User:Pierre Tribhou/queries
Pascal
editWikipedia articles about works
editThe 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") } }
Map of artworks depicting Blaise Pascal
edit- SPARQL Query: https://w.wiki/6Gpf
People interested in Blaise Pascal
edit- SPARQL Query: https://w.wiki/9Sud
Clermont-Ferrand
editLieux de Clermont-ferrand avec un article sur la Wikipédia en français https://w.wiki/7BNU
Overnia
editThe 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". } }
Biblissima
editThe following query uses these:
- 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". } }