SELECT
o.id_order AS 'ID Zamówienia',
o.reference AS 'Referencja',
o.date_add AS 'Data zamówienia',
osl.name AS 'Status zamówienia',
car.name AS 'Sposób wysyłki',
c.firstname AS 'Imię',
c.lastname AS 'Nazwisko',
c.email AS 'E-mail',
CONCAT(a.phone, ' ', a.phone_mobile) AS 'Numery telefonu',
a.company AS 'Firma',
a.address1 AS 'Ulica i nr',
a.address2 AS 'Adres linia 2',
a.postcode AS 'Kod pocztowy',
a.city AS 'Miasto',
cl.name AS 'Kraj',
od.product_id AS 'ID Produktu',
od.product_reference AS 'Indeks produktu',
od.product_name AS 'Nazwa produktu',
od.product_quantity AS 'Ilość'
FROM ps_orders o
LEFT JOIN ps_customer c ON (o.id_customer = c.id_customer)
INNER JOIN ps_order_detail od ON (o.id_order = od.id_order)
LEFT JOIN ps_order_state_lang osl ON (o.current_state = osl.id_order_state AND osl.id_lang = 1)
LEFT JOIN ps_address a ON (o.id_address_delivery = a.id_address)
LEFT JOIN ps_country_lang cl ON (a.id_country = cl.id_country AND cl.id_lang = 1)
LEFT JOIN ps_carrier car ON (o.id_carrier = car.id_carrier)
WHERE o.date_add >= NOW() - INTERVAL 3 DAY
ORDER BY o.date_add DESC;