Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 193 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Heisler’s Hardware is known and trusted by local handymen to provide great quality materials at a reasonable price. Items include automotive, building materials, cleaning supplies, doors and… Read More
Steerfish Steak & Smoke serves hand-cut certified premium beef grilled over hickory wood. The atmosphere brings you back to South Dakota’s rugged history, with bison head mounts, exposed… Read More
Guadalajara’s is a family owned and operated restaurant that is known for having the best Mexican fare in all of scenic Spearfish. The dining area is decorated with traditional Mexican decor… Read More
Have a special occasion coming up? Sip-N-Paint is the premier place to book your private party. With painting parties catered exclusively to you and your event, this Black Hills favorite is ready to… Read More
Family-owned Rustic Rolling Pin is a Spearfish gem and a perfect spot to refuel after a long day of hiking in beautiful Spearfish Canyon. Stop here for a light lunch and then satisfy your sweet tooth… Read More
One of the simplest ways to create a wonderfully romantic date is by simply finding the right road for a drive. The Spearfish Canyon Scenic Byway is that road. Take a cruise down this one-of-a-kind… Read More
The 71,000-square-foot Spearfish Rec Center has a double gymnasium with two basketball courts, volleyball, soccer, tennis, cardio room, strength training room, special event rooms, a cycling room,… Read More
From relaxation to gorgeous backdrops, there’s something for everyone. Eat at the Latchstring Restaurant, rent adventure vehicles, or even say I Do while surrounded by nature.
Read MoreIn the heart of scenic Spearfish, athletes at Crow Peak CrossFit are getting fitter than they thought possible through the dynamic and invigorating group classes. Classes are held from morning to… Read More
Is there any more welcoming place to spend a cozy afternoon than a family coffeehouse and bakeshop? We think not, and Ruby’s Roost Bakery and Coffee is a perfect example. This local Spearfish… Read More
Notice (8): Trying to access array offset on value of type null [APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68]Code Contextif($params['tags'])$options['conditions']['tags'] = $params['tags'];else if($this->params['tags_logical'])$params = array( 'show' => (int) 5, 'title' => 'Organizations around Spearfish', 'images' => false, 'group_type' => 'organization', 'sort' => 'created', 'sort_rule' => '-1', 'keyword' => '', 'radius' => null, 'limit' => (int) 15, 'page' => (int) 1, 'sef' => '', 'tags' => '', 'tags_logical' => '', 'terms' => '', 'show_limit' => (int) 3, 'days' => '', 'max-days' => (int) 365, 'max-miles' => (int) 45, 'message' => '[message to follow]', 'min' => (int) 50, 'prompt' => '', 'height' => '', 'width' => '', 'data_id' => '', 'more' => true, 'type' => '', 'autoshowmore' => false, 'link' => '', 'showdesc' => '', 'rankby' => '', 'empty-message' => '', 'ad_slots' => '', 'see-more-title' => '', 'searchdate' => '', 'searchenddate' => '', 'lat' => (float) 44.481998443604, 'lng' => (float) -103.84400177002, 'latlng' => '44.481998443604,-103.84400177002', 'city' => 'Spearfish', 'state' => 'SD', 'theme' => '', 'page_type' => 'town' ) $options = array( 'page' => (int) 1, 'limit' => (int) 5, 'order' => array( 'created' => (int) -1 ), 'conditions' => array( 'address.town_sef_url' => 'spearfish-sd' ) )PlacesComponent::search() - APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68 PlacesController::local() - APP/Controller/PlacesController.php, line 52 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Spearfish, South Dakota. Population for Spearfish from the last gathering is 8606. You can view Spearfish venues that host many Spearfish SD events every year.
You can find a ton of properties for sale if you search the Spearfish page on Zillow. Currently Spearfish has an average listing price for homes for sale on the market of $291,213. More real estate facts about Spearfish: The number of properties currently for sale in Spearfish is 352. The median homes for sale listing price is $206,983. This is broken down with the number of three bedroom houses in Spearfish consisting of 112 with an average listing price for these house of $259,442. Out of the 66 houses that are four bedroom the average listing price for Spearfish is $313,202. Interest rates for Spearfish are at historic lows as well.
Spearfish South Dakota has a latitude of 44.481998443604 and a longitude of -103.84400177002. View the full profile
On Yahoo, Yelp, SuperPages, AmericanTowns and 25 other directories!
Add your social media links and bio and promote your discounts, menus, events.
Be sure your listing is up on all the key local directories with all your important content (social links and product info).
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.towns.find( {"sef_url":"dearing-ks"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 7 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 9 | |
| 3 | db.towns.find( {"sef_url":"spearfish-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 9 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 11 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 20 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"spearfish-sd","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 36 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 10 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 18 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-103.84400177001953,44.481998443603516],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"SD"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765806029131)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765806029131)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 ) | 0 | 11 | 53 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"spearfish-sd","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 0 | 2 | |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 13 | db.events_cache.find( {"_id":"4457d1641fb8847ca2b1abdd8d468af2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 33 | |
| 15 | db.events_cache.count( {"_id":"4457d1641fb8847ca2b1abdd8d468af2"} ) | 0 | 0 | 7 | |
| 16 | db.events_cache.count( {"_id":"4457d1641fb8847ca2b1abdd8d468af2"} ) | 0 | 0 | 2 | |
| 17 | db.events_cache.insert( {"_id":"4457d1641fb8847ca2b1abdd8d468af2","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.31800000 1765806029)","created":"MongoDate(0.31800000 1765806029)"} , true) | 0 | 0 | 3 | |
| 18 | db.events_cache.find( {"_id":"ffae6cf223a66f78438fcf4efdcd0c1f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 7 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766728799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 33 | |
| 20 | db.events_cache.count( {"_id":"ffae6cf223a66f78438fcf4efdcd0c1f"} ) | 0 | 0 | 1 | |
| 21 | db.events_cache.count( {"_id":"ffae6cf223a66f78438fcf4efdcd0c1f"} ) | 0 | 0 | 1 | |
| 22 | db.events_cache.insert( {"_id":"ffae6cf223a66f78438fcf4efdcd0c1f","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.43300000 1765806029)","created":"MongoDate(0.43300000 1765806029)"} , true) | 0 | 0 | 1 | |
| 23 | db.events_cache.find( {"_id":"4e345f30b1e225c6d9a5507ab8709835"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1768456799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 76 | |
| 25 | db.events_cache.count( {"_id":"4e345f30b1e225c6d9a5507ab8709835"} ) | 0 | 0 | 5 | |
| 26 | db.events_cache.count( {"_id":"4e345f30b1e225c6d9a5507ab8709835"} ) | 0 | 0 | 1 | |
| 27 | db.events_cache.insert( {"_id":"4e345f30b1e225c6d9a5507ab8709835","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.60700000 1765806029)","created":"MongoDate(0.60700000 1765806029)"} , true) | 0 | 0 | 1 | |
| 28 | db.events_cache.find( {"_id":"53f36ef7e3f35e1c8f79473da7e10139"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 14 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.14492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 21 | |
| 30 | db.events_cache.count( {"_id":"53f36ef7e3f35e1c8f79473da7e10139"} ) | 0 | 0 | 14 | |
| 31 | db.events_cache.count( {"_id":"53f36ef7e3f35e1c8f79473da7e10139"} ) | 0 | 0 | 15 | |
| 32 | db.events_cache.insert( {"_id":"53f36ef7e3f35e1c8f79473da7e10139","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.74800000 1765806029)","created":"MongoDate(0.74800000 1765806029)"} , true) | 0 | 0 | 13 | |
| 33 | db.events_cache.find( {"_id":"f244dc3ff102851df5532864c056378e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 9 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767074399)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 18 | |
| 35 | db.events_cache.count( {"_id":"f244dc3ff102851df5532864c056378e"} ) | 0 | 0 | 4 | |
| 36 | db.events_cache.count( {"_id":"f244dc3ff102851df5532864c056378e"} ) | 0 | 0 | 11 | |
| 37 | db.events_cache.insert( {"_id":"f244dc3ff102851df5532864c056378e","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.86700000 1765806029)","created":"MongoDate(0.86700000 1765806029)"} , true) | 0 | 0 | 2 | |
| 38 | db.events_cache.find( {"_id":"790acdd4e709a057deabd7ee4102aa16"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 20 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766123999)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 2 | |
| 40 | db.events_cache.count( {"_id":"790acdd4e709a057deabd7ee4102aa16"} ) | 0 | 0 | 4 | |
| 41 | db.events_cache.count( {"_id":"790acdd4e709a057deabd7ee4102aa16"} ) | 0 | 0 | 4 | |
| 42 | db.events_cache.insert( {"_id":"790acdd4e709a057deabd7ee4102aa16","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.98300000 1765806029)","created":"MongoDate(0.98300000 1765806029)"} , true) | 0 | 0 | 10 | |
| 43 | db.events_cache.find( {"_id":"cdd1d811494e160270aa9aadfeb5fc7a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1768456799)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.8695652173913043]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 6 | |
| 45 | db.events_cache.count( {"_id":"cdd1d811494e160270aa9aadfeb5fc7a"} ) | 0 | 0 | 14 | |
| 46 | db.events_cache.count( {"_id":"cdd1d811494e160270aa9aadfeb5fc7a"} ) | 0 | 0 | 3 | |
| 47 | db.events_cache.insert( {"_id":"cdd1d811494e160270aa9aadfeb5fc7a","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.05700000 1765806030)","created":"MongoDate(0.05700000 1765806030)"} , true) | 0 | 0 | 2 | |
| 48 | db.events_cache.find( {"_id":"260c3f699daa8f484cd5cb11a9b64d25"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766296799)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.14492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 2 | 32 | |
| 50 | db.events_cache.count( {"_id":"260c3f699daa8f484cd5cb11a9b64d25"} ) | 0 | 0 | 8 | |
| 51 | db.events_cache.count( {"_id":"260c3f699daa8f484cd5cb11a9b64d25"} ) | 0 | 0 | 7 | |
| 52 | db.events_cache.insert( {"_id":"260c3f699daa8f484cd5cb11a9b64d25","town_sef_url":"spearfish-sd","data_key":["68f963f9695f30aa8809bc06"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":true}","modified":"MongoDate(0.15200000 1765806030)","created":"MongoDate(0.15200000 1765806030)"} , true) | 0 | 0 | 12 | |
| 53 | db.events_cache.find( {"_id":"e8dc52097ef8ec6ec3caf6748d1ff2f1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76269178]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],1.4492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 51 ).skip( 0 ) | 0 | 3 | 64 | |
| 55 | db.events_cache.count( {"_id":"e8dc52097ef8ec6ec3caf6748d1ff2f1"} ) | 0 | 0 | 11 | |
| 56 | db.events_cache.count( {"_id":"e8dc52097ef8ec6ec3caf6748d1ff2f1"} ) | 0 | 0 | 5 | |
| 57 | db.events_cache.insert( {"_id":"e8dc52097ef8ec6ec3caf6748d1ff2f1","town_sef_url":"spearfish-sd","data_key":["68941fc0fb5e4bed1fb9451e","68941fc0fb5e4bed1fb94577","68941fc0fb5e4bed1fb94622"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.33400000 1765806030)","created":"MongoDate(0.33400000 1765806030)"} , true) | 0 | 0 | 7 | |
| 58 | db.events_cache.find( {"_id":"f8319b2b3c31a28e8d61854e74734e7a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 10 | |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76269178,76029634]},"tags":"music","geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],1.4492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 51 ).skip( 0 ) | 0 | 0 | 20 | |
| 60 | db.events_cache.count( {"_id":"f8319b2b3c31a28e8d61854e74734e7a"} ) | 0 | 0 | 8 | |
| 61 | db.events_cache.count( {"_id":"f8319b2b3c31a28e8d61854e74734e7a"} ) | 0 | 0 | 7 | |
| 62 | db.events_cache.insert( {"_id":"f8319b2b3c31a28e8d61854e74734e7a","town_sef_url":"spearfish-sd","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-103.84400177001953,44.481998443603516],\"has_next_page\":false}","modified":"MongoDate(0.46900000 1765806030)","created":"MongoDate(0.46900000 1765806030)"} , true) | 0 | 0 | 1 | |
| 63 | db.places.find( {"geo":{"$near":[-103.84400177001953,44.481998443603516],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 24 | 2 | |
| 64 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-hardware-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/hardware-stores\/\" target=\"_blank\">9 Best Hardware Stores in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/hardware-stores\/\" target=\"_blank\">Heisler\u2019s Hardware, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Heisler’s Hardware is known and trusted by local handymen to provide great quality materials at a reasonable price. Items include automotive, building materials, cleaning supplies, doors and… <a href=\"https:\/\/bestthingssd.com\/hardware-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-steakhouse-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/steakhouses\/\" target=\"_blank\">The 8 Best Steakhouses in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/steakhouses\/\" target=\"_blank\">Steerfish Steak & Smoke, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Steerfish Steak & Smoke serves hand-cut certified premium beef grilled over hickory wood. The atmosphere brings you back to South Dakota’s rugged history, with bison head mounts, exposed… <a href=\"https:\/\/bestthingssd.com\/steakhouses\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-margaritas-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/margaritas\/\" target=\"_blank\">7 Best Places for Margaritas in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/margaritas\/\" target=\"_blank\">Guadalajara Mexican Restaurant, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Guadalajara’s is a family owned and operated restaurant that is known for having the best Mexican fare in all of scenic Spearfish. The dining area is decorated with traditional Mexican decor… <a href=\"https:\/\/bestthingssd.com\/margaritas\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-paint-and-wine-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/paint-and-wine\/\" target=\"_blank\">9 Best Paint & Wine Spots in South Dakota 2025!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/paint-and-wine\/\" target=\"_blank\">Sip-N-Paint, Black Hills, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Have a special occasion coming up? Sip-N-Paint is the premier place to book your private party. With painting parties catered exclusively to you and your event, this Black Hills favorite is ready to… <a href=\"https:\/\/bestthingssd.com\/paint-and-wine\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-dessert-spots-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/desserts\/\" target=\"_blank\">6 Best Places for Dessert in South Dakota<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/desserts\/\" target=\"_blank\">Rustic Rolling Pin, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Family-owned Rustic Rolling Pin is a Spearfish gem and a perfect spot to refuel after a long day of hiking in beautiful Spearfish Canyon. Stop here for a light lunch and then satisfy your sweet tooth… <a href=\"https:\/\/bestthingssd.com\/desserts\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-romantic-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/romantic-places\/\" target=\"_blank\">10 Most Romantic Places in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/romantic-places\/\" target=\"_blank\">Spearfish Canyon Scenic Byway, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,edited-shannen,valentines-day,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">One of the simplest ways to create a wonderfully romantic date is by simply finding the right road for a drive. The Spearfish Canyon Scenic Byway is that road. Take a cruise down this one-of-a-kind… <a href=\"https:\/\/bestthingssd.com\/romantic-places\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-sports-center-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/sports-centers\/\" target=\"_blank\">The 9 Best Sports Centers in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/sports-centers\/\" target=\"_blank\">Spearfish Rec & Aquatic Center, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">The 71,000-square-foot Spearfish Rec Center has a double gymnasium with two basketball courts, volleyball, soccer, tennis, cardio room, strength training room, special event rooms, a cycling room,… <a href=\"https:\/\/bestthingssd.com\/sports-centers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-unique-hotels-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/unique-hotels\/\" target=\"_blank\">10 Most Unique Hotels in South Dakota<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/unique-hotels\/\" target=\"_blank\">Spearfish Canyon Lodge, Spearfish, South Dakota<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\"><p>From relaxation to gorgeous backdrops, there’s something for everyone. Eat at the Latchstring Restaurant, rent adventure vehicles, or even say I Do while surrounded by nature.<\/p> <a href=\"https:\/\/bestthingssd.com\/unique-hotels\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-crossfit-gym-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/crossfit\/\" target=\"_blank\">The 8 Best CrossFit Gyms in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/crossfit\/\" target=\"_blank\">Crow Peak CrossFit, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">In the heart of scenic Spearfish, athletes at Crow Peak CrossFit are getting fitter than they thought possible through the dynamic and invigorating group classes. Classes are held from morning to… <a href=\"https:\/\/bestthingssd.com\/crossfit\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/sd-bakery-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingssd.com\/bakeries\/\" target=\"_blank\">9 Best Bakeries in South Dakota!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingssd.com\/bakeries\/\" target=\"_blank\">Ruby\u2019s Roost Bakery and Coffee, Spearfish, SD<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Is there any more welcoming place to spend a cozy afternoon than a family coffeehouse and bakeshop? We think not, and Ruby’s Roost Bakery and Coffee is a perfect example. This local Spearfish… <a href=\"https:\/\/bestthingssd.com\/bakeries\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"spearfish-sd","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765809630,"type":"Event","id":76269178,"title":"Inspecting Carol","url":"\/event\/inspecting-carol-2025-12-15-spearfish-sd.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1765820430,"type":"Event","id":76029634,"title":"Rapid City Rush vs. Tahoe Knight Monsters","url":"\/event\/rapid-city-rush-vs-tahoe-knight-monsters-2025-12-31-tm-rapid-city-sd.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/61c\/37e6dc36-b80c-45a5-9bc5-960c7a98161c_106321_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1765834830,"type":"Place","id":1806388,"title":"ArtCentral Film Festival","url":"\/place\/artcentral-film-festival-spearfish-sd.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-film-festival-1.jpg"}],"modified":"MongoDate(0.48100000 1765806030)","created":"MongoDate(0.48100000 1765806030)","_id":ObjectId ("69400fce2fb9e5581b091ddd")} , true) | 0 | 0 | 1 | |
| 65 | db.events_cache.find( {"_id":"cfe64871aeca189a26222ec9f7e9801a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 66 | db.events_radius_cache.find( {"_id":"d4aa01e60188fe63177f25320d229222"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 67 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76269178,76029634]},"geo":{"$geoWithin":{"$center":[[-103.84400177001953,44.481998443603516],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 370 | |
| 68 | db.events_cache.count( {"_id":"cfe64871aeca189a26222ec9f7e9801a"} ) | 0 | 0 | 1 | |
| 69 | db.events_cache.count( {"_id":"cfe64871aeca189a26222ec9f7e9801a"} ) | 0 | 0 | 8 | |
| 70 | db.events_cache.insert( {"_id":"cfe64871aeca189a26222ec9f7e9801a","town_sef_url":"spearfish-sd","data_key":["68f963f9695f30aa8809bc07","68f963f68675dc66050517e1","68f963f9695f30aa8809bc08","68f963f9695f30aa8809bc09","68f963f9695f30aa8809bc0a"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Spearfish\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":44.481998443603516,\"lng\":-103.84400177001953,\"latlng\":\"44.481998443604,-103.84400177002\",\"city\":\"Spearfish\",\"state\":\"SD\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.90400000 1765806030)","created":"MongoDate(0.90400000 1765806030)"} , true) | 0 | 0 | 21 | |
| 71 | db.news.find( {"broadcast":{"$in":["usa","spearfish-sd","sd","lawrence-county-sd"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 11 | |
| 72 | db.places.find( {"address.town_sef_url":"spearfish-sd","group_id":{"$nin":[1806388]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 5 | |
| 73 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 2 | |
| 74 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 1 | |
| 75 | db.towns.find( {"sef_url":"spearfish-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 3 | |
| 76 | db.tokens.find( {"sef_url":{"$in":["usa","sd","lawrence-county-sd","spearfish-sd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 6 | |
| 77 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 78 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 7 | |
| 79 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 80 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 81 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 14 | |
| 82 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 83 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |

