err#-2147467259
err desc:Transaction (Process ID 300) 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(19) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-119.06278610229492 50.249839390601736,-118.76031875610352 50.178437191128495,-118.69165420532227 50.232492993213754,-118.75310897827148 50.29789323854711,-118.96528244018555 50.378751001370055,-119.06278610229492 50.249839390601736)))', 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/lumby/
Script Name: /index.asp