Всем привет. В файле /admin/model/sale/order.php в функции getOrders есть запрос:
$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname, '<br>', o.telephone) AS customer, (SELECT os.color FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";
Пытаюсь добавить еще один результат для получения:
$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname, '<br>', o.telephone) AS customer, (SELECT os.name_panel, os.color FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";
Сразу получаю ошибку:
Fatal error: Uncaught Exception: Error: Operand should contain 1 column(s)<br />Error No: 1241<br />SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname, '<br>', o.telephone) AS customer, (SELECT os.name_panel, os.color FROM bsea_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `bsea_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5 in /var/www/...блаблабла
Подскажите пожалуйста, что я не так делаю?