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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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) 1769925600 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
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
Rajanee Thai Cuisine is small and they don’t offer any indoor seating. But if you’re looking for amazing Thai takeout, this is one of the most popular restaurants in the area.
Read MoreHawaii’s surf culture is legendary and there is no better spot to see the best in action than the beaches of Oahu’s North Shore. Check out the site for competitions and surf conditions… Read More
Tucked inside the North Shore Marketplace sits Coffee Gallery, a cozy shop serving artisanal hand-roasted coffee from Hawaii & beyond, plus a bakery and art exhibits. Be sure to snag a spot on… Read More
Shopping is the perfect way to spend a fun and relaxed rainy day. Instead of a garden-variety mall, check out the Haleiwa Store Lots, a shopping center that’s full of local boutiques and unique… Read More
During your trip to the North Shore of Oahu to watch the big surf, a stop at Ted’s Bakery is an absolute must. Ted’s bakes many different pies, including flavors that you can’t find… Read More
Haleiwa Bowls is as trendy as it is healthy. On the menu, you’ll find 10 different smoothies that are packed with fruits, vegetables, and protein. Menu highlights include the Dirty Paniolo, which is… Read More
This popular food truck offers both light bites and larger meals to fulfill any size of hunger pangs. For those who have built up an appetite practicing sports all day, the camarones al ajillo plate… Read More
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
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 Waialua', '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.573699951172, 'lng' => (float) -158.12699890137, 'latlng' => '21.573699951172,-158.12699890137', 'city' => 'Waialua', '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' => 'waialua-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
Waialua, Hawaii. Population for Waialua from the last gathering is 3761. You can view Waialua venues that host many Waialua HI events every year.
You can find a ton of properties for sale if you search the Waialua page on Zillow. Currently Waialua has an average listing price for homes for sale on the market of $895,501. More real estate facts about Waialua: The number of properties currently for sale in Waialua 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 Waialua 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 Waialua is $1,318,262. Interest rates for Waialua are at historic lows as well.
Waialua Hawaii has a latitude of 21.573699951172 and a longitude of -158.12699890137. 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":"irrigon-or"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 3 | db.towns.find( {"sef_url":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 2 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.1269989013672,21.573699951171875],"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(1769939730868)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769939730868)","$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 | 43 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","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":"b5fd972574ad2f5d75b913bab61ba6b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770616799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 16 | |
| 15 | db.events_cache.count( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1"} ) | 0 | 0 | 2 | |
| 16 | db.events_cache.count( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1"} ) | 0 | 0 | 2 | |
| 17 | db.events_cache.insert( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.98200000 1769939730)","created":"MongoDate(0.98200000 1769939730)"} , true) | 0 | 0 | 2 | |
| 18 | db.events_cache.find( {"_id":"3c1013d60e65e3e2dafefdb4b7242111"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770875999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 20 | |
| 20 | db.events_cache.count( {"_id":"3c1013d60e65e3e2dafefdb4b7242111"} ) | 0 | 0 | 1 | |
| 21 | db.events_cache.count( {"_id":"3c1013d60e65e3e2dafefdb4b7242111"} ) | 0 | 0 | 2 | |
| 22 | db.events_cache.insert( {"_id":"3c1013d60e65e3e2dafefdb4b7242111","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.04400000 1769939731)","created":"MongoDate(0.04400000 1769939731)"} , true) | 0 | 0 | 2 | |
| 23 | db.events_cache.find( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 10 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1772603999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 16 | |
| 25 | db.events_cache.count( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52"} ) | 0 | 0 | 2 | |
| 26 | db.events_cache.count( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52"} ) | 0 | 0 | 2 | |
| 27 | db.events_cache.insert( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.10900000 1769939731)","created":"MongoDate(0.10900000 1769939731)"} , true) | 0 | 0 | 2 | |
| 28 | db.events_cache.find( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 4 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770616799)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 7 | |
| 30 | db.events_cache.count( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24"} ) | 0 | 0 | 1 | |
| 31 | db.events_cache.count( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24"} ) | 0 | 0 | 2 | |
| 32 | db.events_cache.insert( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.14500000 1769939731)","created":"MongoDate(0.14500000 1769939731)"} , true) | 0 | 0 | 2 | |
| 33 | db.events_cache.find( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771221599)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 14 | |
| 35 | db.events_cache.count( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e"} ) | 0 | 0 | 1 | |
| 36 | db.events_cache.count( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e"} ) | 0 | 0 | 1 | |
| 37 | db.events_cache.insert( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.19700000 1769939731)","created":"MongoDate(0.19700000 1769939731)"} , true) | 0 | 0 | 2 | |
| 38 | db.events_cache.find( {"_id":"ecdea109d062b9ba7130020930bc8c6c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770271199)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 3 | |
| 40 | db.events_cache.count( {"_id":"ecdea109d062b9ba7130020930bc8c6c"} ) | 0 | 0 | 1 | |
| 41 | db.events_cache.count( {"_id":"ecdea109d062b9ba7130020930bc8c6c"} ) | 0 | 0 | 1 | |
| 42 | db.events_cache.insert( {"_id":"ecdea109d062b9ba7130020930bc8c6c","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.22200000 1769939731)","created":"MongoDate(0.22200000 1769939731)"} , true) | 0 | 0 | 2 | |
| 43 | db.events_cache.find( {"_id":"63f74200a9d65737f38e0b03764e4eda"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1772603999)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 2 | |
| 45 | db.events_cache.count( {"_id":"63f74200a9d65737f38e0b03764e4eda"} ) | 0 | 0 | 1 | |
| 46 | db.events_cache.count( {"_id":"63f74200a9d65737f38e0b03764e4eda"} ) | 0 | 0 | 1 | |
| 47 | db.events_cache.insert( {"_id":"63f74200a9d65737f38e0b03764e4eda","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.24200000 1769939731)","created":"MongoDate(0.24200000 1769939731)"} , true) | 0 | 0 | 1 | |
| 48 | db.events_cache.find( {"_id":"4236679835999e0466ecc26ee2f3c572"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770443999)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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":"4236679835999e0466ecc26ee2f3c572"} ) | 0 | 0 | 1 | |
| 51 | db.events_cache.count( {"_id":"4236679835999e0466ecc26ee2f3c572"} ) | 0 | 0 | 1 | |
| 52 | db.events_cache.insert( {"_id":"4236679835999e0466ecc26ee2f3c572","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.27200000 1769939731)","created":"MongoDate(0.27200000 1769939731)"} , true) | 0 | 0 | 1 | |
| 53 | db.events_cache.find( {"_id":"8a0293781df17d8cb80093c0ccb52bac"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771307999)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | |
| 55 | db.events_cache.count( {"_id":"8a0293781df17d8cb80093c0ccb52bac"} ) | 0 | 0 | 1 | |
| 56 | db.events_cache.count( {"_id":"8a0293781df17d8cb80093c0ccb52bac"} ) | 0 | 0 | 2 | |
| 57 | db.events_cache.insert( {"_id":"8a0293781df17d8cb80093c0ccb52bac","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.32500000 1769939731)","created":"MongoDate(0.32500000 1769939731)"} , true) | 0 | 0 | 2 | |
| 58 | db.events_cache.find( {"_id":"b58c47ffa86784bd36dd00624417bbdf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771307999)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 43 | |
| 60 | db.events_cache.count( {"_id":"b58c47ffa86784bd36dd00624417bbdf"} ) | 0 | 0 | 1 | |
| 61 | db.events_cache.count( {"_id":"b58c47ffa86784bd36dd00624417bbdf"} ) | 0 | 0 | 1 | |
| 62 | db.events_cache.insert( {"_id":"b58c47ffa86784bd36dd00624417bbdf","town_sef_url":"waialua-hi","data_key":["691e7b9ade4ae56f5a810ba4"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":true}","modified":"MongoDate(0.41000000 1769939731)","created":"MongoDate(0.41000000 1769939731)"} , true) | 0 | 0 | 2 | |
| 63 | db.events_cache.find( {"_id":"6f6741331a6e5f42f640ab029a0a85d0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 64 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771826399)"},"event_id":{"$nin":[76358518]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 72 | |
| 65 | db.events_cache.count( {"_id":"6f6741331a6e5f42f640ab029a0a85d0"} ) | 0 | 0 | 1 | |
| 66 | db.events_cache.count( {"_id":"6f6741331a6e5f42f640ab029a0a85d0"} ) | 0 | 0 | 1 | |
| 67 | db.events_cache.insert( {"_id":"6f6741331a6e5f42f640ab029a0a85d0","town_sef_url":"waialua-hi","data_key":["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","6960668fb1faf7c56a141398","68ae4c88c3af739f25823166"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.57300000 1769939731)","created":"MongoDate(0.57300000 1769939731)"} , true) | 0 | 0 | 2 | |
| 68 | db.events_cache.find( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 69 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771826399)"},"event_id":{"$nin":[76358518,76451350]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 16 | |
| 70 | db.events_cache.count( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781"} ) | 0 | 0 | 2 | |
| 71 | db.events_cache.count( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781"} ) | 0 | 0 | 1 | |
| 72 | db.events_cache.insert( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.62300000 1769939731)","created":"MongoDate(0.62300000 1769939731)"} , true) | 0 | 0 | 2 | |
| 73 | db.places.find( {"geo":{"$near":[-158.1269989013672,21.573699951171875],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 16 | 6 | |
| 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-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-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\">Rajanee Thai Cuisine, 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\"><p>Rajanee Thai Cuisine is small and they don’t offer any indoor seating. But if you’re looking for amazing Thai takeout, this is one of the most popular restaurants in the area.<\/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-educational-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/educational-activities-for-kids\/\" target=\"_blank\">The 9 Best Educational Activities for Children 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\/educational-activities-for-kids\/\" target=\"_blank\">Pipeline North Shore, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Hawaii’s surf culture is legendary and there is no better spot to see the best in action than the beaches of Oahu’s North Shore. Check out the site for competitions and surf conditions… <a href=\"https:\/\/bestthingshi.com\/educational-activities-for-kids\/\" 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\">Coffee Gallery, Haleiwa, 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\">Tucked inside the North Shore Marketplace sits Coffee Gallery, a cozy shop serving artisanal hand-roasted coffee from Hawaii & beyond, plus a bakery and art exhibits. Be sure to snag a spot on… <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-rainy-day-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">10 Best Rainy Day Activities 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\/rainy-day-thingstodo\/\" target=\"_blank\">Haleiwa Store Lots, Haleiwa, 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\">Shopping is the perfect way to spend a fun and relaxed rainy day. Instead of a garden-variety mall, check out the Haleiwa Store Lots, a shopping center that’s full of local boutiques and unique… <a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" 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-bakery-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bakeries\/\" target=\"_blank\">8 Best Bakeries 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\/bakeries\/\" target=\"_blank\">Ted\u2019s Bakery, Haleiwa, Oahu, 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\">During your trip to the North Shore of Oahu to watch the big surf, a stop at Ted’s Bakery is an absolute must. Ted’s bakes many different pies, including flavors that you can’t find… <a href=\"https:\/\/bestthingshi.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\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-smoothies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/smoothies\/\" target=\"_blank\">9 Best Smoothie Places 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\/smoothies\/\" target=\"_blank\">Haleiwa Bowls, Haleiwa, 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\">Haleiwa Bowls is as trendy as it is healthy. On the menu, you\u2019ll find 10 different smoothies that are packed with fruits, vegetables, and protein. Menu highlights include the Dirty Paniolo, which is… <a href=\"https:\/\/bestthingshi.com\/smoothies\/\" 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-mexican-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/mexican-restaurants\/\" target=\"_blank\">The 9 Best Mexican 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\/mexican-restaurants\/\" target=\"_blank\">Surf N Salsa, 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\">This popular food truck offers both light bites and larger meals to fulfill any size of hunger pangs. For those who have built up an appetite practicing sports all day, the camarones al ajillo plate… <a href=\"https:\/\/bestthingshi.com\/mexican-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-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<\/div>\n<\/div>\n\n\n","town_sef_url":"waialua-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":1769950531,"type":"Event","id":76358518,"title":"Five for Fighting","url":"\/event\/five-for-fighting-1-2026-02-03-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/485\/b5011f2a-c1da-47d9-a9dc-d9db1b5ef485_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":1769954131,"type":"Event","id":76451350,"title":"Hawaii Rainbow Warriors Baseball vs. Gonzaga Bulldogs Baseball","url":"\/event\/hawaii-rainbow-warriors-baseball-vs-gonzaga-bulldogs-baseball-2026-02-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/093\/c74cfd95-af21-4e64-9f85-47677b951093_105651_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":1769968531,"type":"Place","id":2222220,"title":"Hawaii Oktoberfest","url":"\/place\/hawaii-oktoberfest-wahiawa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-food-festival-2.jpg"}],"modified":"MongoDate(0.64100000 1769939731)","created":"MongoDate(0.64100000 1769939731)","_id":ObjectId ("697f231395d5c4a7700920b7")} , true) | 0 | 0 | 2 | |
| 75 | db.events_cache.find( {"_id":"a284da43eaa658c7790a33cc3769640b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 76 | db.events_radius_cache.find( {"_id":"712f196580278207467644e50a893fd6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 77 | db.events.count( {"address.town_sef_url":"waialua-hi","start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770530400)"}} ) | 0 | 0 | 2 | |
| 78 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} ) | 0 | 0 | 32 | |
| 79 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} ) | 0 | 0 | 32 | |
| 80 | db.events_radius_cache.count( {"_id":"712f196580278207467644e50a893fd6"} ) | 0 | 0 | 1 | |
| 81 | db.events_radius_cache.count( {"_id":"712f196580278207467644e50a893fd6"} ) | 0 | 0 | 1 | |
| 82 | db.events_radius_cache.insert( {"_id":"712f196580278207467644e50a893fd6","radius":25,"modified":"MongoDate(0.73800000 1769939731)","created":"MongoDate(0.73800000 1769939731)"} , true) | 0 | 0 | 2 | |
| 83 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)"},"event_id":{"$nin":[76358518,76451350]},"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 2 | 70 | |
| 84 | db.events_cache.count( {"_id":"a284da43eaa658c7790a33cc3769640b"} ) | 0 | 0 | 1 | |
| 85 | db.events_cache.count( {"_id":"a284da43eaa658c7790a33cc3769640b"} ) | 0 | 0 | 2 | |
| 86 | db.events_cache.insert( {"_id":"a284da43eaa658c7790a33cc3769640b","town_sef_url":"waialua-hi","data_key":["68dc7100c3af739f25c0f055","69682ffcb1faf7c56afaaf87"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Waialua\",\"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.573699951171875,\"lng\":-158.1269989013672,\"latlng\":\"21.573699951172,-158.12699890137\",\"city\":\"Waialua\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.88000000 1769939731)","created":"MongoDate(0.88000000 1769939731)"} , true) | 0 | 0 | 2 | |
| 87 | db.news.find( {"broadcast":{"$in":["usa","waialua-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 | 6 | |
| 88 | db.places.find( {"address.town_sef_url":"waialua-hi","group_id":{"$nin":[2222220]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 6 | |
| 89 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 2 | |
| 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":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 92 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waialua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 2 | |
| 93 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 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 | 2 | |
| 99 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |

