query-0efaa866d6ac3b6f9e1ada83f34cdab5

rq turtle/ttl

Vermeer exhibition in the Louvre 07:55, 7 April 2017 (UTC)) talk (Jane023. I just want to know how you are modelling this so I know what is going on. Thanks for working on this exhibition btw - it looks really interesting. (Q28854991)Vermeer and the Masters of Genre Painting. Inspiration and Rivalry. and (Q28940890)Vermeer and the Masters of Genre Painting (I hope I fixed it!) and the exhibition items I am talking about are (Q4014797)The Doctor's Visit in a Rich Interior Hi Shonagon, I made a mistake and reverted one of your edits to a painting because I thought it was a mistake of mine. I fixed it, but then I noticed it was linking to an art exhibition at the Louvre, and there are now two items for this. I am not sure this is the right way to do this. Usually I just make one item for the exhibition catalog and then the paintings just link to that, but Nicolas Vigneron wanted separate items for the exhibition catalog and the exhibition (which is OK I guess). Now you are using the art exhibition for the catalog code, but I think this should be pointing to the book. Maybe there is a way to point to both? It is sometimes true for traveling exhibitions that some paintings are in the catalog but don't "travel" with the exhibition. The item I was talking about is ) and I have never seen an paticular exhibiton code different from the catalog when there is one; catalog code is indeed the common reference in art history. You can find all artworks of this exhibition ordered by catalog code with this query:https://www.wikidata.org/w/index.php?title=Q4014797&diff=466429675&oldid=466429671: (Q4014797)The Doctor's Visit in a Rich Interior should be used with the catalog, but that's what was done for this items (for example in : (P528)catalog code . An art exhibition is first an event, and not all exhibitions have a catalog. I agree with you that (P528)catalog code , the other is a book, used in particular with (P608)exhibition history , imho the correct way should be to have 2 items : one is an event, used in particular with VIGNERON. I'm not sure to understand the issue. Like Jane023Hello

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
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#>
SELECT distinct ?item ?numCatalogue ?itemLabel  ?creaLabel ?date (CONCAT(STR(?hauteur),"×",STR(?largeur)," cm") AS ?dimensions)
(GROUP_CONCAT(distinct ?collLb; separator=" - ") as ?collection) (GROUP_CONCAT(distinct ?ninv; separator=" - ") as ?inv) ?img (SAMPLE(?url) as ?URL)
WHERE 
{ 
  ?item wdt:P608 wd:Q28854991 ;
        wdt:P170 ?crea ;
        wdt:P18 ?img ;
        wdt:P195 ?coll ;
        wdt:P2048 ?hauteur ;
        wdt:P2049 ?largeur ;
        p:P528 [ ps:P528 ?numCatalogue ;
                 pq:P972 wd:Q28940890 ] ;
        p:P571 ?declarationdate .
  OPTIONAL { ?item wdt:P217 ?ninv }
  OPTIONAL { ?item wdt:P973 ?url }
  OPTIONAL { MINUS {?declarationdate pq:P1319 ?pasavant }
             MINUS {?declarationdate pq:P1480 wd:Q5727902 }
             ?declarationdate ps:P571 ?dateunique .
             BIND (year(?dateunique) AS ?date)}
  OPTIONAL { MINUS {?declarationdate pq:P1319 ?pasavant }
             ?declarationdate pq:P1480 wd:Q5727902. 
             ?declarationdate ps:P571 ?dateunique . 
             BIND (CONCAT("c.",STR(year(?dateunique))) AS ?date)}
  OPTIONAL { ?declarationdate pq:P1319 ?pasavant . 
             ?declarationdate pq:P1326 ?pasapres.
             BIND (CONCAT(STR(year(?pasavant)),"-",STR(year(?pasapres))) AS ?date)}
  ?coll rdfs:label ?collLb . filter (lang(?collLb) = "fr") .
  SERVICE wikibase:label {bd:serviceParam wikibase:language "fr"}
} GROUP BY ?item ?itemLabel ?numCatalogue ?creaLabel ?date ?hauteur ?largeur ?img 
ORDER BY xsd:integer(?numCatalogue)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v19("?URL") v6("?coll") v2("?collLb"):::projected v17("?collection") v4("?crea") v16("?date"):::projected v13("?dateunique") v9("?declarationdate") v16("?dimensions") v7("?hauteur"):::projected v5("?img"):::projected v18("?inv") v3("?item"):::projected v8("?largeur"):::projected v10("?ninv"):::projected v1("?numCatalogue"):::projected v15("?pasapres") v12("?pasavant") v11("?url"):::projected a1((" ")) c3(["wd:Q28854991"]):::iri c11(["wd:Q28940890"]):::iri c1(["fr"]):::literal c23(["bd:serviceParam"]):::iri c18(["wd:Q5727902"]):::iri f0[["?collLb = 'fr'"]] f0 --> v2 v3 --"p:direct/P608"--> c3 v3 --"p:direct/P170"--> v4 v3 --"p:direct/P18"--> v5 v3 --"p:direct/P195"--> v6 v3 --"p:direct/P2048"--> v7 v3 --"p:direct/P2049"--> v8 a1 --"p:statement/P528"--> v1 a1 --"p:qualifier/P972"--> c11 v3 --"p:P528"--> a1 v3 --"p:P571"--> v9 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P217".-> v10 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P973".-> v11 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v9 -."p:qualifier/P1319".-> v12 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v9 --"p:qualifier/P1480"--> c18 end v9 --"p:statement/P571"--> v13 bind3[/"year-from-dateTime(?dateunique)"/] v13 --o bind3 bind3 --as--o v16 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; v9 -."p:qualifier/P1319".-> v12 end v9 --"p:qualifier/P1480"--> c18 v9 --"p:statement/P571"--> v13 bind5[/"concat('c.',str(year-from-dateTime(?dateunique)))"/] v13 --o bind5 bind5 --as--o v16 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P1319".-> v12 v9 --"p:qualifier/P1326"--> v15 bind6[/"concat(str(year-from-dateTime(?pasavant)),'-',str(year-from-dateTime(?pasapres)))"/] v12 --o bind6 v15 --o bind6 bind6 --as--o v16 end v6 --"rdfs:label"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c23 --"wikibase:language"--> c1 end bind10[/"concat(str(?hauteur),'×',str(?largeur),' cm')"/] v7 --o bind10 v8 --o bind10 bind10 --as--o v16 bind11[/"?collLb"/] v2 --o bind11 bind11 --as--o v17 bind12[/"?ninv"/] v10 --o bind12 bind12 --as--o v18 bind13[/"sample(?url)"/] v11 --o bind13 bind13 --as--o v19