err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(101,76,125) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-75.64910888671875 45.45627757127799,-75.61477661132812 45.41869637328528,-75.48294067382812 45.20913363773732,-75.1849365234375 45.30676845797068,-75.38681030273438 45.53232688809726,-75.48431396484375 45.519819502877084,-75.64910888671875 45.45627757127799)))', 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/ottawa-east/
Script Name: /index.asp