query-19cbdc7be0274520498bf315fdef1e9a
Non-English scientific articles. How should this query be reworked to match the left bracket in those labels? (Q33431140)The effect and safety of tirofiban on acute ST segment elevation myocardial infarction patients receiving no early reperfusion therapy continues to import articles from PubMed, many of them end up in Wikidata with bracketed English names, suggesting that they were originally in another language. I'm trying to get a list of those for which there are DOIs (since PubMed does not store the non-English name), but can't seem to match the left bracket that the English labels begin with, such as that for Daniel's botAs
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?paper ?paperLabel ?doi WHERE {
?paper wdt:P31 wd:Q13442814; wdt:P356 ?doi .
?paper rdfs:label ?paperLabel
FILTER(lang(?paperLabel)="en")
FILTER(regex(str(?paperLabel), "^#x5B.*")).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} LIMIT 10
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?doi"):::projected
v2("?paper"):::projected
v1("?paperLabel"):::projected
c4(["wd:Q13442814"]):::iri
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["regex(str(?paperLabel),'^#x5B.*')"]]
f0 --> v1
f1[["?paperLabel = 'en'"]]
f1 --> v1
v2 --"wdt:P31"--> c4
v2 --"wdt:P356"--> v3
v2 --"rdfs:label"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end