The listing related conditions being on the outer query where filtering out any nfts that didn't have listing information associated to them.
Fix
Move the listing related conditions to the join statement so it filters out what listing is used to determine the sort but doesn't affect the complete list of nfts being returned.
Issue
The listing related conditions being on the outer query where filtering out any nfts that didn't have listing information associated to them.
Fix
Move the listing related conditions to the join statement so it filters out what listing is used to determine the sort but doesn't affect the complete list of nfts being returned.