err desc:Transaction (Process ID 1155) was deadlocked on lock | communication buffer 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 lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-79.3866491317749 43.670106664855,-79.37909603118896 43.65228599875708,-79.37291622161865 43.65377643134649,-79.38064098358154 43.67159665510891,-79.3866491317749 43.670106664855)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Type2 IN ('Condo Apt') AND Sale_Lease IN ('Sale') AND List_Price>=300000 AND List_Price<=2000000 AND Status='A' AND IDX_Approved=1 ORDER BY List_Price ASC
Query String: PageAction=ViewSubCat&URL=/downtown-toronto-condo-lists/east-of-yonge/
Script Name: /index.asp