As I said in my last mail, I know how to do it in the Wikidata DB replica. I was just wondering how to do it in the Wikipedia one, if that's possible. (and no, I don't want the federated join either)
On Wed, Mar 30, 2016 at 5:56 PM Thiemo Mättig thiemo.maettig@wikimedia.de wrote:
Hi Magnus,
This lookup is currently done via …
SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'enwiki' AND ips_site_page = 'Berlin'
This table is on the wikidata.org repo database.
This lookup may change any time, so better depend on the API whenever you can.
Best Thiemo _______________________________________________ Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech