err#-2147467259
err desc:Transaction (Process ID 418) 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(76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.68395614624023 45.412370153806336,-75.69039344787598 45.40965869993609,-75.70206642150879 45.40495853820098,-75.69992065429688 45.40116196821429,-75.70953369140625 45.39688298831242,-75.70172309875488 45.39175983970347,-75.7027530670166 45.394652968941784,-75.70575714111328 45.39628028905252,-75.70515632629395 45.39778702514936,-75.69786071777344 45.39398997323945,-75.69202423095703 45.394050245897446,-75.68824768066406 45.39609947802105,-75.68112373352051 45.398389708338705,-75.68000793457031 45.40158382192322,-75.68155288696289 45.40519958164984,-75.6818962097168 45.40839331024932,-75.68395614624023 45.412370153806336)))', 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/glebe/
Script Name: /index.asp