query-f5798af0ddec1487cb0478ebe50bdc45

rq turtle/ttl

TODO

Use at

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 DISTINCT ?item ?itemLabel ?rkyid (group_concat(?typ) as ?typs) ?mjid ?rpid ?rprid ?coords (group_concat(distinct ?arkz;separator=", ") as ?arks) (group_concat(?loc) as ?locs) (group_concat(?pof) as ?pofs) (sample (?img) as ?img_) (group_concat(?her) as ?hers) ?vtjprt
WHERE
{
  ?item wdt:P1435/wdt:P279* wd:Q55845509 . 
  ?item wdt:P1435 ?her .
  OPTIONAL { ?item wdt:P31 ?typ . }
  OPTIONAL { ?item wdt:P4009 ?rkyid . }
  OPTIONAL { ?item wdt:P18 ?img . }
  OPTIONAL { ?item wdt:P4106 ?mjid. }
  OPTIONAL { ?item wdt:P5310 ?rpid. }
  OPTIONAL { ?item wdt:P5313 ?rprid. }
  OPTIONAL { ?item wdt:P361 ?pof .}
  OPTIONAL { ?item wdt:P1435 ?her .}
  OPTIONAL { ?item wdt:P3824 ?vtjprt .}
  OPTIONAL { ?item wdt:P131 ?loc .}
  OPTIONAL { ?item wdt:P625 ?coords . }
  OPTIONAL { ?item wdt:P84 ?ark . bind(replace(str(?ark),"http://www.wikidata.org/entity/","") as ?arkz)}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fi" }
  }
GROUP BY ?item ?itemLabel ?rkyid ?typs ?mjid ?rpid ?rprid ?coords ?locs ?arks ?pofs ?hers ?vtjprt

Query found at