err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-114.04107979854035 51.096584696396576,-114.03627327998566 51.08278360156097,-114.02631692012238 51.074587252842846,-114.02769021113801 51.067036699664975,-114.01979378779816 51.055169055701676,-113.99919442256379 51.03401553183371,-114.00485924800324 51.012636346818724,-114.02751854976106 50.9880056768916,-114.03850487788606 50.99535303452739,-114.09343651851106 50.99448869988291,-114.11540917476106 51.00183503122072,-114.1181557567923 51.03379962976078,-114.12382058223176 51.02764599782782,-114.15283135493684 51.019007943298426,-114.15300301631379 51.030345059792694,-114.14167336543488 51.03045301900205,-114.14167336543488 51.03757777081401,-114.13600853999543 51.03757777081401,-114.13515023311066 51.04826284471962,-114.15406669420645 51.066139679896395,-114.12745918077871 51.06840501909759,-114.11921943468496 51.06689480528244,-114.11817282225826 51.075938721719254,-114.14941519286373 51.09858232908843,-114.04107979854035 51.096584696396576)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and status='a' and idx_approved=1
Query String: Page=27&PageAction=ViewSubCat&URL=/communities/innercity/
Script Name: /index.asp