err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(19, 125) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-119.47391510009766 49.8610606482361,-119.49640274047852 49.86189059382879,-119.49966430664062 49.861503287659765,-119.49005126953125 49.84899716296947,-119.49623107910156 49.8430749926862,-119.51099395751953 49.814782471725145,-119.50361251831055 49.81001928540649,-119.48490142822266 49.81029622767884,-119.4708251953125 49.80880072058305,-119.46473121643066 49.81029622767884,-119.46593284606934 49.81295479286886,-119.47151184082031 49.81461632195408,-119.47305679321289 49.815502447474685,-119.47537422180176 49.81849300131474,-119.48189735412598 49.821926372249635,-119.48318481445312 49.8229784855393,-119.46902275085449 49.829622883000184,-119.46764945983887 49.833442998288284,-119.46516036987305 49.84473548745441,-119.4667911529541 49.84578710464156,-119.48241233825684 49.841193029666904,-119.47425842285156 49.85392252759648,-119.47391510009766 49.8610606482361)))', 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=4&PageAction=ViewSubCat&URL=/communities/kelowna/lower-mission/
Script Name: /index.asp