Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT order_customFields.order_customFields_delivery_method,
- sum(case `order`.order_status when 'paid' then 1 else 0 end) paid,
- sum(case `order`.order_status when 'later' then 1 else 0 end) later,
- sum(case `order`.order_status when 'delivery-approved' then 1 else 0 end) deliveryapproved,
- sum(case `order`.order_status when 'problem' then 1 else 0 end) problem
- FROM order_customFields
- INNER JOIN `order` ON order_customFields.order_id = `order`.order_id
- WHERE
- order_customFields.order_customFields_order_date >= '2016-12-01' AND
- order_customFields.order_customFields_order_date <= '2016-12-31'
- AND order_customFields.order_customFields_delivery_method is not null
- GROUP BY
- order_customFields.order_customFields_delivery_method
Add Comment
Please, Sign In to add comment