query-c6ad12ef6691cdf0aeb82490c8e5f5ad
title:màj manuelle
SELECT ?id ?item ?wiki ?sls ?line
WHERE
{
?item wikibase:statements 0 .
?wiki schema:about ?item ; schema:isPartOf https://fr.wikipedia.org/ ; schema:name ?n ; schema:inLanguage ?lang .
hint:Prior hint:rangeSafe true .
BIND(strafter(str(?item),"Q") as ?id)
BIND(CONCAT("* [[Q",?id,"]] - [[:",?lang,":",?n,"]]") as ?line)
?item wikibase:sitelinks ?sls .
}
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX schema: <http://schema.org/>
#title:màj manuelle
SELECT ?id ?item ?wiki ?sls ?line
WHERE
{
?item wikibase:statements 0 .
?wiki schema:about ?item ; schema:isPartOf <https://fr.wikipedia.org/> ; schema:name ?n ; schema:inLanguage ?lang .
BIND(strafter(str(?item),"Q") as ?id)
BIND(CONCAT("* [[Q",?id,"]] - [[:",?lang,":",?n,"]]") as ?line)
?item wikibase:sitelinks ?sls .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?id"):::projected
v1("?item"):::projected
v4("?lang")
v6("?line"):::projected
v3("?n")
v7("?sls"):::projected
v2("?wiki"):::projected
c2(["0^^xsd:integer"]):::literal
c5([https://fr.wikipedia.org/]):::iri
v1 --"wikibase:statements"--> c2
v2 --"schema:about"--> v1
v2 --"schema:isPartOf"--> c5
v2 --"schema:name"--> v3
v2 --"schema:inLanguage"--> v4
bind0[/"substring-after(str(?item),'Q')"/]
v1 --o bind0
bind0 --as--o v5
bind1[/"concat('* #91;#91;Q',?id,'#93;#93; - #91;#91;:',?lang,':',?n,'#93;#93;')"/]
v5 --o bind1
v4 --o bind1
v3 --o bind1
bind1 --as--o v6
v1 --"wikibase:sitelinks"--> v7