User:DL2204/SPARQL: Difference between revisions

Jump to navigation Jump to search
no edit summary
(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>
54

edits

Navigation menu