A Database Error Occurred

Error Number: 1054

Unknown column 'concerts.id' in 'field list'

SELECT concert_instances.id, concert_instances.concert_id, concert_instances.available_tickets, concert_instances.start_time, concert_instances.end_time, concert_instances.start_date, concert_instances.created, concert_instances.modified, concerts.id, concerts.name, concerts.summary, concerts.tickets_required, concerts.prime_price, concerts.preferred_price, concerts.standard_price, concerts.student_or_senior_price, concerts.chapel_or_balcony_price, concerts.concert_note_filename, concerts.image_filename, concerts.special, concerts.created, concerts.modified, calendar_days.title as `day_title`, calendar_days.description as `day_description`, calendar_days.collect as `day_collect` FROM `concert_instances` LEFT Join `calendar_dates` ON `concerts`.`start_date` = `calendar_dates`.`date` LEFT Join `calendar_days` ON `calendar_dates`.`day_id` = `calendar_days`.`id` WHERE `concert_instances`.`id` = '394'