query-bbcc622ac5a6338f168c9daab5030e89

rq turtle/ttl

Constraints restored ]reply[18:45, 2 February 2016 (UTC)) talk (Multichill as exceptions. I hope everyone agrees and is happy with this solution. the 72 items. We have 41612 items with a RKD link of which 41540 (99,83%) are humans. Only 72 items (0,17%) are not humans. That makes the human constraints quite applicable. I'm not a big fan of false positives so I added Matěj Suchánek that were removed by (P19)place of birth & (P569)date of birth , (P21)sex or gender , (P106)occupation I restored the contraints for ]reply[17:12, 24 October 2017 (UTC)) talk (Multichill used to be empty ;-) User:Multichill/Humans no genderHaven't really done it for a while, ]reply[17:02, 24 October 2017 (UTC)) talk (MarsupiumOk, I didn't that know you are using it actively … -- ]reply[17:01, 24 October 2017 (UTC)) talk (MultichillRestored it. I generally clean it up every once in a while and keep it to zero. Some of the big imports seem to have increased the numbers a bit. I'll do some clean up in the next couple of weeks. ]reply[17:03, 23 October 2017 (UTC)) talk (Marsupium. But feel free revert me! --Wikidata:Database reports/Constraint violations/P650 to }}Q{{ what will hopefully bring the use of removed them as constraints, so I have Wikidata:Database reports/Humans with missing claims/P650 are available at (P569)date of birth and (P21)sex or gender Reports for ]reply[00:42, 11 September 2017 (UTC)) talk (Marsupium and impede the display of labels. What do you think? --Wikidata:Database reports/Constraint violations/P650 adds those? I guess (most of) the remaining ~2.5k simply don't have that data given at RKDartists? And those cases spam BotMultichill now that (P569)date of birth and (P21)sex or gender : (Q21503247)item-requires-statement constraint : What about removing Multichill@ ]reply[13:34, 7 February 2016 (UTC)) talk (MultichillI also imported gender so that list should drop from about 3300 to about 330. , do a regex replace "\r\nQ" -> "]], [[Q", fix the first and last entry and paste it here.fresh listFor future reference: Download a ]reply[19:22, 2 February 2016 (UTC)) talk (Matěj SuchánekNo problem, maybe I was lazy to do this like you did. : (P21)sex or gender : I believe this query gives the missing exceptions for Marsupium@

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
    ?item wdt:P650 ?value .
    FILTER NOT EXISTS { ?item wdt:P21 [] } .
    FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } . 
    FILTER NOT EXISTS {
      SELECT ?item WHERE {
  wd:P650 p:P2302 ?propertyconstraint .
  ?propertyconstraint ps:P2302 wd:Q21503247 .
  ?propertyconstraint pq:P2306 wd:P21 .
  ?propertyconstraint pq:P2303 ?item .
  }
      }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000

Query found at

• https://www.wikidata.org/wiki/Property_talk:P650