User talk:Yann/List of paintings by Paul Cézanne
SELECT ?item ?ref ?date1 ?date2 ?height ?heightU ?width ?widthU ?collection WHERE {
?item wdt:P31 wd:Q3305213.
?item wdt:P170 wd:Q35548.
?item wdt:P195 ?collection .
optional {?item wdt:P973 ?ref. }
optional {?item wdt:P571 ?date1. }
optional {?item p:P571 ?dobstatement .
?dobstatement psv:P571 [
wikibase:timePrecision "9"^^xsd:integer ;
wikibase:timeValue ?date2 ;
] }
optional {?item p:P2048/psv:P2048 ?heightD.
?heightD wikibase:quantityAmount ?height.
?heightD wikibase:quantityUnit ?heightU.}
optional {?item p:P2049/psv:P2049 ?widthD.
?widthD wikibase:quantityAmount ?width.
?widthD wikibase:quantityUnit ?widthU.}
}
order by ?date1
concatenated using =CONCATENATE("{{Painting table row|",B424,"|date=",D424,"|size=",E424," × ",G424," cm|institution=",I424,"}}")