fix: Don't collapse into a Nested Loop Join if the cross join maintains order

fix: Don't collapse into a Nested Loop Join if the cross join maintains order #21275