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