The ambiguity is in the ROW_NUMBER function: in the order by([id]) the [id] should be written as coalesce(..).

Giorgio