query-9a5be874abec8cdb20eac6c622c7ad16
aree naturali protette italiane su Wikidata con EUAP senza la proprietà OpenStreetMap relation ID (P402) e senza voce su itwiki SELECT DISTINCT ?item ?itemLabel ?itemDescription ?sitelink_it ?sitelink_en ?sitelink_fr WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, it, fr, es, de". } { SELECT DISTINCT ?item WHERE { ?item p:P31 ?statement0. ?statement0 (ps:P31/(wdt:P279*)) wd:Q473972. ?item p:P4800 ?statement1. ?statement1 (ps:P4800) :anyValueP4800. MINUS { ?item p:P402 ?statement2. ?statement2 (ps:P402) :anyValueP402. ?sitelink_it schema:about ?item; schema:isPartOf https://it.wikipedia.org/ . } optional { ?sitelink_fr schema:about ?item; schema:isPartOf https://fr.wikipedia.org/ . } optional { ?sitelink_en schema:about ?item; schema:isPartOf https://en.wikipedia.org/ . } } 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 schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#aree naturali protette italiane su Wikidata con EUAP senza la proprietà OpenStreetMap relation ID (P402) e senza voce su itwiki
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?sitelink_it ?sitelink_en ?sitelink_fr WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, it, fr, es, de". }
{
SELECT DISTINCT ?item WHERE {
?item p:P31 ?statement0.
?statement0 (ps:P31/(wdt:P279*)) wd:Q473972.
?item p:P4800 ?statement1.
?statement1 (ps:P4800) _:anyValueP4800.
MINUS {
?item p:P402 ?statement2.
?statement2 (ps:P402) _:anyValueP402.
?sitelink_it schema:about ?item;
schema:isPartOf <https://it.wikipedia.org/> .
}
optional {
?sitelink_fr schema:about ?item;
schema:isPartOf <https://fr.wikipedia.org/> .
}
optional {
?sitelink_en schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/> .
}
}
ORDER BY DESC (?sitelinks)
}
}
LIMIT 100