err#-2147467259
err desc:Transaction (Process ID 100) 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(125, 76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.7361177355051 45.38527989839964,-75.7383493334055 45.38540046222897,-75.74834860861301 45.37617658672493,-75.7398084551096 45.36143334816135,-75.71641959249973 45.37162438124547,-75.70599116384983 45.35320078880187,-75.70075549185276 45.351813499715824,-75.70066966116428 45.3489483385338,-75.69624938070774 45.34360970399886,-75.69895304739475 45.33730524434515,-75.69573439657688 45.3341376671489,-75.69976843893528 45.32991395526944,-75.69702185690403 45.32206908322778,-75.68946875631809 45.32345710122923,-75.6733325868845 45.33169398653461,-75.6759075075388 45.338330898032964,-75.66595114767551 45.345087681471924,-75.6629041582346 45.34686723579875,-75.65479315817356 45.35027537858648,-75.66376246511936 45.36146350185472,-75.64981497824192 45.36640849013182,-75.65440692007542 45.374036191378764,-75.66329039633274 45.37050888427369,-75.66878356039524 45.3683381244021,-75.67341841757298 45.37050888427369,-75.68002738058567 45.372347935085,-75.6828597933054 45.37448839432836,-75.68483389914036 45.37885950308748,-75.68882502615452 45.3832905580927,-75.69736517965794 45.381029859133946,-75.69997329264879 45.37888964749199,-75.69978017359972 45.37589020049299,-75.70205468684435 45.37578468941034,-75.70171136409044 45.37718646344157,-75.70192594081163 45.381014787504206,-75.70134658366442 45.39165435823504,-75.70922154933214 45.39695832526793,-75.72675246745348 45.38927343843448,-75.7361177355051 45.38527989839964)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Sale_Lease IN ('Sale') AND Type2 IN ('Att/Row/Twnhouse','Condo Apt','Duplex','Fourplex','Garden Home','House','Modular','Multi-Family','Single Family','Triplex','Two Apartment House') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/river-ward/
Script Name: /index.asp