SELECT ... FROM `<database>`.`<table>`, like in This should work in the foreseeable future, during which all the replica databases are accessible on the same server.


2018-01-17 14:11 GMT-06:00 Federico Leva (Nemo) <>:
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):

This was reasonably fast, but is there a better way?


Wikimedia Cloud Services mailing list (formerly