unify codeshare update query