query-d08a96520a5f18e6ca9ae233ca3c5033
Declared translations that don't link to a source work SELECT ?translation (SAMPLE(?nativeLabel) AS ?title) ?translationDescription ?sitelinks WHERE { { ?translation wdt:P31 wd:Q7553. } UNION { ?translation wdt:translator []. } MINUS {?translation wdt:P629 []} MINUS {?translation p:P31/pq:P642 []} ?translation rdfs:label ?nativeLabel . OPTIONAL { ?translation wdt:P407 ?language. ?language wdt:P218 ?langcode. FILTER(LANG(?nativeLabel)=?langcode) } ?translation wikibase:sitelinks ?sitelinks. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?translation ?translationDescription ?sitelinks ORDER BY DESC(?sitelinks) LIMIT 100
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Declared translations that don't link to a source work
SELECT ?translation (SAMPLE(?nativeLabel) AS ?title) ?translationDescription ?sitelinks
WHERE {
{
?translation wdt:P31 wd:Q7553.
}
UNION
{
?translation wdt:translator [].
}
MINUS {?translation wdt:P629 []}
MINUS {?translation p:P31/pq:P642 []}
?translation rdfs:label ?nativeLabel .
OPTIONAL {
?translation wdt:P407 ?language.
?language wdt:P218 ?langcode.
FILTER(LANG(?nativeLabel)=?langcode)
}
?translation wikibase:sitelinks ?sitelinks.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?translation ?translationDescription ?sitelinks
ORDER BY DESC(?sitelinks)
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?langcode")
v5("?language")
v2("?nativeLabel"):::projected
v1("?sitelinks"):::projected
v6("?title")
v4("?translation"):::projected
a1((" "))
a2((" "))
a4((" "))
a3((" "))
c2(["wd:Q7553"]):::iri
c12(["bd:serviceParam"]):::iri
c14(["#91;AUTO_LANGUAGE#93;,en"]):::literal
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v4 --"p:direct/translator"--> a1
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"p:direct/P31"--> c2
end
union0r <== or ==> union0l
end
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v4 --"p:direct/P629"--> a2
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v4 --"p:P31"--> a3
a3 --"p:qualifier/P642"--> a4
end
v4 --"rdfs:label"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P407".-> v5
v5 --"p:direct/P218"--> v3
end
v4 --"wikibase:sitelinks"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
end
bind3[/"sample(?nativeLabel)"/]
v2 --o bind3
bind3 --as--o v6