OpenCart Community

Code: Select all

$query_orders = "SELECT orders.orders_id, orders.customers_id, orders.customers_name, orders.customers_telephone, orders.customers_email_address, orders.delivery_name, orders.delivery_street_address, orders.delivery_suburb, orders.delivery_city, orders.delivery_postcode, orders.delivery_country, orders.billing_name, orders.billing_company, orders.billing_street_address, orders.billing_suburb, orders.billing_city, orders.billing_postcode, orders.billing_country, orders.payment_method, orders.cc_type, orders.cc_owner, orders.cc_number, orders.cc_expires, orders.last_modified, orders.date_purchased, orders.orders_status, orders.currency, orders.currency_value, orders_total.value, customers.customers_firstname, customers.customers_lastname  FROM  orders INNER JOIN (customers) ON (customers.customers_id = orders.customers_id) LEFT JOIN orders_total ON orders.orders_id = orders_total.orders_id AND orders_total.class = 'ot_total'" ;

Code: Select all

$query_orders = "SELECT * FROM  " . $source_db_table_prefix . "orders INNER JOIN (" . $source_db_table_prefix . "customers) ON (" . $source_db_table_prefix . "customers.customers_id = " . $source_db_table_prefix . "orders.customers_id) LEFT JOIN " . $source_db_table_prefix . "orders_total ON " . $source_db_table_prefix . "orders.orders_id = " . $source_db_table_prefix . "orders_total.orders_id AND " . $source_db_table_prefix . "orders_total.class = 'ot_total'" ;