mySQL error: 1054
Unknown column 'c.chapter_id' in 'on clause'
Query: SELECT c.*, u.user_name, l.location_id, l.location_name, p.character_id, p.character_name, e.edit_id, e.edit_user_id, (SELECT user_name AS user_name2 FROM users, edit_log WHERE user_id = edit_user_id AND edit_table_name = 'chapters' AND edit_view = 1 ORDER BY edit_date DESC LIMIT 1) AS user_name2 FROM chapters c, users u, locations l, characters p LEFT JOIN edit_log e ON e.edit_table_name = 'chapters' AND e.edit_data_1 = c.chapter_id AND e.edit_view = 1 WHERE u.user_id = c.chapter_user_id AND c.chapter_checked = 1 AND l.location_id = c.chapter_location_id AND p.character_id = c.chapter_character_id GROUP BY c.chapter_id ORDER BY c.chapter_order, e.edit_date DESC