Select * from DisplaySummaryView where ((officeidkey in (9259))) and officeidkey not in (0,658) and (StatusID in (1,5,6)) order by Price DESC;Select @@RowCount as NumListings