| 1 | db.towns.find( {"sef_url":"conover-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"charlestown-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"charlestown-ri","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-71.64099884033203,41.385501861572266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"RI"}}},{"$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(1769746426450)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769746426450)","$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 | 111 |
| 11 | db.ttd_towns.find( {"town_sef_url":"charlestown-ri","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"f5047de827bb8401fa1b5267b116a3ad"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770357599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 9 |
| 15 | db.events_cache.count( {"_id":"f5047de827bb8401fa1b5267b116a3ad"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"f5047de827bb8401fa1b5267b116a3ad"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"f5047de827bb8401fa1b5267b116a3ad","town_sef_url":"charlestown-ri","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.61100000 1769746426)","created":"MongoDate(0.61100000 1769746426)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"24e6e1400ba60120223031941e13a563"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770616799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 1 | 9 |
| 20 | db.events_cache.count( {"_id":"24e6e1400ba60120223031941e13a563"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"24e6e1400ba60120223031941e13a563"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"24e6e1400ba60120223031941e13a563","town_sef_url":"charlestown-ri","data_key":["68dde221c3af739f25c57898"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.64500000 1769746426)","created":"MongoDate(0.64500000 1769746426)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"4251749c68b9bb96d63692607243ef37"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770357599)"},"event_id":{"$nin":[76203185]},"tags":"music","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 3 |
| 25 | db.events_cache.count( {"_id":"4251749c68b9bb96d63692607243ef37"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"4251749c68b9bb96d63692607243ef37"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"4251749c68b9bb96d63692607243ef37","town_sef_url":"charlestown-ri","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.66700000 1769746426)","created":"MongoDate(0.66700000 1769746426)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"1ef30509bb2d97fe23ad6805982c527a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770962399)"},"event_id":{"$nin":[76203185]},"tags":"music","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 2 | 5 |
| 30 | db.events_cache.count( {"_id":"1ef30509bb2d97fe23ad6805982c527a"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"1ef30509bb2d97fe23ad6805982c527a"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"1ef30509bb2d97fe23ad6805982c527a","town_sef_url":"charlestown-ri","data_key":["6906f8d9de4ae56f5a377685"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":true}","modified":"MongoDate(0.69100000 1769746426)","created":"MongoDate(0.69100000 1769746426)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"cd1dffdf6455cab8bbd6af54dbb7b983"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770011999)"},"event_id":{"$nin":[76203185,76292334]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 1 |
| 35 | db.events_cache.count( {"_id":"cd1dffdf6455cab8bbd6af54dbb7b983"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"cd1dffdf6455cab8bbd6af54dbb7b983"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"cd1dffdf6455cab8bbd6af54dbb7b983","town_sef_url":"charlestown-ri","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.70600000 1769746426)","created":"MongoDate(0.70600000 1769746426)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"184438e087811b18374bb606bc779e22"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1772344799)"},"event_id":{"$nin":[76203185,76292334]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.8695652173913043]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 1 |
| 40 | db.events_cache.count( {"_id":"184438e087811b18374bb606bc779e22"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"184438e087811b18374bb606bc779e22"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"184438e087811b18374bb606bc779e22","town_sef_url":"charlestown-ri","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.72200000 1769746426)","created":"MongoDate(0.72200000 1769746426)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"4630a061317d40ef763292b2b33b8819"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770184799)"},"event_id":{"$nin":[76203185,76292334]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 13 |
| 45 | db.events_cache.count( {"_id":"4630a061317d40ef763292b2b33b8819"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"4630a061317d40ef763292b2b33b8819"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"4630a061317d40ef763292b2b33b8819","town_sef_url":"charlestown-ri","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":false}","modified":"MongoDate(0.75900000 1769746426)","created":"MongoDate(0.75900000 1769746426)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"96d5e24641b73ea7ec773d46095b14a9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1771048799)"},"event_id":{"$nin":[76203185,76292334]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 2 | 28 |
| 50 | db.events_cache.count( {"_id":"96d5e24641b73ea7ec773d46095b14a9"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"96d5e24641b73ea7ec773d46095b14a9"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"96d5e24641b73ea7ec773d46095b14a9","town_sef_url":"charlestown-ri","data_key":["68d40665c3af739f2529bf31"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":true}","modified":"MongoDate(0.81900000 1769746426)","created":"MongoDate(0.81900000 1769746426)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"b041291b099133e619201ebaa00aec80"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1771567199)"},"event_id":{"$nin":[76203185,76292334,76185691]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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 | 51 | 9 |
| 55 | db.events_cache.count( {"_id":"b041291b099133e619201ebaa00aec80"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"b041291b099133e619201ebaa00aec80"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"b041291b099133e619201ebaa00aec80","town_sef_url":"charlestown-ri","data_key":["69757e98b1faf7c56a25e915","68bb9b27c3af739f2533aa7b","68911579fb5e4bed1fbe480f","68ca1ba4c3af739f25d82158","68db3f22c3af739f25854a48","69718d9db1faf7c56a497c15","68c8ca22c3af739f25291e77","6930f093de4ae56f5aa6eee8","690ab51fde4ae56f5a841727","690ea998de4ae56f5ac28703","69684f9ab1faf7c56a24a683","689ab73ffb5e4bed1fdedd0a","68c0e125c3af739f253dd04f","695dc38db1faf7c56a6c0ab7","68911579fb5e4bed1fbe4bd2","68b10f29c3af739f25c5cbc7","68ba49aac3af739f257d88ff","68bf8fa6c3af739f25b380eb","68c0e125c3af739f253dd0cf","68ca1ba4c3af739f25d8219e","68d204a6c3af739f25f529da","68e5cb20c3af739f25c78543","68f2fa20c3af739f2533e18d","69193596de4ae56f5a26a465","69251314de4ae56f5a252931","6954890ede4ae56f5a81738c","68941fc1fb5e4bed1fb9496c","68b6552bc3af739f25c02a17","68911579fb5e4bed1fbe4c70","689eabbefb5e4bed1f7b3f71","68e4799fc3af739f25a9dfe1","68c8ca22c3af739f25291ec4","68d204a6c3af739f25f52a2a","68db3f22c3af739f25854a7b","68e71ca1c3af739f25e5a197","690ea998de4ae56f5ac2873d","69266494de4ae56f5ae48fb6","692a5914de4ae56f5a9b7e67","6969a117b1faf7c56adbec1d","693a2b13de4ae56f5a8b0bfe","695b208fde4ae56f5a081254","69757e98b1faf7c56a25e9a7","68bf8fa6c3af739f25b38146","690ab51fde4ae56f5a8417ae","692f9f13de4ae56f5a523585","695c720ede4ae56f5a665131","695dc38db1faf7c56a6c0b21","68d4a7a5c3af739f25451c69","68bf8fa6c3af739f25b38156","6913ef96de4ae56f5a16bb6b"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-71.64099884033203,41.385501861572266],\"has_next_page\":true}","modified":"MongoDate(0.84900000 1769746426)","created":"MongoDate(0.84900000 1769746426)"} , true) | | 0 | 0 | 1 |
| 58 | 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\/ri-state-parks-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/state-parks\/\" target=\"_blank\">10 Best State Parks in Rhode Island<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/state-parks\/\" target=\"_blank\">Burlingame State Park, Charlestown, RI <\/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\">Perhaps the most rustic and certainly the largest of the parks featured here, this 3,100-acre park consists of the rocky woodlands that envelop Watchaug Pond. Featuring a tucked-away campground with… <a href=\"https:\/\/bestthingsri.com\/state-parks\/\" 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\/ri-camping-spots-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/camping\/\" target=\"_blank\">The 15 Best Camping Spots in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/camping\/\" target=\"_blank\">Burlingame State Park and Campground, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">This campground can be found right next to Watchuag Pond in Charlestown, a scenic little body of water hidden in miles of rocky forest area. They offer 50 fireplaces, toilets, have clean drinking… <a href=\"https:\/\/bestthingsri.com\/camping\/\" 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\/ri-offbeat-attractions-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/unusual-attractions\/\" target=\"_blank\">8 of the Best (and Most Offbeat) Attractions in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/unusual-attractions\/\" target=\"_blank\">The Fantastic Umbrella Factory, Charlestown, RI<\/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\">This magical farm and bazaar dates to the 19th century. At this peculiar market, you’ll find an odd collection of goodies, including Peruvian instruments and dashboard hula girls. Employees… <a href=\"https:\/\/bestthingsri.com\/unusual-attractions\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-crab-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/crab-restaurants\/\" target=\"_blank\">9 Best Places for Crab in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/crab-restaurants\/\" target=\"_blank\">Nordic Lodge, Charlestown, RI<\/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\">Eat away at some giant king crab legs at the Nordic Lodge—a classic New England seafood restaurant located in Charlestown. The meat is so perfectly juicy and delicious that you’ll need to… <a href=\"https:\/\/bestthingsri.com\/crab-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\/ri-nature-centers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\">8 Best Nature Centers in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\">Frosty Drew Observatory & Science Center, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">This property was given to the town of Charlestown after a U.S. Naval Landing Field was closed in 1973. It now serves to educate community members of all ages about nature, in particular marine… <a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-buffets-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/buffets\/\" target=\"_blank\">The 8 Best Buffets in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/buffets\/\" target=\"_blank\">The Nordic Lodge, Charlestown, RI<\/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\">So, let’s be clear. There are buffets, and then there are seafood buffets. Get unlimited amounts of succulent lobster, delicate crab, shrimp, scallops, oysters, and more. Seriously, we are… <a href=\"https:\/\/bestthingsri.com\/buffets\/\" 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\/ri-speakeasies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\">Best Speakeasies in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\">Charlestown Rathskeller, Charlestown, RI<\/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\">The Rathskeller has put a great deal of effort into restoring the building that once housed a speakeasy in the back woods of Charlestown. Now, the restaurant is open seven days a week for lunch and… <a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-hardware-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\">8 Best Hardware Stores in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\">Compass Hardware, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\"><p>You’ll be guaranteed to find a good deal at this independent hardware store! Come here for home supplies, contractor supplies, and coal and propane, which they can even deliver!<\/p> <a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-historic-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/historic-restaurants\/\" target=\"_blank\">8 Best Historic Restaurants in Rhode Island<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/historic-restaurants\/\" target=\"_blank\">The Charlestown Rathskeller, Charlestown, RI <\/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\">Almost a century old, the Charlestown Rathskeller brings with it all of the allure and intrigue of the past. This traditional speakeasy features recently restored 80-year-old murals and a… <a href=\"https:\/\/bestthingsri.com\/historic-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\/ri-italian-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/italian-restaurants\/\" target=\"_blank\">8 Best Italian Restaurants in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/italian-restaurants\/\" target=\"_blank\">Pasquale\u2019s Pizzeria Napoletana, Wakefield, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,hybrid,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Pasquela’s is the place to choose if you want an exquisite pizza. They serve thin-crust Neapolitan-style pizza straight from a wood-burning oven. Pasquela’s imports all ingredients from… <a href=\"https:\/\/bestthingsri.com\/italian-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<\/div>\n<\/div>\n\n\n","town_sef_url":"charlestown-ri","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_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769753626,"type":"Event","id":76203185,"title":"Rhode Island Rams Mens Basketball vs. Richmond Spiders Mens Basketball","url":"\/event\/rhode-island-rams-mens-basketball-vs-richmond-spiders-mens-basketball-2026-02-07-tm-narragansett-ri.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/197485a.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1769753626,"type":"Event","id":76292334,"title":"Joe Samba","url":"\/event\/joe-samba-2026-02-07-jb-south-kingstown-ri.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2023\/01\/joe-sambo-980x551.png"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"15\",\"days\":\"15\",\"ttl\":\"2\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1769753626,"type":"Event","id":76185691,"title":"Corvettes \u2013 Doo Wop Revue 2\/6\/26 FRI 7PM","url":"\/event\/corvettes-doo-wop-revue-2626-fri-7pm-2026-02-06-west-kingston-ri.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769760826,"type":"Event","id":76128741,"title":"Boston College Eagles Womens Basketball vs. North Carolina State Wolfpack Womens Basketball","url":"\/event\/boston-college-eagles-womens-basketball-vs-north-carolina-state-wolfpack-womens-basketball-2026-01-29-tm-chicago-il.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/2b6\/d9286366-4993-4fc8-afba-31b793e862b6_SOURCE"}],"modified":"MongoDate(0.85200000 1769746426)","created":"MongoDate(0.85200000 1769746426)","_id":ObjectId ("697c2ffa9ec14795540a826f")} , true) | | 0 | 0 | 1 |
| 59 | db.events_cache.find( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 60 | db.events_radius_cache.find( {"_id":"c7a00d5ed78f8353749c2514527335c0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 61 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"event_id":{"$nin":[76203185,76292334,76185691,76128741]},"geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 173 |
| 62 | db.events_cache.count( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"} ) | | 0 | 0 | 1 |
| 63 | db.events_cache.count( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"} ) | | 0 | 0 | 1 |
| 64 | db.events_cache.insert( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9","town_sef_url":"charlestown-ri","data_key":["68d204a6c3af739f25f52a2a","68db3f22c3af739f25854a7b","6930f093de4ae56f5aa6efc5","6954890fde4ae56f5a817515","692e4d94de4ae56f5ae93500"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Charlestown\",\"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\":41.385501861572266,\"lng\":-71.64099884033203,\"latlng\":\"41.385501861572,-71.640998840332\",\"city\":\"Charlestown\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.06500000 1769746427)","created":"MongoDate(0.06500000 1769746427)"} , true) | | 0 | 0 | 1 |
| 65 | db.news.find( {"broadcast":{"$in":["usa","charlestown-ri","ri","washington-county-ri"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 66 | db.places.find( {"address.town_sef_url":"charlestown-ri","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 67 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 68 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 69 | db.towns.find( {"sef_url":"charlestown-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 70 | db.tokens.find( {"sef_url":{"$in":["usa","ri","washington-county-ri","charlestown-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 71 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 72 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 73 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 74 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 75 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 76 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 77 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
