Upcoming Shows & Events

array ( 'events_id' => '30', 'YEAR' => '2020', 'MONTH' => '1', 'date_number' => '16', 'month_date' => '1/16', 'title' => 'Broadway Our Way 2020', 'status' => '1', 'ticket_link' => 'https://ci.ovationtix.com/35219/performance/10427980', )
January 2020
  • 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-1-01' and STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) < '2020-2-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
  • 31
  •