[07:22:38] Hello all, [07:22:39] [07:22:40] The scholarship application phase for the Wikimedia Hackathon closed on January 14th, it is not possible to apply for a WMF scholarship anymore. People who applied for a scholarship will be notified of the result around January 31st. [07:22:42] [07:22:43] To verify if you applied for a scholarship during your registration, you can find this information in the email you received from Pretix that contains a link that allows you to view or edit your data. If this data included the add-on "scholarship application", then you successfully applied and your application will be reviewed in the upcoming days. [07:22:45] [07:22:46] If you have any questions, feel free to reach out to us at hackathon[at]wikimedia.org. [10:47:18] What is the SPARQL query to find the number of male/female editors in Kannada Wikipedia? [10:47:54] What is the SPARQL query to find the number of articles about male/female in Kannada Wikipedia? [11:09:55] You don’t need a SPARQL query. You can use this tool: [11:09:55] [11:09:57] https://denelezh.wmcloud.org/ (re @Pavanaja: What is the SPARQL query to find the number of articles about male/female in Kannada Wikipedia?) [11:27:10] Thanks. But that uses dump of 2020-09-21. Any SPARQL query for latest info? (re @satdeep: You don’t need a SPARQL query. You can use this tool: [11:27:12] [11:27:13] https://denelezh.wmcloud.org/) [12:00:57] Why do you want to use SPARQL? The data isn't stored in Wikidata. (re @Pavanaja: Thanks. But that uses dump of 2020-09-21. Any SPARQL query for latest info?) [12:01:23] @Auregann when will the venue be known? Was having a look where to stay and to find something close [14:39:07] Hopefully at the end of January. The location is chosen but we're waiting until we finalized the paperwork to disclose it publicly. I'll add it to the wikipages as soon as I can. (re @MaartenDammers: @Auregann when will the venue be known? Was having a look where to stay and to find something close) [18:08:00] Is there an API to get the search history of words in MediaWiki? [18:30:59] again I don't know what this means. the history of search terms that have been used in the past? (re @M: Is there an API to get the search history of words in MediaWiki?) [19:19:26] Are numbers about usage of various skins on specific wikis available somewhere? I read that Vector 2022 was currently the most-used skin after Vector on enwiki and wanted to check whether the same was true for dewiki 🤨 [20:06:10] silente08: https://quarry.wmcloud.org/query/70575 [20:13:17] Thanks, better numbers than I expected! (re @wmtelegram_bot: silente08: https://quarry.wmcloud.org/query/70575) [20:13:42] I'm not sure if every user using the default will be recorded in the table [20:15:10] can't you just check if the sum of the parts is close to the whole? (re @wmtelegram_bot: I'm not sure if every user using the default will be recorded in the table) [20:18:27] https://quarry.wmcloud.org/query/70577# [20:21:07] yeah not even close [20:28:18] Well, then even cologneblue and modern are more popular 🙈 But I guess a lot will be inactive accounts … [20:35:32] yeah, unfortunately there's no way to get the total number of accounts that have logged in in the last year [20:36:51] given that modern and cologneblue haven't even been available in preferences for years (unless you were already using them), i guess these numbers aren't very representative of the current active userbase [20:37:02] really? that sounds doable. maybe harder in replicas (re @wmtelegram_bot: yeah, unfortunately there's no way to get the total number of accounts that have logged in in the last year) [20:37:29] yeah, for obvious reasons user_touched is not available in the replicas [20:38:01] upa_touched is a bucketed form of user_touched in the user_properties_anon view [20:40:21] but that view only includes 'language', 'skin', 'variant', and gadget properties [20:41:13] is it possible to find how many people have exclicitly turned off a default gadget? [20:41:49] would it be useful to have a view that's just user_touched no other columns? [21:01:48] Hmm, only 2 in ptwiki https://quarry.wmcloud.org/query/70575 (re @wmtelegram_bot: silente08: https://quarry.wmcloud.org/query/70575) [22:03:39] My mean is simple [22:03:39] [22:03:40] Yes (re @jeremy_b: again I don't know what this means. the history of search terms that have been used in the past?) [22:26:39] Is there api for this ? [23:27:50] No