err#-2147467259
err desc:Transaction (Process ID 101) 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(35) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( 6371 * acos( cos( radians(46.497505995962875) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(-80.99790573120117) ) + sin( radians(46.497505995962875) ) * sin( radians( Latitude ) ) ) ) * 1000 < 429.48165590077605 AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/neighbourhoods/the-core/uptown/
Script Name: /index.asp