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(((-75.6516267158081 45.44967478313209,-75.64190639033814 45.43248127408164,-75.65349353328247 45.43178860614807,-75.65302146449585 45.42998160630636,-75.67084104154742 45.42859620058173,-75.67139894102252 45.43058394601506,-75.67062646482623 45.4325113898859,-75.67139894102252 45.43443876793293,-75.6727293166939 45.43501094561925,-75.67826266804099 45.43799028441786,-75.67641730823874 45.439917475344195,-75.67367072620749 45.441061713812644,-75.67100997486472 45.4424468135426,-75.66993709125876 45.445066365710105,-75.66903586902976 45.446662125226304,-75.66774840870261 45.4480169799469,-75.66405768909812 45.448920198348404,-75.6587791017568 45.44937180212549,-75.6516267158081 45.44967478313209)))', 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/vanier/
Script Name: /index.asp