|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 31, 2014
"The Nightmare on Congress Street" Charity Bar Crawl is Savannah's creepiest and scariest bar crawl along Savannah's eeriest strip. Costume Crawlers will quench their thirst on drink specials at each participating bar as they creep down chilling Congress Street. 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. A portion of proceeds will be donated to Savannah Chatham CASA. Thank you to our sponsors: Jack Daniel's Tennessee Fire and Red's Apple Ale.
Nov 29, 2014
Stretch your legs, wake up from the food coma, and burn off that Thanksgiving feast as you wobble your way through the beautiful streets of downtown Savannah, GA on Saturday, November 29th, 2014. After entertaining the in-laws and preparing a festive feast for the masses, you deserve to have some fun! Whether you like your turkey fried, baked, smoked or roasted, this crawl is for you! A portion of will be donated to Second Harvest Food Bank of Coastal Georgia. Thank you to our sponsors: Jack Daniels and Miller Lite. Early Bird Special $10
Dec 20, 2014
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, 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 Shriner's Children's Hospital. Thank you to our sponsors: Jack Daniel's Fire and Blue Moon Gingerbread Spiced Ale. Early Bird Special $10
Feb 7, 2015
Pull out those old wedding gowns, tacky bridesmaid dresses, and funky colored suits and join us for a joyous evening of fun and cheer aka "Bridal Party Gone Wild"! Fake your own bachelor or bachelorette party...couples fake your weddings...or divorcees, play the Cupid is Stupid. It's all for fun and for a great cause. Early Bird Special $10
Mar 7, 2015
"Practice Makes Perfect"! Gear up for St. Patrick's Day in Savannah, GA. by joining us for the "St. Practice Day on River Street" Charity Bar Crawl benefiting the Second Harvest of Coastal Georgia on Saturday March 7th, 2015! 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 on River Street" is the perfect way to build your tolerance and be in tip-top shape for the big day while enjoying the beautiful, historic River Street. Gather your friends, family, and co-workers and join us for this magical celebration! Early Bird Special $10
May 30, 2015
That's right, we are doing it again! We are determined to break this record!! =) Bigger and Better! Thank you to everyone who participated in 2014. We had an absolute blast putting on this event and loved all of the positive feedback, seeing the pictures, and donating $15,000 to 3 great local charities. But, 2015, Part II, is going to be even bigger!! We listened, heard, and will be implementing your suggestions and this year is going to be better than before!! Who's ready? Tickets only $5 until December 31.