Hi,
I asked this on the Cloud mailing list[1] and got some useful advice but am
still looking for a better answer. Apologies for cross-posting.
Take [2] as an example. We see that in this page, the entity Q2113430 has a
property called GeoNames ID (property P1566) and that property has a value
of 18918. *Where can I find the link *between Q2113430 <--> P1566 <-->
18918 *in the database?* (Not through the API, but via a direct SQL query
on the database)
The idea is to get a list of all these triads to use for some investigation
needed for [3].
Thanks in advance,
Huji
[1]
https://lists.wikimedia.org/pipermail/cloud/2018-March/000244.html
[2]
https://www.wikidata.org/wiki/Q2113430
[3]
https://phabricator.wikimedia.org/T174553