err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(96, 17, 46, 31, 30, 24, 47, 82) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and (( Geometry::STGeomFromText('polygon((-79.29618452966662 44.55112976688396,-79.29017638147326 44.551986071528276,-79.28279494226427 44.5514967561314,-79.27386855066271 44.554187939904025,-79.27095030725451 44.55749058626574,-79.26425551355334 44.56103766431491,-79.26648711145373 44.5653183326029,-79.27798842370959 44.56005918162382,-79.28279494226427 44.55846911215352,-79.2845115560338 44.55956993410734,-79.28760146081896 44.55883605511889,-79.29309462488146 44.55700131715092,-79.29841612756701 44.55137442663936,-79.29618452966662 44.55112976688396))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-79.4171150237745 44.57037109473386,-79.42466812436044 44.56694688275635,-79.43496780697762 44.57880847092435,-79.44698410336434 44.57159397872931,-79.44664078061044 44.56890359999888,-79.47582321469247 44.60337993748279,-79.44595413510262 44.61584506651011,-79.45024566952645 44.62097698913626,-79.44217758480966 44.62427584273555,-79.44097595517098 44.6223209891561,-79.42243652646005 44.642965805756525,-79.42037658993661 44.644187162403696,-79.41917496029794 44.64174442339599,-79.40973358456552 44.63869085499878,-79.40939026181161 44.6297735155146,-79.41316681210458 44.62439801889863,-79.41230850521981 44.61657822608396,-79.41145019833505 44.612423532771444,-79.39685898129403 44.61486750601234,-79.38776092831552 44.613523333457785,-79.37557297055184 44.62183226547601,-79.36716156308114 44.61046828012529,-79.36819153134286 44.60570207602864,-79.37814789120614 44.58223198454977,-79.40698700253427 44.57440651433993,-79.4171150237745 44.57037109473386))', 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/orilia-/-bayshore-village/
Script Name: /index.asp