Code Snippet

SELECT 
    c.id_customer AS customer_id,
    c.firstname AS first_name,
    c.lastname AS last_name,
    c.email AS email,
    a.address1 AS address_line_1,
    a.address2 AS address_line_2,
    a.postcode AS postal_code,
    a.city AS city,
    a.phone AS phone,
    a.phone_mobile AS mobile_phone,
    o.id_order AS order_id,
    o.date_add AS order_date,
    o.total_paid AS order_total
FROM
    ps_customer c
JOIN 
    ps_orders o ON c.id_customer = o.id_customer
JOIN 
    ps_address a ON o.id_address_delivery = a.id_address
WHERE 
    o.date_add BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59'
GROUP BY 
    c.id_customer, o.id_order
ORDER BY 
    o.date_add DESC;