query-e10ddc132ca33d23e22b1d39126b04da
Query to find duplicates in certain wiki 19:56, 22 May 2017 (UTC)) talk (Steak that on both items there is an interwiki link to a certain language. I would like to have it for the german wikipedia. Is this possible? only with the side condition (so the query should give both items that link onto each other), but (Q17362920)Wikimedia duplicated page I would like to have a query which gives me items which are marked as
Use at
- https://query.wikidata.org/sparql
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?duplicatedItem ?duplicatedArticle ?originalItem ?originalArticle {
?duplicatedItem p:P31 [ ps:P31 wd:Q17362920; pq:P642 ?originalItem ] .
?duplicatedArticle schema:about ?duplicatedItem; schema:isPartOf <https://de.wikipedia.org/> .
?originalArticle schema:about ?originalItem; schema:isPartOf <https://de.wikipedia.org/> .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?duplicatedArticle"):::projected
v2("?duplicatedItem"):::projected
v4("?originalArticle"):::projected
v1("?originalItem"):::projected
a1((" "))
c7([https://de.wikipedia.org/]):::iri
c2(["wd:Q17362920"]):::iri
a1 --"p:statement/P31"--> c2
a1 --"p:qualifier/P642"--> v1
v2 --"p:P31"--> a1
v3 --"schema:about"--> v2
v3 --"schema:isPartOf"--> c7
v4 --"schema:about"--> v1
v4 --"schema:isPartOf"--> c7