query-65f0f505fec2dac03b2d11307abfa4b2
TODO Users by language დონეზე. ელემენტარულ ცოდნის ქართული ენისამ მომხმარებელს შეუძლია წვლილი შეიტანოს -1ka . English knowledge of advancedThis user has -3en . italiano in professionaleQuesto utente può contribuire con un livello -5it Babel user information Query by Infrastruktur, Wikidata entries without P18 linked to OSM elements that have wikimedia_commons=*
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX osmm: <https://www.openstreetmap.org/meta/>
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
select ?wd ?wdLabel ?countryLabel ?s ?commons ?sitelink WHERE
{
{
select ?wd ?wdLabel ?countryLabel ?s ?commons
where {
SERVICE <https://sophox.org/sparql> {
select ?s ?wd ?commons
where {
?s osmt:wikimedia_commons ?commons ;
osmt:wikidata ?wd .
}
}
FILTER NOT EXISTS { ?wd wdt:P18 [] . }
} } OPTIONAL {?wd wdt:P17 ?country.}
OPTIONAL { ?url schema:about ?wd ;
schema:isPartOf <https://commons.wikimedia.org/> ;
schema:name ?sitelink .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
- https://www.wikidata.org/wiki/User:Ivanbranco
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/11
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?commons"):::projected
v4("?country")
v2("?s"):::projected
v6("?sitelink"):::projected
v5("?url")
v1("?wd"):::projected
a1((" "))
c8([https://commons.wikimedia.org/]):::iri
c11(["bd:serviceParam"]):::iri
c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P18"--> e0a1
e0v1("?wd"):::projected
e0a1((" ")):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> a1
v1 --"wdt:P18"--> a1
subgraph s1["https://sophox.org/sparql"]
style s1 stroke-width:4px;
v2 --https://wiki.openstreetmap.org/wiki/Key:wikimedia_commons--> v3
v2 --https://wiki.openstreetmap.org/wiki/Key:wikidata--> v1
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P17".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v5 -."schema:about".-> v1
v5 --"schema:isPartOf"--> c8
v5 --"schema:name"--> v6
end
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c11 --"wikibase:language"--> c13
end