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(((-79.16614632487176 43.75509024497495,-79.2121515738952 43.732767622810776,-79.22519783854364 43.70696222626321,-79.24991707682489 43.698026999505856,-79.26090340494989 43.69157295197295,-79.2945490348327 43.76947152418727,-79.25541024088739 43.777900321978684,-79.26639656901239 43.80714399211612,-79.24373726725457 43.81259461912815,-79.23137764811395 43.78137065812312,-79.18605904459832 43.79723248681175,-79.16614632487176 43.75509024497495)))', 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=34&PageAction=ViewSubCat&URL=/communities/Durham-region/
Script Name: /index.asp