Here is the query I ran against AWS Redshift's PostgreSQL database.
select
z.pu_miles_tiers,
z.ustomer_mail,
z.customer_num,
z.customer_prenum,
z.dr,
e.agent_prenom,
e.agent_patronyme
from events e
inner join vouchers z on z.voucher_id = e.parent_id
where nature_id in(2001,2002,2003,2007,2005,2006,5002,2008)
and e.d_dr between '2016-01-26' and '2016-01-27'
