Find list of Items where "Instance of" i.e. "Category" is missing?

[adarshmadrecha]

This is required to identify "bad data"

[adarshmadrecha]

PREFIX yq: <https://data.jain.wiki/entity/>
PREFIX yp: <https://data.jain.wiki/prop/direct/>

SELECT DISTINCT ?item ?itemName WHERE {
  ?item ?a ?type .

  # Only consider "Items", don't give list of Properties
  FILTER(STRSTARTS(STR(?item), "https://data.jain.wiki/entity/Q"))  # only Q* entities

  # Exclude items which have value set for P1
  FILTER NOT EXISTS { ?item yp:P1 ?category . }
  
  # Exclude deleted items (which have no label)
  FILTER EXISTS { ?item rdfs:label ?anyLabel . }

  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
  }
}

LIMIT 10