err#-2147467259
err desc:Transaction (Process ID 550) 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.5146656036377 44.40607098390135,-79.50925827026367 44.40478330603915,-79.51638221740723 44.38939029561891,-79.52831268310547 44.37874774023201,-79.55195903778076 44.36712152818467,-79.55341815948486 44.36730560229242,-79.5554780960083 44.37181523723721,-79.58852291107178 44.35748750928293,-79.59144115447998 44.356965877064745,-79.61049556732178 44.3526392190968,-79.61255550384521 44.3597580895433,-79.61349964141846 44.36110812257994,-79.6133279800415 44.362151308620156,-79.61199760437012 44.362458124508755,-79.61268424987793 44.36451374951468,-79.62002277374268 44.36288766405336,-79.62015151977539 44.37000528941461,-79.62354183197021 44.37068019175262,-79.62379932403564 44.373164992423085,-79.60667610168457 44.37816495078207,-79.5146656036377 44.40607098390135)))', 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','House','Mobile/Trailer','Modular','Multi-Family','Other','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/hyde-park-public-school/
Script Name: /index.asp