Upcoming Shows & Events

• S
• M
• T
• W
• T
• F
• S
•  
•  
•  
SELECT events.e_id as events_id, 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' ) ),'%c/%e') as month_date, shows.title, shows.status, 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' ) ) >= '2020-4-01' and STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) < '2020-5-01' and e_status=1 and shows.status = '1'
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
•  
•