query-2d9e6b2a13cab6a2a184d8f49215c967

rq turtle/ttl

PM20 folder with certain string(s) in the item label, alias or description

select ?item ?itemLabel ?pm20 with { select * where { bind ("brücken hamburg" as ?searchfor) } } as %p with { select ?item where { include %p bind (concat("haswbstatement:P4293 ", ?searchfor) as ?searchstr) SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "search" . bd:serviceParam mwapi:gsrsearch ?searchstr . bd:serviceParam mwapi:gsrlimit "max" . bd:serviceParam mwapi:gsrnamespace "0" . bd:serviceParam mwapi:gsrprop "" . ?item wikibase:apiOutputItem mwapi:title . } } } as %i where { include %i include %p ?item rdfs:label ?itemLabel . filter (lang(?itemLabel)="en") ?item wdt:P4293 ?pm20Id. bind(uri(concat('https://pm20.zbw.eu/folder/', ?pm20Id)) as ?pm20) }

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# PM20 folder with certain string(s) in the item label, alias or description

select ?item ?itemLabel ?pm20
where {
   {
  select ?item
  where {
     {
  select * where {
    bind ("brücken hamburg" as ?searchfor)
  }
}    bind (concat("haswbstatement:P4293 ", ?searchfor) as ?searchstr)
    SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:endpoint "www.wikidata.org" .
      bd:serviceParam wikibase:api "Generator" .
      bd:serviceParam mwapi:generator "search" .
      bd:serviceParam mwapi:gsrsearch ?searchstr .
      bd:serviceParam mwapi:gsrlimit "max" .
      bd:serviceParam mwapi:gsrnamespace "0" .
      bd:serviceParam mwapi:gsrprop "" .
      ?item wikibase:apiOutputItem mwapi:title .
    }
  }
}   {
  select * where {
    bind ("brücken hamburg" as ?searchfor)
  }
}  ?item rdfs:label ?itemLabel .
  filter (lang(?itemLabel)="en")
  ?item wdt:P4293 ?pm20Id.
  bind(uri(concat('https://pm20.zbw.eu/folder/', ?pm20Id)) as ?pm20)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?item"):::projected v1("?itemLabel"):::projected v6("?pm20"):::projected v5("?pm20Id") v5("?searchfor") v3("?searchstr") c5(["www.wikidata.org"]):::literal c16([""]):::literal c12(["max"]):::literal c14(["0"]):::literal c9(["search"]):::literal c3(["bd:serviceParam"]):::iri c18(["mwapi:title"]):::iri c7(["Generator"]):::literal f0[["?itemLabel = 'en'"]] f0 --> v1 bind1[/"'brücken hamburg'"/] bind1 --as--o v5 bind2[/"concat('haswbstatement:P4293 ',?searchfor)"/] v5 --o bind2 bind2 --as--o v3 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c3 --"mwapi:endpoint"--> c5 c3 --"mwapi:api"--> c7 c3 --"mwapi:generator"--> c9 c3 --"mwapi:gsrsearch"--> v3 c3 --"mwapi:gsrlimit"--> c12 c3 --"mwapi:gsrnamespace"--> c14 c3 --"mwapi:gsrprop"--> c16 v4 --"mwapi:apiOutputItem"--> c18 end bind3[/"'brücken hamburg'"/] bind3 --as--o v5 v4 --"rdfs:label"--> v1 v4 --"wdt:P4293"--> v5 bind4[/"concat('https://pm20.zbw.eu/folder/',?pm20Id)"/] v5 --o bind4 bind4 --as--o v6