err#-2147467259
err desc:Transaction (Process ID 324) 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) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.75485229492188 45.40574192564928,-75.76223373413086 45.39863077981453,-75.76180458068848 45.39332696975895,-75.7602596282959 45.394050245897446,-75.75837135314941 45.38977072743874,-75.75390815734863 45.39200093946351,-75.75279235839844 45.39043377263847,-75.75373649597168 45.38832405636792,-75.7521915435791 45.38518947535892,-75.74995994567871 45.38573201143376,-75.74858665466309 45.38356183589307,-75.75081825256348 45.382778140918234,-75.74892997741699 45.37988440382442,-75.74206352233887 45.38145186313508,-75.73356628417969 45.39061460179757,-75.73768615722656 45.390132389421,-75.74257850646973 45.39730487396956,-75.74764251708984 45.399534788688726,-75.74875831604004 45.40164408648163,-75.75322151184082 45.40272883754116,-75.75485229492188 45.40574192564928)))', 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/westboro/
Script Name: /index.asp