query-62b983d54414f022c4f7b75e48ee4fdf

rq turtle/ttl

Numbers of sitelinks for items with Art UK artist ID (P1367) for each language

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
SELECT ?lang (COUNT(DISTINCT ?item) AS ?count) WHERE {

  ?item wdt:P1367 ?yp_id .     # BBC 'Your paintings' artist identifier
  ?article schema:about ?item .
  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") v6("?count") v3("?item"):::projected v5("?lang"):::projected v4("?yp_id") f0[["substring(str(?article),'11^^xsd:integer','15^^xsd:integer') = '.wikipedia.org/'"]] f0 --> v2 v3 --"wdt:P1367"--> v4 v2 --"schema:about"--> v3 v2 --"schema:inLanguage"--> v5 bind2[/"count(?item)"/] v3 --o bind2 bind2 --as--o v6