поменял запрос в 3 шаге ошибка такая:
Warning: mysql_query(): Unable to save result set in /home/users/p/system/database/mysql.php on line 21
Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified, (SELECT oh.comment FROM order_history oh WHERE oh.order_status_id = o.order_status_id AND oh.order_id = o.order_id) FROM `order` o WHERE o.order_status_id > '0' ORDER BY o.order_id DESC LIMIT 0,50 in /home/users/p/system/database/mysql.php on line 49
подскажите, в чем может быть проблема? хочу вывести последний коммент админа из истории заказа.