tomayac’s avatartomayac’s Twitter Archive—№ 6,679

  1. …in reply to @undefined
    @RubenVerborgh Thanks, had to try myself ;-) It failed even earlier: Unsupported operator: NOTEXISTS: client.wikidataldf.com/#startFragment=http%3A%2F%2Fdata.wikidataldf.com%2Fwikidata&query=PREFIX%20%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0ASELECT%20%3Fcity%20(MAX(%3Fpopulation)%20AS%20%3Fmax_population)%20%20%3Fcitylabel%20%3Fmayorlabel%20WHERE%20%7B%0A%20%3Fcity%20%3AP31c%2F%3AP279c*%20%3AQ515%20.%20%20%23%20find%20instances%20of%20subclasses%20of%20city%0A%20%3Fcity%20%3AP6s%20%3Fstatement%20.%20%20%20%20%20%20%23%20with%20a%20P6%20(head%20of%20goverment)%20statement%0A%20%3Fstatement%20%3AP6v%20%3Fmayor%20.%20%20%20%20%20%23%20...%20that%20has%20the%20value%20%3Fmayor%0A%20%3Fmayor%20%3AP21c%20%3AQ6581072%20.%20%20%20%20%20%23%20...%20where%20the%20%3Fmayor%20has%20P21%20(sex%20or%20gender)%20female%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fstatement%20%3AP582q%20%3Fx%20%7D%20%20%23%20...%20but%20the%20statement%20has%20no%20P582%20(end%20date)%20qualifier%0A%0A%20%23%20Now%20select%20the%20population%20value%20of%20the%20%3Fcity%0A%20%23%20(the%20number%20is%20reached%20through%20a%20chain%20of%20three%20properties)%0A%20%3Fcity%20%3AP1082s%2F%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E%20%3Fpopulation%20.%0A%0A%20%23%20Optionally%2C%20find%20English%20labels%20for%20city%20and%20mayor%3A%0A%20OPTIONAL%20%7B%0A%20%20%20%3Fcity%20rdfs%3Alabel%20%3Fcitylabel%20.%0A%20%20%20FILTER%20(%20LANG(%3Fcitylabel)%20%3D%20%22en%22%20)%0A%20%7D%0A%20OPTIONAL%20%7B%0A%20%20%20%3Fmayor%20rdfs%3Alabel%20%3Fmayorlabel%20.%0A%20%20%20FILTER%20(%20LANG(%3Fmayorlabel)%20%3D%20%22en%22%20)%0A%20%7D%0A%7D%20GROUP%20BY%20%3Fcity%20%3Fcitylabel%20%3Fmayorlabel%0AORDER%20BY%20DESC(%3Fmax_population)%20LIMIT%20100