Sort by WEIGHT() a query joined with a Federated table

Is there a way to return the WEIGHT() in a FEDERATE table? I would like to sort by multiple fields, one of them being the weight… something like this

select, mysqltable.longtext from t1 join mysqltable on where t1.query='SELECT *, WEIGHT() as weight from test_index where match(\'pile box\')' ORDEB Y t1.weight DESC, mysqltable.position

Since I couldn’t figure this out I have to only sort by mysqltable.position which breaks the search (irrelevant results are shown first)