[14:22:54] <nikki>	 Lydia_WMDE: how come you noticed that page I deleted? :D
[14:23:16] <Lydia_WMDE>	 haha
[14:23:20] <Lydia_WMDE>	 i am going through twitter
[14:23:28] <nikki>	 ah, did they spam it there?
[14:23:29] <Lydia_WMDE>	 and that guy was very proud of his item
[14:23:32] <Lydia_WMDE>	 :D
[14:23:40] <Lydia_WMDE>	 and I clicked it to see if it should be deleted
[14:23:45] <Lydia_WMDE>	 and then i saw you already had
[14:23:55] <nikki>	 oh what a shame :D
[14:23:59] <Lydia_WMDE>	 :D
[14:24:36] <Lydia_WMDE>	 it's truly sad
[18:06:37] <SothoTalKer>	 Hello there
[18:07:23] <SothoTalKer>	 How can I get all items that contain a certain property (and that property value) easily? There's a script for it, but this sadly times out.
[18:10:47] <SothoTalKer>	 my problem, it's just too many items :D
[18:30:09] <Druesenfieber>	 SothoTalKer: a sparql query
[18:31:48] <SothoTalKer>	 hm, i just leave out the damn label, then it should work. I don't need the label anyways :D
[18:32:33] <Druesenfieber>	 You can use labels in sparql queries
[18:33:16] <SothoTalKer>	 labels just slow the query down by like an order or two of magnitude.
[18:35:28] <SothoTalKer>	 let's just hope libreoffice can cope with half a million rows
[18:37:14] <SothoTalKer>	 good thing i did upgrade to 16 GB a while ago
[19:47:47] <nikki>	 SothoTalKer: half a million rows in libreoffice? are you crazy? :D
[19:48:04] <SothoTalKer>	 i am :)
[19:48:28] <nikki>	 hehe
[19:49:51] <CarlFK>	 do it on a raspberry pi! 
[19:51:07] <SothoTalKer>	 it's just to fix wrong values :p
[19:51:23] <nikki>	 what property anyway?
[19:51:47] <nikki>	 viaf?
[19:57:48] <SothoTalKer>	 nikki: P268 - since the constraint cannot verify the alphanumeric check character: https://en.wikisource.org/wiki/User:Inductiveload/BnF_ARK_format
[19:59:35] <nikki>	 hmm... and it can't be done in sparql either?
[20:01:34] <SothoTalKer>	 if you can construct a query that calculates and compares the check digit. i don't know :)
[20:01:45] <nikki>	 now I'm curious :D
[20:01:56] * nikki has a look
[20:06:07] <melderick>	 seems better to use a dump and do the check externally :)
[20:06:23] <melderick>	 (hi!)
[20:06:40] <SothoTalKer>	 hello (!)
[20:07:15] <nikki>	 I don't remember the last time the dumps were smaller than my hard drive
[20:07:25] <nikki>	 although since I now have a bigger hard drive maybe one would fit now :D
[20:09:56] <SothoTalKer>	 i hate working with the viaf data file
[20:10:52] <SothoTalKer>	 138 GB in one single "XML" file, which is not even real XML :)
[20:11:22] <nikki>	 eww
[20:11:56] <SothoTalKer>	 well, it is one entry per line, starting with the VIAF ID followed by all data in XML.
[20:12:12] <SothoTalKer>	 it's about 33 million lines now
[20:26:02] <nikki>	 :D
[20:26:12] <nikki>	 it's awful
[20:26:16] <nikki>	 but I think it works
[20:26:31] <nikki>	 and too long to make a short url from
[20:28:51] <nikki>	 SothoTalKer: here, you can compare it to what you get :D https://tinyurl.com/y75wfrx7
[20:35:18] <SothoTalKer>	 looks nice :)
[20:37:44] <SothoTalKer>	 i better save that for future use =)
[23:10:00] <SothoTalKer>	 i'm actually surprised to only see such a few wrong values :)