1,157
edits
Bibliographical Items: Difference between revisions
From eneoli wikibase
→Database Queries
| Line 30: | Line 30: | ||
} group by ?year ?num_of_articles order by ?year | } group by ?year ?num_of_articles order by ?year | ||
</sparql> | </sparql> | ||
== Languages and number of articles == | |||
<sparql tryit="1"> | |||
#title: Languages and # of articles | |||
#defaultView:BarChart | |||
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/> | |||
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/> | |||
select ?languageLabel (count(distinct ?item) as ?num_of_articles) | |||
where { | |||
?item endp:P5 enwb:Q2; endp:P7 ?language. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} group by ?languageLabel ?num_of_articles order by desc(?num_of_articles) | |||
