cv logo
site search by freefind advanced

Event Calendar
Post your event

 

 

 

 

 

 


Clubs - Pubs - Restaurants

20 Brix
Adis
Anna Ree's Andouille
Azad India Restaurant
Back Porch Saloon
Backyard Inn
Blue Wisp Jazz Club
Bobby Mackey's
Bocca Billiards
Boogie Nights
By Gollys
Chinatown Buffet
Cindy's Friendly Tavern
DJ's Sport's Tavern
El Jinete
El Picante
Foreign Exchange
Front Street Cafe
Fuji Steakhouse
Go Bananas
Gramma's Pizza
Great Scott
Hibachi Grill
Hibachi Master
House Of Billiards
Indian Bistro
Inner Circle
J & B Tavern
Knotty Pine
Latitudes Cafe Anderson
Lebos
Legends Nightclub
Little Caesars
Macadu's
Mad Frog
Madison Theater
McLevy's Pub
Mio's
MJ's On Main
Mt. Carmel Pub
Old Boston Pizza
Padrino
Paxton's Grill
Pete's Cafe
Pirates Den
Putter's Tavern Maineville
Putter's Tavern Milford
Putter's Tavern West Chester
Quaker Steak & Lube
Ricks Tavern
Rong Tans
Royal Taj

RP McMurphy's Irish Pub
Shaffer's Shack
Smokey Bones
Sports Rock Bar & Grill
Stanley's Pub
Sushi Cincinnati
Swamp Water Grill
Tapouts Sports Bar
The Lake
The Landing
The Lounge
The Sandbar
The Still
The Varsity
The Veg Head
The Venue
Tong's Thai
Tostados Grill
Towerview Sports Bar
Township Fields & Tavern
Traci's Sports Lounge & Grill
Win Place or Show

 

 

Featured

DJ's Sports Tavern

Reviewing any pub’s grub always makes my nerves uneasy. Especially a brand new one. Fact is pub food is usually poor quality cheapie frozen stuff.
Read more



Recent Comments"; $comments = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' ORDER BY `dated` DESC LIMIT 10"); while ($comment = mysql_fetch_array($comments)) { $page_query = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '" . $comment["page_id"] . "'"); $page = mysql_fetch_assoc($page_query); echo $comment["name"] . " on " . $page["reference"] . " at " . date("g:ia (jS-M)", strtotime($comment["dated"])); echo "
"; } // End of 'Recent Comments' ************************************************************************************************ echo "

"; // Start of 'Most Commented' *********************************************************************************************** echo "

Most Commented

"; $comments = mysql_query("SELECT `page_id`, COUNT(`page_id`) AS `total` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' GROUP BY `page_id` ORDER BY `total` DESC LIMIT 5"); while ($comment = mysql_fetch_assoc($comments)) { $page_query = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '" . $comment["page_id"] . "'"); $page = mysql_fetch_assoc($page_query); echo "" . $page["reference"] . " (" . $comment["total"] . ")"; echo "
"; } // End of 'Most Commented' ************************************************************************************************* echo "

"; // Start of 'Top Posters' ************************************************************************************************** echo "

Top Posters

"; $names = mysql_query("SELECT `name`, COUNT(`name`) AS `total` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' GROUP BY `name` ORDER BY `total` DESC LIMIT 5"); while ($name = mysql_fetch_assoc($names)) { echo $name["name"] . " (" . $name["total"] . ")"; echo "
"; } // End of 'Top Posters' **************************************************************************************************** echo "

"; // Start of 'Best Rated' ************************************************************************************************** echo "

Best Rated

"; $comments = mysql_query("SELECT `page_id`, AVG(`rating`) AS `average` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' AND `rating` != '0' GROUP BY `page_id` ORDER BY `average` DESC LIMIT 10"); while ($comment = mysql_fetch_assoc($comments)) { $average = round($comment["average"] / 0.5) * 0.5; $page_query = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '" . $comment["page_id"] . "'"); $page = mysql_fetch_assoc($page_query); echo "" . $page["reference"] . " (" . $average . ")"; echo "
"; } // End of 'Best Rated' **************************************************************************************************** ?>
|
|
|
|
|
|
|
|