query-26f672b5fb32bd96e16a6192a196c204

rq turtle/ttl

How many common article has a wikipedia with another wikipedia?Plese help me count: how many common articles the Ukrainian Wikipedia has with Russian Wikipedia? how many common articles the Ukrainian Wikipedia has with Polish Wikipedia?«Сommon article a wikipedia has with another wikipedia» means that the article has an interwiki link with the article in another wikipedia. 16:28, 20 September 2019 (UTC)) talk (Perohanych--If one of them was smaller, the below might not time-out. Maybe there is a way to optimize it:

Use at

https://query.wikidata.org/sparql

PREFIX schema: <http://schema.org/>
SELECT (COUNT(*) as ?count) 
{
    ?uk schema:isPartOf <https://uk.wikipedia.org/> .
    ?uk schema:about ?item .
    ?ru schema:isPartOf <https://ru.wikipedia.org/> .
    ?ru schema:about ?item .  
}

Query found at

https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/09

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v2("?item") v3("?ru") v1("?uk") c4([https://ru.wikipedia.org/]):::iri c2([https://uk.wikipedia.org/]):::iri v1 --"schema:isPartOf"--> c2 v1 --"schema:about"--> v2 v3 --"schema:isPartOf"--> c4 v3 --"schema:about"--> v2 bind1[/"count(*)"/] bind1 --as--o v4