User
Difference between revisions of "VIGNERON/Stats"
< User:VIGNERON
(+ storing queries) |
(→All items by types: +) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
<query> | <query> | ||
| − | SELECT ?type (COUNT(?item) AS ?c ) | + | SELECT ?type ?typeLabel (COUNT(?item) AS ?c ) |
WHERE { | WHERE { | ||
?item prop:P2 ?type . | ?item prop:P2 ?type . | ||
| + | OPTIONAL { ?type rdfs:label ?typeLabel . FILTER (lang(?typeLabel) = "fr"). } | ||
} | } | ||
| − | GROUP BY ?type | + | GROUP BY ?type ?typeLabel |
ORDER BY DESC(?c) | ORDER BY DESC(?c) | ||
| + | </query> | ||
| + | |||
| + | == Items about recording without a file == | ||
| + | |||
| + | <query> | ||
| + | SELECT * WHERE { | ||
| + | ?item prop:P2 entity:Q2 . | ||
| + | MINUS { ?item prop:P3 [] } | ||
| + | OPTIONAL { ?item prop:P4/rdfs:label ?langLabel . FILTER (lang(?langLabel) = "fr"). } | ||
| + | OPTIONAL { ?item prop:P7 ?transc } | ||
| + | } | ||
</query> | </query> | ||