[10:08:56] <takitam[m]>	 amz3: nice
[10:42:49] <amz3>	 takitam[m]: tx!
[16:56:48] <urossusa>	 Move my data to my both key
[16:57:14] <urossusa>	 Thank you
[17:32:49] <takitam[m]>	 https://test.wikidata.org/wiki/Q107321    pentest? ;)
[18:13:40] <stephanebisson>	 Hi, I'm trying to go from Wikipedia:User_pages on enwiki to Aide:Page_utilisateur on frwiki. They are both connected to Q4592334. There's probably an easy way to do that with Wikibase client. Can someone point me in the right direction? Thanks!
[18:15:05] <stephanebisson>	 In other words, I would like to find the page on my local wiki that is connected to Q4592334.
[18:15:33] <Lucas_WMDE>	 stephanebisson: do you mean something like https://www.wikidata.org/wiki/Special:GoToLinkedPage/frwiki/Q4592334 ?
[18:16:20] <sjoerddebruin>	 gggr just when i'm getting my pizza delivered lucas steals the answer!
[18:16:34] <stephanebisson>	 Lucas_WMDE: That's very interesting. If I could fetch the resulting URL with an API...
[18:16:47] <Lucas_WMDE>	 stephanebisson: wbgetentities can do that for you
[18:16:54] <Lucas_WMDE>	 there, you can even specify the item by its sitelink
[18:16:58] <Lucas_WMDE>	 instead of by ID
[18:17:03] <Lucas_WMDE>	 https://www.wikidata.org/wiki/Special:ApiSandbox#action=wbgetentities&format=json&sites=enwiki&titles=Wikipedia%3AUser_pages&props=sitelinks%7Csitelinks%2Furls&sitefilter=frwiki
[18:17:13] <Lucas_WMDE>	 sjoerddebruin: :P
[18:18:15] <stephanebisson>	 Thanks a lot! That should get me going
[18:18:22] <Lucas_WMDE>	 great :)
[21:32:52] <multichill>	 Amir1: Help me out here. The wb_entity_per_page table is long gone (missed it in a tool). How do I join wb_items_per_site with the page table now?
[21:33:18] <multichill>	 Do I really need to mess with CONCAT("Q", id) etc. or any better option available?
[21:35:19] <Amir1>	 Any table using it should have an extra column. Can you give the query and I rewrite it 
[21:36:08] <Amir1>	 On phone now, will be on laptop in half an hour 
[21:44:45] <multichill>	 Amir1: MariaDB [wikidatawiki_p]> SELECT * FROM wb_items_per_site LIMIT 1; returns 4 columns
[21:44:55] <multichill>	 Let me guess, the view wasn't updated on toolforge?
[21:45:24] <Amir1>	 It's likely 
[21:45:33] <Amir1>	 Let me check 
[21:46:07] <multichill>	 It follows https://www.mediawiki.org/wiki/Wikibase/Schema/wb_items_per_site
[22:12:24] <Amir1>	 multichill: does this column exist? https://github.com/wikimedia/mediawiki-extensions-Wikibase/blob/master/repo/sql/Wikibase.sql#L24
[22:18:57] <multichill>	 yes, but I meant the page on Wikidata because I'm joining against the page_props table
[22:19:52] <multichill>	 It's a query to get all the items that have zero claims, but do have a sitelink to a Wikipedia page with a colon in it
[22:20:17] <multichill>	 So something like "Template:bla" or "Category:something" so the bot can add the missing statement
[22:20:46] <multichill>	 Might just switch it SPARQL if that doesn't time out