err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(17,86,41,20,97,43,44,51,11,46,37,16,13,15,85,76,110,50,100,30,24,47,88,31,14,82) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-78.43711056480032 43.894306856943764,-78.33548702964407 43.916074538676156,-78.24210324058157 43.9338785395263,-78.12949337730032 43.94178971837134,-78.05258908042532 43.9556317485671,-77.95371212730032 43.9556317485671,-77.84934201011282 43.97342390781993,-77.76969113120657 43.99121073815978,-77.69553341636282 43.965516939368776,-77.64334835776907 44.00109000791072,-77.73947872886282 44.229827304098784,-77.70651974448782 44.26524166375744,-77.66532101401907 44.25737364870196,-77.63236202964407 44.24950458069935,-77.72849240073782 44.438071585110684,-77.91800656089407 44.3850984215129,-77.90702023276907 44.353684276286,-77.94547238120657 44.31439290156258,-77.98941769370657 44.29473734227872,-78.06906857261282 44.247537149176594,-78.12949337730032 44.21014344674598,-78.17343868980032 44.162875340373596,-78.26132931480032 44.117541171782605,-78.31900753745657 44.093874743960114,-78.31076779136282 44.137255956969376,-78.51126827964407 44.08401093592191,-78.43711056480032 43.894306856943764)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and status='a' and idx_approved=1
Query String: Page=3&PageAction=ViewSubCat&URL=/communities/northumberland/
Script Name: /index.asp