[17:34:34] * halfak joins the Research Group call [17:35:43] If anyone wants to chat pre-meeting, I'm there. [17:57:02] * halfak seriously considers using the term "bigly" in a proposal that he is writing. [18:25:29] halfak: I've considered bigly / 'Make X Great Again', and am wondering if entrenching things like that non-ironically into everyday life is good / bad [18:34:22] Who said anything about using the terms non-ironically? [18:34:24] :P [18:34:27] yuvipanda, ^ [18:34:38] :D [18:34:38] ok [20:22:58] Yes You Can, halfak [20:26:10] I'm pretty sure you are permitted to use hyuge in any manner you see fit [20:31:08] WRONG [20:31:12] ;) [22:39:21] halfak ack [22:39:26] you tingled my trump senses [22:39:44] You're the puppet! [22:39:50] halfak you are good with database queries so maybe you can help me with a certain querry I am trying to form [22:39:57] Sure :) [22:39:59] I tried several things and quarry didnt like it [22:40:26] so I want to identify usernames that has at least one upload (could be many more) but has no contribution in the main namespace. [22:40:44] I will reivew each and every file on copyright grounds. [22:41:01] aiming for commons? [22:41:08] no, english wikipedia [22:41:17] this kind of behaviour is normal on commons. [22:41:17] kk [22:41:27] its bizzire on english wikipedia [22:41:33] I found love letters while pursing them [22:41:49] love letter being the users userpage content, uploads from their girlfriend [22:41:58] some 8 years old IIRC [22:43:00] What table contains uploads? [22:43:06] Or should I be looking in the logging table? [22:43:14] one second [22:43:21] let me pull the queries I and someone else tried [22:43:54] https://quarry.wmflabs.org/query/15190 [22:43:58] Unrelated. I just moved this to mainspace :D https://www.mediawiki.org/wiki/Mediawiki-utilities [22:44:40] so image, revision and page are the relevant tables I think [22:46:45] lets continue in #wikimedia-ai [22:48:13] I got a response from a question I asked hours ealier so maybe we can come up with a good solid solution :)