SQL Error: Unknown column 'h1.user_id' in 'on clause' at /home/5values/data/www/5values.ru/classes/modules/test/mapper/Test.mapper.class.php line 651
Array ( [code] => 1054 [message] => Unknown column 'h1.user_id' in 'on clause' [query] => SELECT h1.*, u.user_login as user_login, u.user_is_team as user_is_team, u.user_profile_name as user_profile_name, u.user_mail as user_mail, u.user_profile_group as user_profile_group FROM prefix_topic_test_history h1, prefix_user as u LEFT JOIN (SELECT topic_id, user_id, MAX(final_mark) as `final_mark` FROM prefix_topic_test_history WHERE topic_id = 324 AND date_finish > 0 AND ( time_limit = 0 OR (UNIX_TIMESTAMP(date_finish)-UNIX_TIMESTAMP(date_start)) < time_limit*60 ) GROUP BY user_id) as `h2` ON `h1`.user_id = `h2`.user_id WHERE `h2`.topic_id = `h1`.topic_id AND `h1`.user_id = u.user_id AND `h1`.final_mark = `h2`.final_mark GROUP BY h1.user_id ORDER BY h1.`final_mark` DESC [context] => /home/5values/data/www/5values.ru/classes/modules/test/mapper/Test.mapper.class.php line 651 )