err#-2147467259
err desc:Transaction (Process ID 551) 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(37) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-76.51102066040039 44.216539697816984,-76.51857376098633 44.240525915869256,-76.51016235351562 44.24138677785183,-76.47514343261719 44.22982558010047,-76.48630142211914 44.218139083121855,-76.51102066040039 44.216539697816984)))', 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/city-central/
Script Name: /index.asp