[release-20.0-rc] fix: order by subquery planning (#16049)

[release-20.0-rc] fix: order by subquery planning (#16049) #4530