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(((-76.12220764160156 45.52270606936926,-75.94505310058594 45.454350939222046,-75.81184387207031 45.34345888780142,-76.07414245605469 45.18300480207451,-76.39686584472656 45.44568028040937,-76.12220764160156 45.52270606936926)))', 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: PageAction=ViewSubCat&URL=/communities/ottawa-north/
Script Name: /index.asp