SELECT
DATE_FORMAT( event.show_time , \'%l:%i %p\' ) AS show_time ,
DATE_FORMAT( event.door_time , \'%l:%i %p\' ) AS door_time ,
`event`.`date`,
`venues`.`name` as `venue_name`
FROM `artist_events` AS `event`
LEFT JOIN `venues` ON `event`.`venue_id` = `venues`.`id`
WHERE `event`.`date` IS NOT NULL'
AND unix_timestamp(`event`.`date`) > unix_timestamp(date(now() + INTERVAL 8 DAY))
AND `event`.`id` IS NOT NULL
AND `event`.`artist_id` = :artist_id
ORDER BY `event`.`date` ASC