User:Rama
Jump to navigation
Jump to search
| Babel user information | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Users by language |
Scripts and tools
[edit]- User:Rama/common.js (main config)
- User:Rama/wikidata useful.js (config)
- copy
Examples of queries
[edit]Egyptian steles of the Louvre
[edit]The following query uses these:
- Properties: instance of (P31)
, collection (P195)
Features: ImageGrid (Q24515278) 
#defaultView:ImageGrid
SELECT ?item ?itemLabel ?pic
WHERE
{
?item wdt:P31 wd:Q178743.
?item wdt:P195 wd:Q3044749.
?item wdt:P18 ?pic
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Check accession numbers
[edit]The following query uses these:
- Properties: collection (P195)
SELECT DISTINCT ?item ?itemLabel ?dptLabel ?inv ?img WHERE { ?item wdt:P195 ?dpt. ?item wdt:P217 ?inv. VALUES ?inv {"A 45"}. OPTIONAL{?item wdt:P18 ?img} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Statuettes of Bastet with photographs
[edit]The following query uses these:
- Items: figurine (Q16738862)
- Properties: instance of (P31)
Features: ImageGrid (Q24515278)
#defaultView:ImageGrid
SELECT distinct ?item ?itemLabel ?pic
WHERE
{
VALUES ?statuette {wd:Q16738862 wd:Q1066288 wd:Q179700} # statuette or statue
VALUES ?bastet {wd:Q129106 wd:Q146104 wd:Q146007} # Bastet or Sekhmet or Wadjet
?item wdt:P31 ?statuette. # is a statuette or statue
?item wdt:P180 ?bastet. # subject is Bastet
?item wdt:P18 ?pic # Pikz or it did not happen
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Chief Mousers of the Cabinet, by date
[edit]The following query uses these:
- Properties: instance of (P31)
#defaultView:Timeline SELECT ?item ?itemLabel ?startdate (SAMPLE(?image) AS ?image) WHERE { ?item wdt:P31 wd:Q146. ?item p:P39 ?mouserOffice. ?mouserOffice ps:P39 wd:Q198641. ?mouserOffice pq:P580 ?startdate . #?item wdt:P569 ?startdate . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } OPTIONAL { ?item wdt:P18 ?image } } GROUP BY ?item ?itemLabel ?startdate
Microscopes
[edit]The following query uses these:
- Items: microscope (Q196538)
- Properties: instance of (P31)
Features: ImageGrid (Q24515278)
#defaultView:ImageGrid
SELECT ?item ?itemLabel ?pic
WHERE
{
?item wdt:P31/wdt:P279* wd:Q196538.
?item wdt:P18 ?pic
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Art in Geneva
[edit]Works of art from FCAC or FMAC (contemporary art in Geneva)
[edit]The following query uses these:
- Items: Fonds cantonal d'art contemporain, Genève (Q27481225)
- Properties: collection (P195)
Features: map (Q24515275)
#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo ?authorLabel WHERE {
VALUES ?institution {wd:Q27481225 wd:Q16636570 wd:Q3145370 wd:Q71 wd:Q123859078 wd:Q121890510} # selected institutions are FCAC, FMAC, HUG, City of Geneva, Fonds d'art de Carouge, Fonds d'art contemporain de Meyrin
?item wdt:P195 ?institution ; # item is in collection of one of the selected institutions
wdt:P625 ?geo ;
wdt:P170 ?author ;
wdt:P276 ?location ;
OPTIONAL { ?item wdt:P18 ?pic .} # get the picture as well if we can
OPTIONAL { ?location wdt:P6375 ?streetAddress .} # get the street address of location
# MINUS { ?item wdt:P18 [] } . # that lack a picture
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Geneva Lux
[edit]The following query uses these:
- Items: Geneva Lux (Q3070027)
- Properties: collection (P195)
Features: map (Q24515275)
#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo ?authorLabel WHERE {
?item wdt:P195 wd:Q3070027 ; # item is in collection Geneva Lux
wdt:P625 ?geo ;
#wdt:P170 ?author ;
wdt:P276 ?location ;
OPTIONAL { ?item wdt:P18 ?pic .} # get the picture as well if we can
OPTIONAL { ?location wdt:P6375 ?streetAddress .} # get the street address of location
# MINUS { ?item wdt:P18 [] } . # that lack a picture
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Works of art by Albert Siegenthaler
[edit]The following query uses these:
- Properties: creator (P170)
Features: map (Q24515275)
#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo WHERE {
?item wdt:P170 wd:Q38082245 ; # item is in collection of one of the selected institutions
wdt:P625 ?geo ;
wdt:P276 ?location ;
OPTIONAL { ?item wdt:P18 ?pic .} # get the picture as well if we can
OPTIONAL { ?location wdt:P6375 ?streetAddress .} # get the street address of location
# MINUS { ?item wdt:P18 [] } . # that lack a picture
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}