query-af025fda5dcc79c80b0b026c11248336

rq turtle/ttl

Propertiesinstance of (P31)subclass of (P279)main subject (P921)title (P1476)published in (P1433)taxon name (P225)stated in (P248)reference has role (P6184)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?journalLabel ?item ?itemLabel
WHERE {
   {
  SELECT ?journal WHERE {
    ?journal (wdt:P31/(wdt:P279*)) wd:Q5633421;
             wdt:P921 wd:Q39286.
    ?journal wdt:P1476 ?jtitle.
    FILTER (STR(?jtitle) != "Phytotaxa")
  } ORDER BY ?journal
}  ?item wdt:P1433 ?journal .
  ?item wdt:P1476 ?title.
  FILTER (CONTAINS(LCASE(STR(?title)), "nov."))
  FILTER NOT EXISTS { ?taxon p:P225 [ prov:wasDerivedFrom [ pr:P248 ?item; pr:P6184 ?role ] ] }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?item rdfs:label ?itemLabel .
    ?journal rdfs:label ?journalLabel.
    ?item schema:description ?itemDesc .
  }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v9("?itemDesc") v7("?itemLabel"):::projected v5("?journal") v8("?journalLabel"):::projected v6("?jtitle") v2("?role") v3("?taxon") v4("?title") a3((" ")) a2((" ")) a1((" ")) c11(["wd:Q39286"]):::iri c17(["en"]):::literal c9(["wd:Q5633421"]):::iri c15(["bd:serviceParam"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0a1 --"p:reference/P248"--> e0v1 e0a1 --"p:reference/P6184"--> e0v2 e0a2 --"prov:wasDerivedFrom"--> e0a1 e0v3 --"p:P225"--> e0a2 e0v1("?item"):::projected e0v2("?role"):::projected e0v3("?taxon"):::projected e0a2((" ")):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> a1 f0 --> c1 f0 --> v1 f0 --> c2 f0 --> v2 f0 --> a2 f0 --> c3 f0 --> v3 f0 --> c4 a1 --"p:reference/P248"--> v1 a1 --"p:reference/P6184"--> v2 a2 --"prov:wasDerivedFrom"--> a1 v3 --"p:P225"--> a2 f1[["contains(lower-case(str(?title)),'nov.')"]] f1 --> v4 f2[["str(?jtitle) != 'Phytotaxa'"]] f2 --> v6 v5 --"p:direct/P31"--> a3 a3 --"p:direct/P279"--> c9 v5 --"p:direct/P921"--> c11 v5 --"p:direct/P1476"--> v6 v1 --"p:direct/P1433"--> v5 v1 --"p:direct/P1476"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 v1 --"rdfs:label"--> v7 v5 --"rdfs:label"--> v8 v1 --"schema:description"--> v9 end