err desc:Transaction (Process ID 412) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT TOP 50 ID, List_Price, Photos_Updated_Timestamp, Address, Municipality, MLS_Number, List_Broker, Listing_Agent, Bedrooms, Bedrooms_Plus, Washrooms, ImagePathOfFirstImage FROM PropertiesFreeholdAndCondos Where Status = 'A' AND Address != '' AND List_Broker = 'KELLER WILLIAMS EXPERIENCE REALTY, BROKERAGE' AND (Agent_ID != '1452909' OR Agent_ID IS NULL) AND Sale_Lease = 'Sale' AND IDX_Approved = 1 AND Board IN(17, 82) ORDER BY ID DESC
Query String:
Script Name: /index.asp