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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-tech