How Does Your Brain Score? Take the Staying Sharp Brain Health Assessment

Find things to do around Ballwin

helpful resources

We hear you

Real Possibilities is a trademark of AARP.

FIND IT FAST

Advertisement

JOIN OR RENEW
AARP TODAY

  • JOIN FOR JUST $16 A YEAR
  • Immediate access to your member benefits
  • Discounts on travel and everyday savings
  • Subscription to the award-winning AARP The Magazine
  • An ally on the issues that matter most to you in Ballwin
  • Free membership for your spouse or partner
  • JOIN/RENEW NOW

LOCAL SERVICES

Advertisement

Contact
AARP in St. Louis

Email: stlouis@aarp.org
More Info: Contact Us

(mongo) 24 queries took 1302 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1db.default_tokens.find( [], [] ).sort( [] ).limit( 1 ).skip( 0 )019
2db.towns.find( {"sef_url":"ballwin-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )0121
3db.pages.find( {"slug":"home","type":"town"}, [] ).sort( [] ).limit( 1 ).skip( 0 )017
4db.modules.find( {"name":"Head"}, [] ).sort( [] ).limit( 1 ).skip( 0 )016
5db.modules.find( {"name":"Bottom"}, [] ).sort( [] ).limit( 1 ).skip( 0 )017
6db.blogs_posts.find( {"post_tag":{"$in":["caregiving","healthy-living","savings-and-planning","work-and-jobs","life-reimagined","all","mo","st-louis-mo"]},"blog_type":"10up","published":"1","post_terms":{"$ne":"espanol"},"$or":[{"priority":{"$gte":"1"}},{"post_date":{"$gte":1500786000}}]}, [] ).sort( {"priority":-1,"post_date":-1} ).limit( 8 ).skip( 0 )0415
7db.blogs_posts.find( {"post_tag":{"$in":["caregiving","healthy-living","savings-and-planning","work-and-jobs","life-reimagined","all","mo","st-louis-mo"]},"post_terms":{"$ne":"espanol"},"blog_type":{"$ne":"10up"},"published":"1","post_id":{"$nin":["135467","128796","112296","128366"]},"post_url":{"$nin":["http:\/\/states.aarp.org\/moonlight-ramble-rescheduled-due-rainy-forecast\/","http:\/\/states.aarp.org\/join-cmt-aarp-st-louis-great-race-2017\/","http:\/\/states.aarp.org\/outdoor-adventure-group-returns-hike-us\/","http:\/\/states.aarp.org\/join-aarp-st-louis-symphony-may-4th\/"]}}, [] ).sort( {"priority":-1,"post_date":-1} ).limit( 4 ).skip( 0 )0414
8db.events_cache.find( {"key":"557ac7db72d998566efd67c9e8842452"}, [] ).sort( [] ).limit( 1 ).skip( 0 )008
9db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505970000)","$lt":"MongoDate(0.00000000 1506574800)"},"town_sef_url":"ballwin-mo","$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )00149
10db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.544998168945,38.595100402832],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953573,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505970000)","$lt":"MongoDate(0.00000000 1506834000)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )0049
11db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.544998168945,38.595100402832],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471942,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505970000)","$lt":"MongoDate(0.00000000 1506834000)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )02282
12db.events.find( {"aggregate":[{"$geoNear":{"near":[-90.544998168945,38.595100402832],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471942,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505970000)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$sort":{"start":1,"id":1}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"},"id":{"$first":"$_id"},"city":{"$first":"$city"},"cvent_id":{"$first":"$cvent_id"},"cvent_status":{"$first":"$cvent_status"},"date_string":{"$first":"$date_string"},"distance":{"$first":"$distance"},"end":{"$first":"$end"},"event_id":{"$first":"$event_id"},"featured":{"$first":"$featured"},"geo":{"$first":"$geo"},"group_key":{"$first":"$group_key"},"image_url":{"$first":"$image_url"},"location_string":{"$first":"$location_string"},"repeat_id":{"$first":"$repeat_id"},"search_text":{"$first":"$search_text"},"sef_tail":{"$first":"$sef_tail"},"start":{"$first":"$start"},"state":{"$first":"$state"},"tags":{"$first":"$tags"},"title":{"$first":"$title"},"town_sef_url":{"$first":"$town_sef_url"},"venue_name":{"$first":"$venue_name"},"dates":{"$push":{"start":"$start","date_string":"$date_string","sef_tail":"$sef_tail"}}}},{"$sort":{"start":1,"id":1}},{"$sort":{"start":1,"id":1}},{"$skip":0},{"$limit":15}]}, [] ).sort( {"start":1,"id":1} ).limit( 15 ).skip( 0 )015178
13db.events_cache.insert( {"key":"557ac7db72d998566efd67c9e8842452","data":[{"Event":{"_id":{"title":"Haken - 10th Anniversary Tour","venue_name":"Delmar Hall","city":"Saint Louis","state":"MO"},"id":ObjectId ("594f7aa5265c74323731cbd5"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Friday, Sep 22, 2017 at 8:00pm","distance":14.062541468005,"end":"","event_id":57821375,"featured":"","geo":[-90.296401977539,38.655200958252],"group_key":"57821375","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/f84\/098ed9de-45e7-4f9b-989f-191ee9ee9f84_108671_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Haken - 10th Anniversary Tour, Delmar Hall, 6133 Delmar Blvd., Saint Louis, ","sef_tail":"\/event\/haken-10th-anniversary-tour-2017-09-22-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506128400)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"Haken - 10th Anniversary Tour","town_sef_url":"saint-louis-mo","venue_name":"Delmar Hall","dates":[]}},{"Event":{"_id":{"title":"FC Cincinnati at Saint Louis FC","venue_name":"World Wide Technology Soccer Park","city":"Fenton","state":"MO"},"id":ObjectId ("5950cb23265c743237322f70"),"city":"Fenton","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 23, 2017 at 7:30pm","distance":7.7780339863016,"end":"","event_id":57854969,"featured":"","geo":[-90.461601257324,38.50350189209],"group_key":"57854969","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/25d\/09139288-a226-487d-a98d-6136663e325d_106551_CUSTOM.jpg","location_string":"Fenton, MO","repeat_id":"","search_text":"FC Cincinnati at Saint Louis FC, World Wide Technology Soccer Park, 1 Soccer Park Rd, Fenton, MO 63026, Fenton, ","sef_tail":"\/event\/fc-cincinnati-at-saint-louis-fc-2017-09-23-tm-fenton-mo.html","start":"MongoDate(0.00000000 1506213000)","state":"MO","tags":["ticketmaster","sports","sports-and-recreation","aarp-rec","aarp-sports"],"title":"FC Cincinnati at Saint Louis FC","town_sef_url":"fenton-mo","venue_name":"World Wide Technology Soccer Park","dates":[]}},{"Event":{"_id":{"title":"105.7 The Point Welcomes: USO Red Rock & Blue 2017 - The Revivalists","venue_name":"The Pageant","city":"Saint Louis","state":"MO"},"id":ObjectId ("595df8a12c0167f818641246"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 23, 2017 at 8:00pm","distance":13.993590208454,"end":"","event_id":58405616,"featured":"","geo":[-90.297897338867,38.655601501465],"group_key":"58405616","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/fa7\/c7bc0a47-3692-473a-8137-c68c3259cfa7_219261_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"105.7 The Point Welcomes: USO Red Rock & Blue 2017 - The Revivalists, The Pageant, 6161 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/1057-the-point-welcomes-uso-red-rock-blue-2017-the-revivalists-2017-09-23-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506214800)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"105.7 The Point Welcomes: USO Red Rock & Blue 2017 - The Revivalists","town_sef_url":"saint-louis-mo","venue_name":"The Pageant","dates":[]}},{"Event":{"_id":{"title":"105.7 The Point Presents Modern Day Zero Reunion Show","venue_name":"Delmar Hall","city":"Saint Louis","state":"MO"},"id":ObjectId ("599404fdd864a97078de9f38"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 23, 2017 at 8:00pm","distance":14.062541468005,"end":"","event_id":58733045,"featured":"","geo":[-90.296401977539,38.655200958252],"group_key":"58733045","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/fbc\/b293c0ad-c904-4215-bc59-8d7f2414dfbc_106141_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"105.7 The Point Presents Modern Day Zero Reunion Show, Delmar Hall, 6133 Delmar Blvd., Saint Louis, ","sef_tail":"\/event\/1057-the-point-presents-modern-day-zero-reunion-show-2017-09-23-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506214800)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"105.7 The Point Presents Modern Day Zero Reunion Show","town_sef_url":"saint-louis-mo","venue_name":"Delmar Hall","dates":[]}},{"Event":{"_id":{"title":"P.O.S. - F\/W 2017 RAP TOUR","venue_name":"Duck Room at Blueberry Hill","city":"Saint Louis","state":"MO"},"id":ObjectId ("5950cb24265c7432373230cd"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 23, 2017 at 9:00pm","distance":13.618815410152,"end":"","event_id":58309042,"featured":"","geo":[-90.305297851562,38.655899047852],"group_key":"58309042","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/c58\/aeed3c4d-8d76-4884-a186-14f01c3ffc58_292451_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"P.O.S. - F\/W 2017 RAP TOUR, Duck Room at Blueberry Hill, 6504 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/pos-fw-2017-rap-tour-2017-09-23-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506218400)","state":"MO","tags":["ticketmaster","music","hiphop","rap","urban","arts-and-entertainment","aarp-ae"],"title":"P.O.S. - F\/W 2017 RAP TOUR","town_sef_url":"saint-louis-mo","venue_name":"Duck Room at Blueberry Hill","dates":[]}},{"Event":{"_id":{"title":"Shiba San","venue_name":"Ryse Nightclub","city":"St. Charles","state":"MO"},"id":ObjectId ("598d6dd16c2d9e74bf67e286"),"city":"St. Charles","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 23, 2017 at 9:00pm","distance":12.359091657567,"end":"","event_id":58668214,"featured":"","geo":[-90.484397888184,38.767398834229],"group_key":"58668214","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/df8\/81eadad8-4449-412e-a2b1-3d8bbb78edf8_106181_CUSTOM.jpg","location_string":"St. Charles, MO","repeat_id":"","search_text":"Shiba San, Ryse Nightclub, One Ameristar Blvd, St. Charles, ","sef_tail":"\/event\/shiba-san-2017-09-23-tm-saint-charles-mo.html","start":"MongoDate(0.00000000 1506218400)","state":"MO","tags":["ticketmaster","music","dance","electronic","club-dance","arts-and-entertainment","aarp-ae"],"title":"Shiba San","town_sef_url":"saint-charles-mo","venue_name":"Ryse Nightclub","dates":[]}},{"Event":{"_id":{"title":"Brad Paisley: Weekend Warrior World Tour 2017","venue_name":"Hollywood Casino Amphitheatre - St. Louis, MO","city":"Maryland Heights","state":"MO"},"id":ObjectId ("59521bc28bd78c4bdff5b9ed"),"city":"Maryland Heights","cvent_id":null,"cvent_status":null,"date_string":"Sunday, Sep 24, 2017 at 7:00pm","distance":11.479569749806,"end":"","event_id":58254376,"featured":"","geo":[-90.468696594238,38.75],"group_key":"58254376","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/52b\/05239b60-799b-4a6d-aaef-32da7d69052b_279511_CUSTOM.jpg","location_string":"Maryland Heights, MO","repeat_id":"","search_text":"Brad Paisley: Weekend Warrior World Tour 2017, Hollywood Casino Amphitheatre - St. Louis, MO, 14141 Riverport Dr, Maryland Heights, ","sef_tail":"\/event\/brad-paisley-weekend-warrior-world-tour-2017-2017-09-24-tm-maryland-heights-mo.html","start":"MongoDate(0.00000000 1506297600)","state":"MO","tags":["ticketmaster","music","country","arts-and-entertainment","aarp-ae"],"title":"Brad Paisley: Weekend Warrior World Tour 2017","town_sef_url":"maryland-heights-mo","venue_name":"Hollywood Casino Amphitheatre - St. Louis, MO","dates":[]}},{"Event":{"_id":{"title":"Broken Social Scene with special guest Frightened Rabbit","venue_name":"The Pageant","city":"Saint Louis","state":"MO"},"id":ObjectId ("59521bc28bd78c4bdff5ba4a"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Sunday, Sep 24, 2017 at 8:00pm","distance":13.993590208454,"end":"","event_id":58069726,"featured":"","geo":[-90.297897338867,38.655601501465],"group_key":"58069726","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/dc6\/a35330e4-cd8f-464d-a273-34fdc132adc6_413101_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Broken Social Scene with special guest Frightened Rabbit, The Pageant, 6161 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/broken-social-scene-with-special-guest-frightened-rabbit-2017-09-24-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506301200)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"Broken Social Scene with special guest Frightened Rabbit","town_sef_url":"saint-louis-mo","venue_name":"The Pageant","dates":[]}},{"Event":{"_id":{"title":"Rhiannon Giddens","venue_name":"The Pageant","city":"Saint Louis","state":"MO"},"id":ObjectId ("59536dae8bd78c4bdff63037"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Monday, Sep 25, 2017 at 8:00pm","distance":13.993590208454,"end":"","event_id":58211734,"featured":"","geo":[-90.297897338867,38.655601501465],"group_key":"58211734","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/595\/861d810b-7ad9-456b-b93b-53f0e0ac4595_359321_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Rhiannon Giddens, The Pageant, 6161 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/rhiannon-giddens-2017-09-25-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506387600)","state":"MO","tags":["ticketmaster","music","country","arts-and-entertainment","aarp-ae"],"title":"Rhiannon Giddens","town_sef_url":"saint-louis-mo","venue_name":"The Pageant","dates":[]}},{"Event":{"_id":{"title":"Matchbox Twenty & Counting Crows: A Brief History Of Everything Tour","venue_name":"Hollywood Casino Amphitheatre - St. Louis, MO","city":"Maryland Heights","state":"MO"},"id":ObjectId ("5954bef38bd78c4bdff6ab06"),"city":"Maryland Heights","cvent_id":null,"cvent_status":null,"date_string":"Tuesday, Sep 26, 2017 at 6:45pm","distance":11.479569749806,"end":"","event_id":57710384,"featured":"","geo":[-90.468696594238,38.75],"group_key":"57710384","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/6cd\/2327d892-e3e2-4450-9dfc-dcd9c2a3a6cd_370391_CUSTOM.jpg","location_string":"Maryland Heights, MO","repeat_id":"","search_text":"Matchbox Twenty & Counting Crows: A Brief History Of Everything Tour, Hollywood Casino Amphitheatre - St. Louis, MO, 14141 Riverport Dr, Maryland Heights, ","sef_tail":"\/event\/matchbox-twenty-counting-crows-a-brief-history-of-everything-tour-2017-09-26-tm-maryland-heights-mo.html","start":"MongoDate(0.00000000 1506469500)","state":"MO","tags":["ticketmaster","music","rock","arts-and-entertainment","aarp-ae"],"title":"Matchbox Twenty & Counting Crows: A Brief History Of Everything Tour","town_sef_url":"maryland-heights-mo","venue_name":"Hollywood Casino Amphitheatre - St. Louis, MO","dates":[]}},{"Event":{"_id":{"title":"Two Door Cinema Club","venue_name":"The Pageant","city":"Saint Louis","state":"MO"},"id":ObjectId ("5954bef48bd78c4bdff6abe7"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Tuesday, Sep 26, 2017 at 8:00pm","distance":13.993590208454,"end":"","event_id":58091858,"featured":"","geo":[-90.297897338867,38.655601501465],"group_key":"58091858","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/182\/9dbcb944-fe94-4291-b1ea-6cbe20e84182_416211_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Two Door Cinema Club, The Pageant, 6161 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/two-door-cinema-club-2017-09-26-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506474000)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"Two Door Cinema Club","town_sef_url":"saint-louis-mo","venue_name":"The Pageant","dates":[]}},{"Event":{"_id":{"title":"Banditos","venue_name":"Duck Room at Blueberry Hill","city":"Saint Louis","state":"MO"},"id":ObjectId ("59648ff8057e8db2c5f9013d"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Tuesday, Sep 26, 2017 at 8:00pm","distance":13.618815410152,"end":"","event_id":58441206,"featured":"","geo":[-90.305297851562,38.655899047852],"group_key":"58441206","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/fbc\/b293c0ad-c904-4215-bc59-8d7f2414dfbc_106141_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Banditos, Duck Room at Blueberry Hill, 6504 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/banditos-2017-09-26-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506474000)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"Banditos","town_sef_url":"saint-louis-mo","venue_name":"Duck Room at Blueberry Hill","dates":[]}},{"Event":{"_id":{"title":"The Quebe Sisters","venue_name":"Duck Room at Blueberry Hill","city":"Saint Louis","state":"MO"},"id":ObjectId ("595610378bd78c4bdff72a5b"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Wednesday, Sep 27, 2017 at 8:00pm","distance":13.618815410152,"end":"","event_id":57931885,"featured":"","geo":[-90.305297851562,38.655899047852],"group_key":"57931885","image_url":"https:\/\/s1.ticketm.net\/dbimages\/54086a.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"The Quebe Sisters, Duck Room at Blueberry Hill, 6504 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/the-quebe-sisters-2017-09-27-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506560400)","state":"MO","tags":["ticketmaster","music","country","arts-and-entertainment","aarp-ae"],"title":"The Quebe Sisters","town_sef_url":"saint-louis-mo","venue_name":"Duck Room at Blueberry Hill","dates":[]}},{"Event":{"_id":{"title":"Hard Working Americans","venue_name":"Delmar Hall","city":"Saint Louis","state":"MO"},"id":ObjectId ("595610378bd78c4bdff72a88"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Wednesday, Sep 27, 2017 at 8:00pm","distance":14.062541468005,"end":"","event_id":58309049,"featured":"","geo":[-90.296401977539,38.655200958252],"group_key":"58309049","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/f63\/2a141e51-70f9-483f-b666-0dbe6e4e1f63_435771_CUSTOM.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"Hard Working Americans, Delmar Hall, 6133 Delmar Blvd., Saint Louis, ","sef_tail":"\/event\/hard-working-americans-2017-09-27-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506560400)","state":"MO","tags":["ticketmaster","music","folk","arts-and-entertainment","aarp-ae"],"title":"Hard Working Americans","town_sef_url":"saint-louis-mo","venue_name":"Delmar Hall","dates":[]}},{"Event":{"_id":{"title":"William Elliott Whitmore","venue_name":"Duck Room at Blueberry Hill","city":"Saint Louis","state":"MO"},"id":ObjectId ("598979926c2d9e74bf666ec8"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Thursday, Sep 28, 2017 at 8:00pm","distance":13.618815410152,"end":"","event_id":58644895,"featured":"","geo":[-90.305297851562,38.655899047852],"group_key":"58644895","image_url":"https:\/\/s1.ticketm.net\/dbimages\/113834a.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"William Elliott Whitmore, Duck Room at Blueberry Hill, 6504 Delmar Boulevard, Saint Louis, ","sef_tail":"\/event\/william-elliott-whitmore-2017-09-28-tm-saint-louis-mo.html","start":"MongoDate(0.00000000 1506646800)","state":"MO","tags":["ticketmaster","music","rock","pop","arts-and-entertainment","aarp-ae"],"title":"William Elliott Whitmore","town_sef_url":"saint-louis-mo","venue_name":"Duck Room at Blueberry Hill","dates":[]}}],"params":"{\"keyword\":\"\",\"tags\":\"\",\"tags_logical\":{\"$and\":[{\"tags\":\"ticketmaster\"},{\"tags\":{\"$ne\":\"alternative-and-indie\"}},{\"tags\":{\"$ne\":\"clubs-and-dance\"}},{\"tags\":{\"$ne\":\"hard-rock\"}},{\"tags\":{\"$ne\":\"metal\"}},{\"tags\":{\"$ne\":\"more-music\"}},{\"tags\":{\"$ne\":\"rap-and-hiphop\"}}]},\"terms\":\"\",\"page\":1,\"show\":15,\"show_limit\":3,\"limit\":15,\"sort\":\"\",\"days\":10,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":\"3\",\"radius\":15,\"title\":\"\",\"more\":\"yes\",\"showfeature\":\"yes\",\"link\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"care-min\":8,\"tek-min\":8,\"ds-min\":8,\"lat\":38.595100402832,\"lng\":-90.544998168945,\"latlng\":\"38.595100402832,-90.544998168945\",\"count\":22}","modified":"MongoDate(0.72500000 1506009421)","created":"MongoDate(0.72500000 1506009421)","_id":ObjectId ("59c3e14d1ac48f1e4e8ba746")} , true)0015
14db.modules.find( {"name":"Cvent New Widget Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )0111
15db.events_cache.find( {"key":"ad77790c678047591f6adda6415dd6c3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )009
16db.communities.find( {"community_id":86}, [] ).sort( [] ).limit( 1 ).skip( 0 )0124
17db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505970000)"},"town_sef_url":{"$in":["chesterfield-mo","arnold-mo","barnhart-mo","crystal-city-mo","ballwin-mo","eureka-mo","fenton-mo","festus-mo","florissant-mo","glencoe-mo","grover-mo","hazelwood-mo","bridgeton-mo","earth-city-mo","cottleville-mo","alton-il","bethalto-il","cottage-hills-il","east-alton-il","edwardsville-il","glen-carbon-il","godfrey-il","granite-city-il","hamel-il","hartford-il","lovejoy-il","madison-il","maryville-il","national-stock-yards-il","roxana-il","south-roxana-il","venice-il","wood-river-il","east-saint-louis-il","fairview-heights-il","swansea-il","shiloh-il","belleville-il","caseyville-il","collinsville-il","columbia-il","dupo-il","east-carondelet-il","millstadt-il","o-fallon-il","troy-il","maryland-heights-mo","hematite-mo","herculaneum-mo","high-ridge-mo","house-springs-mo","imperial-mo","kimmswick-mo","liguori-mo","pacific-mo","pevely-mo","saint-albans-mo","saint-ann-mo","valley-park-mo","saint-louis-mo","affton-mo","saint-charles-mo","portage-des-sioux-mo","saint-peters-mo","west-alton-mo","ellisville-mo","overland-mo","shrewsbury-mo","o-fallon-mo","sauget-il","webster-groves-mo","maplewood-mo","jennings-mo","university-city-mo","kirkwood-mo"]},"tags":"cvent_gold"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )00509
18db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505970000)"},"town_sef_url":{"$in":["chesterfield-mo","arnold-mo","barnhart-mo","crystal-city-mo","ballwin-mo","eureka-mo","fenton-mo","festus-mo","florissant-mo","glencoe-mo","grover-mo","hazelwood-mo","bridgeton-mo","earth-city-mo","cottleville-mo","alton-il","bethalto-il","cottage-hills-il","east-alton-il","edwardsville-il","glen-carbon-il","godfrey-il","granite-city-il","hamel-il","hartford-il","lovejoy-il","madison-il","maryville-il","national-stock-yards-il","roxana-il","south-roxana-il","venice-il","wood-river-il","east-saint-louis-il","fairview-heights-il","swansea-il","shiloh-il","belleville-il","caseyville-il","collinsville-il","columbia-il","dupo-il","east-carondelet-il","millstadt-il","o-fallon-il","troy-il","maryland-heights-mo","hematite-mo","herculaneum-mo","high-ridge-mo","house-springs-mo","imperial-mo","kimmswick-mo","liguori-mo","pacific-mo","pevely-mo","saint-albans-mo","saint-ann-mo","valley-park-mo","saint-louis-mo","affton-mo","saint-charles-mo","portage-des-sioux-mo","saint-peters-mo","west-alton-mo","ellisville-mo","overland-mo","shrewsbury-mo","o-fallon-mo","sauget-il","webster-groves-mo","maplewood-mo","jennings-mo","university-city-mo","kirkwood-mo"]},"tags":{"$in":["cvent","tek","careversation"]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )02522
19db.events.find( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505970000)"},"town_sef_url":{"$in":["chesterfield-mo","arnold-mo","barnhart-mo","crystal-city-mo","ballwin-mo","eureka-mo","fenton-mo","festus-mo","florissant-mo","glencoe-mo","grover-mo","hazelwood-mo","bridgeton-mo","earth-city-mo","cottleville-mo","alton-il","bethalto-il","cottage-hills-il","east-alton-il","edwardsville-il","glen-carbon-il","godfrey-il","granite-city-il","hamel-il","hartford-il","lovejoy-il","madison-il","maryville-il","national-stock-yards-il","roxana-il","south-roxana-il","venice-il","wood-river-il","east-saint-louis-il","fairview-heights-il","swansea-il","shiloh-il","belleville-il","caseyville-il","collinsville-il","columbia-il","dupo-il","east-carondelet-il","millstadt-il","o-fallon-il","troy-il","maryland-heights-mo","hematite-mo","herculaneum-mo","high-ridge-mo","house-springs-mo","imperial-mo","kimmswick-mo","liguori-mo","pacific-mo","pevely-mo","saint-albans-mo","saint-ann-mo","valley-park-mo","saint-louis-mo","affton-mo","saint-charles-mo","portage-des-sioux-mo","saint-peters-mo","west-alton-mo","ellisville-mo","overland-mo","shrewsbury-mo","o-fallon-mo","sauget-il","webster-groves-mo","maplewood-mo","jennings-mo","university-city-mo","kirkwood-mo"]},"tags":{"$in":["cvent","tek","careversation"]}}},{"$sort":{"featured":-1,"start":1,"id":1}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"},"id":{"$first":"$_id"},"city":{"$first":"$city"},"cvent_id":{"$first":"$cvent_id"},"cvent_status":{"$first":"$cvent_status"},"date_string":{"$first":"$date_string"},"distance":{"$first":"$distance"},"end":{"$first":"$end"},"event_id":{"$first":"$event_id"},"featured":{"$first":"$featured"},"geo":{"$first":"$geo"},"group_key":{"$first":"$group_key"},"image_url":{"$first":"$image_url"},"location_string":{"$first":"$location_string"},"repeat_id":{"$first":"$repeat_id"},"search_text":{"$first":"$search_text"},"sef_tail":{"$first":"$sef_tail"},"start":{"$first":"$start"},"state":{"$first":"$state"},"tags":{"$first":"$tags"},"title":{"$first":"$title"},"town_sef_url":{"$first":"$town_sef_url"},"venue_name":{"$first":"$venue_name"},"dates":{"$push":{"start":"$start","date_string":"$date_string","sef_tail":"$sef_tail"}}}},{"$sort":{"featured":-1,"start":1,"id":1}},{"$sort":{"featured":-1,"start":1,"id":1}},{"$skip":0},{"$limit":2}]}, [] ).sort( {"featured":-1,"start":1,"id":1} ).limit( 2 ).skip( 0 )0294
20db.events_cache.count( {"_id":ObjectId ("59c3e14d1ac48f1e4e8ba746")} )0111
21db.events_cache.count( {"_id":ObjectId ("59c3e14d1ac48f1e4e8ba746")} )0112
22db.events_cache.update( {"_id":ObjectId ("59c3e14d1ac48f1e4e8ba746")}, {"$set":{"key":"ad77790c678047591f6adda6415dd6c3","data":[{"Event":{"_id":{"title":"AARP MISSOURI'S Free Screening of Mark Felt\u2014The Man Who Brought Down the White House - St Charles","venue_name":"Wehrenberg St. Charles Stadium 18 Cinema","city":"St Charles","state":"MO"},"id":ObjectId ("59bae26d25afd816715fb710"),"city":"St Charles","cvent_id":"C604A83B-7D61-455C-8C03-E3018D38A102","cvent_status":"Closed","date_string":"Thursday, Sep 21, 2017 at 7:00pm","distance":null,"end":"MongoDate(0.00000000 1506049200)","event_id":null,"featured":false,"geo":[-90.5267521,38.7625474],"group_key":"C604A83B-7D61-455C-8C03-E3018D38A102","image_url":"https:\/\/local-aarp-americantownscom.netdna-ssl.com\/img\/template\/icons\/mfg-thumb.png","location_string":"St Charles, MO","repeat_id":"C604A83B-7D61-455C-8C03-E3018D38A102","search_text":"AARP MISSOURI'S Free Screening of Mark Felt\u2014The Man Who Brought Down the White House - St Charles Wehrenberg St. Charles Stadium 18 Cinema 1830 S 1st Capitol Dr St Charles styletextalign centerspan stylefontfamily helvetica arial sansserif fontsize pxsrchttpscustomcventcomacefebdaebabeacepixfffedcfbcadaaaajpg altmark felt styleborder solid ffffff width px height spanppspan pxspan stylefontsize pxselect aarp members guest invited free prerelease screening strongemmark feltbrought down white houseemstrong starring liam neeson diane lanenbspspanspanppspan sansserifbased true story most famous anonymous american history mark secondincommand deep throat whistleblowernbsps watergate scandal spanspanppspan sansserifthis film rated pgsome languageemnbspemspandonmiss chance join this screeningnbspspanppspan pxspanpdivnbspdiv","sef_tail":"\/aarp-event\/aarp-missouris-free-screening-of-mark-feltthe-man-who-brought-down-the-white-house-st-charles-XKNVBK34HH7.html","start":"MongoDate(0.00000000 1506038400)","state":"MO","tags":["cvent","mfg"],"title":"AARP MISSOURI'S Free Screening of Mark Felt\u2014The Man Who Brought Down the White House - St Charles","town_sef_url":"saint-peters-mo","venue_name":"Wehrenberg St. Charles Stadium 18 Cinema","dates":[]}},{"Event":{"_id":{"title":"Visit the AARP booth at the St. Charles Home Show","venue_name":"St. Charles Convention Center","city":"St. Charles","state":"MO"},"id":ObjectId ("59b1c8b8a28392aad3219d9c"),"city":"St. Charles","cvent_id":"666526F1-3552-4B17-903F-C53668B64EDE","cvent_status":"","date_string":"Friday, Sep 22, 2017 at 11:00am","distance":null,"end":"MongoDate(0.00000000 1506290400)","event_id":null,"featured":false,"geo":[-90.5024297,38.7696837],"group_key":"666526F1-3552-4B17-903F-C53668B64EDE","image_url":"https:\/\/local-aarp-americantownscom.netdna-ssl.com\/img\/template\/icons\/aarp_event_classic.png","location_string":"St. Charles, MO","repeat_id":"666526F1-3552-4B17-903F-C53668B64EDE","search_text":"Visit the AARP booth at the St. Charles Home Show St. Charles Convention Center One Convention Center Plaza St. Charles styletextalign centerspan stylefontsize px fontfamily arial sansserifvisit aarp booth home show september members show their membership card will receive free giftspanp","sef_tail":"\/aarp-event\/aarp-st-louis-at-the-home-show-st-charles-mo-92217-ZKN3Y84P3J6.html","start":"MongoDate(0.00000000 1506096000)","state":"MO","tags":["cvent"],"title":"Visit the AARP booth at the St. Charles Home Show","town_sef_url":"saint-peters-mo","venue_name":"St. Charles Convention Center","dates":[]}}],"params":"{\"keyword\":false,\"tags\":{\"$in\":[\"cvent\",\"tek\",\"careversation\"]},\"tags_logical\":\"\",\"terms\":\"\",\"page\":1,\"show\":2,\"show_limit\":3,\"limit\":15,\"sort\":\"\",\"days\":\"\",\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"radius\":0,\"title\":\"Upcoming AARP Event\",\"more\":\"yes\",\"showfeature\":\"yes\",\"link\":\"\",\"see-more-title\":\"\",\"searchdate\":false,\"care-min\":8,\"tek-min\":8,\"ds-min\":8,\"lat\":38.595100402832,\"lng\":-90.544998168945,\"latlng\":\"38.595100402832,-90.544998168945\",\"view\":\"cvents\",\"featured_first\":true,\"community\":{\"$in\":[\"chesterfield-mo\",\"arnold-mo\",\"barnhart-mo\",\"crystal-city-mo\",\"ballwin-mo\",\"eureka-mo\",\"fenton-mo\",\"festus-mo\",\"florissant-mo\",\"glencoe-mo\",\"grover-mo\",\"hazelwood-mo\",\"bridgeton-mo\",\"earth-city-mo\",\"cottleville-mo\",\"alton-il\",\"bethalto-il\",\"cottage-hills-il\",\"east-alton-il\",\"edwardsville-il\",\"glen-carbon-il\",\"godfrey-il\",\"granite-city-il\",\"hamel-il\",\"hartford-il\",\"lovejoy-il\",\"madison-il\",\"maryville-il\",\"national-stock-yards-il\",\"roxana-il\",\"south-roxana-il\",\"venice-il\",\"wood-river-il\",\"east-saint-louis-il\",\"fairview-heights-il\",\"swansea-il\",\"shiloh-il\",\"belleville-il\",\"caseyville-il\",\"collinsville-il\",\"columbia-il\",\"dupo-il\",\"east-carondelet-il\",\"millstadt-il\",\"o-fallon-il\",\"troy-il\",\"maryland-heights-mo\",\"hematite-mo\",\"herculaneum-mo\",\"high-ridge-mo\",\"house-springs-mo\",\"imperial-mo\",\"kimmswick-mo\",\"liguori-mo\",\"pacific-mo\",\"pevely-mo\",\"saint-albans-mo\",\"saint-ann-mo\",\"valley-park-mo\",\"saint-louis-mo\",\"affton-mo\",\"saint-charles-mo\",\"portage-des-sioux-mo\",\"saint-peters-mo\",\"west-alton-mo\",\"ellisville-mo\",\"overland-mo\",\"shrewsbury-mo\",\"o-fallon-mo\",\"sauget-il\",\"webster-groves-mo\",\"maplewood-mo\",\"jennings-mo\",\"university-city-mo\",\"kirkwood-mo\"]}}","modified":"MongoDate(0.56200000 1506009422)"}}, {"multiple":false} )0012
23db.modules.find( {"name":"HP - Blog - Learn More"}, [] ).sort( [] ).limit( 1 ).skip( 0 )0116
24db.modules.find( {"name":"Navbar AARPe"}, [] ).sort( [] ).limit( 1 ).skip( 0 )0122