err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(24,114,47) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-80.13077340605469 44.77444243453358,-80.12665353300781 44.811475941464735,-80.07721505644531 44.82511387456252,-80.07584176542969 44.80563012554538,-80.04562936308594 44.81050167995517,-80.04562936308594 44.82413984345788,-80.02914987089844 44.84361733861764,-80.02914987089844 44.85530067585916,-80.00168405058594 44.85822113987334,-79.95361886503906 44.865034979889316,-79.90967355253906 44.86211486148542,-79.90280709746094 44.833879413915334,-79.92477975371094 44.81537282292825,-79.90967355253906 44.808553107563625,-79.88083444121094 44.814398627248615,-79.84924874785156 44.80075815969932,-79.86435494902344 44.77151772448986,-79.76410470488281 44.78808912298153,-79.73114572050781 44.78711446649379,-79.72153268339844 44.797834782702516,-79.68994699003906 44.776392158942826,-79.69956002714844 44.74909002676292,-79.65973458769531 44.70713663047326,-79.99619088652344 44.55761384032797,-79.94812570097656 44.5125839561903,-80.06348214628906 44.482218090294445,-80.14313302519531 44.47143930446892,-80.23514352324219 44.47829876218369,-80.23377023222656 44.49397449493067,-80.26123605253906 44.48025845914931,-80.26535592558594 44.52531332274444,-80.19257150175781 44.50964601513095,-80.12253365996094 44.479278618894064,-80.01541696074219 44.5390187612381,-80.00580392363281 44.582071998921236,-80.02365670683594 44.605542154999604,-79.99344430449219 44.66417607517668,-80.05112252714844 44.71689594967742,-80.13077340605469 44.74031160129103,-80.13077340605469 44.77444243453358)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and type2 in ('vacant land') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/vacant-lot/
Script Name: /index.asp