query-42e907b059bbe173308cea2f7b27505f

rq turtle/ttl

Vojtěch Dostálmw:Manual:$wgHashedUploadDirectory

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?username (COUNT(DISTINCT ?file) AS ?count)
WHERE
{

{
  SELECT ?file
  WHERE
  {

{
  SELECT ?item ?image ?filename ?contentUrl
  WHERE
  {
    SERVICE <https://query.wikidata.org/sparql>
    {
      ?item wdt:P31 wd:Q5153359 .
      ?item wdt:P18 ?image .
    }
    BIND (REPLACE(wikibase:decodeUri(SUBSTR(STR(?image), 52)), " ", "_") AS ?filename)
    BIND (MD5(?filename) AS ?MD5)
    BIND (URI(CONCAT("https://upload.wikimedia.org/wikipedia/commons/", SUBSTR(?MD5, 1, 1), "/", SUBSTR(?MD5, 1, 2), "/", ?filename)) As ?contentUrl)
  }
}    ?file schema:contentUrl ?contentUrl .
  }
}  ?file p:P170 / pq:P4174 ?username .
}
GROUP BY ?username

Query found at

• https://www.wikidata.org/wiki/User_talk:Dipsacus_fullonum