err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(101,76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-75.7943344116211 45.27077911652709,-75.7203483581543 45.30218048336065,-75.69700241088867 45.310390280907505,-75.70455551147461 45.27150395939559,-75.7313346862793 45.275369631685194,-75.78369140625 45.25277588260605,-75.7943344116211 45.27077911652709)))', 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/barrhaven/
Script Name: /index.asp