query-d64c49a08b2db666354e1bafe72ba344
title: Wikidata statements with a retracted paper as reference SELECT DISTINCT ?entity ?entityLabel ?propertyLabel ?valueLabel ?retracted ?retractedLabel WITH { SELECT DISTINCT ?entity ?p ?statement ?retracted WHERE { ?retracted wdt:P31 wd:Q45182324 . ?entity ?p ?statement . ?statement prov:wasDerivedFrom / pr:P248 ?retracted . } } AS %STATEMENTS WHERE { INCLUDE %STATEMENTS ?p ^wikibase:claim ?property . ?statement ?ps ?value . ?ps ^wikibase:statementProperty ?property . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Wikidata statements with a retracted paper as reference
SELECT DISTINCT ?entity ?entityLabel ?propertyLabel ?valueLabel ?retracted ?retractedLabel WHERE {
{
SELECT DISTINCT ?entity ?p ?statement ?retracted WHERE {
?retracted wdt:P31 wd:Q45182324 .
?entity ?p ?statement .
?statement prov:wasDerivedFrom / pr:P248 ?retracted .
}
} ?p ^wikibase:claim ?property .
?statement ?ps ?value .
?ps ^wikibase:statementProperty ?property .
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;
v2("?entity"):::projected
v3("?p")
v5("?property")
v6("?ps")
v1("?retracted"):::projected
v4("?statement")
v7("?value")
a1((" "))
c8(["bd:serviceParam"]):::iri
c2(["wd:Q45182324"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v1 --"wdt:P31"--> c2
v2 -->v3--> v4
v4 --"prov:wasDerivedFrom"--> a1
a1 --"pr:P248"--> v1
v5 --"wikibase:claim"--> v3
v4 -->v6--> v7
v5 --"wikibase:statementProperty"--> v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end