from the name of the table, I guess there is a considerable amount of records in it.
It looks like it, unneccessarily, computes the dateadd function for each row.
you might store the value in a variable
declare @yesterday smalldatetime = dateadd("d", -1, getdate())
and use it like
and date > @yesterday