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 ?>



Connecting to MySQL server: p3plzcpnl506558.prod.phx3.secureserver.net with user: twincitiesfun
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, t3.ent_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Pull tabs ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Pizza' AND t1.est_id = t5.est_id AND t5.music_type = 'Jazz ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30Query: 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, t3.ent_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Pull tabs ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Pizza' AND t1.est_id = t5.est_id AND t5.music_type = 'Jazz ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Query: 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, t3.ent_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Pull tabs ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Pizza' AND t1.est_id = t5.est_id AND t5.music_type = 'Jazz ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC
Query: SELECT date_format(date2, '%Y-%c-%e') as ArticleDate FROM featured_events
Query: SELECT eo.est_id, est_name, est_city, icon FROM est_overview as eo, type_of_est as toe WHERE eo.est_id = toe.est_id AND toe.est_type = 'Restaurants' AND eo.accnt_type = 'P' AND publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT eo.est_id, title, `description`, est_name, est_city FROM perks as p, est_overview as eo WHERE eo.est_id = p.est_id AND eo.publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT est_type, count(*) AS Count FROM type_of_est as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.est_type ORDER BY Count DESC LIMIT 8
Query: SELECT ent_type, count(*) AS Count FROM type_of_entertain as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.ent_type ORDER BY Count DESC LIMIT 8
Query: SELECT cuisine_type, count(*) AS Count FROM type_of_cuisine as toc, est_overview as eo WHERE eo.est_id = toc.est_id AND eo.accnt_type = 'P' GROUP BY toc.cuisine_type ORDER BY Count DESC LIMIT 8
Query: SELECT music_type, count(*) AS Count FROM type_of_music as tom, est_overview as eo WHERE eo.est_id = tom.est_id AND eo.accnt_type = 'P' GROUP BY tom.music_type ORDER BY Count DESC LIMIT 8
Query: SELECT perks_type, count(*) AS Count FROM type_of_perks as top, est_overview as eo WHERE eo.est_id = top.est_id AND eo.accnt_type = 'P' GROUP BY top.perks_type ORDER BY Count DESC LIMIT 8
Query: SELECT est_city, count(*) AS Count FROM est_overview as eo WHERE eo.accnt_type = 'P' GROUP BY eo.est_city ORDER BY Count DESC LIMIT 8
Query: SELECT event_type, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.event_type ORDER BY Count DESC LIMIT 9
Query: SELECT dotw, dotw_num, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.dotw, de.dotw_num ORDER BY dotw_num ASC LIMIT 7
Jazz Music Pizza Food Pull tabs in the Twin Cities | Twincitiesfun.com



Jazz Music Pizza Food Pull tabs in the Twin Cities

6 Results, Scroll down to view
Search Options
+More Map
Sort: Featured | Name | City
1 - 6 of 6 Results
Query: SELECT title FROM perks WHERE est_id = '003748'

TCFun
Discount!

Burnsville Ale House

3809 Highway 13 W. Burnsville, MN 55337
952-882-2911
Query: SELECT * FROM gift_cards WHERE est_id = 3748 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '003748' ORDER BY music_type

Music: 80's  All Types  Bar Top 40  Blues  Classic Rock  Cover Music  Jazz  Jukebox  Live Concerts  Oldies  Pop  R&B  Rock  Top 40 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '003748' ORDER BY cuisine_type

Cuisine: All Deitary Needs  American  Asian  Burgers  Dessert Menu  Fish  fresh Salad  Grill  Homemade Pastry  Jamaican  Kids Menu  Meat  Mexican  MSG Free  Pizza  Salad  Seafood  Soul Food  Southwestern  Specialty Sandwhich  Take out  Vegetarian  Wings 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003748' ORDER BY ent_type

Amenities Arcade Games  Bachelor/ette Party Specials  Bands  Birthday Parties  Children's Menu  Darts  Dine in / Take out  DTV  Family Friendly  Full-Service Bar  Gift Cards  Grooms Dinners  Happy Hour  Jukebox  Live Music  NFL Sunday Ticket  Outdoor/Patio  Private Party   Pull tabs  Receptions/wedding  Take Out  TV  Wi-Fi 

Query: SELECT title FROM perks WHERE est_id = '003540'

Dugout Bar

96 Mahtomedi Ave Mahtomedi, MN 55115
651-429-8640
Query: SELECT * FROM gift_cards WHERE est_id = 3540 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '003540' ORDER BY music_type

Music: Blues  Classic Rock  House  Jazz  Jukebox  Live Music  R&B  Top 40 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '003540' ORDER BY cuisine_type

Cuisine: American  Pizza  Soup  Take out 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003540' ORDER BY ent_type

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Big Screen TV  Birthday Parties  Darts  Family Friendly  Happy Hour  Jukebox  Live Music  Other  Outdoor/Patio  Pool Tables  Pull tabs  Receptions/wedding  Take Out  Texas Hold'em  Wi-Fi 

Query: SELECT title FROM perks WHERE est_id = '003770'

Eagles 34

2507 E. 25th St. Minneapolis, MN 55406
612-724-9714
Query: SELECT * FROM gift_cards WHERE est_id = 3770 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '003770' ORDER BY music_type

Music: Blues  Cajun Music  Country  Dinning Music  Jazz  Live Music  Rock 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '003770' ORDER BY cuisine_type

Cuisine: American  Burgers  Chicken  fresh Salad  Pizza  Salad  Seafood  Soup  Vegetarian 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003770' ORDER BY ent_type

Amenities Banquet  Bar Bingo  Big Screen TV  Bingo  Birthday Parties  Brunch  Catering  Dancing  Dart Tournaments  Darts  Family Friendly  Full-Service Bar  Happy Hour  Karaoke  Meeting Room  Meetings  Outdoor/Patio  Private Party   Progressive Bango  Pull tabs  Receptions/wedding  Take Out  Trivia  Wi-Fi 

Query: SELECT title FROM perks WHERE est_id = '003595'

Fireside Pizza

3410 150th Street Rosemont, MN 55068
651-423-1822
Query: SELECT * FROM gift_cards WHERE est_id = 3595 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '003595' ORDER BY music_type

Music: 80's  Blues  Country  Eclectic  House  Jazz  Live Music  Rock  Top 40  World 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '003595' ORDER BY cuisine_type

Cuisine: American  Italian  Pizza  Salad Bar  Subs  Vegetarian  Wings 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003595' ORDER BY ent_type

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Bar Bingo  Big Screen TV  Boot Hockey ice rink  Darts  Happy Hour  Indoor Sports  Pull tabs  Restaurant Employee Hospitality Specials 

Query: SELECT title FROM perks WHERE est_id = '003420'

Sarna's Classic Grill

3939 University Ave. Columbia Heights, MN 55421
763-788-3939
Query: SELECT * FROM gift_cards WHERE est_id = 3420 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '003420' ORDER BY music_type

Music: Blues  Jazz  Live Music  Mix  Rock  Top 100 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '003420' ORDER BY cuisine_type

Cuisine: American  Breakfast  Catering  Dessert Menu  Fish  fresh Salad  Pizza  Seafood  Soup  Steaks  Take out 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003420' ORDER BY ent_type

Amenities Arcade Games  Big Screen TV  Brunch  Catering  Family Friendly  Live Music  MLB Extra Innings  NBA League Pass  NFL Sunday Ticket  NHL Center Ice  Outdoor/Patio  Progressive Bingo  Pull tabs  Receptions/wedding  Reservations Accepted  Restaurant Employee Night  Take Out 

Query: SELECT title FROM perks WHERE est_id = '002280'

Tasty Pizza - Hangar 45

875 45th Ave NE Hilltop, MN 55421
763-571-2722
Query: SELECT * FROM gift_cards WHERE est_id = 2280 AND publish = '1'
Query: SELECT tm.music_type FROM type_of_music as tm WHERE tm.est_id = '002280' ORDER BY music_type

Music: Acoustic  Blues  Jazz  Live Music  Rock 

Query: SELECT tc.cuisine_type FROM type_of_cuisine as tc WHERE tc.est_id = '002280' ORDER BY cuisine_type

Cuisine: American  Italian  Pizza 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '002280' ORDER BY ent_type

Amenities Family Friendly  Karaoke  NFL Sunday Ticket  Pull tabs 


1 - 6 of 6 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