query-ab0d89ab2136e24deec508c820508a20
avoir un lien cliquable dans les résultats SELECT DISTINCT ?item (URI(REPLACE(?p1630,'\$1',?id)) AS ?url) WHERE { wd:P4606 p:P1630 [ ps:P1630 ?p1630 ; pq:P407 wd:Q1860 ] . # change Q1860 to Q150 if you prefer the French url ?item wdt:P4606 [] . ?item p:P4606 ?statement . ?statement ps:P4606 ?id . MINUS {?statement pq:P407 [] . } }
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#avoir un lien cliquable dans les résultats
SELECT DISTINCT ?item (URI(REPLACE(?p1630,'\\$1',?id)) AS ?url) WHERE
{
wd:P4606 p:P1630 [ ps:P1630 ?p1630 ; pq:P407 wd:Q1860 ] . # change Q1860 to Q150 if you prefer the French url
?item wdt:P4606 [] .
?item p:P4606 ?statement .
?statement ps:P4606 ?id .
MINUS {?statement pq:P407 [] . }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?id"):::projected
v2("?item"):::projected
v1("?p1630"):::projected
v3("?statement")
v5("?url")
a2((" "))
a3((" "))
a1((" "))
c4(["wd:P4606"]):::iri
c3(["wd:Q1860"]):::iri
a1 --"p:statement/P1630"--> v1
a1 --"p:qualifier/P407"--> c3
c4 --"p:P1630"--> a1
v2 --"p:direct/P4606"--> a2
v2 --"p:P4606"--> v3
v3 --"p:statement/P4606"--> v4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v3 --"p:qualifier/P407"--> a3
end
bind1[/"replace(?p1630,'\$1',?id)"/]
v1 --o bind1
v4 --o bind1
bind1 --as--o v5