[06:50:51] Good morning. :D [10:17:50] WikidataFacts: how can I get a list of uses of https://www.wikidata.org/wiki/Q833670 before 1968? [10:23:04] sjoerddebruin: http://tinyurl.com/zywohuy ? [10:23:42] WikidataFacts: great! This is probably not the only university in Belgium that got split in two languages. [10:28:33] oh, what is this [ ] notation? [10:29:05] an anonymous variable [10:29:37] an abbreviation for http://tinyurl.com/zldepkc [10:29:48] [ ] takes the place of ?0_ in that query [10:31:21] Okay, the employer section of https://fr.wikipedia.org/wiki/Walter_Van_Gerven is a real fuckup now. :P [10:35:47] This would make a great database report though... [10:36:05] I can try to write a generalized version later [10:36:57] Probably too expensive, as you need to fetch the dates from other items. [10:49:56] Does any of you know how to create new MediaWiki system messages? :D [10:50:01] https://phabricator.wikimedia.org/T138652 [10:51:14] This task has been open for too long, and blocks us the possibility of using Wikidata in a more automated and efortless way [10:51:28] *effortless [10:52:28] It's only needed to create an empty MediaWiki message [10:56:35] is it possible to get all pages that redirect to a given page in mediawiki ? [10:57:00] Yes, via Special:WhatLinksHere [10:57:46] abian: but that will also show all pages that contain a link to the page, not just the redirects, right ? [10:58:09] for instance https://en.wikipedia.org/wiki/GPL redirects to https://en.wikipedia.org/wiki/GNU_General_Public_License and I'd like to know which other page redirects there [10:58:38] https://en.wikipedia.org/w/index.php?title=Special:WhatLinksHere/GNU_General_Public_License&hidetrans=1&hidelinks=1 [10:58:48] oh ! [10:58:51] darn [10:59:10] abian: awesome thanks ! I would have never thought it had options :-) [10:59:16] You can play with the [ Show transclusions | Show links | Hide redirects ] [10:59:24] No problem :) [10:59:40] abian: added a few people who might be able to help [11:01:19] * dachary now looking how to get that information using the API [11:08:11] https://en.wikipedia.org/w/api.php?action=help&modules=query%2Blinkshere looks like it [11:16:38] Many thanks, Lydia_WMDE :D [11:17:17] leszek_wmde: hey, around? [11:18:49] Amir1: yup. my internet connection is up and down but generally I am here [11:19:18] I did not manage to look too much at your patches yesterday. Hopefully will make it this afternoon [11:19:22] leszek_wmde: okay, What should I do for today? (sorry I couldn't join) [11:19:32] https://phabricator.wikimedia.org/T145880 [11:19:44] This is the only thing for me here [11:19:50] other ones are blocked on review [11:20:13] Oh, I should write CI tests for InterwikiLookupAdapter [11:20:42] yes, those tests would be cool [11:21:08] but are you able to do anything for T145880 while those patches are still being reviewed? [11:21:09] T145880: Expose client entity usage via API in repos - https://phabricator.wikimedia.org/T145880 [11:23:49] As a curiosity, do you add redundant statements using P131 (located in the administrative territorial entity) for your countries? [11:24:29] For example, A is in B, B is in C, and you write P131 and P131 [11:25:25] Some users are adding these kinds of redundancies to be able to run their queries, but I think that's not the best idea [11:27:51] We should apply the same criteria to all countries but, right now, P131 has no a defined structure/usage [11:35:10] leszek_wmde: yeah, I will work T145880 while other ones in review [11:35:10] T145880: Expose client entity usage via API in repos - https://phabricator.wikimedia.org/T145880 [11:35:36] Amir1 awesome! Hopefully we'll get those patches moving [11:50:47] awesome [11:51:57] abian: I don't know if there's anything explicitly saying not to, but we generally only add the most specific statements and I usually only see people who aren't very familiar with wikidata adding redundant ones [11:53:39] there's an argument for keeping them if they have a good reference which doesn't say anything more specific, but I've not come across any yet, the ones I see either don't have a reference or just say they were imported from wikipedia [11:55:01] I wish I could move statements between items... [11:55:33] Waiting for that since 2013. :) https://phabricator.wikimedia.org/T55619 [11:56:33] I just came across an item with a bunch of population statements that should be on a different item... all those qualifiers and references ;_; [11:57:14] Oh, that stuff is fun. [12:13:07] addshore: where can I find the discussion for the creation of https://www.wikidata.org/wiki/Property:P3278? [12:13:30] nikki: I think so [12:13:53] But users cannot run some recursive queries, so they decide to add these redundancies :( [12:15:17] I proposed [[Help:P131/Q29|this model]] for Spain, but hasn't been applyied (yet?) [12:15:17] 10[1] 10https://www.wikidata.org/wiki/Help:P131/Q29 [12:15:20] *applied [12:17:07] It would be useful that you proposed models for your countries as you considered [12:20:33] if someone is doing it systematically because their queries are timing out, they should really ask for help optimising it [12:21:32] We're slowly fixing the Netherlands too [12:26:08] https://www.wikidata.org/wiki/User_talk:Abi%C3%A1n [12:26:54] On my talk, Asqueladd explains why he doesn't agree with me (he adds redundancies) [12:27:16] Although I fear that it's in Spanish [12:31:05] https://www.reddit.com/r/talesfromtechsupport/comments/56uxtu/im_saving_the_company_money/:) [12:42:12] some of the queries linked work fine for me, some of them don't and I don't know why :/ [12:43:42] like "?item wdt:P131/wdt:P131* wd:Q5739 ." runs in under a second, "?item wdt:P31/wdt:P279* wd:Q811979 ." runs in 2-5 seconds, but put them together and it's so slow it times out [12:48:24] WikidataFacts: ^ maybe you have some ideas? [12:48:41] the query I'm looking at is the one linked where it says "pero no así" on the talk page [12:50:08] (I can't easily link it, it times out so I don't get a short url link) [13:14:39] nikki et al.: https://etherpad.wikimedia.org/p/Query_not_working [13:14:55] Should we open a task? [14:01:07] WikidataFacts: Got a question from someone else: https://nl.wikipedia.org/wiki/Gebruiker:Bdijkstra/Wikidata/VNVR doesn't work with Listeria, can you build a SPARQL query? [14:01:17] hang on, on the phone, sorry [14:01:36] It's not that important. :) [14:04:19] multichill: Can you build something to fill the holes at the right of this too? https://www.wikidata.org/wiki/User%3ASjoerddebruin%2FDutch_politics%2FEerste_Kamer [14:21:03] sjoerddebruin: I’m back, and I don’t understand the question… the template already uses a SPARQL query, right? [14:21:28] (nikki, not really… you could try subqueries, or disabling optimization (search for “optim” in the examples), but I don’t think either is likely to work) [14:22:23] WikidataFacts: it's about instances of https://www.wikidata.org/wiki/Q6688521, the only thing that is lacking are the various flags used by the instances including from & till date. [14:28:11] ooohhhhh [14:28:15] I feel so stupid now [14:28:31] I interpreted “flags” as “options” and kept searching the table for things that were missing [14:28:41] until I realized that there are actual flags in there, and those columns are empty :D [14:38:51] sjoerddebruin: I think I have the query you need: http://tinyurl.com/hb8deq2 [14:39:06] but I can’t figure out how to combine that with the bot: see https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/VNVR [14:39:43] Well, he was just asking for a SPARQL alternative. Shouldn't it show more flags though? [14:40:11] I’ve set it up to show just one flag [14:40:17] do you want all of them? that would actually be simpler [14:40:28] (one flag per item, that is) [14:41:13] He seems to be asking for that. [14:41:19] I have to go now, thanks in advance! [14:42:07] okay, that would be http://tinyurl.com/hnhw3m9 [14:43:00] hm, but it looks like the list bot summarizes them anyway [17:11:30] I need help with a sparql query, I need to find all entities with a property whose target is a particular entity and only that entity, E.g all items with property sister city(P:190) and only target as London(Q84) [17:12:28] codezee: SELECT ?item WHERE { ?item wdt:P190 wd:Q84. } [17:15:24] WikidataFacts: there's an additional constraint, that the target should be the only target [17:16:59] codezee: http://tinyurl.com/zrd5t9m [17:21:08] WikidataFacts: thanks! works perfectly [17:21:27] you’re welcome! :) [17:25:49] WikidataFacts: thanks, think this is good. [17:26:17] alright, great! [17:45:32] WikidataFacts: yup, he's happy with it. <3 [17:46:37] yay :) [18:14:55] sjoerddebruin: Maybe, does biografisch portaal link to P&P? [18:15:08] Yup! [18:15:21] Well to a different site but the same information and the same ID [18:15:30] Than it's easy [18:15:52] Do we have more I can add while I'm at it? [18:16:35] Well P&P <> BP would be great to have first [18:17:34] We can fetch the gender from BP then, 444 P&P without a gender atm [18:22:45] sjoerddebruin: Can you hack up a sparql query of potential items to check? [18:23:09] Probably Biografisch Portaal + Dutch + Politician [18:25:34] multichill: that't will be https://query.wikidata.org/#SELECT%20%3Fitem%20WHERE%20%7B%20%3Fitem%20wdt%3AP651%20%3Fdummy0%20.%20%3Fitem%20wdt%3AP27%20wd%3AQ29999%20.%20%3Fitem%20wdt%3AP106%20wd%3AQ82955%20%7D [18:26:04] 194 of those lack a P&P [18:26:50] bla [18:27:09] bla bla [18:27:45] Thanks for the earworm. ;) [18:27:55] WikidataFacts: May I stress you again? [18:28:05] sure [18:29:48] sjoerddebruin: So http://www.parlementairdocumentatiecentrum.nl/id/vg09ll6e63sv the id is the same? [18:29:57] Yes! [18:30:13] http://www.parlement.com/id/vg09ll6e63sv [18:30:31] I would like to kill wrong statements, that a company is a PLC [18:30:50] WikidataFacts: Basic query is claim[1454:5225895] and noclaim[17:145] [18:31:28] WikidataFacts: To which I want to add, that P159 is inside the UK [18:32:21] WikidataFacts: so claim[1454:5225895] AND (noclaim[17:145] OR P159 inside UK) [18:33:44] kopiersperre: you want those where it is in the UK or those without such a statement? [18:37:10] WikidataFacts: I want all the companies with legal form = PLC which are not in the UK [18:37:37] okay [18:38:00] sjoerddebruin: https://www.wikidata.org/w/index.php?title=Q13570096&type=revision&diff=386884407&oldid=364074209 ? [18:40:29] kopiersperre: timeouts :( [18:41:16] multichill: looks good to me [18:41:27] okay, this one works and I think it could only have false positives, not negatives: http://tinyurl.com/hw8kzj9 [18:41:57] sjoerddebruin: https://www.wikidata.org/w/index.php?title=Special:Contributions/BotMultichill&offset=20161011184046&target=BotMultichill [18:42:09] <3 [18:42:42] Will ask Pasleim for adding genders if you're finished. [18:42:58] I'm now running on http://tinyurl.com/jgg3psg [18:43:09] I will do another run without the nationality and see what that turns up [18:44:01] sjoerddebruin: Many hits like https://www.wikidata.org/w/index.php?title=Q3347044&type=revision&diff=386886581&oldid=360406869 [18:44:24] Yeah, this is a huge improvement. [18:52:49] Done. About 350 extra links I think sjoerddebruin [18:53:08] Woah, that was fast. [18:55:25] Maybe you should do the same for dbnl [18:55:47] I'm now doing the full run (everything that has P651, but no P&P), that might take some time, but does turn up things like https://www.wikidata.org/wiki/Q21553482 [18:56:13] and https://www.wikidata.org/wiki/Q16189315 [19:07:08] multichill: made a start with https://www.wikidata.org/wiki/Q27210697 btw [19:07:53] Another big job [19:08:16] Wouldn't it be fun to get P&P to 100% sjoerddebruin? [19:08:16] And two open property proposal for Belgian ones. [19:11:08] Well, everything is welcome. :) [19:13:23] How could I change the datatype of https://test.wikidata.org/wiki/Property:P748 ? I'm trying to create a test situation that should use "instance of". I'm not sure that's even possible ? [19:14:13] abian: I found something that makes the query work! see my comment on https://phabricator.wikimedia.org/T116298 (specifically, the last link) [19:14:20] WikidataFacts: ^ you might be interested in that too [19:15:14] it's not pretty though [19:15:36] nikki: oh wow [19:16:06] that’s a very creative solution :D [19:16:43] so you can use gas:service for any wdt:Pxyz* path? with specified length? [19:17:34] it's not really my solution, I just found https://www.mediawiki.org/wiki/Wikidata_query_service/Problematic_queries#Cities_in_Saxony which seemed like a very similar query, followed the link to the ticket and saw what SMalyshev said [19:18:04] so I don't know anything about it other than that it works for the query I was trying to get to work :) [19:18:49] I am pleased to have found *something* though, even if I have no idea why it works :P [19:22:50] even if I spell out the length-limited path, it doesn’t work: http://tinyurl.com/jaeozhl [19:23:02] I’ll have to remember that workaround, thanks for the info [19:26:24] I'm still completely confused by it not being able to put two things together that it can do perfectly well separately [19:37:18] nikki: Whooo! That's... quite weird, but works! :D [19:37:38] :) [19:38:19] I've also asked myself why, if you can run a query A, and can run a query B, sometimes can't run a query A UNION B [19:38:40] I mean, the cause is the 30-seconds limit, but... it could be avoided somehow in these cases [19:42:33] WikidataFacts: That's bad. Another solution would be to set "P17:Q145" for all companies based in major UK cities [19:45:12] Autolist with WDQ is also very broken [19:45:29] sjoerddebruin: I expanded the gender bot to also grab Biografisch portaal [19:46:06] :3 [19:47:56] sjoerddebruin: Want to help to add the gender to the remaining 50? See http://tinyurl.com/guhedr6 [19:51:08] multichill: sure [19:53:45] nikki: Since you're a magician with queries, perhaps you know how to improve the Constraint:Contemporary one so that it can be run with the most used properties... (?) :) [19:54:10] https://www.wikidata.org/w/index.php?title=Template:Constraint:Contemporary&action=edit [19:56:06] multichill: http://www.biografischportaal.nl/persoon/20845196 seems weird [19:59:07] abian: which properties is it failing on? [19:59:19] sjoerddebruin: Fun, full names of nobility [19:59:21] I can try, dunno if I'll have any success though :) [19:59:36] And died the same day? [19:59:44] ;) [19:59:48] :) [20:02:15] nikki: For example, https://www.wikidata.org/wiki/Property_talk:P25 wouldn't work with a higher (and reasonable) limit [20:03:46] that one returns 5 results in 10 seconds for me [20:05:03] Maybe some inconsistencies where fixed (?) [20:05:06] Try this, https://www.wikidata.org/wiki/Property_talk:P102 [20:07:16] *were [20:10:34] Humm, I think someone has been fixing contemporary constraints, they're only a few now [20:10:38] Okay, better :) [20:10:53] sjoerddebruin: Only a few p&P links missing at https://www.wikidata.org/wiki/User:Sjoerddebruin/Dutch_politics/Tweede_Kamer now [20:11:46] I'm wondering how we can link https://petscan.wmflabs.org/?psid=116588 to BP... [20:12:03] yeah, that one doesn't time out either (but only just... 28.7 seconds) [20:18:21] With our dear P131 definitely reaches the timeout limit [20:26:28] sjoerddebruin: Yeah, have the same with rkd artists. I hacked up http://tools.wmflabs.org/multichill/painters/index_connect.php?propa=1749&propb=651 for that a couple of days ago [20:26:50] Far from finished, but it works [20:31:08] I'm working on finishing stuff I've started with. :P [20:37:36] Just have a look at it when you feel like it. I'm sure you'll like it [20:44:08] sjoerddebruin: Gerard z'n Belgen blijven we ook maar tegenkomen he https://www.wikidata.org/w/index.php?title=Q13725157&type=revision&diff=143421069&oldid=109247180 :-( [20:44:25] Shit, that bot for Julian dates fucked up the qualifier suggestions for birth and death date. [20:44:43] All I get is P31 [20:46:23] oh so that's why I got p31 earlier [20:47:08] https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P569#Properties_statistics [20:49:14] sjoerddebruin: Time for bed. Fixed the regex and https://www.wikidata.org/wiki/Special:Contributions/BotMultichill is finding more and more links to add [20:49:50] multichill: great, good night [22:09:07] wikidata, rejoice, maps now link directly to Wikidata items or to query service in the map bottom links - https://www.mediawiki.org/wiki/Help:Extension:Kartographer#GeoShapes_external_data [22:09:11] cc: Lydia_WMDE [22:11:40] <3