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