query-e958df6307b478864ec0b83c20031cc0
SPARQL query shows deleted item:This query returns a deleted item: Smalyshev (WMF)@
Use at
- https://query.wikidata.org/sparql
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?item ?YouTube ?YouTubeEntity WHERE {
?item p:P2397 ?YouTubeEntity .
?YouTubeEntity ps:P2397 ?YouTube .
filter(SUBSTR(str(?YouTube),1,2)!="UC")
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?YouTube"):::projected
v3("?YouTubeEntity"):::projected
v2("?item"):::projected
f0[["substring(str(?YouTube),'1^^xsd:integer','2^^xsd:integer') != 'UC'"]]
f0 --> v1
v2 --"p:P2397"--> v3
v3 --"p:statement/P2397"--> v1