err#-2147467259
err desc:Transaction (Process ID 701) 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,50,76,52,93) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.7316780090332 45.40495853820099,-75.72185039520264 45.40902600863624,-75.718674659729 45.40697724532183,-75.72275161743164 45.405681665462026,-75.72768688201904 45.40128249816683,-75.72923183441162 45.400740111355574,-75.7316780090332 45.40495853820099)))', 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=ViewCategory&URL=/hintonburg/
Script Name: /index.asp