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 t1.id, mysqltable.longtext from t1 join mysqltable on t1.id=mysqltable.id 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)