Re: [Toolserver-l] Is the wikidata replication out of sync?

2014-03-02 Thread Kolossos
Thanks for your answer. I was connect with sql-s3 by using for connecting to db by: mysql -h wikidatawiki-p.db.toolserver.org On sql-s3 I still miss the entry but on sql-s5 it works. Greetings Tim Am 02.03.2014 14:32, schrieb Merlissimo: > Am 02.03.2014 12:58, schrieb Kolossos: >> Is there any

Re: [Toolserver-l] Is the wikidata replication out of sync?

2014-03-02 Thread Merlissimo
Am 02.03.2014 12:58, schrieb Kolossos: > Is there any idea for a workaround to get from 300.000 Wikipedia > articles the Wikidata Q-Number? > > [1] SELECT `ips_item_id` FROM `wb_items_per_site` > WHERE `ips_site_id` = 'dewiki' > AND `ips_site_page` = 'Bundesanstalt_für_Verwaltungsdienstleistunge

[Toolserver-l] Is the wikidata replication out of sync?

2014-03-02 Thread Kolossos
Hello, if I test the query [1] on Toolserver I got an empty result, on labs I got an correct answer. With other articles this query works fine. Could somebody check this? This query is part of project WIWOSM, so unfortunately I can not move to Labs in the moment, because this project need a Postgr