SELECT shows.show_id as show_id, shows.ticket_status as ticket_status, events.e_id as events_id, events.e_time as e_time, date_format(STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ),'%e') as date_number, date_format(STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ),'%W') as day_name, date_format(STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ),'%c/%e') as month_date, shows.title, shows.show_type, events.e_ticket_link as ticket_link from events, shows where events.e_show_id=shows.show_id and STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) >= DATE_SUB(now(), INTERVAL 1 DAY) and STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) >= '2017-1-01' and STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) < '2017-2-01' and e_status=1 && (events.e_tbd != '1' && events.e_group != '1') ORDER BY STR_TO_DATE(events.`e_date`, '%m/%d/%Y'), shows.`title`, STR_TO_DATE(events.`e_time`, '%m/%d/%Y')