query-0a180bb952432e36498934fa3d0c3e29
Labels ≠ Sitelink TODO
Use at
- https://query.wikidata.org/sparql
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?wiki_sitelink ?sitelink_label ?label {
?wiki_sitelink schema:about ?item; schema:isPartOf <https://it.wikipedia.org/>; schema:name ?sitelink_label .
?item rdfs:label ?label .
FILTER(LANG(?label) = 'it') .
FILTER(false = (LCASE(SUBSTR(STR(?wiki_sitelink), 31)) = LCASE(ENCODE_FOR_URI(LCASE(STR(?label))))) )
FILTER(false=CONTAINS(?sitelink_label,")"))
} LIMIT 100
Query found at
- https://www.wikidata.org/wiki/User:Jarekt/queries
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/02
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?item"):::projected
v3("?label"):::projected
v1("?sitelink_label"):::projected
v2("?wiki_sitelink"):::projected
c7([https://it.wikipedia.org/]):::iri
f0[["'false^^xsd:boolean' = contains(?sitelink_label,')')"]]
f0 --> v1
f1[["'false^^xsd:boolean' = lower-case(substring(str(?wiki_sitelink),'31^^xsd:integer')) = lower-case(encode-for-uri(lower-case(str(?label))))"]]
f1 --> v2
f1 --> v3
f2[["?label = 'it'"]]
f2 --> v3
v2 --"schema:about"--> v4
v2 --"schema:isPartOf"--> c7
v2 --"schema:name"--> v1
v4 --"rdfs:label"--> v3