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` = '3')
LIMIT 11
