query-ff5e49096507824a628f04cb211bea9f

rq turtle/ttl

nombre de premis SELECT distinct ?item ?itemLabel ?count { { SELECT ?item (COUNT(?props) AS ?count) { ?item wdt:P166 ?props. } GROUP BY ?item ORDER BY DESC (?count)

LIMIT 40

} ?sitelink schema:about ?item; schema:inLanguage "ca". FILTER( ?count > 25) . OPTIONAL {?item rdfs:label ?itemLabel. FILTER((LANG(?itemLabel)) = "ca")} }

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#nombre de premis
SELECT distinct ?item ?itemLabel ?count
{ {  SELECT  ?item  (COUNT(?props) AS ?count)
    { ?item wdt:P166 ?props. }
   GROUP BY ?item
   ORDER BY DESC (?count)
#            LIMIT 40
}
  ?sitelink schema:about ?item;
    schema:inLanguage "ca".
 FILTER( ?count > 25) .
 OPTIONAL {?item rdfs:label ?itemLabel.     FILTER((LANG(?itemLabel)) = "ca")}
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count"):::projected v3("?item"):::projected v2("?itemLabel"):::projected v4("?props") v5("?sitelink") c2(["ca"]):::literal f0[["?count > '25^^xsd:integer'"]] f0 --> v5 v3 --"wdt:P166"--> v4 bind2[/"count(?props)"/] v4 --o bind2 bind2 --as--o v5 v5 --"schema:about"--> v3 v5 --"schema:inLanguage"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."rdfs:label".-> v2 end