Get only future records
Looks like you want your current date to be before or on last show date. If that is the case try following HAVING clause.  

HAVING MAX(CAST(CONCAT(shows.show_date, ' ', shows.show_time) AS DATETIME) &gt;= Now()