err#-2147467259
err desc:Transaction (Process ID 702) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(101,76,125) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.66146850585938 45.41773242370463,-75.62061309814453 45.42279297541518,-75.58353424072266 45.38326041603453,-75.53512573242188 45.31521901816278,-75.70060729980469 45.27851029653566,-75.69957733154297 45.34249365462379,-75.70026397705078 45.370478735401555,-75.68721771240234 45.38470721669896,-75.67279815673828 45.394833784601595,-75.66146850585938 45.41773242370463)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/ottawa-south/
Script Name: /index.asp