err#-2147467259
err desc:Transaction (Process ID 430) 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(17, 43, 24) AND (Address LIKE '%COLLINGWOOD%' OR Municipality LIKE '%COLLINGWOOD%' OR Postal_Code LIKE '%COLLINGWOOD%' OR MLS_Number LIKE '%COLLINGWOOD%' OR Community LIKE '%COLLINGWOOD%' ) AND (List_Price >=699000) AND (List_Price <=899000) AND Type2 = 'Retail' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&searchDetails=COLLINGWOOD&priceRangeFrom=699000&priceRangeTo=899000&Type2=Retail
Script Name: /index.asp