[02:03:13] RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 117 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [02:04:13] ummm... [02:04:31] what's that under "pronunciation audio"? https://www.wikidata.org/wiki/Q7504 [02:06:18] oh well, better revert it: https://www.wikidata.org/w/index.php?title=Q7504&type=revision&diff=769015928&oldid=768393464&diffmode=source [02:16:34] so mucho vandalism :| https://www.wikidata.org/w/index.php?title=Q29405052&diff=prev&oldid=768845249&diffmode=source [11:17:33] SothoTalKer: what a surprise, the ips are from spanish-speaking countries :( [11:56:49] :'( [12:30:53] PROBLEM - High lag on wdqs1003 is CRITICAL: 1.247e+04 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [14:04:18] nikki: just reverting it would be enough, i suppose? [17:10:02] SothoTalKer: yeah, if the item is getting vandalised by a lot of ips or the ip is repeatedly vandalising stuff you can ask for protection or blocks, but usually they do a couple of edits and vanish again [17:12:43] I haven't found an easy way to look for specific types of edits for new users. There is https://www.wikidata.org/w/index.php?title=Special:AbuseLog&wpSearchFilter=79 [17:18:49] I mostly use https://tools.wmflabs.org/pltools/rech/ [18:21:28] nikki: looks good. thanks ^-^ [21:35:43] <_813_> hi. i just ran a query [21:35:43] <_813_> https://query.wikidata.org/#SELECT%20%3Fs%20%3Fc%20WHERE%20%7B%0A%20%20%3Fs%20wdt%3AP31%20wd%3AQ6256.%0A%20%20%3Fs%20wdt%3AP36%20%3Fc.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fc%20wdt%3AP31%20wd%3AQ5119.%20%7D%0A%20%20%0A%7D [21:35:43] <_813_> to find all capitals that are not instance of 'capital' and it looks like berlin is not marked as capital but have property 'instance of' 'federal capital' which is subclass of capital. [21:35:43] <_813_> Should i update all cities or make exception for berlin (and possibly others)? [22:14:23] RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 1131 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [22:28:19] _813_: there are different types of capitals. I don't think a change is neccessary. [22:29:57] <_813_> SothoTalKer: But now its harder to ask wikidata for all capitals [22:30:40] you would need to make a query that includes the property itself and all the subclasses [22:31:13] you should use wdt:P31/wdt:P279* to include subclasses [22:33:39] that ^ [22:34:19] <_813_> nikki: thanks! [22:34:19] <_813_> SothoTalKer: Ok, i will review this list and update only unmarked cities [22:36:52] for capitals though, we have https://www.wikidata.org/wiki/Property:P1376 as the inverse of P36 [22:37:06] so the p31 statements are redundant and I'm not sure why they're there [22:39:03] probably remnants [22:42:50] <_813_> nikki: in P1376 capital mean 'seat of government' but capital may not be seat of gov. [22:42:50] <_813_> https://en.wikipedia.org/wiki/List_of_countries_with_multiple_capitals [22:45:08] capital doesn't necessarily mean seat of government [22:45:16] as your link shows [22:46:09] Maybe mark P31 deprecated :D [22:47:36] <_813_> nikki: i mean exactly this [22:50:15] if someone wants to say that something is the seat of government, then that's https://www.wikidata.org/wiki/Q1901835 [22:51:27] <_813_> so we have at least 3 nearly equal properties... [22:52:59] <_813_> *2 [22:58:55] i don't think P31 and P1376 are actually the same [22:59:07] or one should removed in favor of the other. [22:59:40] P1376 can be used in conunction with a start and end date [22:59:48] +j [23:01:22] not P31, but i mean Q5119 for P31 [23:06:44] P31 can also have start/end dates... [23:08:21] technically true.