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(((-104.63240500958712 50.48201642189625,-104.68253013165743 50.471529021790495,-104.69351645978243 50.45491921286033,-104.66879722150118 50.435679514149115,-104.61386558087618 50.429993560709086,-104.56992026837618 50.43655421560693,-104.5493209031418 50.45929078079682,-104.56511374982149 50.476336035663365,-104.59669944318087 50.486385485240504,-104.63240500958712 50.48201642189625)))', 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/regina-central/
Script Name: /index.asp