Ah, I see. Are the JSON blobs dumped somewhere so I can process them using my own python script or something?
On Tue, Mar 13, 2018 at 11:20 PM, Brian Wolff <[email protected]> wrote: > You can't. The value of properties such as GeoNames are literally not > in the database. > > Very roughly speaking - Wikidata uses mediawiki to store json blobs > describing data. The actual data being stored is not exposed to the > MediaWiki database. The idea instead is that people would export this > data and use a specialized graph database to query it, such as > https://query.wikidata.org/ > > The closest you can get is: > select pl_from 'page id', page_title 'Q id' from pagelinks inner join > page on page_id = pl_from where pl_namespace =120 and pl_title = > 'P1566' limit 20; > > Which will give you a list of pages that have the P1566 property (or > otherwise link to it). > > > -- > Brian > > On Wed, Mar 14, 2018 at 1:45 AM, Huji Lee <[email protected]> wrote: > > 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 > > _______________________________________________ > > MediaWiki-l mailing list > > To unsubscribe, go to: > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > _______________________________________________ > MediaWiki-l mailing list > To unsubscribe, go to: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
