SELECT s.*,sv.*,i.*, STR_TO_DATE( start_date, '%m/%d/%Y' ) AS DATE_START, STR_TO_DATE( end_date, '%m/%d/%Y' ) AS DATE_END FROM `shows` s LEFT JOIN `show_venue` sv ON s.sshow_venue = sv.cc_id LEFT JOIN `images` i ON i.i_show_id = `s`.`show_id` WHERE (`s`.`show_id` = '296' AND i.it_id = '3') LIMIT 11

FANCY/FREE

Sunday, November 12, 2017

Stay Tuned 
For Bernstein's 100th, a celebration of the FREEDOM of music.


You May Also Like

Images
04-02-2017
The Tower
more
Images
05-08-2017
Pasadena Ice Skating Center
more
Images
10-08-2017
Location TBA
more