| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-78.13069915771484,37.18170166015625],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765692000)"}}}},{"$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"},"time_string":{"$first":"$time_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 ) | | 0 | 5 | 25 |
| 11 | db.events_cache.insert( {"_id":"245b90f5040950b780f7955a56678afe","data":[{"Event":{"_id":{"title":"Chester, VA Farmer's Market","venue_name":"","city":"Chester","state":"VA"},"id":ObjectId ("687938e3384bf9134e018a0c"),"city":"Chester","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 20, 2025 at 9:00am","time_string":"9:00 AM","distance":39.03292165160374,"end":"MongoDate(0.00000000 1766235600)","event_id":74835099,"featured":"","geo":[-77.44950103759766,37.338199615478516],"group_key":"3201471","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Chester, VA","repeat_id":"3201471","search_text":"Chester, VA Farmer's Market, , 11700 Chester Village Drive, Chester, season year round market hours every saturday location chester village drive","sef_tail":"\/event\/chester-va-farmers-market-2025-12-20-chester-va.html","start":"MongoDate(0.00000000 1766221200)","state":"VA","tags":["farmers-market","step-outside","aarp","open-year-round","clubs-and-organizations"],"title":"Chester, VA Farmer's Market","town_sef_url":"chester-va","venue_name":"","dates":{"1":{"start":"MongoDate(0.00000000 1766826000)","date_string":"Saturday, Dec 27, 2025 at 9:00am","sef_tail":"\/event\/chester-va-farmers-market-2025-12-27-chester-va.html"}}}},{"Event":{"_id":{"title":"Colonial Heights Farmers Market","venue_name":"","city":"Colonial Heights","state":"VA"},"id":ObjectId ("687938e3384bf9134e018aea"),"city":"Colonial Heights","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 20, 2025 at 9:00am","time_string":"9:00 AM","distance":41.19077005711623,"end":"MongoDate(0.00000000 1766232000)","event_id":74835567,"featured":"","geo":[-77.39440155029297,37.286399841308594],"group_key":"3201486","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Colonial Heights, VA","repeat_id":"3201486","search_text":"Colonial Heights Farmers Market, , 2600 Boulevard, Colonial Heights, season year round market hours every saturday pm locationnbsp boulevard","sef_tail":"\/event\/colonial-heights-farmers-market-2025-12-20-colonial-heights-va.html","start":"MongoDate(0.00000000 1766221200)","state":"VA","tags":["farmers-market","step-outside","aarp","open-year-round","clubs-and-organizations"],"title":"Colonial Heights Farmers Market","town_sef_url":"colonial-heights-va","venue_name":"","dates":{"1":{"start":"MongoDate(0.00000000 1766826000)","date_string":"Saturday, Dec 27, 2025 at 9:00am","sef_tail":"\/event\/colonial-heights-farmers-market-2025-12-27-colonial-heights-va.html"}}}},{"Event":{"_id":{"title":"River Street Market","venue_name":"","city":"Petersburg","state":"VA"},"id":ObjectId ("687938e4384bf9134e018e92"),"city":"Petersburg","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 20, 2025 at 9:00am","time_string":"9:00 AM","distance":37.25764590346281,"end":"MongoDate(0.00000000 1766232000)","event_id":74842262,"featured":"","geo":[-77.45570373535156,37.21390151977539],"group_key":"3201644","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Petersburg, VA","repeat_id":"3201644","search_text":"River Street Market, , Old Towne Petersburg, 30 River Street, Petersburg, seasonnbspyear round market hoursnbsp saturdays pm locationnbsptowne petersburg river street","sef_tail":"\/event\/river-street-market-2025-12-20-petersburg-va.html","start":"MongoDate(0.00000000 1766221200)","state":"VA","tags":["farmers-market","step-outside","aarp","open-year-round","clubs-and-organizations"],"title":"River Street Market","town_sef_url":"petersburg-va","venue_name":"","dates":{"1":{"start":"MongoDate(0.00000000 1766826000)","date_string":"Saturday, Dec 27, 2025 at 9:00am","sef_tail":"\/event\/river-street-market-2025-12-27-petersburg-va.html"}}}},{"Event":{"_id":{"title":"Cumberland County Farmers and Artisans Market","venue_name":"LPJ Community Center","city":"Cumberland","state":"VA"},"id":ObjectId ("68793934384bf9134e02db5c"),"city":"Cumberland","cvent_id":null,"cvent_status":null,"date_string":"Sunday, Dec 21, 2025 at 1:00pm","time_string":"1:00 PM","distance":22.21488531858929,"end":"MongoDate(0.00000000 1766340000)","event_id":75811562,"featured":"","geo":[-78.2796475,37.4802255],"group_key":"3215130","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Cumberland, VA","repeat_id":"3215130","search_text":"Cumberland County Farmers and Artisans Market, LPJ Community Center, 1874 Anderson Highway, Cumberland, seasonnbspyear round market hours sundays locationnbspcommunity center elementary school anderson highway","sef_tail":"\/event\/cumberland-county-farmers-and-artisans-market-2025-12-21-cumberland-va.html","start":"MongoDate(0.00000000 1766322000)","state":"VA","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","2025-updated"],"title":"Cumberland County Farmers and Artisans Market","town_sef_url":"cumberland-va","venue_name":"LPJ Community Center","dates":[]}},{"Event":{"_id":{"title":"Virginia Ducks Unlimited Volunteer Celebration","venue_name":"","city":"Doswell","state":"VA"},"id":ObjectId ("687941527db01079a505e1c3"),"city":"Doswell","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Feb 28, 2026 at 4:00pm","time_string":null,"distance":37.72310600962719,"end":"","event_id":null,"featured":"","geo":[-78.21440124511719,37.722999572753906],"group_key":null,"image_url":"https:\/\/cdn-step.americantowns.com\/img\/ducks.png","location_string":"The Meadow Pavilion","repeat_id":null,"search_text":"Virginia Ducks Unlimited Volunteer Celebration The Meadow Pavilion","sef_tail":"\/du-event\/virginia-ducks-unlimited-volunteer-celebration-106641.html","start":"MongoDate(0.00000000 1772294400)","state":"VA","tags":["ducks"],"title":"Virginia Ducks Unlimited Volunteer Celebration","town_sef_url":"doswell-va","venue_name":"","dates":[]}}],"params":"{\"title\":\"Events Near Crewe VA\",\"keyword\":\"\",\"radius\":45,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show\":15,\"show_limit\":3,\"sort\":\"\",\"days\":365,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"\",\"min\":20,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"more\":\"yes\",\"autoshowmore\":\"no\",\"link\":\"\",\"showdesc\":\"yes\",\"rankby\":\"distance\",\"type\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"lat\":37.18170166015625,\"lng\":-78.13069915771484,\"latlng\":\"37.181701660156,-78.130699157715\",\"count\":1}","modified":"MongoDate(0.18700000 1765697210)","created":"MongoDate(0.18700000 1765697210)"} , true) | | 0 | 0 | 3 |
