User:DL2204/SPARQL

From Wikibase World
Jump to navigation Jump to search

SPARQL queries

A list of Wikibases where DL2204 is involved as author:

#title: Wikibase (co-)authored by David Lindemann (Q354)
PREFIX wwdt: <https://wikibase.world/prop/direct/>
PREFIX wwd: <https://wikibase.world/entity/>

SELECT ?wikibase ?wikibaseLabel ?wikibaseUrl ?inception (sample(?desc) as ?description) (group_concat(distinct str(?authorName); SEPARATOR=" & ") as ?authors)
WHERE {
    ?wikibase wwdt:P3 wwd:Q10 ; wwdt:P17 wwd:Q354; wwdt:P5 ?inception; schema:description ?desc; wwdt:P1 ?wikibaseUrl ; wwdt:P17 ?author.
    ?author rdfs:label ?authorName.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?wikibase ?wikibaseLabel ?wikibaseUrl ?inception ?description ?authors order by ?inception

Try it!