Cacher is the code snippet organizer for pro developers

SELECT o.id_order, o.date_add, concat(c.firstname, ' ', c.lastname) as name, c.email 
FROM ps_orders o left JOIN ps_customer c ON o.id_customer = c.id_customer 
WHERE o.current_state <> 6 
AND o.date_add >= '2018-04-4 00:00:00'
ORDER BY o.date_add DESC