err#-2147467259
err desc:Transaction (Process ID 295) 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.40147638320923 43.64070283498836,-79.39971148967743 43.636440103330344,-79.39763009548187 43.6371855208474,-79.39545214176178 43.63840456915101,-79.394411444664 43.63873067979074,-79.38701927661896 43.639972989822816,-79.3886125087738 43.64397926467944,-79.39371943473816 43.642799149455875,-79.39953446388245 43.641215274168495,-79.40147638320923 43.64070283498836)))', 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/city-place/
Script Name: /index.asp