err#-2147467259
err desc:Transaction (Process ID 53) 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(17,82,47,110,14,43) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-79.67984890950902 44.349865080266504,-79.68053555501683 44.34857616577515,-79.68628621114476 44.34777825212405,-79.68680119527562 44.3526269444471,-79.687230348718 44.354038513656505,-79.68920445455296 44.35545004886603,-79.69074940694554 44.3567388121897,-79.70070576680882 44.36520712318509,-79.70731472973966 44.37122010821082,-79.69778752331877 44.375207971962645,-79.69667172436857 44.37434907040772,-79.69538426404142 44.37471717261668,-79.69641423230314 44.37612820964923,-79.69564175610685 44.376618997168926,-79.6940109730258 44.3748398728388,-79.69238018994474 44.37514662226934,-79.69392514233732 44.377048432874346,-79.69349598889494 44.37760055986792,-79.69152188305998 44.37839806744535,-79.69074940686369 44.38140395991373,-79.6884319782339 44.381587989133145,-79.66931211954943 44.373158857336236,-79.6734319925963 44.37033660617323,-79.68055593973986 44.36938559960382,-79.67986929423205 44.3663790901721,-79.6796976328551 44.36515189911714,-79.67862474924914 44.364753056488766,-79.67984890950902 44.349865080266504)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Type2 IN ('Agriculture','Att/Row/Twnhouse','Condo Apt','Duplex','Fourplex','Garden Home','Hospitality','House','Mobile/Trailer','Modular','Multi-Family','Other','Recreational','Single Family','Special Purpose','Triplex','Two Apartment House','Unknown','Vacant Land') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/smart-search/school-zones/allandalle-heights/
Script Name: /index.asp