I got this error:
Code: Select all
Error: Unknown column 'o.order_status' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM order_download od LEFT JOIN `order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '3' AND o.order_status > '0' AND o.order_status_id = '5'