|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|
Oct 29, 2016
The Nightmare on Congress Street” Charity Bar Crawl is Savannah's creepiest and scariest bar crawl along Savannah's eeriest strip. This is also SAVANNAH'S BIGGEST COSTUME CONTEST, $1500! As opposed to a typical "bar crawl" where participants travel as one big group with designated time slots at each bar, this event allows participants to "crawl" at their own pace." Along with some free giveaways, crawlers will quench their thirst on drink specials at each participating bar as they creep down chilling and haunted Congress Street. Register now and become part of the Fall's most fun and creepiest events!
Nov 19, 2016
Stetch your legs, prepare for the food coma, and get ready to burn some calories before that Thanksgiving feast that you will soon consume as you wobble your way through the beautiful streets of downtown Savannah, GA. on Saturday, November 19th, 2016. Before entertaining the in-laws and preparing a festive feast for the masses, you deserve to have some fun! Whether you like your turkey friend, baked, smoked, or roasted, this crawl is for you!
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!