if I remove the entire

where

, all records are shown, although some do apply to that term