Every time I see or think of using NOT IN operator my head makes loud submarine dive alarm sound. Yours should too! Despite large number of articles and books that explain how does NOT IN operator work and describe what can go wrong, I can spot it in the wild again and again. It’s easy to explain why it requires special attention, but imaginary cost and energy savings seem to be greater.