A Database Error Occurred

Error Number: 1054

Unknown column 'ch.cnh_itinerary' in 'on clause'

SELECT * FROM cms_newsletter n JOIN cms_newsletter_hotels ch ON n.cn_id = ch.cnh_newsletter_id LEFT OUTER JOIN hotel h ON ch.cnh_hotel_code = h.hotelcode LEFT OUTER JOIN room r ON ch.cnh_room_id = r.room_id LEFT OUTER JOIN ref_location l ON SUBSTRING(ch.cnh_hotel_code, 1, 3) = l.loc_code LEFT OUTER JOIN cms_newsletter_itinerary iti ON ch.cnh_itinerary = iti.id WHERE n.cn_id = '5' ORDER BY cnh_seq ASC