[01:03:51] hey! [01:04:17] Gallomimia: thanks for the invite :) [01:19:19] hello [01:46:12] ummm. welcome? oh right [01:46:15] discord? [10:31:13] Everything under https://www.wikidata.org/wiki/Special:Contributions/185.38.14.210 is vandalism (related to a guy who's vandalizing MusicBrainz with random crap against our team members) [10:31:32] What's the best way to batch-remove? Or should I enter removal requests for all of them separately? :) [10:34:58] reosarevok: gone [10:35:01] Thanks! [14:43:38] Hi, I am trying to look for all the people born on nov 30 with an entry on wd. But I can't seem to figure out how do i compare just a part of the date -- can anyone please help me with that? [14:45:53] it’s possible, but highly inefficient (something like https://w.wiki/4UEA) [14:46:46] also, since the first results of that query happen to be in the early centuries AD, it’s important to mention that times in the query service are always in (proleptic) Gregorian calendar [14:47:38] so the date may not actually have been November 30 in the calendar used at the time [14:58:56] Hi, I have a quick question about SPARQL and hope somebody could help me. [15:02:41] I'd like to exclude objects that have a certain property set at all. I want a list of every Pokemon Game from the Core Series (it's more of an exercise in SPARQL) but exclude objects that describe two games "Pokémon Black 2 and White 2" by omitting results with the property "has part" which should only apply to combined items. Is that the way to do it? And if, can someone please help how to do so in SPARQL? [15:13:48] Lucas_WMDE I tried applying two filters on that, and I am getting "Query timeout limit reached". [15:14:04] yes, that’s why I said it’s highly inefficient [15:14:28] there’s not really any way to make this work I’m afrai [15:14:49] unless your other filters already limit the possible results to such a small set that the birthday filter only needs to run on comparatively few items [15:14:53] I think I would have to run two queries differently and then find intersection set? [15:15:34] I think we can reduce it by changing the order of filters -- those who died april 12 and then of those, who were born nov 30. [15:16:38] And maybe limiting people born not before 1500? [15:17:05] Nevermind, I found otu [15:17:06] out [15:48:15] acagastya: limiting to people born not before 1500 would be relatively cheap, but also won’t reduce the result set that much, I assume [15:49:11] (see https://twitter.com/LucasWerkmeistr/status/1465313646465146886 for how to implement that kind of filter efficiently) [19:19:20] Octavio campos martinez 4428179510