err#-2147467259
err desc:Transaction (Process ID 388) 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(19) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-119.39561605453491 50.17912425955248,-119.39076662063599 50.18080066503706,-119.38656091690063 50.18500516095297,-119.38003778457642 50.195391152486096,-119.3753170967102 50.20275339707287,-119.40166711807251 50.20017124653387,-119.40866231918335 50.18643405569154,-119.40643072128296 50.179618942699236,-119.39561605453491 50.17912425955248)))', 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/predator-ridge/
Script Name: /index.asp