FANCY/FREE

Sunday, November 12, 2017

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


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 s.show_id = i.i_show_id AND i.it_id = 2
                            WHERE `s`.`show_id`  IN (294,297) 
                            GROUP BY `s`.`show_id`
                            LIMIT 3

You May Also Like

05-08-2017
Pasadena Ice Skating Center
more
10-15-2017
Location TBA
more