SELECT
	ps_customer.firstname as receiver_name, ps_customer.lastname as receiver_surname, ps_customer.email as receiver_email,
    ps_address.company as receiver_company, ps_address.address1 as receiver_address, ps_address.postcode as receiver_post_code, ps_address.city as receiver_city, ps_address.phone as receiver_phone,
	ps_country.iso_code AS receiver_country, ps_orders.total_paid AS cod_value
FROM ps_orders
JOIN ps_customer ON ps_customer.id_customer = ps_orders.id_customer
JOIN ps_address ON ps_address.id_customer = ps_orders.id_customer
JOIN ps_country ON ps_country.id_country = ps_address.id_country
WHERE ps_orders.date_add > '2014-02-02'
ORDER BY ps_orders.date_add DESC