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) <nemowiki(a)gmail.com>om>:
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(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud