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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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) 1769839200 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
Dragon Tattoo is the brainchild of renowned tattoo artist Lance McLane, a living legend in the classic American style of tattooing. If you’re in the northern end of Oahu and looking for some… Read More
Kemo’o Farms Pub and Grill isn’t hidden behind a password like a typical speakeasy but it has an intimate speakeasy-type atmosphere that can be a fun switch for your next night out.… Read More
Keo’s Kitchen is the most diverse Thai restaurant on this list. They also serve breakfast and many classic Hawaiian dishes.
Read MoreLocated right off the highway en route to Oahu's famed North Shore sits Green World Coffee Farm. A coffee grower's cafe & espresso bar with retail space that sells whole beans & Hawaiian… Read More
Kilani Bakery sells a wide array of baked goods, so this is a perfect stop if you are looking for something sweet to please everyone in the family. In addition to cakes, chocolatey brownies, pies,… Read More
It’s very likely you’ve heard of the company Dole. But we’re sure not many know that the Dole plantation in Wahiawa, Hawaii, boasts one of the largest mazes in the whole world! No… Read More
The Pet Hale is a resource for Hawaiians with furry family members throughout the Mililani area. Not only does this pet shop offer an exceptional array of pet supplies and products but it helps to… Read More
Who has two thumbs and is fantastic at body piercings? The exceptional piercer at Two Thumbs Tattoo. This Haleiwa shop provides a top-quality visit every time.
Read MoreAfter just one bite from The Cosmic Kitchen, you’ll be thanking your lucky stars that you found this Haleiwa restaurant. It’s known for some of the best vegan sandwiches around, like its tuna-less… Read More
The Vintage Hawaii is a highly-curated thrift shop that, together with other local businesses, transformed the once-rundown area. In addition to transforming the neighborhood, the Vintage funds… 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 Schofield Barracks', '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) 21.496000289917, 'lng' => (float) -158.05099487305, 'latlng' => '21.496000289917,-158.05099487305', 'city' => 'Schofield Barracks', 'state' => 'HI', 'theme' => '', 'page_type' => 'town' ) $options = array( 'page' => (int) 1, 'limit' => (int) 5, 'order' => array( 'created' => (int) -1 ), 'conditions' => array( 'address.town_sef_url' => 'schofield-barracks-hi' ) )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
Schofield Barracks, Hawaii. Population for Schofield Barracks from the last gathering is 14428. You can view Schofield Barracks venues that host many Schofield Barracks HI events every year.
You can find a ton of properties for sale if you search the Schofield Barracks page on Zillow. Currently Schofield Barracks has an average listing price for homes for sale on the market of $895,501. More real estate facts about Schofield Barracks: The number of properties currently for sale in Schofield Barracks is 3,118. The median homes for sale listing price is $453,333. This is broken down with the number of three bedroom houses in Schofield Barracks consisting of 813 with an average listing price for these house of $743,821. Out of the 419 houses that are four bedroom the average listing price for Schofield Barracks is $1,318,262. Interest rates for Schofield Barracks are at historic lows as well.
Schofield Barracks Hawaii has a latitude of 21.496000289917 and a longitude of -158.05099487305. 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":"niceville-fl"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 3 | db.towns.find( {"sef_url":"schofield-barracks-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"schofield-barracks-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 3 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.05099487304688,21.496000289916992],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"HI"}}},{"$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(1769893699772)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769893699772)","$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 | 25 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"schofield-barracks-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 0 | 1 | |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 13 | db.events_cache.find( {"_id":"3144aa7eb61ca31315c2e1391285881b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | |
| 15 | db.events_cache.count( {"_id":"3144aa7eb61ca31315c2e1391285881b"} ) | 0 | 0 | 1 | |
| 16 | db.events_cache.count( {"_id":"3144aa7eb61ca31315c2e1391285881b"} ) | 0 | 0 | 1 | |
| 17 | db.events_cache.insert( {"_id":"3144aa7eb61ca31315c2e1391285881b","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.86600000 1769893699)","created":"MongoDate(0.86600000 1769893699)"} , true) | 0 | 0 | 1 | |
| 18 | db.events_cache.find( {"_id":"595e513f72bffe1a041af9619df068b6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770789599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 17 | |
| 20 | db.events_cache.count( {"_id":"595e513f72bffe1a041af9619df068b6"} ) | 0 | 0 | 1 | |
| 21 | db.events_cache.count( {"_id":"595e513f72bffe1a041af9619df068b6"} ) | 0 | 0 | 1 | |
| 22 | db.events_cache.insert( {"_id":"595e513f72bffe1a041af9619df068b6","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.91700000 1769893699)","created":"MongoDate(0.91700000 1769893699)"} , true) | 0 | 0 | 1 | |
| 23 | db.events_cache.find( {"_id":"99395c633932dc3124834c74956d93c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 17 | |
| 25 | db.events_cache.count( {"_id":"99395c633932dc3124834c74956d93c6"} ) | 0 | 0 | 1 | |
| 26 | db.events_cache.count( {"_id":"99395c633932dc3124834c74956d93c6"} ) | 0 | 0 | 1 | |
| 27 | db.events_cache.insert( {"_id":"99395c633932dc3124834c74956d93c6","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.97100000 1769893699)","created":"MongoDate(0.97100000 1769893699)"} , true) | 0 | 0 | 1 | |
| 28 | db.events_cache.find( {"_id":"902a4fa871154379a39ec013e5f2fa4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 6 | |
| 30 | db.events_cache.count( {"_id":"902a4fa871154379a39ec013e5f2fa4b"} ) | 0 | 0 | 1 | |
| 31 | db.events_cache.count( {"_id":"902a4fa871154379a39ec013e5f2fa4b"} ) | 0 | 0 | 1 | |
| 32 | db.events_cache.insert( {"_id":"902a4fa871154379a39ec013e5f2fa4b","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.99400000 1769893699)","created":"MongoDate(0.99400000 1769893699)"} , true) | 0 | 0 | 1 | |
| 33 | db.events_cache.find( {"_id":"587e629907ab35c1fdf76b7702307c29"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771135199)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 12 | |
| 35 | db.events_cache.count( {"_id":"587e629907ab35c1fdf76b7702307c29"} ) | 0 | 0 | 1 | |
| 36 | db.events_cache.count( {"_id":"587e629907ab35c1fdf76b7702307c29"} ) | 0 | 0 | 1 | |
| 37 | db.events_cache.insert( {"_id":"587e629907ab35c1fdf76b7702307c29","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.03400000 1769893700)","created":"MongoDate(0.03400000 1769893700)"} , true) | 0 | 0 | 1 | |
| 38 | db.events_cache.find( {"_id":"1c37d5d30a3be6d9e670d38546d27db2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770184799)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 1 | |
| 40 | db.events_cache.count( {"_id":"1c37d5d30a3be6d9e670d38546d27db2"} ) | 0 | 0 | 1 | |
| 41 | db.events_cache.count( {"_id":"1c37d5d30a3be6d9e670d38546d27db2"} ) | 0 | 0 | 1 | |
| 42 | db.events_cache.insert( {"_id":"1c37d5d30a3be6d9e670d38546d27db2","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.04900000 1769893700)","created":"MongoDate(0.04900000 1769893700)"} , true) | 0 | 0 | 1 | |
| 43 | db.events_cache.find( {"_id":"e9a84a17adee6c6c4f5b1801c2eded6c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 1 | |
| 45 | db.events_cache.count( {"_id":"e9a84a17adee6c6c4f5b1801c2eded6c"} ) | 0 | 0 | 1 | |
| 46 | db.events_cache.count( {"_id":"e9a84a17adee6c6c4f5b1801c2eded6c"} ) | 0 | 0 | 1 | |
| 47 | db.events_cache.insert( {"_id":"e9a84a17adee6c6c4f5b1801c2eded6c","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.06300000 1769893700)","created":"MongoDate(0.06300000 1769893700)"} , true) | 0 | 0 | 1 | |
| 48 | db.events_cache.find( {"_id":"b6cdb078076cd0c157ad80b5899bc270"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770357599)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 6 | |
| 50 | db.events_cache.count( {"_id":"b6cdb078076cd0c157ad80b5899bc270"} ) | 0 | 0 | 1 | |
| 51 | db.events_cache.count( {"_id":"b6cdb078076cd0c157ad80b5899bc270"} ) | 0 | 0 | 1 | |
| 52 | db.events_cache.insert( {"_id":"b6cdb078076cd0c157ad80b5899bc270","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.08700000 1769893700)","created":"MongoDate(0.08700000 1769893700)"} , true) | 0 | 0 | 1 | |
| 53 | db.events_cache.find( {"_id":"5cffeacd5dee3a45066f6ea241238c04"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771221599)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | |
| 55 | db.events_cache.count( {"_id":"5cffeacd5dee3a45066f6ea241238c04"} ) | 0 | 0 | 1 | |
| 56 | db.events_cache.count( {"_id":"5cffeacd5dee3a45066f6ea241238c04"} ) | 0 | 0 | 1 | |
| 57 | db.events_cache.insert( {"_id":"5cffeacd5dee3a45066f6ea241238c04","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.13600000 1769893700)","created":"MongoDate(0.13600000 1769893700)"} , true) | 0 | 0 | 1 | |
| 58 | db.events_cache.find( {"_id":"0fe473785c3623da4bfe67045362f331"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771221599)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],0.43478260869565216]}}}, ["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 | 19 | |
| 60 | db.events_cache.count( {"_id":"0fe473785c3623da4bfe67045362f331"} ) | 0 | 0 | 1 | |
| 61 | db.events_cache.count( {"_id":"0fe473785c3623da4bfe67045362f331"} ) | 0 | 0 | 1 | |
| 62 | db.events_cache.insert( {"_id":"0fe473785c3623da4bfe67045362f331","town_sef_url":"schofield-barracks-hi","data_key":["6967019cb1faf7c56a6c99ed"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":true}","modified":"MongoDate(0.17900000 1769893700)","created":"MongoDate(0.17900000 1769893700)"} , true) | 0 | 0 | 1 | |
| 63 | db.events_cache.find( {"_id":"9cdc228cf9d2e644040b8e14aae2af6e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 64 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76454614]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 50 | 38 | |
| 65 | db.events_cache.count( {"_id":"9cdc228cf9d2e644040b8e14aae2af6e"} ) | 0 | 0 | 1 | |
| 66 | db.events_cache.count( {"_id":"9cdc228cf9d2e644040b8e14aae2af6e"} ) | 0 | 0 | 1 | |
| 67 | db.events_cache.insert( {"_id":"9cdc228cf9d2e644040b8e14aae2af6e","town_sef_url":"schofield-barracks-hi","data_key":["6967019cb1faf7c56a6c9a36","691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e","69041d9ede4ae56f5ae0eecf","69251314de4ae56f5a252aaf","69041d9ede4ae56f5ae0eef6","689ab740fb5e4bed1fdee435","68dc90a1c3af739f25fd395f","691d2a16de4ae56f5a437e49","6967019cb1faf7c56a6c9c92","689c08befb5e4bed1f1f9c5e","68fae321c3af739f25d95935","68fae321c3af739f25d95954","6944b711de4ae56f5ab96c5a","6967019cb1faf7c56a6c9d83","6944b711de4ae56f5ab96c8c","6944b711de4ae56f5ab96c98","6944b711de4ae56f5ab96cc0","69339394de4ae56f5aea31dc","6960668eb1faf7c56a141027","694f4310de4ae56f5a0c3166","69339394de4ae56f5aea322f","6967019db1faf7c56a6c9e8b","69339394de4ae56f5aea325c","6960668eb1faf7c56a1410b0","693cce13de4ae56f5ae98669","69339394de4ae56f5aea3298","6967019db1faf7c56a6c9f68","6960668fb1faf7c56a141147","694f4310de4ae56f5a0c31fb","691e7b9ade4ae56f5a811029","6960668fb1faf7c56a14119d","695dc38eb1faf7c56a6c1005","692f9f13de4ae56f5a523992","692f9f13de4ae56f5a5239a7","6967019db1faf7c56a6ca097","6938d997de4ae56f5aaaa9dd","6960668fb1faf7c56a14121c","68dc90a1c3af739f25fd3cb8","69266495de4ae56f5ae493ed","6938d997de4ae56f5aaaab2a","6960668fb1faf7c56a14126f","69266495de4ae56f5ae4941e","6960668fb1faf7c56a141326","68dc90a1c3af739f25fd3dbe","6967019db1faf7c56a6ca21d","695f150fb1faf7c56aac1a4f"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.27100000 1769893700)","created":"MongoDate(0.27100000 1769893700)"} , true) | 0 | 0 | 1 | |
| 68 | db.events_cache.find( {"_id":"9262ac0a413c1be36304ff19af422a22"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 69 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76454614,76454527]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 11 | |
| 70 | db.events_cache.count( {"_id":"9262ac0a413c1be36304ff19af422a22"} ) | 0 | 0 | 1 | |
| 71 | db.events_cache.count( {"_id":"9262ac0a413c1be36304ff19af422a22"} ) | 0 | 0 | 1 | |
| 72 | db.events_cache.insert( {"_id":"9262ac0a413c1be36304ff19af422a22","town_sef_url":"schofield-barracks-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.05099487304688,21.496000289916992],\"has_next_page\":false}","modified":"MongoDate(0.31300000 1769893700)","created":"MongoDate(0.31300000 1769893700)"} , true) | 0 | 0 | 1 | |
| 73 | db.places.find( {"geo":{"$near":[-158.05099487304688,21.496000289916992],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 39 | 2 | |
| 74 | 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\/hi-tattoo-parlor-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">10 Best Tattoo Parlors in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">Dragon Tattoo, Wahiawa, HI<\/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\">Dragon Tattoo is the brainchild of renowned tattoo artist Lance McLane, a living legend in the classic American style of tattooing. If you’re in the northern end of Oahu and looking for some… <a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" 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\/hi-speakeasies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/speakeasy-bars\/\" target=\"_blank\">7 Best Speakeasies in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/speakeasy-bars\/\" target=\"_blank\">Kemo\u2019o Farms Pub and Grill, Wahiawa, HI<\/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\">Kemo’o Farms Pub and Grill isn’t hidden behind a password like a typical speakeasy but it has an intimate speakeasy-type atmosphere that can be a fun switch for your next night out.… <a href=\"https:\/\/bestthingshi.com\/speakeasy-bars\/\" 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\/hi-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">Keo\u2019s Kitchen, Wahiawa, HI<\/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\"><p>Keo’s Kitchen is the most diverse Thai restaurant on this list. They also serve breakfast and many classic Hawaiian dishes.<\/p> <a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" 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\/hi-coffee-shops-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/coffee-shops-cafes\/\" target=\"_blank\">9 Coolest Coffee Shops in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/coffee-shops-cafes\/\" target=\"_blank\">Green World Farms, Wahiawa, HI<\/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\">Located right off the highway en route to Oahu's famed North Shore sits Green World Coffee Farm. A coffee grower's cafe & espresso bar with retail space that sells whole beans & Hawaiian… <a href=\"https:\/\/bestthingshi.com\/coffee-shops-cafes\/\" 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\/hi-doughnut-shop-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/doughnut-shops\/\" target=\"_blank\">7 Best Doughnut Shops in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/doughnut-shops\/\" target=\"_blank\">Kilani Bakery, Wahiawa, HI<\/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\">Kilani Bakery sells a wide array of baked goods, so this is a perfect stop if you are looking for something sweet to please everyone in the family. In addition to cakes, chocolatey brownies, pies,… <a href=\"https:\/\/bestthingshi.com\/doughnut-shops\/\" 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\/hi-offbeat-attractions-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/unusual-attractions\/\" target=\"_blank\">7 of the Best (and Most Offbeat) Attractions in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/unusual-attractions\/\" target=\"_blank\">Pineapple Garden Maze, Wahiawa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">It’s very likely you’ve heard of the company Dole. But we’re sure not many know that the Dole plantation in Wahiawa, Hawaii, boasts one of the largest mazes in the whole world! No… <a href=\"https:\/\/bestthingshi.com\/unusual-attractions\/\" 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\/hi-pet-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/pet-stores\/\" target=\"_blank\">10 Best Pet Stores in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/pet-stores\/\" target=\"_blank\">The Pet Hale, Mililani, HI<\/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\">The Pet Hale is a resource for Hawaiians with furry family members throughout the Mililani area. Not only does this pet shop offer an exceptional array of pet supplies and products but it helps to… <a href=\"https:\/\/bestthingshi.com\/pet-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\/hi-piercing-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\">10 Best Piercing Shops in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\">Two Thumbs Tattoo, Haleiwa, HI<\/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>Who has two thumbs and is fantastic at body piercings? The exceptional piercer at Two Thumbs Tattoo. This Haleiwa shop provides a top-quality visit every time.<\/p> <a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" 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\/hi-vegan-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/vegan-vegetarian-restaurants\/\" target=\"_blank\">10 Best Vegan Restaurants in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/vegan-vegetarian-restaurants\/\" target=\"_blank\">The Cosmic Kitchen, Haleiwa, HI<\/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\">After just one bite from The Cosmic Kitchen, you\u2019ll be thanking your lucky stars that you found this Haleiwa restaurant. It\u2019s known for some of the best vegan sandwiches around, like its tuna-less… <a href=\"https:\/\/bestthingshi.com\/vegan-vegetarian-restaurants\/\" 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\/hi-thrift-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" target=\"_blank\">The 6 Best Thrift Stores in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" target=\"_blank\">The Vintage Hawaii, Wahiawa, HI<\/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\">The Vintage Hawaii is a highly-curated thrift shop that, together with other local businesses, transformed the once-rundown area. In addition to transforming the neighborhood, the Vintage funds… <a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" 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":"schofield-barracks-hi","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\":\"30\",\"days\":\"15\",\"ttl\":\"3\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1769904500,"type":"Event","id":76454614,"title":"GEESE","url":"\/event\/geese-2026-01-31-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e9f\/1ffb711c-f066-4afa-b36d-77260e885e9f_SOURCE"},{"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":1769908100,"type":"Event","id":76454527,"title":"Circle Jerks","url":"\/event\/circle-jerks-2026-02-21-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/1e4\/8535c7e2-780e-4dd1-a3fd-0e3b3ef231e4_SOURCE"},{"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":1769922500,"type":"Place","id":2237292,"title":"Havana International Jazz Festival and Cultural Exchange Tour","url":"\/place\/havana-international-jazz-festival-and-cultural-exchange-tour-waianae-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"}],"modified":"MongoDate(0.32600000 1769893700)","created":"MongoDate(0.32600000 1769893700)","_id":ObjectId ("697e6f449ec14795540a833b")} , true) | 0 | 0 | 2 | |
| 75 | db.events_cache.find( {"_id":"f35a8fd57f7e5be3dab5d3dcfe7314cf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 76 | db.events_radius_cache.find( {"_id":"4a8f21bba74965701460d75ace0a065a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 77 | db.events.count( {"address.town_sef_url":"schofield-barracks-hi","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | 0 | 0 | 1 | |
| 78 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | 0 | 0 | 17 | |
| 79 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | 0 | 0 | 16 | |
| 80 | db.events_radius_cache.count( {"_id":"4a8f21bba74965701460d75ace0a065a"} ) | 0 | 0 | 1 | |
| 81 | db.events_radius_cache.count( {"_id":"4a8f21bba74965701460d75ace0a065a"} ) | 0 | 0 | 1 | |
| 82 | db.events_radius_cache.insert( {"_id":"4a8f21bba74965701460d75ace0a065a","radius":25,"modified":"MongoDate(0.38100000 1769893700)","created":"MongoDate(0.38100000 1769893700)"} , true) | 0 | 0 | 1 | |
| 83 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[76454614,76454527]},"geo":{"$geoWithin":{"$center":[[-158.05099487304688,21.496000289916992],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 | 75 | |
| 84 | db.events_cache.count( {"_id":"f35a8fd57f7e5be3dab5d3dcfe7314cf"} ) | 0 | 0 | 1 | |
| 85 | db.events_cache.count( {"_id":"f35a8fd57f7e5be3dab5d3dcfe7314cf"} ) | 0 | 0 | 1 | |
| 86 | db.events_cache.insert( {"_id":"f35a8fd57f7e5be3dab5d3dcfe7314cf","town_sef_url":"schofield-barracks-hi","data_key":["6967019cb1faf7c56a6c9a36","691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Schofield Barracks\",\"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\":21.496000289916992,\"lng\":-158.05099487304688,\"latlng\":\"21.496000289917,-158.05099487305\",\"city\":\"Schofield Barracks\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.47600000 1769893700)","created":"MongoDate(0.47600000 1769893700)"} , true) | 0 | 0 | 1 | |
| 87 | db.news.find( {"broadcast":{"$in":["usa","schofield-barracks-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 2 | |
| 88 | db.places.find( {"address.town_sef_url":"schofield-barracks-hi","group_id":{"$nin":[2237292]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 1 | 1 | |
| 89 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 1 | |
| 90 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 1 | |
| 91 | db.towns.find( {"sef_url":"schofield-barracks-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 92 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","schofield-barracks-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 93 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 94 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 95 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 96 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 97 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 98 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 99 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |
