Thanks so much, though I'm not sure why your solution lost the "bassoon-cat-dog" row. Anyway I changed it to this which gives what I want:

=let( data, query( importrange("1jzBPxUMkRIhvGAqEJO4O57vx0D_rl_ZO7LgM5R9mhAs","A:I"), "select Col5, Col2, Col3, Col4, Col6, Col7, Col8, Col9 where Col1 = 'y' order by Col5, Col6 desc, Col2, Col3", 1 ), arrayformula(regexreplace(to_text(data), "([^)]*)", ""))
)