err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(105, 12) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-115.09399815893556 49.42351596337539,-115.05005284643556 49.44249437186332,-114.99306126928713 49.362959299972694,-115.01194402075197 49.310162783127765,-115.11631413793947 49.251931552581645,-115.35252019262697 49.37905543789242,-115.09399815893556 49.42351596337539)))', 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=2&PageAction=ViewSubCat&URL=/Communities/fernie-rural/
Script Name: /index.asp