query-28bd7efa67afff8eb3624c007fe7629d

rq turtle/ttl

Numbers of sitelinks for items with a Let's Solve the File Format Problem! ID (P3381) for each language SELECT ?lang (COUNT(DISTINCT ?article) AS ?count) WHERE { ?article schema:about/wdt:P3381 ?wiki . # find articles about things with a Let's Solve the File Format Problem! wiki page FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") . ?article schema:inLanguage ?lang . } GROUP BY ?lang ORDER BY DESC (?count)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
#Numbers of sitelinks for items with a Let's Solve the File Format Problem! ID (P3381) for each language
SELECT ?lang (COUNT(DISTINCT ?article) AS ?count) WHERE {
  ?article schema:about/wdt:P3381 ?wiki .  # find articles about things with a Let's Solve the File Format Problem! wiki page
  FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") .
  ?article schema:inLanguage ?lang .
} GROUP BY ?lang
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?article"):::projected v5("?count") v4("?lang"):::projected v3("?wiki") a1((" ")) f0[["substring(str(?article),'11^^xsd:integer','15^^xsd:integer') = '.wikipedia.org/'"]] f0 --> v2 v2 --"schema:about"--> a1 a1 --"wdt:P3381"--> v3 v2 --"schema:inLanguage"--> v4 bind2[/"count(?article)"/] v2 --o bind2 bind2 --as--o v5