err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(101,76,125) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-75.75210571289062 45.40399435412046,-75.72120666503906 45.382537001817276,-75.70198059082031 45.349732502325544,-75.6961441040039 45.32004734399729,-75.7064437866211 45.2623219323963,-75.83381652832031 45.22848059584359,-75.88462829589844 45.33187500352943,-75.75210571289062 45.40399435412046)))', 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=21&PageAction=ViewSubCat&URL=/communities/ottawa-west/
Script Name: /index.asp