[15:49:30] can I have dev feedback [15:49:30] I am trying to run an sql query [15:49:30] its too much for quarry [15:49:31] must I do this with some tool? [15:49:43] I dont know the first thing about creating a tool [15:49:54] can you link me to the documentation? [16:00:39] ToAruShiroiNeko: i'd guess you just need to ssh into your labs account [16:00:56] I would want the output published [16:01:01] and it isnt a one off thing [16:01:24] what I want to do is list usernames (and or files) by people without edits on namespaces aside from file, file talk user and user talk [16:01:38] so basically identifying images that are uploaded by users without any contributions [16:02:09] i'm sure there is documentation for doing this somewhere, but i can't find it :/ [16:03:11] maybe you can just do it for me? [16:03:44] https://quarry.wmflabs.org/query/15186 [16:03:48] this is what Nemo_bis had [16:03:49] if i do, you're going to ask me every time [16:04:25] I need an on wiki posting to process it for the time being [16:04:34] if this is useful, I can worry about writing a tool [16:04:39] would that be ok? [16:06:59] feel free to modify the querry [16:07:23] All I care about are users without main namespace edits but have uploads [16:07:47] preferably in a format such as "username" "number of non-mainspace edits" "number of uploads" [16:08:02] if uploads is 0, I dont care [16:08:13] I will hand review those files. [16:08:52] https://wikitech.wikimedia.org/wiki/Help:MySQL_queries has some examples [16:10:20] Nemo_bis I dont mind if you can help generate this [19:23:04] MatmaRex? [22:21:38] hello [22:21:40] anyone around? [22:21:56] I am trying to have a list of usernames that have uploads and no edits in main namespace