err#-2147467259
err desc:Transaction (Process ID 199) 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.62426090240479 45.37331265913831,-75.61808109283447 45.37536264311112,-75.6134033203125 45.37557366665445,-75.60898303985596 45.374699421134046,-75.6013011932373 45.37620673255969,-75.59649467468262 45.37301118463942,-75.61932563781738 45.36423757289521,-75.62426090240479 45.37331265913831)))', 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/hunt-club/
Script Name: /index.asp