SELECT in federated table is to slow
Federated tables are going to be inherently slow, especially when doing joins.  It's basically copying down an entire copy of the table for each join.

Federated tables should simply be avoided.