err desc:Transaction (Process ID 514) 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, Photos_Updated_Timestamp, List_Price, Address, Municipality, MLS_Number, List_Broker, Listing_Agent, Bedrooms, Bedrooms_Plus, Washrooms, ImagePathOfFirstImage, Sale_Lease FROM PropertiesFreeholdAndCondos WHERE Status = 'A' AND List_Broker = 'ROYAL LEPAGE TEAM REALTY' AND (Agent_ID != '1991877' OR Agent_ID IS NULL) AND Sale_Lease = 'Sale' AND Board IN(125, 101, 76, 82, 125) ORDER BY ID DESC
Query String: PageAction=ViewSubCat&URL=/buyers/my-listings/
Script Name: /index.asp