|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.
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! Early Bird Special $10
Feb 15, 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.