Ошибка в запросе

[MaJIon]

Здравствуйте почему ошибка в запросе? 

 

(SELECT SUM(mpn) AS mpn FROM " . DB_PREFIX . "order_product WHERE o.order_id = '" . (int)$order_id . "') AS mpn,

Так тоже не катит 
(SELECT SUM(mpn) AS mpn FROM " . DB_PREFIX . "order_product WHERE o.order_id) AS mpn

Полный запрос 

$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, o.shipping_code, o.total, (SELECT SUM(mpn) AS mpn FROM " . DB_PREFIX . "order_product WHERE o.order_id = '" . (int)$order_id . "') AS mpn, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";

 

[MaJIon]

Тема закрыта, решено!