query-05c35ea8327dfe1391425c0da0dc3980

rq turtle/ttl

Items of admin.-terr. units with bad RO labels SELECT ?item ?label ?page_title ?article WHERE { ?item wdt:P31/wdt:P279* wd:Q56061 . ?item wdt:P36 ?capital . ?item rdfs:label ?label filter (lang(?label) = "ro") . ?article schema:about ?item ; schema:name ?page_title . ?article schema:isPartOf https://ro.wikipedia.org/ . FILTER(strStarts(?page_title, "Raionul")) . FILTER NOT EXISTS { FILTER(CONTAINS(?label, "aionul")) . }

FILTER(strlen(?label) < 10)

} GROUP BY ?item ?label ORDER BY ?label

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#Items of admin.-terr. units with bad RO labels
SELECT ?item ?label ?page_title ?article WHERE {
    ?item wdt:P31/wdt:P279* wd:Q56061 .
    ?item wdt:P36 ?capital .
    ?item rdfs:label ?label filter (lang(?label) = "ro") .
    ?article schema:about ?item ; schema:name ?page_title .
    ?article schema:isPartOf <https://ro.wikipedia.org/> .
    FILTER(strStarts(?page_title, "Raionul")) .
    FILTER NOT EXISTS { FILTER(CONTAINS(?label, "aionul")) . }
#    FILTER(strlen(?label) < 10)
} 
GROUP BY ?item ?label
ORDER BY ?label

Query found at