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(((-114.0216064453125 51.00511401428095,-114.02881622314453 50.99906460644636,-114.02915954589844 50.99603960672507,-114.02297973632812 50.98717954450119,-114.03739929199219 50.97421055086891,-114.0274429321289 50.971832509075206,-114.02023315429688 50.94891059293974,-114.0109634399414 50.93982519613568,-113.98933410644531 50.93225267576595,-113.99002075195312 50.91688748924508,-114.0106201171875 50.90736285477543,-114.00924682617188 50.89393847048056,-113.97148132324219 50.853208608722035,-113.96049499511719 50.872928039711454,-113.95774841308594 50.87357798883879,-113.9556884765625 50.87856063103759,-113.9388656616211 50.88180989329178,-113.94092559814453 50.8865750680795,-113.90625 50.88570870891517,-113.91036987304688 50.91255835156951,-113.92135620117188 50.93549819263062,-113.92066955566406 50.972697265634395,-113.92581939697266 50.97399437028297,-113.9560317993164 50.96188665132062,-113.95877838134766 50.963184057881776,-113.95809173583984 50.97972281580131,-113.99894714355469 50.97939858303638,-113.9992904663086 50.9865311808553,-114.01165008544922 51.00338569253192,-114.0216064453125 51.00511401428095)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and status='a' and idx_approved=1
Query String: Page=9&PageAction=ViewSubCat&URL=/communities/calgary-south/
Script Name: /index.asp