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` = '297' AND i.it_id = '3') LIMIT 11

ROCK/ANTHEM

Sunday, October 15, 2017

Stay Tuned
Iconic songs and the FREEDOM of togetherness.


You May Also Like

Images
11-12-2017
Location TBA
more
Images
08-26-2017
@Caltech
more