query-dce47cf5a2a46ca605a802a61bfe61d1
discontinued-journalsdata refresh rate: 3600 preferred output format: Table query title: Discontinued journals
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT DISTINCT ?journal (GROUP_CONCAT(DISTINCT ?title; separator=" • ") AS ?combinedTitle) (COUNT(DISTINCT ?paper) AS ?count) WHERE {
?journal wdt:P236 ?issn ;
wdt:P582 ?endtime .
?journal wdt:P1476 ?title .
FILTER (LANG(?title) = "en")
?paper wdt:P1433 ?journal .
?paper wdt:P50 ?author .
?paper wdt:P921 ?topic .
}
GROUP BY ?journal
ORDER BY DESC(?count)
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?author")
v9("?combinedTitle")
v10("?count")
v5("?endtime")
v4("?issn")
v3("?journal"):::projected
v6("?paper"):::projected
v2("?title"):::projected
v8("?topic")
f0[["?title = 'en'"]]
f0 --> v2
v3 --"wdt:P236"--> v4
v3 --"wdt:P582"--> v5
v3 --"wdt:P1476"--> v2
v6 --"wdt:P1433"--> v3
v6 --"wdt:P50"--> v7
v6 --"wdt:P921"--> v8
bind3[/"?title"/]
v2 --o bind3
bind3 --as--o v9
bind4[/"count(?paper)"/]
v6 --o bind4
bind4 --as--o v10