query-6034e265ba332f2af1046147779caf25
ISSN serial IDs
SELECT ?wikidataid ?olbpid ?article ?start ?end (group_concat(?issn) as ?issns) WHERE {?wikidataid wdt:P236 ?issn . OPTIONAL {?article schema:about ?wikidataid . ?article schema:inLanguage "en" . ?article schema:isPartOf https://en.wikipedia.org/ } OPTIONAL {?wikidataid wdt:P5396 ?olbpid} OPTIONAL {?wikidataid wdt:P571 ?start} OPTIONAL {?wikidataid wdt:P576 ?end} } GROUP BY ?wikidataid ?article ?olbpid ?start ?end ORDER BY ?wikidataid LIMIT 100000
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
#ISSN serial IDs
SELECT ?wikidataid ?olbpid ?article ?start ?end
(group_concat(?issn) as ?issns)
WHERE
{?wikidataid wdt:P236 ?issn .
OPTIONAL {?article schema:about ?wikidataid .
?article schema:inLanguage "en" .
?article schema:isPartOf <https://en.wikipedia.org/> }
OPTIONAL {?wikidataid wdt:P5396 ?olbpid}
OPTIONAL {?wikidataid wdt:P571 ?start}
OPTIONAL {?wikidataid wdt:P576 ?end}
}
GROUP BY ?wikidataid ?article ?olbpid ?start ?end
ORDER BY ?wikidataid
LIMIT 100000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?article"):::projected
v6("?end"):::projected
v2("?issn"):::projected
v7("?issns")
v4("?olbpid"):::projected
v5("?start"):::projected
v1("?wikidataid"):::projected
c6([https://en.wikipedia.org/]):::iri
c4(["en"]):::literal
v1 --"wdt:P236"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."schema:about".-> v1
v3 --"schema:inLanguage"--> c4
v3 --"schema:isPartOf"--> c6
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P5396".-> v4
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P571".-> v5
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P576".-> v6
end
bind1[/"?issn"/]
v2 --o bind1
bind1 --as--o v7