err desc:Transaction (Process ID 1427) 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(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 >=-1000) AND (List_Price <=199000) AND Type2 = 'Vacant Land' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&searchDetails=Collingwood&priceRangeFrom=-1000&priceRangeTo=199000&Type2=Vacant%20Land
Script Name: /index.asp