1 2 3 4 5 6 7 8 9 10 11
| SELECT oi.order_id, s.order_status_name, m.payment_method_name, UCASE(u.last_name), u.first_name, FROM_UNIXTIME(oi.mdate), oi.order_item_name, oi.product_quantity, oi.product_final_price, o.order_total, oi.product_attribute, u.zip, u.city, u.user_email, u.phone_1, u.phone_2, o.customer_note
FROM `jos_vm_order_item` oi, `jos_vm_orders` o, `jos_vm_user_info` u, `jos_vm_order_payment` p, `jos_vm_payment_method` m, `jos_vm_order_status` s
WHERE oi.order_id = o.order_id
AND oi.user_info_id = u.user_info_id
AND o.user_info_id = u.user_info_id
AND oi.order_id = p.order_id
AND p. payment_method_id = m. payment_method_id
AND o.order_status = s.order_status_code
AND o.order_status in('C', 'P')
Order by oi.mdate DESC
LIMIT 0 , 200 |
Partager