Fix thread count estimation for right subquery join

Fix wrong thread count estimation for right subquery join in some cases. Close #24075. #26052 (Vladimir C).