query-9e8821eac953fcc32f06fbabc8f1af59
SPARQLAfter 2007 + except the ones already indexed with Main subject = Predatory publishing
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q13442814;
rdfs:label ?itemLabel.
?item wdt:P577 ?date FILTER (?date > "2007-01-01T00:00:00Z"^^xsd:dateTime) .
MINUS{?item wdt:P921 wd:Q29959533} # not already main subject = pred publ
FILTER(CONTAINS(LCASE(?itemLabel), "predatory"))
FILTER((LANG(?itemLabel)) = "en")
}
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?date")
v3("?item"):::projected
v1("?itemLabel"):::projected
c5(["wd:Q13442814"]):::iri
c9(["wd:Q29959533"]):::iri
f0[["?itemLabel = 'en'"]]
f0 --> v1
f1[["contains(lower-case(?itemLabel),'predatory')"]]
f1 --> v1
f2[["?date > '2007-01-01T00:00:00Z^^xsd:dateTime'"]]
f2 --> v2
v3 --"wdt:P31"--> c5
v3 --"rdfs:label"--> v1
v3 --"wdt:P577"--> v2
subgraph minus3["MINUS"]
style minus3 stroke-width:6px,fill:pink,stroke:red;
v3 --"wdt:P921"--> c9
end