query-9295bf5931e25829051dbb20aa83dd17
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?title ?trwiki ?dewiki (GROUP_CONCAT(DISTINCT ?gsprache; SEPARATOR = ", ") AS ?sprachen) ?LTAid (URI(CONCAT("https://www.librarything.com/author/", ?LTAid)) AS ?LTAurl) WHERE {
{
?item wdt:P7400 ?LTAid;
wdt:P31 ?instanz.
OPTIONAL {
?trwiki schema:about ?item;
schema:isPartOf <https://tr.wikipedia.org/>;
schema:name ?title.
}
OPTIONAL {
?dewiki schema:about ?item;
schema:isPartOf <https://de.wikipedia.org/>;
schema:name ?de_title.
}
OPTIONAL { ?item wdt:P1412 ?sprache. }
FILTER((BOUND(?trwiki)) && (?instanz = wd:Q5))
SERVICE wiki⁶base:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?sprache rdfs:label ?gsprache.
}
}
}
GROUP BY ?item ?title ?trwiki ?dewiki ?LTAid
ORDER BY (?title)