|SQL||select distinct products.* from products inner join product_category_relation relation on relation.product_id = products.id where relation.category_id = ? and products.type = 1 order by name|
Dec 17, 2016
We hope you are ready to "Survive Savannah's Winter Wonderland". Crawlers will have to brave the ice-cold winter weather and journey through our winter wonderland, otherwise known as the beautiful, historic, downtown Savannah, Georgia. Here in Savannah, things are always bigger and better!! 12 bars later, you'll be sufficiently full of holiday cheer. Along with presents from Santa, and a Santa Hat, each bar will provide festive drink specials for "The Twelve Bars of Christmas" participants ONLY. Tis' the season for Tacky Sweaters, Mr. and Mrs. Claus, Elves, Reindeer, Snowmen, Angles, Gingerbread Men/Women, Christmas Trees, Lights, Drummer Boys, Snowflakes... let's get creative!
Feb 11, 2017
February 11th. Valentine's Day Saturday Night. Single's Awareness Day. Or just another Saturday.... Whatever you want to call it, we've got some fun planned for everyone's favorite (or least favorite) day of love. Here's the deal, you'd probably spend V-day on pricey dinner reservations, boxes upon boxes of Russell Stover or having a threesome with your consistent lovers Ben & Jerry while hating and loving that Netflix gives you only 10 seconds to decide if eight episodes of Breaking Bad in one night is too much. We have a way better alternative! Nature's oldest heart break mender, alcohol, is here for you to drown your sorrows or celebrate your singledom! Join us as we spend the night crawling through 12 Savannah bars, enjoying, or crying into, one drink at each stop! Here's the fun part.. no matter if you're "Single", "In a Relationship"or "It's Complicated" this event will be lovely way to mix it up with other singles, shake up your relationship or make your love life that much more complicated.
Mar 11, 2017
"Practice Makes Perfect"! Gear up for St. Patrick's Day in Savannah, GA. by joining us for the "St. Practice Day" Bar Crawl! It happens every year, you plan to party all day and all night long, but you conk out sometime in the afternoon. "St. Practice Day" is the perfect way to build your tolerance and be in tip-top shape for the big day while enjoying the beautiful, historic Savannah, Georgia. Gather your friends, family, and co-workers and join us for this magical celebration!
May 27, 2017
Savannah has attempted to break the Guinness World Record for the largest bar crawl the past two years with no success. We got within 500 crawlers both times, but it just wasn't meant to be. We are going to continue the South's most popular bar crawl in 2017 but hold off from getting Guinness World Records involved. We will attempt again in 2018!! Unitl then, come up, enjoy what 2017 has in store for you, and help us raise some money for a good cause. EVERYONE who registers for this crawl will get their choice of retro/retired bar crawl t-shirts, left over from past events.
Jul 1, 2017
What happends when Uncle Sam and the nation's most Patriotic Crawlers celebrate Indepenence Day? You get the "Red, White, and Brew's" Independence Day Bar Crawl! Come celebrate America's 421th Birthday on Saturday, July 2nd, as we bar hop through Savannah's most popular bars. Gather your friends, rock your red, white, and blue, and get ready for a day full of Star Spangled shenanigans and festivites with hundreds of your closest friends. This is your chance to celebrate America's birthday by bar hopping through downtown Savavannah with hundreds of other patriots!
Sep 2, 2017
Yes, you read this right, "Everybody Gets Lei'd"! Come dressed in your favorite Luau themed attire. Coconut bras, board shorts, bikinis, grass skirts, Hawaiian shirts, tank tops, floaties, and flip-flops are a must on this once a year classic! Along with summer accessories, each Savannah Crawler will receive exclusive DRINK SPECIALS! Register now and become part of the Summer's Largest Party!