err#-2147467259
err desc:Transaction (Process ID 476) 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.62431859996286 44.46353384961308,-79.62809515025583 44.46120603517207,-79.66877889659372 44.443683190516616,-79.6952147486445 44.47272168451891,-79.69469976451364 44.47517152957296,-79.69830465342966 44.47774375619368,-79.74053335085046 44.522311004040404,-79.74413823976647 44.52304534356811,-79.74860143556725 44.52010792991988,-79.74791479005944 44.51876156583596,-79.75048971071374 44.51802717231359,-79.76353597536217 44.53418169161266,-79.7594161023153 44.53540533627791,-79.75048971071374 44.53956553581407,-79.7535796154989 44.550454058810736,-79.74619817628991 44.5519220189588,-79.74379491701256 44.55754885652526,-79.73212194337975 44.56708877242988,-79.71735906496178 44.57161357012259,-79.70671605959069 44.57882805988719,-79.69057989277644 44.58885349142032,-79.67650365986628 44.59985502367077,-79.666547300003 44.60975462195316,-79.66380071797175 44.60877695893296,-79.67238378681941 44.596677017173256,-79.60577916994225 44.51606874433461,-79.59685277834069 44.519985534470585,-79.58775472536217 44.51802717231359,-79.58758306398522 44.51582393620912,-79.59822606935631 44.51619114801167,-79.63461828127038 44.502602768295034,-79.64594793214928 44.49574616819089,-79.6217436779989 44.46671912960914,-79.62431859996286 44.46353384961308)))', 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','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/w.r.-best-memorial-public-school/
Script Name: /index.asp