err#-2147467259
err desc:Transaction (Process ID 656) 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.41010035574436 43.63744175598323,-79.41151656210423 43.64064072085134,-79.4187692552805 43.64064072085134,-79.42730940878391 43.63890149894327,-79.42533530294895 43.63380777374239,-79.41319026052952 43.63713116779933,-79.41117323935032 43.63747281471332,-79.41010035574436 43.63744175598323)))', 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 Status='A' AND IDX_Approved=1 ORDER BY List_Price ASC
Query String: PageAction=ViewSubCat&URL=/communities/liberty-village/
Script Name: /index.asp