Стыдно такое спрашивать ...

WHERE [ACTIVITY] = 311 AND [DATE]>@start AND [DATE]<@stop AND C.[Bonus] > 0 AND [PARAM1]=2146624