err desc:Transaction (Process ID 161) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT Count(ID) AS intX FROM PropertiesFreeholdAndCondos Where Status = 'A' AND Board IN(76) AND (Address LIKE '%Ottawa%' OR Municipality LIKE '%Ottawa%' OR Postal_Code LIKE '%Ottawa%' OR MLS_Number LIKE '%Ottawa%' OR Community LIKE '%Ottawa%' ) AND (List_Price >=279900) AND (List_Price <=479900) AND Type2 = 'Att/Row/Twnhouse' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&searchDetails=Ottawa&priceRangeFrom=279900&priceRangeTo=479900&Type2=Att/Row/Twnhouse
Script Name: /index.asp