mySQL error: 1054
Unknown column 'character_id' in 'on clause'
Query: SELECT c.*, user_name, edit_id, edit_user_id, (SELECT user_name AS user_name2 FROM users, edit_log WHERE user_id = edit_user_id AND edit_table_name = 'characters' AND edit_view = 1 ORDER BY edit_date DESC LIMIT 1) AS user_name2 FROM characters c, users u LEFT JOIN edit_log e ON edit_table_name = 'characters' AND edit_data_1 = character_id AND edit_view = 1 WHERE user_id = character_user_id AND character_checked = 1 GROUP BY character_id ORDER BY character_order, edit_date DESC