err#-2147467259
err desc:Transaction (Process ID 915) 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.17719841003418 50.23798304220771,-119.17874336242676 50.21316299140583,-119.0602970123291 50.18602187890411,-119.01858329772949 50.196023031449336,-119.0105152130127 50.238971183889724,-119.0218448638916 50.256095718778674,-119.07883644104004 50.270580903875555,-119.17719841003418 50.23798304220771)))', 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/lavington/
Script Name: /index.asp