query-58cd88bec28825b8268f92690d9b2033
Journal titles from WikispeciesAs this query:
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?label ?issn ?specieslink ?title WHERE {
?item p:P236/ps:P236 ?issn .
OPTIONAL { ?item wdt:P1476 ?title } .
?specieslink schema:about ?item; schema:isPartOf <https://species.wikimedia.org/> .
?item rdfs:label ?label .
FILTER(LANG(?label) = 'en' && SUBSTR(STR(?label), 1, 4) = 'ISSN') .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?issn"):::projected
v2("?item"):::projected
v1("?label"):::projected
v5("?specieslink"):::projected
v4("?title"):::projected
a1((" "))
c10([https://species.wikimedia.org/]):::iri
f0[["?label = 'en'substring(str(?label),'1^^xsd:integer','4^^xsd:integer') = 'ISSN'"]]
f0 --> v1
v2 --"p:P236"--> a1
a1 --"p:statement/P236"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P1476".-> v4
end
v5 --"schema:about"--> v2
v5 --"schema:isPartOf"--> c10
v2 --"rdfs:label"--> v1