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