1,482
edits
NeoVoc: Difference between revisions
From eneoli wikibase
→Authors, and in how many of their articles NeoVoc terms appear
| Line 70: | Line 70: | ||
</sparql> | </sparql> | ||
=== Authors, and in how many of their articles NeoVoc terms appear === | === Authors, and in how many of their articles NeoVoc terms appear === | ||
#title: Authors, and in how many of their articles NeoVoc terms appear | #title: Authors, and in how many of their articles NeoVoc terms appear | ||
| Line 82: | Line 81: | ||
select ?author ?lastname ? | select ?author ?lastname ?authorLabel (group_concat(distinct concat(str(?lemma)," (",str(?count),")");SEPARATOR=", ") as ?terms) # (count(?bib_item) as ?in_how_many_articles) (lang(?lemma) as ?lang) | ||
where { | where { | ||
?author endp:P52 ?lastname. | ?author endp:P52 ?lastname. | ||
| Line 94: | Line 92: | ||
} group by ?author ?lemma ?count order by ?count | } group by ?author ?lemma ?count order by ?count | ||
} | } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,pt". } | ||
} group by ?author ?lastname ? | } group by ?author ?lastname ?authorLabel ?terms order by ?lastname | ||
</sparql> | </sparql> | ||
