| 1 | db.towns.find( {"sef_url":"summerville-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 60 |
| 3 | db.towns.find( {"sef_url":"saint-john-wa"}, [] ).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 | 10 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 16 |
| 6 | db.ttd_towns.find( {"town_sef_url":"saint-john-wa","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 65 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 50 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 50 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 44 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-117.58399963378906,47.09239959716797],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"WA"}}},{"$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(1766341855214)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766341855214)","$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 | 75 |
| 11 | db.ttd_towns.find( {"town_sef_url":"saint-john-wa","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 25 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 86 |
| 13 | db.events_cache.find( {"_id":"997f77120fa95fe541ddd459d984f435"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766987999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 52 |
| 15 | db.events_cache.count( {"_id":"997f77120fa95fe541ddd459d984f435"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"997f77120fa95fe541ddd459d984f435"} ) | | 0 | 0 | 2 |
| 17 | db.events_cache.insert( {"_id":"997f77120fa95fe541ddd459d984f435","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.75700000 1766341855)","created":"MongoDate(0.75700000 1766341855)"} , true) | | 0 | 0 | 8 |
| 18 | db.events_cache.find( {"_id":"b13c4257578abf17885ce020abec169c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 4 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767247199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 181 |
| 20 | db.events_cache.count( {"_id":"b13c4257578abf17885ce020abec169c"} ) | | 0 | 0 | 33 |
| 21 | db.events_cache.count( {"_id":"b13c4257578abf17885ce020abec169c"} ) | | 0 | 0 | 5 |
| 22 | db.events_cache.insert( {"_id":"b13c4257578abf17885ce020abec169c","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.19300000 1766341856)","created":"MongoDate(0.19300000 1766341856)"} , true) | | 0 | 0 | 10 |
| 23 | db.events_cache.find( {"_id":"ec7c3a38985deb61c6977ff9b4c350f6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1768975199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 218 |
| 25 | db.events_cache.count( {"_id":"ec7c3a38985deb61c6977ff9b4c350f6"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"ec7c3a38985deb61c6977ff9b4c350f6"} ) | | 0 | 0 | 4 |
| 27 | db.events_cache.insert( {"_id":"ec7c3a38985deb61c6977ff9b4c350f6","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.69800000 1766341856)","created":"MongoDate(0.69800000 1766341856)"} , true) | | 0 | 0 | 10 |
| 28 | db.events_cache.find( {"_id":"853066657ff906b3783811b7f90bf5d9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 5 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766987999)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 4 |
| 30 | db.events_cache.count( {"_id":"853066657ff906b3783811b7f90bf5d9"} ) | | 0 | 0 | 6 |
| 31 | db.events_cache.count( {"_id":"853066657ff906b3783811b7f90bf5d9"} ) | | 0 | 0 | 10 |
| 32 | db.events_cache.insert( {"_id":"853066657ff906b3783811b7f90bf5d9","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.79800000 1766341856)","created":"MongoDate(0.79800000 1766341856)"} , true) | | 0 | 0 | 10 |
| 33 | db.events_cache.find( {"_id":"d3cbc8be4ca744ad6cc2ffd8c4f36036"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767592799)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 |
| 35 | db.events_cache.count( {"_id":"d3cbc8be4ca744ad6cc2ffd8c4f36036"} ) | | 0 | 0 | 30 |
| 36 | db.events_cache.count( {"_id":"d3cbc8be4ca744ad6cc2ffd8c4f36036"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"d3cbc8be4ca744ad6cc2ffd8c4f36036","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.93900000 1766341856)","created":"MongoDate(0.93900000 1766341856)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"c424f95603b232626728e60e8f001e44"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766642399)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 2 |
| 40 | db.events_cache.count( {"_id":"c424f95603b232626728e60e8f001e44"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"c424f95603b232626728e60e8f001e44"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"c424f95603b232626728e60e8f001e44","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.96200000 1766341856)","created":"MongoDate(0.96200000 1766341856)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"073ce145469bd8b9c4a5338150174a27"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1768975199)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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":"073ce145469bd8b9c4a5338150174a27"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"073ce145469bd8b9c4a5338150174a27"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"073ce145469bd8b9c4a5338150174a27","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.01000000 1766341857)","created":"MongoDate(0.01000000 1766341857)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"99409d04c0e7753926089a4917c988b8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766815199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 12 |
| 50 | db.events_cache.count( {"_id":"99409d04c0e7753926089a4917c988b8"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"99409d04c0e7753926089a4917c988b8"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"99409d04c0e7753926089a4917c988b8","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.05100000 1766341857)","created":"MongoDate(0.05100000 1766341857)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"1e0f5890fc7edb84dc397c783e8f3e4d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767679199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 35 |
| 55 | db.events_cache.count( {"_id":"1e0f5890fc7edb84dc397c783e8f3e4d"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"1e0f5890fc7edb84dc397c783e8f3e4d"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"1e0f5890fc7edb84dc397c783e8f3e4d","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.13000000 1766341857)","created":"MongoDate(0.13000000 1766341857)"} , true) | | 0 | 0 | 1 |
| 58 | db.events_cache.find( {"_id":"b07c474a6d7e18039898f876046dc044"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767679199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 0 | 30 |
| 60 | db.events_cache.count( {"_id":"b07c474a6d7e18039898f876046dc044"} ) | | 0 | 0 | 1 |
| 61 | db.events_cache.count( {"_id":"b07c474a6d7e18039898f876046dc044"} ) | | 0 | 0 | 1 |
| 62 | db.events_cache.insert( {"_id":"b07c474a6d7e18039898f876046dc044","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.20700000 1766341857)","created":"MongoDate(0.20700000 1766341857)"} , true) | | 0 | 0 | 5 |
| 63 | db.events_cache.find( {"_id":"a06b5682464b9a541488eb3e0694f26d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 64 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767679199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],0.6521739130434783]}}}, ["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 | 30 |
| 65 | db.events_cache.count( {"_id":"a06b5682464b9a541488eb3e0694f26d"} ) | | 0 | 0 | 1 |
| 66 | db.events_cache.count( {"_id":"a06b5682464b9a541488eb3e0694f26d"} ) | | 0 | 0 | 1 |
| 67 | db.events_cache.insert( {"_id":"a06b5682464b9a541488eb3e0694f26d","town_sef_url":"saint-john-wa","data_key":["68afbdaec3af739f253699ff"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"45\",\"days\":\"15\",\"show\":1,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":true}","modified":"MongoDate(0.27000000 1766341857)","created":"MongoDate(0.27000000 1766341857)"} , true) | | 0 | 0 | 1 |
| 68 | db.events_cache.find( {"_id":"fcbbf22bcf3192ad6bfc1efb5ed422ae"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 69 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1768197599)"},"event_id":{"$nin":[76102195]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 9 | 37 |
| 70 | db.events_cache.count( {"_id":"fcbbf22bcf3192ad6bfc1efb5ed422ae"} ) | | 0 | 0 | 1 |
| 71 | db.events_cache.count( {"_id":"fcbbf22bcf3192ad6bfc1efb5ed422ae"} ) | | 0 | 0 | 16 |
| 72 | db.events_cache.insert( {"_id":"fcbbf22bcf3192ad6bfc1efb5ed422ae","town_sef_url":"saint-john-wa","data_key":["68c0e124c3af739f253dc72d","691fcd19de4ae56f5a67e96c","69421410de4ae56f5ac6a4ad","6938d994de4ae56f5aaa9731","68c0e125c3af739f253dc93e","68c0e125c3af739f253dc9b8","68cb6d27c3af739f2584baef","68cb6d27c3af739f2584bb21","68cb6d27c3af739f2584bb9e"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.43000000 1766341857)","created":"MongoDate(0.43000000 1766341857)"} , true) | | 0 | 0 | 10 |
| 73 | db.events_cache.find( {"_id":"5a70434daa14bd6a02d54a1935930cf0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 8 |
| 74 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1768197599)"},"event_id":{"$nin":[76102195,76165386]},"tags":"music","geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 17 |
| 75 | db.events_cache.count( {"_id":"5a70434daa14bd6a02d54a1935930cf0"} ) | | 0 | 0 | 8 |
| 76 | db.events_cache.count( {"_id":"5a70434daa14bd6a02d54a1935930cf0"} ) | | 0 | 0 | 28 |
| 77 | db.events_cache.insert( {"_id":"5a70434daa14bd6a02d54a1935930cf0","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-117.58399963378906,47.09239959716797],\"has_next_page\":false}","modified":"MongoDate(0.58100000 1766341857)","created":"MongoDate(0.58100000 1766341857)"} , true) | | 0 | 0 | 1 |
| 78 | db.places.find( {"geo":{"$near":[-117.58399963378906,47.09239959716797],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 1 | 10 |
| 79 | 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\/wa-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/restaurants\/\" target=\"_blank\">11 Best Restaurants in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/restaurants\/\" target=\"_blank\">The Black Cypress, Pullman, WA<\/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\">For an eclectic blend of Greek and Italian food, try the Black Cypress in Pullman. The restaurant is a standout in an area that isn't notable for its eateries. Especially popular are the cheese… <a href=\"https:\/\/bestthingswa.com\/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\/wa-fries-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/fries\/\" target=\"_blank\">The 7 Best Places for French Fries in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/fries\/\" target=\"_blank\">South Fork Public House, Pullman, WA<\/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\">With a warm and welcoming environment, South Fork Pubic House in Pullman, Washington, is a modern-style pub that’s known for its pub-style menu items, flat screen TVs that let you watch your… <a href=\"https:\/\/bestthingswa.com\/fries\/\" 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\/wa-golf-course-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/public-golf-courses\/\" target=\"_blank\">The 10 Best Public Golf Courses in Washington State!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/public-golf-courses\/\" target=\"_blank\">Palouse Ridge Golf Club, Pullman, WA<\/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\">Majestic rolling hills formed by the dunes of a past glacier make Palouse Ridge Golf Course in Pullman one of the finest public courses in America and it\u2019s patterned after Scottish courses that… <a href=\"https:\/\/bestthingswa.com\/public-golf-courses\/\" 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\/wa-candy-shop-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/candy-shops\/\" target=\"_blank\">8 Best Candy Shops in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/candy-shops\/\" target=\"_blank\">Palouse Country Candy, Pullman, WA<\/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\">This special store offers candy goers a large variety of candy and chocolates. A landmark in Pullman, Palouse Country Candy creates delicious truffles and macaroons, and also gives customers the… <a href=\"https:\/\/bestthingswa.com\/candy-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\/wa-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/bars\/\" target=\"_blank\">8 Best Bars in Washington: 2024 Edition!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/bars\/\" target=\"_blank\">Rico\u2019s Public House, Pullman, WA<\/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\">Rico’s Public House is a snapshot of American bar culture at its finest. Located in the quaint college town of Pullman, this watering hole has all the offerings which will delight your sudsy… <a href=\"https:\/\/bestthingswa.com\/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\/wa-burger-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/burgers\/\" target=\"_blank\">9 Best Burgers in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/burgers\/\" target=\"_blank\">The Coug, Pullman, WA<\/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\">This university town bar serves up some great eats. The burgers here have consistently been a local favorite. Grab the Coug Burger with your favorite beer and watch the football game with the… <a href=\"https:\/\/bestthingswa.com\/burgers\/\" 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\/wa-pubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/pubs\/\" target=\"_blank\">9 Best Pubs in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/pubs\/\" target=\"_blank\">The Coug, Pullman, WA<\/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\">Whether you\u2019re looking for a new place to try lunch or dinner or a special place to grab drinks with a friend, the Coug, located in Pullman is a great choice. The writing really is on the walls at… <a href=\"https:\/\/bestthingswa.com\/pubs\/\" 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\/wa-lunch-spots-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/lunch-spots\/\" target=\"_blank\">7 Best Lunch Spots in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/lunch-spots\/\" target=\"_blank\">The Black Cypress, Pullman, WA <\/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 Black Cypress is a hot spot for this college town. Offering both traditional Greek and Italian food such as lamb chops, carbonara, and beet salad, this place is popular among locals. The… <a href=\"https:\/\/bestthingswa.com\/lunch-spots\/\" 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\/wa-mac-and-cheese-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/mac-and-cheese\/\" target=\"_blank\">8 Best Places for Mac and Cheese in Washington!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/mac-and-cheese\/\" target=\"_blank\">South Fork Public House, Pullman, WA<\/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\">One of the area\u2019s favorite bars, South Fork Public House in Pullman, Washington, does bar food better than anyone. Opened in 2010, they serve comfort food in a new way. Take their mac & cheese,… <a href=\"https:\/\/bestthingswa.com\/mac-and-cheese\/\" 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\/wa-senior-discount-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingswa.com\/senior-discounts\/\" target=\"_blank\">10 Best Senior Discounts in Washington<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingswa.com\/senior-discounts\/\" target=\"_blank\">Spokane Tribe Casino, Airway Heights, WA<\/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\">In the mood for some gaming? Head to the Spokane Tribe Casino. The casino offers fantastic specials for seniors over 55, including a free swipe and win on Wednesdays during select hours and early… <a href=\"https:\/\/bestthingswa.com\/senior-discounts\/\" 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":"saint-john-wa","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\":\"45\",\"days\":\"15\",\"ttl\":\"4\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1766356257,"type":"Event","id":76102195,"title":"Rain - A Tribute to the Beatles","url":"\/event\/rain-a-tribute-to-the-beatles-2025-12-26-tm-spokane-wa.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/d91\/1dd1a54f-9188-4891-806b-d8a2d3a6bd91_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":1766356257,"type":"Event","id":76165386,"title":"Professional Bull Riders","url":"\/event\/professional-bull-riders-2026-01-10-tm-spokane-wa.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/2c1\/d8040b96-af04-4444-b277-ddc2972492c1_SOURCE"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1766370657,"type":"Place","id":2244089,"title":"St. John Community Fair and Stockshow","url":"\/place\/st-john-community-fair-and-stockshow-saint-john-wa.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.jpg"}],"modified":"MongoDate(0.61400000 1766341857)","created":"MongoDate(0.61400000 1766341857)","_id":ObjectId ("69483ce11d939887c104eb09")} , true) | | 0 | 0 | 12 |
| 80 | db.events_cache.find( {"_id":"7ddb5b6dbd6130b68559e9dcc9ab0a40"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 81 | db.events_radius_cache.find( {"_id":"8c93d0cc6756a99c50194fc7279d1c79"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 82 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"event_id":{"$nin":[76102195,76165386]},"geo":{"$geoWithin":{"$center":[[-117.58399963378906,47.09239959716797],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 | 0 | 376 |
| 83 | db.events_cache.count( {"_id":"7ddb5b6dbd6130b68559e9dcc9ab0a40"} ) | | 0 | 0 | 9 |
| 84 | db.events_cache.count( {"_id":"7ddb5b6dbd6130b68559e9dcc9ab0a40"} ) | | 0 | 0 | 6 |
| 85 | db.events_cache.insert( {"_id":"7ddb5b6dbd6130b68559e9dcc9ab0a40","town_sef_url":"saint-john-wa","data_key":[],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Saint John\",\"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\":47.09239959716797,\"lng\":-117.58399963378906,\"latlng\":\"47.092399597168,-117.58399963379\",\"city\":\"Saint John\",\"state\":\"WA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.07800000 1766341858)","created":"MongoDate(0.07800000 1766341858)"} , true) | | 0 | 0 | 10 |
| 86 | db.modules.find( {"name":"AT - Event Empty"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 87 | db.news.find( {"broadcast":{"$in":["usa","saint-john-wa","wa","whitman-county-wa"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 9 |
| 88 | db.places.find( {"address.town_sef_url":"saint-john-wa","group_id":{"$nin":[2244089]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 4 | 5 |
| 89 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 90 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 91 | db.towns.find( {"sef_url":"saint-john-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 92 | db.tokens.find( {"sef_url":{"$in":["usa","wa","whitman-county-wa","saint-john-wa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 93 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 94 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 95 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 96 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 97 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 98 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 99 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
