opencart SQL Query Result issue

Code: Select all

$sql = "SELECT op.name AS productname, op.order_id AS order_id, op.quantity AS quantity, op.total AS total, pv.vendorname AS vendorname, vc.commission_type AS commission_type, vc.commission_name AS commission_name, o.currency_value AS currency_value, o.currency_code AS currency_code, op.tax AS tax, os.name AS status, vc.commission AS commission FROM " . DB_PREFIX . "order_product op 
INNER JOIN " . DB_PREFIX . "product_to_vendors pv ON (op.vendors_id = pv.vendors_id) 
INNER JOIN " . DB_PREFIX . "order o ON (o.order_id = op.order_id) 
INNER JOIN " . DB_PREFIX . "vendors_commission vc ON (vc.commission_id = pv.commission_id) 
INNER JOIN " . DB_PREFIX . "order_status os ON os.order_status_id = o.order_status_id
AND o.order_id = op.order_id WHERE op.vendors_id = pv.vendors_id";