err#-2147467259
err desc:Transaction (Process ID 418) 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(76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.75493812561035 45.40483801609086,-75.76163291931152 45.3992334540044,-75.76171875 45.3930858756558,-75.7606029510498 45.39356806283365,-75.75837135314941 45.38989128168995,-75.75373649597168 45.392121488957834,-75.75287818908691 45.39037349612355,-75.7536506652832 45.38838433506846,-75.7518482208252 45.38524975740214,-75.74987411499023 45.38585257429885,-75.74867248535156 45.38380297062277,-75.74987411499023 45.38295899456896,-75.7478141784668 45.379824116060036,-75.7426643371582 45.38139157704206,-75.73382377624512 45.39007211258467,-75.73777198791504 45.39025294290086,-75.74206352233887 45.39712406621648,-75.74575424194336 45.39851024420521,-75.74850082397461 45.401342763046685,-75.75201988220215 45.40242751989156,-75.75493812561035 45.40483801609086)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Sale_Lease IN ('Sale') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/westboro/
Script Name: /index.asp