err#-2147467259
err desc:Transaction (Process ID 471) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT IDX_Approved,ID, Address, Municipality, Apt_Unit, MLS_Number, Approximate_Square_Footage, List_Price, Remarks_For_Clients, Bedrooms, Washrooms, List_Broker FROM PropertiesFreeholdAndCondos WHERE 1=1 AND Municipality IN ('Richmond Hill') AND Sale_Lease IN ('Sale') AND Type2 IN ('Comm Element Condo','Condo Apt','Co-Op Apt','Co-Ownership Apt','Leasehold Condo') AND Status='A' AND IDX_Approved=1 ORDER BY List_Price ASC
Query String: PageAction=ViewSubCat&URL=/communities/richmond-hill-condos-for-sale/
Script Name: /index.asp