query-a8b3b9cf67d5be660ab90118082f3754
title:Pages in ltwiki with Wikidata items without any statements SELECT (wd:Q29934200 as ?item) (substr(GROUP_CONCAT(?l),1,2000000) as ?all) { hint:Query hint:optimizer "None". { SELECT (CONCAT("[[",?n,"]] · ") as ?l) { ?i wikibase:statements 0 . [ ] schema:about ?i ; schema:isPartOf https://lt.wikipedia.org/; schema:name ?n } } }
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
#title:Pages in ltwiki with Wikidata items without any statements
SELECT (wd:Q29934200 as ?item) (substr(GROUP_CONCAT(?l),1,2000000) as ?all)
{
{
SELECT (CONCAT("[[",?n,"]] · ") as ?l)
{
?i wikibase:statements 0 . [ ] schema:about ?i ; schema:isPartOf <https://lt.wikipedia.org/>; schema:name ?n
}
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?all")
v1("?i")
v4("?item")
v3("?l")
v2("?n")
a1((" "))
c2(["0^^xsd:integer"]):::literal
c5([https://lt.wikipedia.org/]):::iri
v1 --"wikibase:statements"--> c2
a1 --"schema:about"--> v1
a1 --"schema:isPartOf"--> c5
a1 --"schema:name"--> v2
bind0[/"concat('#91;#91;',?n,'#93;#93; · ')"/]
v2 --o bind0
bind0 --as--o v3
bind2[/"'wd:Q29934200'"/]
bind2 --as--o v4
bind3[/"substring(,'1^^xsd:integer','2000000^^xsd:integer')"/]
null --o bind3
bind3 --as--o v5