adjust api. remove order by