From line 119 of order.php:
Code: Select all
$order_query = $this->db->query("SELECT *, (SELECT oh.comment FROM `oc_order_history` oh WHERE oh.order_id = '" . (int)$order_id . "' LIMIT 1) AS order_cc_info, (SELECT os.name FROM `" . DB_PREFIX . "order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `" . DB_PREFIX . "order` o WHERE o.order_id = '" . (int)$order_id . "'");
Code: Select all
SELECT *, (SELECT oh.comment FROM `oc_order_history` oh WHERE oh.order_id = '109' LIMIT 1) AS order_cc_info, (SELECT os.name FROM `oc_order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `oc_order` o WHERE o.order_id = '109'