470 // default to the global read db471 if (!$dbx) {472 global $db;473 $dbx = $db;474 }475 // execute the query476 elapsed('begin SQL: ' . $sql);477 $rows = $dbx->query($sql, PDO::FETCH_OBJ);478 elapsed('end SQL');479 return $rows->fetchAll();480 }481482 function sql_array($SQL, $dbx=NULL){483 $rows = sql($SQL,$dbx);484 $rs = array();
SELECT venue.description_ambience, venue.description_scene, venue.description_eats_drinks, venue.music, venue.place_type, venue.id AS venue_id, venue.id FROM venue WHERE venue.active = 1 AND venue.id =
255 $dbx = $params['dbw'] ? $dbw : $db;256257 #d($a);258259 // query, count, list260 $sql_type = $params['sql_type'] ?: 'query';261 $sql = $a->sql->$sql_type;262 return \sql($sql, $dbx);263 }264265266 /**267 *268 */269 public static function count($aql, $params = [])
SELECT venue.description_ambience, venue.description_scene, venue.description_eats_drinks, venue.music, venue.place_type, venue.id AS venue_id, venue.id FROM venue WHERE venue.active = 1 AND venue.id =
2038-01-18 22:14:08
227 * order by string228 * limit int229 * dbw bool230 *231 */232 public static function select($aql, $params = [])233 {234 $rs = \Sky\AQL::select($aql, $params);235236 // for backwards compatibility, encrypt any fields ending with _id237 foreach ($rs as $i => $r) {238 foreach ($r as $k => $v) {239 if (substr($k, -3) == '_id') {240 $start = strpos($k, '__');241 if ($start) {
venue {
description_ambience,
description_scene
description_celebrities,
description_eats_drinks,
music,
place_type,
}id =
454 description_celebrities,455 description_eats_drinks,456 music,457 place_type,458459 }" ;460461 $list = \aql::select($aql , ['where' => "id = {$id} "]) ;462463 if ($list && count($list))464 return $list[0];465 return null;466 }467468
venue {
description_ambience,
description_scene
description_celebrities,
description_eats_drinks,
music,
place_type,
}id =
6 );78 $venue = \Crave\Model\venue::getOne($params);91011 $venue_info = [12 'venue' => $venue,13 'descriptions' => \Crave\Model\venue::getFullVenue($venue->id),14 'venue_type' => new \Crave\Model\venue_type($venue->venue_type_id),15 'media_items' => $venue->media_items16 ];17181920
319320 // push data array into the file's scope321 foreach ($__d as $__k => $__v) $$__k = $__v;322 unset($__d, $__k, $__v);323324 // for backwards compatibility325 $p = $this;326 include $__p;327328 // removing $__p, otherwise it will be in defined_vars()329 unset($__p);330 return get_defined_vars();331 }332333 /**
/var/www/codebases/barcrawls/pages/_market.slug_/_venue_type.slug_/_venue_type.slug_.php
232 $get_contents = (bool) ($_POST['_json'] || $_GET['_script']);233 if ($get_contents) {234 if ($_GET['_script']) $this->no_template = true;235 ob_start();236 }237238 // run-first / settings / script files need to be executed in the same scope239 $vars = $this->includePath($this->page_path, $vars);240241 if ($get_contents) {242 // refreshing a secondary div after an ajax state change243 if (is_array($this->div)) {244 $this->div['page'] = ob_get_contents();245 } else {246 if (!$this->div) {
| color | |
|---|---|
| 1 | "4cb2e1" |
| 5 | "FF9897" |
| 12 | "30389f" |
| 14 | "62CD99" |
| 16 | "a60808" |
| 10 | "fbb804" |
| 11 | "ff9e00" |
| 13 | "00d2ff" |
| 9 | "1e8816" |
| 2 | "e67700" |
| 15 | "926e21" |
/templates/website/content/images/BarCrawls-4thOfJuly-Generic-Flyer.jpg
Raising a toast to the red, white and booze, BarCrawls.com invites you to get star-spangled hammered as you embark on our highly anticipated 4th of July Bar Crawl. In an effort to properly celebrate America’s birthday, we have partnered up with top pubs saloons, taverns and bars to spread patriotism throughout your city by way of firecracking drink specials and cover-free admission. An all-American barhopping celebration, BarCrawls.com’s 4th of July Bar Crawl is sure to leave you and your fellow crawlers seeing stars and stripes.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-Halloween-Generic-Flyer.jpg
<p>Trick or treat yourself to a hauntingly unforgettable Halloween with BarCrawls.com’s spellbinding Night of the Crawling Dead, an All Hallow’s Eve barhopping experience that will leave heads rolling. Partnering up with your city’s premier saloons, bars, taverns and pubs, you are invited to get dressed up and messed up in ghoulish glamour for a full weekend of to-die-for drink specials, cover-free admission at all participating venues. For one howl of a time this Halloween, look no further than BarCrawls.com’s spooktacular Night of the Crawling Dead Bar Crawl......</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-TGE-Generic-Flyer.jpg
Make your ancestors proud as you embark on Get Basted, a booze-enthused barhopping voyage colonized by BarCrawls.com and your city’s most wonder-fowl bars, pubs, taverns and saloons. A Thanksgiving Eve crawl highlighted by drink specials and cover-free admission at all participating venues, the time to get stuffed, give thanks and Get Basted is now.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-XmasEve-Generic-Flyer.jpg
Naughty never felt quite as nice as it does at BarCrawls.com’s Bad Santa Bar Crawl. Hosted by some of the city’s ho-ho-hottest bars and pubs, this bar-hopping holiday party reminds us that when it comes to the season of giving, the best gifts aren’t wrapped in ribbon but rather served in a chilled mug, preferably by way of dangerously discounted drink specials and cover-free admission. So don we now our red and green apparel for an indulgent celebration of yuletide cheer, loud for all to hear as we join BarCrawls.com for its annual Bad Santa Bar Crawl, a true Christmas miracle.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-NYE-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-nye-2017-banner.jpg
As the year comes to a close, celebrate your party-rocking past, present and future by slipping into something sparkly and crawling your way into the new year with BarCrawls.com at Crawl Til The Ball Falls, an end-of-year barhopping blowout. Hosted by some of the best pubs, saloons, bars and taverns that your city has to offer, look no further than this New Year’s Eve crawl for outstanding drink specials and cover-free admission to all participating venues. From dusk on December 31st 'til dawn on January 1st, tickets to this New Year’s party ensure that you end this year and kick off the next like you always wanted—on a wild brews-chase, of course! BarCrawls.com’s Crawl Til The Ball Falls invites you to a NYE bash sure to rock until you or the iconic Times Square ball drops—whichever comes first.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-SPD-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-irishstroll-banner.jpg
<p>Irish or otherwise, join us for a full weekend of Irish luck as BarCrawls.com is proud to present its annual St. Patrick’s Day bar crawl, Irish Strolls. From the top o’ the morning to the end of the rainbow, your city’s top bars, pubs, taverns and saloons will be serving up full-blarney festivities by way of unbeatable drink specials, cover-free admission and more. Raising the bar on St Patty’s Day shamrocking, BarCrawls.com will also be hosting a full weekend of bar events and parties ensuring that you find your pint of gold over and over again. With bottomless brews and your greenest hues, BarCrawls.com invites you to make this.....</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-CincoDeMayo-Generic-Flyer.jpg
After a long harsh winter of indoor drinking, it is finally time to shed layers and inhibitions by joining us for BarCrawls.com’s Cinco de Mayo Bar Crawl. Your chance to soak up the sun, Latin-American culture and plenty of margaritas, this barhopping party’s highlights include caliente drink specials, cover-free admission to some of your city’s best bars, pubs, taverns and saloons and more. One fiesta you truly don’t want to miss, BarCrawls.com’s Cinco de Mayo Bar Crawl is the ultimate summer prelude party.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
| color | |
|---|---|
| 1 | "4cb2e1" |
| 5 | "FF9897" |
| 12 | "30389f" |
| 14 | "62CD99" |
| 16 | "a60808" |
| 10 | "fbb804" |
| 11 | "ff9e00" |
| 13 | "00d2ff" |
| 9 | "1e8816" |
| 2 | "e67700" |
| 15 | "926e21" |
/templates/website/content/images/BarCrawls-4thOfJuly-Generic-Flyer.jpg
Raising a toast to the red, white and booze, BarCrawls.com invites you to get star-spangled hammered as you embark on our highly anticipated 4th of July Bar Crawl. In an effort to properly celebrate America’s birthday, we have partnered up with top pubs saloons, taverns and bars to spread patriotism throughout your city by way of firecracking drink specials and cover-free admission. An all-American barhopping celebration, BarCrawls.com’s 4th of July Bar Crawl is sure to leave you and your fellow crawlers seeing stars and stripes.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-Halloween-Generic-Flyer.jpg
<p>Trick or treat yourself to a hauntingly unforgettable Halloween with BarCrawls.com’s spellbinding Night of the Crawling Dead, an All Hallow’s Eve barhopping experience that will leave heads rolling. Partnering up with your city’s premier saloons, bars, taverns and pubs, you are invited to get dressed up and messed up in ghoulish glamour for a full weekend of to-die-for drink specials, cover-free admission at all participating venues. For one howl of a time this Halloween, look no further than BarCrawls.com’s spooktacular Night of the Crawling Dead Bar Crawl......</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-TGE-Generic-Flyer.jpg
Make your ancestors proud as you embark on Get Basted, a booze-enthused barhopping voyage colonized by BarCrawls.com and your city’s most wonder-fowl bars, pubs, taverns and saloons. A Thanksgiving Eve crawl highlighted by drink specials and cover-free admission at all participating venues, the time to get stuffed, give thanks and Get Basted is now.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-XmasEve-Generic-Flyer.jpg
Naughty never felt quite as nice as it does at BarCrawls.com’s Bad Santa Bar Crawl. Hosted by some of the city’s ho-ho-hottest bars and pubs, this bar-hopping holiday party reminds us that when it comes to the season of giving, the best gifts aren’t wrapped in ribbon but rather served in a chilled mug, preferably by way of dangerously discounted drink specials and cover-free admission. So don we now our red and green apparel for an indulgent celebration of yuletide cheer, loud for all to hear as we join BarCrawls.com for its annual Bad Santa Bar Crawl, a true Christmas miracle.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-NYE-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-nye-2017-banner.jpg
As the year comes to a close, celebrate your party-rocking past, present and future by slipping into something sparkly and crawling your way into the new year with BarCrawls.com at Crawl Til The Ball Falls, an end-of-year barhopping blowout. Hosted by some of the best pubs, saloons, bars and taverns that your city has to offer, look no further than this New Year’s Eve crawl for outstanding drink specials and cover-free admission to all participating venues. From dusk on December 31st 'til dawn on January 1st, tickets to this New Year’s party ensure that you end this year and kick off the next like you always wanted—on a wild brews-chase, of course! BarCrawls.com’s Crawl Til The Ball Falls invites you to a NYE bash sure to rock until you or the iconic Times Square ball drops—whichever comes first.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-SPD-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-irishstroll-banner.jpg
<p>Irish or otherwise, join us for a full weekend of Irish luck as BarCrawls.com is proud to present its annual St. Patrick’s Day bar crawl, Irish Strolls. From the top o’ the morning to the end of the rainbow, your city’s top bars, pubs, taverns and saloons will be serving up full-blarney festivities by way of unbeatable drink specials, cover-free admission and more. Raising the bar on St Patty’s Day shamrocking, BarCrawls.com will also be hosting a full weekend of bar events and parties ensuring that you find your pint of gold over and over again. With bottomless brews and your greenest hues, BarCrawls.com invites you to make this.....</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-CincoDeMayo-Generic-Flyer.jpg
After a long harsh winter of indoor drinking, it is finally time to shed layers and inhibitions by joining us for BarCrawls.com’s Cinco de Mayo Bar Crawl. Your chance to soak up the sun, Latin-American culture and plenty of margaritas, this barhopping party’s highlights include caliente drink specials, cover-free admission to some of your city’s best bars, pubs, taverns and saloons and more. One fiesta you truly don’t want to miss, BarCrawls.com’s Cinco de Mayo Bar Crawl is the ultimate summer prelude party.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
| color | |
|---|---|
| 1 | "4cb2e1" |
| 5 | "FF9897" |
| 12 | "30389f" |
| 14 | "62CD99" |
| 16 | "a60808" |
| 10 | "fbb804" |
| 11 | "ff9e00" |
| 13 | "00d2ff" |
| 9 | "1e8816" |
| 2 | "e67700" |
| 15 | "926e21" |
| color | |
|---|---|
| 1 | "4cb2e1" |
| 5 | "FF9897" |
| 12 | "30389f" |
| 14 | "62CD99" |
| 16 | "a60808" |
| 10 | "fbb804" |
| 11 | "ff9e00" |
| 13 | "00d2ff" |
| 9 | "1e8816" |
| 2 | "e67700" |
| 15 | "926e21" |
/templates/website/content/images/BarCrawls-4thOfJuly-Generic-Flyer.jpg
Raising a toast to the red, white and booze, BarCrawls.com invites you to get star-spangled hammered as you embark on our highly anticipated 4th of July Bar Crawl. In an effort to properly celebrate America’s birthday, we have partnered up with top pubs saloons, taverns and bars to spread patriotism throughout your city by way of firecracking drink specials and cover-free admission. An all-American barhopping celebration, BarCrawls.com’s 4th of July Bar Crawl is sure to leave you and your fellow crawlers seeing stars and stripes.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-Halloween-Generic-Flyer.jpg
<p>Trick or treat yourself to a hauntingly unforgettable Halloween with BarCrawls.com’s spellbinding Night of the Crawling Dead, an All Hallow’s Eve barhopping experience that will leave heads rolling. Partnering up with your city’s premier saloons, bars, taverns and pubs, you are invited to get dressed up and messed up in ghoulish glamour for a full weekend of to-die-for drink specials, cover-free admission at all participating venues. For one howl of a time this Halloween, look no further than BarCrawls.com’s spooktacular Night of the Crawling Dead Bar Crawl......</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-TGE-Generic-Flyer.jpg
Make your ancestors proud as you embark on Get Basted, a booze-enthused barhopping voyage colonized by BarCrawls.com and your city’s most wonder-fowl bars, pubs, taverns and saloons. A Thanksgiving Eve crawl highlighted by drink specials and cover-free admission at all participating venues, the time to get stuffed, give thanks and Get Basted is now.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-XmasEve-Generic-Flyer.jpg
Naughty never felt quite as nice as it does at BarCrawls.com’s Bad Santa Bar Crawl. Hosted by some of the city’s ho-ho-hottest bars and pubs, this bar-hopping holiday party reminds us that when it comes to the season of giving, the best gifts aren’t wrapped in ribbon but rather served in a chilled mug, preferably by way of dangerously discounted drink specials and cover-free admission. So don we now our red and green apparel for an indulgent celebration of yuletide cheer, loud for all to hear as we join BarCrawls.com for its annual Bad Santa Bar Crawl, a true Christmas miracle.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-NYE-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-nye-2017-banner.jpg
As the year comes to a close, celebrate your party-rocking past, present and future by slipping into something sparkly and crawling your way into the new year with BarCrawls.com at Crawl Til The Ball Falls, an end-of-year barhopping blowout. Hosted by some of the best pubs, saloons, bars and taverns that your city has to offer, look no further than this New Year’s Eve crawl for outstanding drink specials and cover-free admission to all participating venues. From dusk on December 31st 'til dawn on January 1st, tickets to this New Year’s party ensure that you end this year and kick off the next like you always wanted—on a wild brews-chase, of course! BarCrawls.com’s Crawl Til The Ball Falls invites you to a NYE bash sure to rock until you or the iconic Times Square ball drops—whichever comes first.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-SPD-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-irishstroll-banner.jpg
<p>Irish or otherwise, join us for a full weekend of Irish luck as BarCrawls.com is proud to present its annual St. Patrick’s Day bar crawl, Irish Strolls. From the top o’ the morning to the end of the rainbow, your city’s top bars, pubs, taverns and saloons will be serving up full-blarney festivities by way of unbeatable drink specials, cover-free admission and more. Raising the bar on St Patty’s Day shamrocking, BarCrawls.com will also be hosting a full weekend of bar events and parties ensuring that you find your pint of gold over and over again. With bottomless brews and your greenest hues, BarCrawls.com invites you to make this.....</p>
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-CincoDeMayo-Generic-Flyer.jpg
After a long harsh winter of indoor drinking, it is finally time to shed layers and inhibitions by joining us for BarCrawls.com’s Cinco de Mayo Bar Crawl. Your chance to soak up the sun, Latin-American culture and plenty of margaritas, this barhopping party’s highlights include caliente drink specials, cover-free admission to some of your city’s best bars, pubs, taverns and saloons and more. One fiesta you truly don’t want to miss, BarCrawls.com’s Cinco de Mayo Bar Crawl is the ultimate summer prelude party.
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
market {
[market_nbhd]s as neighborhoods,
city,
code,
country_code,
latitude,
longitude,
name,
on_website,
slug,
venue_search_nickname,
state,
state_full,
market1,
market2,
market3,
market4,
name_alt1,
name_alt2,
name_alt3,
county,
target,
skybox
}
country on market.country_code ilike country.code {
name as country_name,
slug as country_slug
}
2018-06-25 11:14:06
/templates/website/content/images/BarCrawls-TGE-Generic-Flyer.jpg
Make your ancestors proud as you embark on Get Basted, a booze-enthused barhopping voyage colonized by BarCrawls.com and your city’s most wonder-fowl bars, pubs, taverns and saloons. A Thanksgiving Eve crawl highlighted by drink specials and cover-free admission at all participating venues, the time to get stuffed, give thanks and Get Basted is now.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
SELECT ct_holiday.date, ct_holiday.holiday1, ct_holiday.holiday2, ct_holiday.holiday3, ct_holiday.holiday4, ct_holiday.holiday5, ct_holiday.holiday6, ct_holiday.name, ct_holiday.on_crave, ct_holiday.slug, ct_holiday.id AS ct_holiday_id, ct_holiday.id FROM ct_holiday WHERE ct_holiday.active = 1
SELECT count(*) as count FROM ct_holiday WHERE ct_holiday.active = 1
SELECT id, id AS ct_holiday_id FROM ( SELECT DISTINCT ON (q.id) id, row FROM ( SELECT ct_holiday.id, row_number() OVER() as row FROM ct_holiday WHERE ct_holiday.active = 1 ) as q ) as fin ORDER BY row
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
2018-11-24 00:00:00
/templates/website/content/images/BarCrawls-4thOfJuly-Generic-Flyer.jpg
Raising a toast to the red, white and booze, BarCrawls.com invites you to get star-spangled hammered as you embark on our highly anticipated 4th of July Bar Crawl. In an effort to properly celebrate America’s birthday, we have partnered up with top pubs saloons, taverns and bars to spread patriotism throughout your city by way of firecracking drink specials and cover-free admission. An all-American barhopping celebration, BarCrawls.com’s 4th of July Bar Crawl is sure to leave you and your fellow crawlers seeing stars and stripes.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-Halloween-Generic-Flyer.jpg
<p>Trick or treat yourself to a hauntingly unforgettable Halloween with BarCrawls.com’s spellbinding Night of the Crawling Dead, an All Hallow’s Eve barhopping experience that will leave heads rolling. Partnering up with your city’s premier saloons, bars, taverns and pubs, you are invited to get dressed up and messed up in ghoulish glamour for a full weekend of to-die-for drink specials, cover-free admission at all participating venues. For one howl of a time this Halloween, look no further than BarCrawls.com’s spooktacular Night of the Crawling Dead Bar Crawl......</p>
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-TGE-Generic-Flyer.jpg
Make your ancestors proud as you embark on Get Basted, a booze-enthused barhopping voyage colonized by BarCrawls.com and your city’s most wonder-fowl bars, pubs, taverns and saloons. A Thanksgiving Eve crawl highlighted by drink specials and cover-free admission at all participating venues, the time to get stuffed, give thanks and Get Basted is now.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-XmasEve-Generic-Flyer.jpg
Naughty never felt quite as nice as it does at BarCrawls.com’s Bad Santa Bar Crawl. Hosted by some of the city’s ho-ho-hottest bars and pubs, this bar-hopping holiday party reminds us that when it comes to the season of giving, the best gifts aren’t wrapped in ribbon but rather served in a chilled mug, preferably by way of dangerously discounted drink specials and cover-free admission. So don we now our red and green apparel for an indulgent celebration of yuletide cheer, loud for all to hear as we join BarCrawls.com for its annual Bad Santa Bar Crawl, a true Christmas miracle.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-NYE-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-nye-2017-banner.jpg
As the year comes to a close, celebrate your party-rocking past, present and future by slipping into something sparkly and crawling your way into the new year with BarCrawls.com at Crawl Til The Ball Falls, an end-of-year barhopping blowout. Hosted by some of the best pubs, saloons, bars and taverns that your city has to offer, look no further than this New Year’s Eve crawl for outstanding drink specials and cover-free admission to all participating venues. From dusk on December 31st 'til dawn on January 1st, tickets to this New Year’s party ensure that you end this year and kick off the next like you always wanted—on a wild brews-chase, of course! BarCrawls.com’s Crawl Til The Ball Falls invites you to a NYE bash sure to rock until you or the iconic Times Square ball drops—whichever comes first.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-SPD-Generic-Flyer.jpg
/templates/website/content/images/barcrawls.com-irishstroll-banner.jpg
<p>Irish or otherwise, join us for a full weekend of Irish luck as BarCrawls.com is proud to present its annual St. Patrick’s Day bar crawl, Irish Strolls. From the top o’ the morning to the end of the rainbow, your city’s top bars, pubs, taverns and saloons will be serving up full-blarney festivities by way of unbeatable drink specials, cover-free admission and more. Raising the bar on St Patty’s Day shamrocking, BarCrawls.com will also be hosting a full weekend of bar events and parties ensuring that you find your pint of gold over and over again. With bottomless brews and your greenest hues, BarCrawls.com invites you to make this.....</p>
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
/templates/website/content/images/BarCrawls-CincoDeMayo-Generic-Flyer.jpg
After a long harsh winter of indoor drinking, it is finally time to shed layers and inhibitions by joining us for BarCrawls.com’s Cinco de Mayo Bar Crawl. Your chance to soak up the sun, Latin-American culture and plenty of margaritas, this barhopping party’s highlights include caliente drink specials, cover-free admission to some of your city’s best bars, pubs, taverns and saloons and more. One fiesta you truly don’t want to miss, BarCrawls.com’s Cinco de Mayo Bar Crawl is the ultimate summer prelude party.
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
*DEPTH TOO GREAT*
ct_holiday {
date,
holiday1,
holiday2,
holiday3,
holiday4,
holiday5,
holiday6,
name,
on_crave,
slug
}
131132 # $access_groups to global (for authenticate hook)133 # authentication hook134 $access_groups = $router->settings['access_groups'];135 include 'includes/hooks/login-authenticate.php';136137 # run the page138 $p->run();139140 # output the error if the master is down141 if ($db_host && !$dbw && !$p->is_ajax_request) {142 echo $master_db_connect_error;143 } else {144 // no problems with the master db145 // make sure our php-cron-daemon is running only on one host
28 $codebase_path . 'cms/',29 $codebase_path . 'jb-inc/',30 $skyphp_codebase_path31 );32 */333435 include $skyphp_codebase_path . 'sky.php';