err#-2147467259
err desc:Transaction (Process ID 695) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:select id from propertiesfreeholdandcondos with (nolock) 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.69168090820312 45.36758436884978,-75.81321716308594 45.32849592422864,-75.79879760742188 45.27053750018047,-75.67588806152344 45.30580259943578,-75.69168090820312 45.36758436884978)))', 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/nepean/
Script Name: /index.asp