query
RESULTSET
query
  ACTIVE_END ACTIVE_START ALLEVENTS DISABLED DISPLAY_ORDER EVENT_DATE EVENT_LOCATION ID LAST_MODIFIED LDESCRIPTION LINK1 LINK2 MODIFIED_BY NAME PRICE_DISCOUNTED PRICE_RETAIL PRICE_SALE SDESCRIPTION SHIPPING_TYPE SKU SNAME STOCK TYPE URL_NAME VENDOR
1 {ts '2015-02-08 00:00:00'} {ts '2014-06-25 00:00:00'} 1 0 0 2015-02-07 00:00:00.0 [empty string] 56 2014-06-26 10:22:27.0 [empty string] https://www.facebook.com/events/647314875344392/ https://staffordpromotions.wufoo.com/forms/bridal-party-gone-wild-charity-bar-crawl/ 2 "Bridal Party Gone Wild" Charity Bar Crawl 0.00 0.00 0.00 <p>We are giving away a vacation "honeymoon" cruise for two! 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"! The tackiest, funkiest, outlandish dressed person wins a crusie! 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, to benefit the Kicklighter Resource Center. Register online for a discount or at Ampersand anytime between 2PM-8PM on Saturday, February 7th, 2015. Thank you to our sponsors Premier Wedding Expos, Miller Lite, Blue Moon First Peach Ale, Jack Daniel's, El Jimador, Cumulus Broadcasting I-95 The Rock of Savannah, Everlasting Honeymoons, and United Indoor Advertising. </p> 0 6FC78CB6-B8C8-57E4-7796FD88608854BA "Bridal Party Gone Wild" Charity Bar Crawl 1 1 "Bridal-Party-Gone-Wild"-Charity-Bar-Crawl [empty string]
2 {ts '2015-08-22 00:00:00'} {ts '2014-12-16 00:00:00'} 1 0 0 2015-08-22 00:00:00.0 [empty string] 89 2014-12-17 16:32:04.0 [empty string] https://www.facebook.com/events/397957903693875/ https://staffordpromotions.wufoo.com/forms/everybody-gets-leid-charity-bar-crawl-2015/ 2 "Everybody Get's Lei'd" Charity Bar Crawl 0.00 0.00 0.00 <p>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!  A portion of the proceeds will be donated to (TBA)</p> <p> </p> 0 B21D0C3B-C656-32B1-2E50D82681065DCD "Everybody Get's Lei'd" Charity Bar Crawl 1 1 "Everybody-Get's-Lei'd"-Charity-Bar-Crawl [empty string]
3 {ts '2015-03-07 00:00:00'} {ts '2014-06-25 00:00:00'} 1 0 0 2015-03-07 00:00:00.0 [empty string] 57 2014-06-26 10:25:01.0 <p><br />  </p> https://www.facebook.com/events/473117992823151/ https://staffordpromotions.wufoo.com/forms/st-practice-day-charity-bar-crawl/ 2 "St. Practice Day" Charity Bar Crawl 0.00 0.00 0.00 <p>"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 Boomys anytime between 2PM-8PM on Saturday, March 7th, 2015. Thank you to our sponsors: Miller Lite, Leinenkugel Summer Shandy, Jack Daniel's, Southern Comfort, Cumulus Broadcasting, I-95 The Rock of Savannah, Pablo and Britt Photography, and United Indoor Advertising.</p> 0 CD4D6020-B537-E53E-592378C21439B8FD "St. Practice Day" Charity Bar Crawl 1 1 "St.-Practice-Day"-Charity-Bar-Crawl [empty string]
4 {ts '2015-05-30 00:00:00'} {ts '2014-06-25 00:00:00'} 1 0 0 2015-05-30 00:00:00.0 [empty string] 58 2014-06-26 10:26:44.0 <p>Join us to be part of a GUINNESS WORLD RECORD for Largest Bar Crawl!! Currently held in Kansas City, we want to bring this record to the SouthEast to Savannah, GA! Crawlers will have 30 bars to choose from, $1 & $2 alcoholic and non-alcoholic drink specials, access to the exclusive Jack Fire After Party, free giveaways from our lovely sponsors, the first 4,886 people to bring completed (hole-punched at 10 bars) souvenir scorecard to the After Party will get a FREE event t-shirt, 6,000+ participants, benefiting a great lcoal non-profit, and all to break a Guinness World Record!! </p> <p>Thank you to our sponsors: Miller Lite, Jack Daniel's, United Indoor Advertising, Rock of Savannah I95, Rock 106.1, SOUTH Magazine, WJCL, and Scores. </p> <p>Brought to you by Bar Crawl Savannah, Stafford Promotions, and the Savannah Waterfront Association.</p> https://www.facebook.com/events/1499150937026213/ https://staffordpromotions.wufoo.com/forms/the-crawl-of-the-south-part-ii/ 2 "THE CRAWL of the SOUTH" Charity Bar Crawl 0.00 0.00 0.00 <p>Join us to be part of a GUINNESS WORLD RECORD for Largest Bar Crawl!! Currently held in Kansas City, we want to bring this record to the SouthEast to Savannah, GA! Crawlers will have 30 bars to choose from, $1 & $2 alcoholic and non-alcoholic drink specials, access to the exclusive Jack Fire After Party, free giveaways from our lovely sponsors, the first 4,886 people to bring completed (hole-punched at 10 bars) souvenir scorecard to the After Party will get a FREE event t-shirt, 6,000+ participants, benefiting a great lcoal non-profit, and all to break a Guinness World Record!! </p> <p>Thank you to our sponsors: Miller Lite, Jack Daniel's, United Indoor Advertising, Rock of Savannah I95, Rock 106.1, SOUTH Magazine, WJCL, and Scores. </p> <p>Brought to you by Bar Crawl Savannah, Stafford Promotions, and the Savannah Waterfront Association.</p> 0 4269D0E3-145E-15C3-5A521C41169E8A0A "THE CRAWL of the SOUTH" Charity Bar Crawl 1 1 "THE-CRAWL-of-the-SOUTH"-Charity-Bar-Crawl [empty string]
5 {ts '2015-11-22 00:00:00'} {ts '2014-12-17 00:00:00'} 1 0 0 2015-11-21 00:00:00.0 [empty string] 77 2014-10-08 20:18:16.0 [empty string] https://www.facebook.com/events/689810137783930/ https://staffordpromotions.wufoo.com/forms/the-gobble-wobble-charity-bar-crawl-2015/ 2 "The Gobble Wobble" Charity Bar Crawl 0.00 0.00 0.00 <p><span style="font-family:lucida sans unicode,lucida grande,sans-serif"><span style="color:rgb(20, 24, 35); font-size:14px">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 21th, 2015. 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! Early Bird Special:  $5</span></span></p> <p> </p> <p> </p> 0 B2608146-B2B4-CEB3-6CCF75C542C317BC "The Gobble Wobble" Charity Bar Crawl 1 1 "The-Gobble-Wobble"-Charity-Bar-Crawl [empty string]
6 {ts '2015-11-01 00:00:00'} {ts '2014-12-17 00:00:00'} 1 0 0 2015-10-31 00:00:00.0 [empty string] 52 2014-06-26 09:50:30.0 [empty string] https://www.facebook.com/events/637086773067999/ https://staffordpromotions.wufoo.com/forms/the-nightmare-on-congress-street-2015/ 2 "The Nightmare on Congress Street" Charity Bar Crawl 0.00 0.00 0.00 <p>"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.  Early Bird Special:  $5</p> 0 B263743A-9255-041E-D1DA3C28C33A7396 "The Nightmare on Congress Street" Charity Bar Crawl 1 1 "The-Nightmare-on-Congress-Street"-Charity-Bar-Crawl [empty string]
7 {ts '2015-12-20 00:00:00'} {ts '2014-12-28 00:00:00'} 1 0 0 2015-12-19 00:00:00.0 TBD 53 2014-06-26 09:57:49.0 [empty string] https://www.facebook.com/events/420784488086239/?context=create&previousaction=create&source=49&sid_create=1464661194 https://staffordpromotions.wufoo.com/forms/the-twelve-bars-of-christmas-charity-bar-crawl-s1p257t51o74v7b/ 2 "The Twelve Bars of Christmas" 5k Charity Bar Crawl 0.00 0.00 0.00 <p>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 TBD.   Early Bird Special:  $5</p> <p> </p> 0 15276333-0936-6AA3-29B51DD39A914181 "The Twelve Bars of Christmas" 5k Charity Bar Crawl 1 1 "The-Twelve-Bars-of-Christmas"-5k-Charity-Bar-Crawl [empty string]
8 {ts '2015-04-26 00:00:00'} {ts '2015-01-20 00:00:00'} 1 0 0 2015-04-25 00:00:00.0 [empty string] 95 2015-01-21 00:30:55.0 [empty string] https://www.facebook.com/events/575202065943026/ https://staffordpromotions.wufoo.com/forms/aces-in-all-the-right-places-charity-bar-crawl/ 2 Aces in all the Right Places" Charity Poker Crawl 0.00 0.00 0.00 <p>A new and improved version of a "poker run", Bar Crawl Savannah brings you "Aces in the Right Places" Charity POKER Crawl in the beautiful, historic, downtown, Savannah, GA.  Invite your friends, family, and coworkers to join in for what will be a day full of fun, excitement, and debauchery.  A portion of the proceeds will benefit the Anderson Cancer Institute.  Register now, get out the house, and be part of something good in Savannah.  We hope to see you there!  </p> <p> </p> 0 755DF35C-C3FE-20A0-7BDF0403C26191B8 Aces in all the Right Places" Charity Poker Crawl 1 1 Aces-in-all-the-Right-Places"-Charity-Poker-Crawl [empty string]
9 {ts '2015-03-15 00:00:00'} {ts '2014-12-10 00:00:00'} 1 0 0 2015-03-14 00:00:00.0 Savannah Station 87 2014-12-11 12:09:26.0 [empty string] https://www.facebook.com/events/322037691338087/ https://staffordpromotions.wufoo.com/forms/st-patricks-day-firefighters-ball/ 2 St. Patrick's Day Firefighter's Ball sponsored by Spiva Law Firm 0.00 0.00 0.00 <p>It's that time of year again. Tickets to the HOTTEST party in Savannah are NOW on sale and you are officially invited to the St. Patrick's Day Firefighter's Ball sponsored by Spive Law Firm in the Beautiful, Historic, Savannah, Georgia! Come out and meet your Savannah Firefighters as well as many firefighters from all across the world including New York City, Chicago, Los Angeles, Charleston, Atlanta, Boise, Orlando, and Ireland. The Savannah St. Patrick's Day Firefighter's Ball has everything you can imagine on St. Patrick's Day weekend. There will be an open bar, heavy hor d'ourves presented by local Savannah restaurants, LIVE music performed by Les Racquet, and a fantasic silent auction. The St. Patrick's Day Firefighter's Ball will be at the Savannah Station on Saturday, March 14th, 2015 from 6PM-11PM. This fundraiser is open to the public.</p> <p> </p> 0 30896BAB-ADC8-FC1F-B5975D450893A6B0 St. Patrick's Day Firefighter's Ball sponsored by Spiva Law Firm 1 1 St.-Patrick's-Day-Firefighter's-Ball-sponsored-by-Spiva-Law-Firm [empty string]
10 {ts '2015-01-01 00:00:00'} {ts '2014-12-10 00:00:00'} 1 0 0 2014-12-31 00:00:00.0 Barrelhouse South (125 W. Congress St) 88 2014-12-11 12:16:27.0 <p><span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">Boy, do we have a TREAT for you! </span><a href="https://www.facebook.com/zachdeputy">Zach Deputy</a><span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px"> is coming home and is performing a LIVE New Year's Eve concert at </span><a href="https://www.facebook.com/barrelhousesav">Barrelhouse South</a><span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">. Talk about intimate, only 150 tickets are available. Come out and support Savannah's local music scene. Zach has even agreed to play for 5 hours! That's right, 5 hours of amazing "Island-Infused Drum n' Bass Gospel Ninja Soul". </span><br /> <br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">What: Zach Deputy LIVE and Barrelhouse South</span><br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">Where: Barrelhouse South (125 West Congress Street)</span><br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">When: Wednesday, December 31, 2014, Doors open at 9PM, show is from 10PM-3AM</span><br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">Cost: $25 in advance and $40 at the door (odds are tickets will be sold out) VIP: $75. Includes open bar and re-entry.</span><br /> <br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">Because we will be celebrating the New Year, there will be a FREE Champagne toast at midnight. </span><br /> <br /> <span style="background-color:rgb(255, 255, 255); color:rgb(20, 24, 35); font-family:helvetica,arial,lucida grande,tahoma,verdana,arial,sans-serif; font-size:13.63636302948px">No re-entry or refunds.</span></p> <p> </p> https://www.facebook.com/events/1576128255951622/ https://staffordpromotions.wufoo.com/forms/zach-deputy-live-at-barrelhouse-south/ 2 Zach Deputy LIVE at Barrelhouse South #Savannah #NYE #YOLO 0.00 0.00 0.00 <p><span style="font-size:12px"><span style="font-family:verdana,geneva,sans-serif">Boy, do we have a TREAT for you! Zach Deputy is coming home and performing a LIVE New Year's Eve contert at Barrelhouse South. Only 150 tickets are available for this intimate show. Come out and support Savannah's local music scene. Zach has even aggreed to play for 5 hours! That's right, 5 hours of amazing "Island-Infused Drum n' Bass Gospel Ninja Soul".</span></span></p> <p> </p> 0 FD6C9F7C-0EF4-27B2-399F65CC67CE9A25 Zach Deputy LIVE at Barrelhouse South #Savannah #NYE #YOLO 1 1 Zach-Deputy-LIVE-at-Barrelhouse-South-#Savannah-#NYE-#YOLO [empty string]
CACHED false
EXECUTIONTIME 0
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
SQLPARAMETERS
array
1 11

"THE CRAWL of the SOUTH" Charity Bar Crawl

May 30, 2015

Join us to be part of a GUINNESS WORLD RECORD for Largest Bar Crawl!! Currently held in Kansas City, we want to bring this record to the SouthEast to Savannah, GA! Crawlers will have 30 bars to choose from, $1 & $2 alcoholic and non-alcoholic drink specials, access to the exclusive Jack Fire After Party, free giveaways from our lovely sponsors, the first 4,886 people to bring completed (hole-punched at 10 bars) souvenir scorecard to the After Party will get a FREE event t-shirt, 6,000+ participants, benefiting a great lcoal non-profit, and all to break a Guinness World Record!! 

Thank you to our sponsors: Miller Lite, Jack Daniel's, United Indoor Advertising, Rock of Savannah I95, Rock 106.1, SOUTH Magazine, WJCL, and Scores. 

Brought to you by Bar Crawl Savannah, Stafford Promotions, and the Savannah Waterfront Association.


Full Event Details Register Now

"Everybody Get's Lei'd" Charity Bar Crawl

Aug 22, 2015

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!  A portion of the proceeds will be donated to (TBA)

 


Full Event Details Register Now

"The Nightmare on Congress Street" Charity Bar Crawl

Oct 31, 2015

"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.  Early Bird Special:  $5


Full Event Details Register Now

"The Gobble Wobble" Charity Bar Crawl

Nov 21, 2015

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 21th, 2015. 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! Early Bird Special:  $5

 

 


Full Event Details Register Now

"The Twelve Bars of Christmas" 5k Charity Bar Crawl

Dec 19, 2015

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 TBD.   Early Bird Special:  $5

 


Full Event Details Register Now
© 2014 Stafford Promotions | Website designed and Hosted by Sabre Technologies Facebook