query-9db6bd9da860ee8d5ccd35aeea78d5d2

rq turtle/ttl

Stopping a timeout on castles in the UK which keeps timing out. But no joy, it still times out, which really frustrating as there are only about 4000 castle sites in the UK (Q145)United Kingdom in the (Q23413)castle explains a timeout workaround to get a list of museums in Northern Ireland, which works. Great I thought, I'd use that for https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization#Optimization_strategies

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?place ?placeLabel ?placeDescription ?location ?tripadvisor 
  (GROUP_CONCAT(?categoryLabel; SEPARATOR = ", ") AS ?categories) WHERE {
  {
    SELECT ?place ?categoryLabel ?placeLabel ?placeDescription ?tripadvisor ?location WHERE {
      ?place wdt:P131* wd:Q145 .
      wd:Q23413 ^wdt:P279*/^wdt:P31 ?place .
      ?place wdt:P31 ?category.
      OPTIONAL { ?place wdt:P3134 ?tripadvisor.}
      ?place wdt:P625 ?location.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en-GB,en". }
    }
  }
}
GROUP BY ?place ?placeLabel ?placeDescription ?location ?tripadvisor

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/12
• https://www.wikidata.org/wiki/Wikidata:Request_a_query/en
• https://www.wikidata.org/wiki/Wikidata:Request_a_query/es
• https://www.wikidata.org/wiki/Wikidata:Request_a_query/fr