User:DL2204/SPARQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "= SPARQL queries = A list of Wikibases where DL2204 is involved as author: <sparql tryit="1"> #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 (sample(?desc) as ?description) (group_concat(distinct str(?authorName); SEPARATOR=" & ") as ?authors) WHERE { ?wikibase wwdt:P3 wwd:Q10 ; wwdt:P17 wwd:Q354; schema:description...") |
No edit summary |
||
| Line 8: | Line 8: | ||
PREFIX wwd: <https://wikibase.world/entity/> | PREFIX wwd: <https://wikibase.world/entity/> | ||
SELECT ?wikibase ?wikibaseLabel ?wikibaseUrl (sample(?desc) as ?description) (group_concat(distinct str(?authorName); SEPARATOR=" & ") as ?authors) | SELECT ?wikibase ?wikibaseLabel ?wikibaseUrl ?inception (sample(?desc) as ?description) (group_concat(distinct str(?authorName); SEPARATOR=" & ") as ?authors) | ||
WHERE { | WHERE { | ||
?wikibase wwdt:P3 wwd:Q10 ; wwdt:P17 wwd:Q354; schema:description ?desc; wwdt:P1 ?wikibaseUrl ; wwdt:P17 ?author. | ?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. | ?author rdfs:label ?authorName. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} group by ?wikibase ?wikibaseLabel ?wikibaseUrl ?description ?authors | } group by ?wikibase ?wikibaseLabel ?wikibaseUrl ?inception ?description ?authors order by ?inception | ||
</sparql> | </sparql> | ||
Latest revision as of 11:53, 12 June 2024
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