err#-2147467259
err desc:Transaction (Process ID 1306) 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.76845243573189 45.36119211803571,-75.79445913434029 45.347018042916105,-75.83548620343208 45.34056313889858,-75.88586881756783 45.320349100701485,-75.87273672223091 45.29704875609895,-75.85488393902779 45.304414148960134,-75.8379752933979 45.28473071567794,-75.79377248883247 45.303629357561704,-75.8050163090229 45.31702968856405,-75.80585516989231 45.31971540976643,-75.8057264238596 45.321646636216606,-75.80594100058079 45.32502612410784,-75.79401053488255 45.32445283232511,-75.75178183615208 45.33374547859814,-75.76087988913059 45.34912930037308,-75.76845243573189 45.36119211803571)))', 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: Page=3&PageAction=ViewSubCat&URL=/communities/college-ward/
Script Name: /index.asp