$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer,
(SELECT os.name 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,
(SELECT cgd.name FROM " . DB_PREFIX . "customer c LEFT JOIN " . DB_PREFIX . "customer_group_description cgd
ON cgd.customer_group_id = c.customer_group_id
WHERE c.customer_group_id = o.customer_group_id
AND cgd.language_id = '" . (int)$this->config->get('config_language_id') . "')
AS customer_group,, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified
FROM `" . DB_PREFIX . "order` o";
Пропали Группы