|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|
Jul 2, 2016
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 420th 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! Register online to save money or the day of at Barrelhouse South from 4pm-9pm.
Aug 13, 2016
Yes, you read this right, "Everybody Get's 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! Register now online to save money or at Boomys from 4pm-9pm on August 13th, 2016.
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! This event is benefiting (TBA).
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! A portion of proceeds will be donated to The Ronald McDonald House of the Coastal Empire. Register online for a discount online or at McDonough's anytime between 3pm-10pm on Saturday, December 17th, 2016.
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. A portion of the proceeds are benefiting the American Diabetes Association.
Mar 11, 2017
"Practice Makes Perfect"! Gear up for St. Patrick's Day in Savannah, GA. by joining us for the "St. Practice Day" Charity Bar Crawl benefiting the Savannah Irish Committee! 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! Register online for a discount or at (TBA) anytime between 4-10PM on Saturday, March 11th, 2017.
May 27, 2017
"THE CRAWL of the SOUTH" is Savannah's attepnt to break the Guinness World Record for Largest Bar Crawl! Currently, the record is help at 4885 crawlers by Kansas City, Missouri. Not only do we want to beat the record, we want to set the bar so high that Savannah, GA. stays in the book forever. Please SHARE with friends and LIKE out Facebook, Bar Crawl Savannah, to stay up to date on more informaiton.