added deleted column to nearly all queries