query-06979ef6d279c66dfc6c3d172f490bd6

rq turtle/ttl

No RO labels for Italians SELECT ?item ?LabelEN ?LabelIT { {
SELECT ?item (COUNT(?item) AS ?cnt) { ?item p:P27 [ ps:P27 wd:Q38 ] . ?item p:P27 ?valueStatement . ?item wdt:P31 wd:Q5 .

?sitelink schema:about ?item .

?item wikibase:sitelinks ?s .

FILTER (?s < 2 )

?item rdfs:label ?LabelEN filter (lang(?LabelEN) = "en" ) .
?item rdfs:label ?LabelIT filter (lang(?LabelIT) = "it" ) .
  FILTER NOT EXISTS { ?item rdfs:label ?LabelRO filter (lang(?LabelRO) = "ro" ) . }
} GROUP BY ?item
           LIMIT 5000

} FILTER(?cnt = 1)

SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en". }

}

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#No RO labels for Italians
SELECT ?item ?LabelEN ?LabelIT
    {
        {   
    SELECT ?item (COUNT(?item) AS ?cnt) {
      ?item p:P27 [ ps:P27 wd:Q38 ] .
      ?item p:P27 ?valueStatement .
      ?item wdt:P31 wd:Q5 .
#     ?sitelink schema:about ?item .
#     ?item wikibase:sitelinks ?s .
#     FILTER (?s < 2 )
    ?item rdfs:label ?LabelEN filter (lang(?LabelEN) = "en" ) .
    ?item rdfs:label ?LabelIT filter (lang(?LabelIT) = "it" ) .
      FILTER NOT EXISTS { ?item rdfs:label ?LabelRO filter (lang(?LabelRO) = "ro" ) . }
    } GROUP BY ?item
               LIMIT 5000
  }
  FILTER(?cnt = 1)
#  SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en". }
}

Query found at

• https://www.wikidata.org/wiki/User:XXN/q