reversed COALESCE in id lookup