omit logic for checking deleted at
add removed required for where clause
added version