err#-2147467259
err desc:Transaction (Process ID 165) 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 ( 6371 * acos( cos( radians(45.306285530760334) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(-75.79055786132812) ) + sin( radians(45.306285530760334) ) * sin( radians( Latitude ) ) ) ) * 1000 < 5668.962220495294 AND Sale_Lease IN ('Sale') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/barrhaven/
Script Name: /index.asp