query-3a80471d8bdb6b6cb1c5377a7e0d31d1
Different items with same IMDb id Redirects and deleted items as resultMany of the results of the following query are redirects or deleted:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item1 ?item2 ?item1Label ?item2Label ?imdb WHERE {
?item1 wdt:P345 ?imdb FILTER (SUBSTR(?imdb,1,2)='nm') .
?item2 wdt:P345 ?imdb FILTER (STR(?item1)<STR(?item2)) .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
} ORDER BY ?imdb
Query found at
- https://www.wikidata.org/wiki/User:Jobu0101/API
- https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service/queries/Archive/2016
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?imdb"):::projected
v2("?item1"):::projected
v3("?item2"):::projected
c6(["bd:serviceParam"]):::iri
c8(["en"]):::literal
f0[["str(?item1) < str(?item2)"]]
f0 --> v2
f0 --> v3
f1[["substring(?imdb,'1^^xsd:integer','2^^xsd:integer') = 'nm'"]]
f1 --> v1
v2 --"wdt:P345"--> v1
v3 --"wdt:P345"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end