saveIntoErrorLog("DBConnection.php", "DBConnection()", "mysqli_connect()", mysqli_connect_error()); return false; } // Set charset for the connection mysqli_set_charset($connection, 'utf8'); $this->connection = $connection; $this->statement = true; // With mysqli_connect, database is selected automatically return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "DBConnection()", "", $e); return false; }*/ } function CloseConnection() { //try { $close = mysqli_close($this->connection); if(!$close) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "mysqli_close()"); } return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "", $e); return false; }*/ } /** * Execute query for select */ function SelectQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rowCount = 0; $resultData = array(); while($rowData = mysql_fetch_array($this->dbResult, MYSQL_ASSOC)) { $resultData[$rowCount] = $rowData; $rowCount++; } mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Insert */ function InsertQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $id = mysql_insert_id(); mysql_free_result($this->dbResult); return $id; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Update/Delete */ function ExecuteQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysqli_query($this->connection, $this->dbQuery); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rows = 0; $rows = mysqli_affected_rows($this->connection); mysqli_free_result($this->dbResult); return $rows; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute queries for webservice */ function SelectQueryResult($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $resultData = $this->dbResult; //mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Use this method to log the database errors. */ function saveIntoErrorLog($fileName="", $methodName="", $sqlQuery="", $exception="") { $errorCode = mysql_errno(); $errorText = mysql_error(); $errorMessage = "File: ".$fileName.", Method/Function: ".$methodName.", Query: ".$sqlQuery.", Error: ".$errorCode."-".$errorText; if($exception != "") $errorMessage.= " Exception : ".$exception ; // timestamp for the error entry $errorMessage = "[".date("j-M-Y H:i:s (T)")."] ".$errorMessage."\r\n"; // save to the error log error_log($errorMessage, 3, ERROR_LOG."ErrorLog".date("j-M-Y").".log"); } } //ends the class over here ?> SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t2.est_type, t3.ent_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Take Out' AND t1.est_id = t3.est_id AND t3.ent_type = 'Pool Tables ' AND t1.est_id = t5.est_id AND t5.music_type = 'Rock' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Take Out Rock Music with Pool Tables in the Twin Cities | Twincitiesfun.com



Take Out Rock Music with Pool Tables in the Twin Cities

8 Results, Scroll down to view
Search Options
+More Map
Sort: Featured | Name | City
1 - 8 of 8 Results

Bogart's Nightclub / Apple Place Lanes

14917 Garrett Avenue S Apple Valley, MN 55124
952-432-1515

Place to Go: 21+ Clubs  Arcades  Bars/Nightclubs  Bowling Alleys  Nightclub  Outdoor/Patio  Pizza  Restaurants  Sports Bars  Take Out 

Music: 80's  All Types  Bar Top 40  Hip Hop  Live Music  R&B  Rock 

Amenities Arcade Games  Big Screen TV  Birthday Parties  Bowling  Corporate Team Building  Dancing  Family Friendly  Jukebox  Karaoke  Ladies Night  Live DJ  Live Music  Outdoor/Patio  Pool Tables  Pull tabs  Restaurant Employee Night  Take Out  Texas Hold'em 

Dick's Vape Shop

7777 Hwy 65 Spring Lake Park, MN 55432
763-463-9807

Place to Go: 18+ Clubs  21+ Clubs  Bars/Nightclubs  Billiards/Pool Halls  E-cigs store  Electronic cigarettes  Fun  Miscellaneous  Music Venue  Other  Outdoor/Patio  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Retail  Sand Volleyball  Seasonal Fun  Sports Bars  Summer Destinations  Take Out  Vape Shop  Weekend Breakfast/Brunch  WiFi Hotspots 

Music: Classic Rock  Country  Rock 

Amenities Big Screen TV  Bingo  Birthday Parties  Breakfast  Catering  Dart Tournaments  Darts  Dine in / Take out  Featured Hotspots  Full-Service Bar  Happy Hour  Indoor Sports  Other  Outdoor Sports  Outdoor/Patio  Pool Tables  Pool Tournaments  Pull tabs  Reservations Accepted  Sand Volleyball  Take Out  Wi-Fi 

Jersey's Bar & Grill

6449 Concord Blvd Inver Grove Heights, MN 55076
651-455-4561

Place to Go: Bars/Nightclubs  Nightclub  Restaurants  Sports Bars  Take Out 

Music: Alternative  DJ  Hip Hop  Jukebox  Live Music  R&B  Rock 

Amenities Arcade Games  Family Friendly  Jukebox  Pool Tables  Pull tabs  Take Out  Wi-Fi 

Povlitzki's on 65

8407 NE Plaza Blvd. Spring Lake Park, MN 55432
763-784-7110

Place to Go: 21+ Clubs  Bars/Nightclubs  Nightclub  Restaurants  Sports Bars  Take Out 

Music: 80's  Country  Rock 

Amenities Arcade Games  Banquet  Big Screen TV  Birthday Parties  Catering  Darts  Jukebox  Live Music  Pool Tables  Pool Tournaments  Pull tabs  Receptions/wedding  Take Out  Texas Hold'em 

The Dog House Bar and Grill

2029 Windlynn Ave Maplewood, MN 55109
651-621-1535

Place to Go: Arcades  Bars/Nightclubs  Music Venue  Outdoor/Patio  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Music: 80's  Acoustic  Alternative  Country  Indie Rock  Jukebox  Live Concerts  Live Music  Rock  Top 40 

Amenities Arcade Games  Bar Bingo  Big Screen TV  Birthday Parties  Darts  Family Friendly  Happy Hour  Jukebox  Karaoke  Ladies Night  Live Music  Open Mic/Amateur Night  Outdoor/Patio  Pool Tables  Progressive Bingo  Restaurant Employee Hospitality Specials  Tri-wheel®  Wi-Fi 

Whiskey Junction

901 Cedar Ave. S. Minneapolis, MN 55404
612-338-9550

Place to Go: 21+ Clubs  Bars/Nightclubs  Billiards/Pool Halls  Catering  Delivery  Music Venue  Outdoor/Patio  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Take Out  Weekend Breakfast/Brunch  WiFi Hotspots 

Music: Blues  Country  Live Music  R&B  Rock 

Amenities Bachelor/ette Party Specials  Big Screen TV  Birthday Parties  Brunch  Catering  Family Friendly  Happy Hour  Live Music  Outdoor/Patio  Pool Tables  Pool Tournaments  Pull tabs  Receptions/wedding  Wi-Fi 

Casey's Bar and Grille

Closed Minneapolis, MN 55408
612-825-3229

Place to Go: Bars/Nightclubs  Outdoor/Patio  Restaurants  Sports Bars  Take Out 

Music: All Types  Bar Top 40  Blues  Classic Rock  Country  House  Jukebox  Live Music  Rock 

Amenities Arcade Games  Big Screen TV  Birthday Parties  Darts  Happy Hour  Jukebox  Ladies Night  Live Music  Outdoor/Patio  Pool Tables  Take Out 

Fatboys Bar & Grill

Closed East Bethel, MN 55011
763-434-8181

Place to Go: Bars/Nightclubs  Nightclub  Outdoor/Patio  Restaurants  Sports Bars  Take Out 

Music: Acoustic  Blues  Country  DJ  House  Jukebox  Live Music  R&B  Rock 

Amenities Arcade Games  Big Screen TV  Brunch  Catering  Dancing  Darts  Family Friendly  Jukebox  Karaoke  Kids Eat Free  Ladies Night  Live Music  NFL Sunday Ticket  Outdoor/Patio  Pool Tables  Pull tabs  Receptions/wedding  Take Out  Texas Hold'em 


1 - 8 of 8 Results
*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.
Popular Searches

Minneapolis Happy Hour

Minneapolis Restaurants

Lunch Specials at Restaurants in St. Paul

Bars/Nightclubs with Indoor Sports

Drink Specials in Mpls