|
|
| Line 48: |
Line 48: |
| | } GROUP BY ?lang ?langLabel ?code | | } GROUP BY ?lang ?langLabel ?code |
| | ORDER BY DESC(?nb) | | ORDER BY DESC(?nb) |
| − | </query>
| |
| − |
| |
| − |
| |
| − | <translate>
| |
| − | == Signed languages by number of signers and videos ==
| |
| − | </translate>
| |
| − | <query _pagination="10" lang="<translate>Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" signers="<translate> Number of signers</translate>" videos="<translate> Number of videos</translate>">
| |
| − | SELECT ?lang ?langLabel ?code (COUNT(DISTINCT ?signer) as ?signers) (COUNT(?record) as ?videos)
| |
| − | WHERE {
| |
| − | ?lang prop:P2 entity:Q4 ; # instance of (P2) is language (Q4)
| |
| − | prop:P24 entity:Q88890 . # of type (P24) hand signed (Q88890)
| |
| − | OPTIONAL { ?lang prop:P13 ?code }
| |
| − | ?record prop:P4 ?lang ; # language (P4) is ?lang
| |
| − | prop:P5 ?signer. # instance of (P2) is speaker (Q3)
| |
| − | ?record prop:P2 entity:Q2. # instance of (P2) is record (Q2)
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?lang ?langLabel ?code
| |
| − | ORDER BY DESC(?videos)
| |
| | </query> | | </query> |
| | | | |
