err#-2147467259
err desc:Transaction (Process ID 661) 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.61490535736084 45.463953342267004,-75.61361789703369 45.4629600660623,-75.61091423034668 45.45802352472279,-75.61125755310059 45.457481682887185,-75.61022758483887 45.45703014404687,-75.60838222503662 45.453357493848074,-75.60863971710205 45.45218339948004,-75.60692310333252 45.44956417780963,-75.6053352355957 45.44914268250109,-75.6044340133667 45.44676418565503,-75.60636520385742 45.447426561941285,-75.6084680557251 45.44706526674938,-75.6090259552002 45.445951258673304,-75.61005592346191 45.44601147588853,-75.60494899749756 45.43697817526933,-75.59756755828857 45.44026044177699,-75.59426307678223 45.44041099988081,-75.59173107147217 45.442127333868406,-75.59100151062012 45.443301637566,-75.58692455291748 45.44757710092163,-75.58816909790039 45.449895350485264,-75.58872699737549 45.45118991592353,-75.59057235717773 45.45061790230084,-75.59173107147217 45.45221350476919,-75.59319019317627 45.45200276740782,-75.59387683868408 45.45230382054015,-75.59361934661865 45.453447807787036,-75.59494972229004 45.45597653935815,-75.59237480163574 45.45663880746051,-75.5943489074707 45.46007043577954,-75.59061527252197 45.46103366232948,-75.59267520904541 45.46467571396945,-75.6000566482544 45.464615516681114,-75.6029748916626 45.46401354026239,-75.60340404510498 45.465518469256686,-75.61490535736084 45.463953342267004)))', 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=ViewSubCat&URL=/communities/beacon-hill/
Script Name: /index.asp