[08:55:43] <snitch>	 [[Tech]]; MediaWiki message delivery; /* We need your feedback to improve Lua functions */ new section; https://meta.wikimedia.org/w/index.php?diff=17873869&oldid=17857901&rcid=11612314
[09:09:16] <ShakespeareFan00>	 Hi
[09:09:23] <ShakespeareFan00>	 Anyone here good with SQL?
[09:13:06] <thib>	 hi there, we have an admin at frwiki who lost his smartphone AND his 2FA backup codes, what's the procedure to recover his account?
[09:14:00] <thib>	 he's an ex-OTRS member
[09:14:35] <p858snake>	 thib: a ticket in phab and then support and safety can assist
[09:16:39] <ShakespeareFan02>	 Hi I have a query https://quarry.wmflabs.org/query/25874
[09:16:58] <ShakespeareFan02>	 How do I limit it to ONLY images used in User: space?
[09:19:57] <thib>	 p858snake: thanks
[09:23:18] <thedj>	 ShakespeareFan02: the imagelinks table should have a namespace column i think..
[09:24:11] <ShakespeareFan02>	 Okay
[09:24:21] <ShakespeareFan02>	 I'm using that
[09:24:31] <ShakespeareFan02>	 il.from and il.to
[09:24:41] <ShakespeareFan02>	 It's ensuring there is ONLY one entry
[09:24:57] <ShakespeareFan02>	 I.E an image is only used in one namespace
[09:25:06] <ShakespeareFan02>	 That I'm not sure how to do
[09:25:18] <thedj>	 ah
[09:25:56] <ShakespeareFan02>	 The current query is taking longer than normal to run so I expect it's finding all image used in User namespace (And other namespaces)
[09:26:03] <ShakespeareFan02>	 which is much larger dataset
[09:29:18] <thedj>	 so you want to find all image usages of image in a specific category, that are used outside of user space ?
[09:31:20] <ShakespeareFan02>	 "<kolbert> I just want to know what files in Category:All free media are only linked to from userpages
[09:31:20] <ShakespeareFan02>	 <ShakespeareFan00> Ah
[09:31:21] <ShakespeareFan02>	 <kolbert> and that aren't already member of Category:Userspace files"
[09:31:32] <ShakespeareFan02>	 Was how it was phrased on #wikipedia-en
[09:35:06] <ShakespeareFan02>	 OK - This doesn't work - https://quarry.wmflabs.org/query/25874
[09:35:19] <ShakespeareFan02>	 but worked here - https://quarry.wmflabs.org/query/18905
[09:35:24] <ShakespeareFan02>	 Consistencey appreciated
[09:37:33] <thedj>	 ehm, ok, that goes beyond my immediate skill level i think. it would take too much of my attention away from my work :)
[09:42:53] <ShakespeareFan02>	 SOmething is wrong
[09:42:54] <ShakespeareFan02>	 https://quarry.wmflabs.org/query/18905
[09:42:58] <ShakespeareFan02>	 finds no entries
[13:21:23] <Stryn>	 "channel is logged: http://ur1.ca/qn76y" link is not working
[13:25:28] <MatmaRex>	 hah. classic death of URL shorteners
[13:25:34] <MatmaRex>	 wm-bot logs it, i think
[13:25:35] <wm-bot>	 http://wm-bot.wmflabs.org/dump/%23wikimedia-tech.htm
[13:25:35] <MatmaRex>	 @info
[13:26:07] <MatmaRex>	 Stryn: http://wm-bot.wmflabs.org/logs/%23wikimedia-tech/
[13:26:53] <MatmaRex>	 (i can't change the topic)
[15:49:30] * anarcat waves
[15:49:52] <anarcat>	 paravoid: hello! are you around?
[15:50:19] <paravoid>	 I am
[15:50:24] <paravoid>	 not for long though :)
[16:54:58] <Csisc>	 Hello
[16:55:49] <Csisc>	 See you tomorrow