SELECT ... FROM `<database>`.`<table>`, like in https://quarry.wmflabs.org/query/24212. This should work in the foreseeable future, during which all the replica databases are accessible on the same server.
Zhuyifei1999 2018-01-17 14:11 GMT-06:00 Federico Leva (Nemo) <nemow...@gmail.com>: > I usually use bash or python scrips to query data from multiple wikis at > once, but I wanted something "simple" in Quarry such as a list of users who > are active in two wikis, and I felt very stupid. > > I ended up using two separate queries, a subquery and a mix of > GROUP_CONCAT, TO_BASE64 and SET SESSION group_concat_max_len (to make a > sort of temporary table in a pseudo-array string): > https://quarry.wmflabs.org/query/23956 > > This was reasonably fast, but is there a better way? > > Federico > > _______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
