err#-2147467259
err desc:Transaction (Process ID 1213) 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.70914342999458 45.39688298831242,-75.70073202252388 45.382778140918234,-75.70227697491646 45.37457883448438,-75.69815710186958 45.36963456045664,-75.69541051983833 45.37168467775233,-75.6980712711811 45.37777429382285,-75.6882007420063 45.38205472052984,-75.68390920758247 45.37735226237295,-75.68073347210884 45.37264941311944,-75.66820219159126 45.368307974372875,-75.66322401165962 45.37065962839337,-75.66751554608345 45.37885950308748,-75.67592695355415 45.3879623828148,-75.67781522870064 45.389589895579775,-75.67086294293404 45.399775855279145,-75.6688030064106 45.40290962735953,-75.66948965191841 45.40586244583094,-75.67309454083443 45.410502277311515,-75.67094877362251 45.41333419492406,-75.67352369427681 45.41652746358743,-75.70201948285103 45.40483801609086,-75.69970205426216 45.400920907537866,-75.70914342999458 45.39688298831242)))', 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=2&PageAction=ViewSubCat&URL=/communities/capital/
Script Name: /index.asp