err#-2147467259
err desc:Transaction (Process ID 649) 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('POLYGON((-79.6806535689393 44.38855613787692,-79.6147356001893 44.38757475884581,-79.49113940878306 44.42681708579111,-79.47946643515024 44.44887932515101,-79.49663257284556 44.44495775808818,-79.55178308067843 44.502823146011224,-79.55658959923312 44.503802590788034,-79.56929254112765 44.49866032212986,-79.58508538780734 44.49351759992225,-79.60328149376437 44.514820210647834,-79.59538507042453 44.51751308984631,-79.665766240214 44.60386395165227,-79.65992975339759 44.62121649172652,-79.66542291746009 44.62121649172652,-79.67949914906058 44.600441719523765,-79.68773889515433 44.59164074920647,-79.69529199574026 44.58675074528655,-79.71795129749808 44.573056545650644,-79.73855066273245 44.5642514284015,-79.74747705433401 44.55055192994573,-79.75365686390433 44.54663719511984,-79.7526268956426 44.53440195179053,-79.74586987547809 44.52794070387077,-79.75805783324176 44.5241468355042,-79.75067639403278 44.518883963856446,-79.7935917408904 44.502725199787804,-79.79462170915212 44.50113356425529,-79.79084515885916 44.49978676178864,-79.79685330705252 44.48790906600247,-79.75067639403278 44.432897286875104,-79.76337933592731 44.425909901354125,-79.76320767455036 44.42431617013095,-79.735226870107 44.43375532926033,-79.74037671141559 44.42284499505201,-79.72733044676716 44.408253838215415,-79.72406888060505 44.41683731257542,-79.70467114239 44.42468395811589,-79.68338513164781 44.42823912267511,-79.66639065532945 44.428361710699924,-79.65128445415758 44.42309019346952,-79.6806535689393 44.38855613787692))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) OR ( Geometry::STGeomFromText('POLYGON((-79.67656588501995 44.39684813823066,-79.67350709281163 44.41525560005078,-79.68689668152365 44.40986027444171,-79.68801248047384 44.41096390426401,-79.69204652283224 44.415623445034974,-79.69307649109396 44.415010368775825,-79.69393479797873 44.41586867373891,-79.70844018433127 44.4093084517212,-79.71719491455588 44.419608284048834,-79.70457780367724 44.42457362645297,-79.69135987765185 44.42665771859386,-79.68380677542882 44.42794491485589,-79.66672646842198 44.42812879772226,-79.65222108206945 44.42304115835801,-79.67556702933507 44.39489790460169,-79.67656588501995 44.39684813823066))', 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','Single Family','Triplex','Two Apartment House','Unknown','Vacant Land') AND Status='A' AND IDX_Approved=1
Query String: Page=7&PageAction=ViewSubCat&URL=/smart-search/school-zones/eastview-secondary-school/
Script Name: /index.asp