query-1fa0d0fc0e29f3793ec2e91111b63019
Menschen mit "Zika" in der Bezeichnung (label) SELECT ?item ?itemLabel WITH { SELECT * WHERE { BIND ("zika" AS ?searchfor) } } AS %p WITH { SELECT ?item WHERE { INCLUDE %p BIND (CONCAT("haswbstatement:P31=Q5 ", ?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") FILTER(CONTAINS(LCASE(?itemLabel), ?searchfor)) OPTIONAL { ?item wdt:P698 ?PMID. } OPTIONAL { ?item wdt:P356 ?DOI. } }
Use at
- https://query.wikidata.org/sparql
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#>
#Menschen mit "Zika" in der Bezeichnung (label)
SELECT ?item ?itemLabel
WHERE {
{
SELECT ?item
WHERE {
{
SELECT * WHERE {
BIND ("zika" AS ?searchfor)
}
} BIND (CONCAT("haswbstatement:P31=Q5 ", ?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 ("zika" AS ?searchfor)
}
} ?item rdfs:label ?itemLabel .
FILTER (LANG(?itemLabel)="en")
FILTER(CONTAINS(LCASE(?itemLabel), ?searchfor))
OPTIONAL { ?item wdt:P698 ?PMID. }
OPTIONAL { ?item wdt:P356 ?DOI. }
}