query-7cb3c3b289543215b528e893ce03caeb

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?type 
  (CONCAT("+",STR(COALESCE(?pointintime,?starttime))) AS ?start)
  ?description ?notes ?link ?title ?keywords WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en-GB,en,fr,de,es,pt,pl,nl,cs". }
  { 
    SELECT DISTINCT ?item ?type ?pointintime ?starttime ?description ?notes ?link ?title ?keywords WHERE {
# places that need tripadvisor entries to be notable
   VALUES ?notable {wd:Q23413 wd:Q16748868} # castle, city walls

  ?item wdt:P3134 ?tripadvisor. 
  ?item wdt:P17 wd:Q145.

  ?item wdt:P31/wdt:P279* ?notable. 

VALUES ?registerclass {
 wd:Q18618628 # cultural heritage
  wd:Q19829908 # places
  wd:Q22964288 # military
  wd:Q23779665 # maritime
  wd:Q74568206 # archives
}
      {
          ?registerclass ^wdt:P31 ?register.

         ?register wikibase:claim ?claim .
          ?register wikibase:statementProperty ?value.

          ?item ?claim ?stat .
          ?stat ?value ?entry .
          OPTIONAL {
          ?register wdt:P2378 ?issuer.
          ?issuer rdfs:label ?issuerlabel. FILTER (LANG(?issuerlabel) = "en")
          ?register wdt:P1630 ?URLprefix.
                  {?stat pq:P1435 ?caveat.} # heritage designation
            UNION {?stat pq:P518  ?caveat}  # applies to part
            UNION {?stat pq:P1810 ?caveat}  # subject named as
            ?caveat rdfs:label ?caveatlabel1. FILTER (LANG(?caveatlabel1) = "en")
          }
          BIND (IF(BOUND(?caveatlabel1),?caveatlabel1,"entry") AS ?caveatlabel2)

          BIND(CONCAT("[[d:Special:EntityPage/",STR(?ISSUERLABEL),"|",STR(?ISSUERLABEL),"]] [[:Template:Website]]") AS ?description)
        }
    }
  }
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v13("?URLprefix") v14("?caveat") v6("?caveatlabel1") v15("?caveatlabel2") v8("?claim") v16("?description"):::projected v11("?entry") v12("?issuer") v5("?issuerlabel") v2("?item"):::projected v1("?notable") v7("?register") v4("?registerclass") v17("?start") v10("?stat") v3("?tripadvisor") v9("?value") a1((" ")) c4(["en-GB,en,fr,de,es,pt,pl,nl,cs"]):::literal c2(["bd:serviceParam"]):::iri c7(["wd:Q145"]):::iri subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c2 --"wikibase:language"--> c4 end bind0[/VALUES ?notable/] bind0-->v1 bind00(["wd:Q23413"]) bind00 --> bind0 bind01(["wd:Q16748868"]) bind01 --> bind0 v2 --"wdt:P3134"--> v3 v2 --"wdt:P17"--> c7 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> v1 bind1[/VALUES ?registerclass/] bind1-->v4 bind10(["wd:Q18618628"]) bind10 --> bind1 bind11(["wd:Q19829908"]) bind11 --> bind1 bind12(["wd:Q22964288"]) bind12 --> bind1 bind13(["wd:Q23779665"]) bind13 --> bind1 bind14(["wd:Q74568206"]) bind14 --> bind1 v7 --"wdt:P31"--> v4 v7 --"wikibase:claim"--> v8 v7 --"wikibase:statementProperty"--> v9 v2 -->v8--> v10 v10 -->v9--> v11 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v7 -."wdt:P2378".-> v12 v12 --"rdfs:label"--> v5 v7 --"wdt:P1630"--> v13 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v10 --"pq:P1810"--> v14 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v10 --"pq:P518"--> v14 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v10 --"pq:P1435"--> v14 end union0r <== or ==> union0l end v14 --"rdfs:label"--> v6 end bind2[/"if(bound(?caveatlabel1),?caveatlabel1,'entry')"/] v6 --o bind2 bind2 --as--o v15 bind3[/"concat('#91;#91;d:Special:EntityPage/',str(?ISSUERLABEL),'|',str(?ISSUERLABEL),'#93;#93; #91;#91;:Template:Website#93;#93;')"/] null --o bind3 bind3 --as--o v16 bind4[/"concat('+',str(?pointintime?starttime))"/] null --o bind4 null --o bind4 bind4 --as--o v17