query-f73a9c7c3c58d6f70a0a6364b165f533

rq turtle/ttl

PropertiesISSN (P236)publisher (P123)official website (P856)published in (P1433)end time (P582)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?journal ?journalLabel WHERE {
  {
    SELECT DISTINCT ?journal WHERE {
      ?journal wdt:P236 ?issn;
        wdt:P123 ?publisher;
        p:P123 ?publisherStatement.
      ?publisherStatement pq:P582 ?endTime.
      ?journal wdt:P856 ?website.
    }
    LIMIT 100
  }
  FILTER(NOT EXISTS { ?item wdt:P1433 ?journal. })
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?endTime") v3("?issn") v1("?item") v2("?journal"):::projected v4("?publisher") v5("?publisherStatement") v7("?website") c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"p:direct/P1433"--> e0v2 e0v1("?item"):::projected e0v2("?journal"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> v2 v1 --"p:direct/P1433"--> v2 v2 --"p:direct/P236"--> v3 v2 --"p:direct/P123"--> v4 v2 --"p:P123"--> v5 v5 --"p:qualifier/P582"--> v6 v2 --"p:direct/P856"--> v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end