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' **************************************************************************************************** ?>
Featured Artist

Kiss Tribute Band KYSS
Tribute bands are always a huge hit at local venues and Cincy has its own KISS tribute band comprised of super talented musicians from both original and cover bands. The Cincy KISS tribute KYSS is a show that certainly warrants great attention. We sat down with KYSS members and hit them hard with our ten questions.
Read more

cv logo
site search by freefind advanced

Event Calendar
Post your gig

 

Cincinnati Bands

3 Day Rule

Pop, Rock

5 Richards

After Midnight

Classic Rock

Amish Mafia

Classic rock

Amnesia Lane

Pop, Dance

Another Tragedy

Metal, Rock

Backbeat

Cover/Tribute

Balderdash

Blues, Soul, R&B

Basic Truth

Funk, R&B, Soul

The Ben Peterson Band

Acoustic, Classic Rock

Big In Vegas

Classic Rock

Blackjack Alley

Blues Merchants

Blues, R&B

Boe Davis

Caleb

Hip Hop

Color Blind

Funk, Hip Hop/Rap, R&B

Dallas Moore

Country, Rock, Southern

Dan Varner Band

Classic Rock, Country, Singer/Songwriter

Dr. Dan And The Stray Dogs

Classic Rock

East Fork Junction

Bluegrass

Empty Garden

Farehaven

Alternative/Modern Rock, Heavy Metal

Fathead Davis

R&B

Fish Head

Blues, R&B

Full Circle

Classic Rock

Greg Blachman

Rock, Progressive Rock, Progressive

Hogwild

Hurricane Jane

Classic Rock, Modern Rock

Jake Speed

Singer/Songwriter


Jimmy's New Invention

Alternative/Modern Rock, Cover/Tribute, Classic Rock

John Ford

Classic Rock
Singer/Songwriter

Leadfoot Johnny

Funk, Rock & Roll, R&B, Soul

Livid


Mad Life Crisis

Classic Rock, Modern Rock

Medicine Men

Blues, Funk, Jazz, R&B

Model Behavior

Pop Rock

Mostly Gentlemen

Country, Southern Rock

Naked Karate Girls

OFF R ROCKERS

Classic Rock, Rock, Country

One Man Electrical Band
Parti Gras

Reason 420

Rock, Hard Rock

Rusty Griswolds

Second Chance At Eden

Rock

Six Pac Band

Sonny Moorman

Blues
Singer/Songwriter

Spare Change

Rock

Strange Love

Cover, Tribute

Tempted Souls

Soul, Rock, R&B, Blues

The Gamut

Blues, Classic Rock

The Irocs

The Kevin Fox Band

Acoustic, Pop, Rock
Singer/Songwriter

The Refranes

The SunBurners

Pop, Country, Reggae,
Trop-Rock

The Whiskey Shambles

Them Carls

Vaughn & Company

Singer/Songwriter

Waiting On Ben

Light Jazz, Vintage Rock,
Acoustic Rock

Weezy Jefferson

Pop, Rock

Zack Attack

 

4th Day Echo

Rock

Acoustic Music By Monte

Altered

Rock, Hard Rock

Anna and Milovan

Acoustic Pop, New Folk, Blues
Singer/Songwriter

Antic Terror

Bad Habit

Classic Rock

Bam Bam & The Wayouts

Classic Rock, Rock, Southern
Rock and Blues

Barcodes
Beauty From Ashes

Big Ham Band

Blues, Funk, R&B

Big Whiskey

Blue Caboose

Folk, Bluegrass

Bob Cushing

Classic Rock, Country
Singer/Songwriter

Boo Radley

Catch 22

Alternative/Modern Rock, Cover/Tribute, Classic Rock

Cover Model

Dalton Street Gang

Blues, Classic Rock, R&B

Devils Due

80's Rock

DV8

Alternative/Modern Rock, Classic Rock, Cover/Tribute

Eclipse

Euphoria

Classic Rock

Fast Forward Band

Final Order

Alternative/Modern Rock, Cover/Tribute, Heavy Metal

Five O' Clock Friday

Alternative/Modern Rock,
Classic Rock

Gangbox

Greg Loving

Blues, Folk, Rock, Country

Holly Spears

Acoustic, Rock, Pop
Singer/Songwriter

Jack Trigger

Rock/Cover

Jerry's Little Band

Jam

Joey Said No

Dance, Modern Rock, Classic Rock, Pop

Kyle English

Acoustic
Singer/Songwriter

Little Rebel Band

Bluegrass, R&B, Rock & Roll

Ma Crow and The Lady Slippers

Acoustic, Folk, Bluegrass


Marsha Brady


Midnight Special

Classic Rock

Montage
My Sister Sarah
Noisewater
Old Skool Band

One Nite Stand

Rock

Perfect Norm

Jam

Right Turn Clyde

Southern Rock, Classic Rock, Alternative/Modern Rock

Saffire Express

Classic Rock, Country, Pop, R&B

Silver Arm

Irish Dance Music

Slim Tempo and The Changeups
Southern Savior
Stays In Vegas
Stone Soup

Sullivan Janszen Band

Alternative, Classic Rock

Terry Lee and the
Rockaboogie Band

50's Rock n' Roll, Country, Classic Country, R&B

The Goodle Boys

Americana, Bluegrass


The Juice

R&B, Blues, Rock, Funk

The Menus
The Stray Mafia

The Whammies

80's Cover, Classic Rock

The Wrigleys

Unleashed

Alternative/Modern Rock, Cover/Tribute, Classic Rock

Voodoo Puppet

Blues-Rock

 

Wasted Charm

Pop, Classic Rock



















































Recently added

Southern Savior
Zack Attack
The Whiskey Shambles
The Refranes
The Wrigleys


|
|
|
|
|
|
|
|