added join type for filter apply