err#-2147467259<br>err desc:Transaction (Process ID 174) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.<br>sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE 1=1  AND Municipality IN ('Mississauga')  AND Sale_Lease IN ('Sale') AND Type2 IN ('Condo Apt')  AND Status='A'  AND IDX_Approved=1 ORDER BY ID DESC <br>Query String: PageAction=ViewSubCat&URL=/communities/mississauga-condos/<br>Script Name: /index.asp<br>