SELECT o1.EMAILADDRESS,
o1.ORDERDATE,
[ZZAll Productions].REGIONID,
[ZZAll Productions].EVENTTYPE,
[ZZAll Productions].EVENTCATEGORY,
[ZZAll Productions].EVENTNAME,
FROM ZZZOrders o1
INNER Join [ZZAll Productions]
ON o1.PRODUCTIONID = [ZZAll Productions].PRODUCTIONID
WHERE o1.ORDERDATE = ( Select top 1 o2.ORDERDATE FROM ZZZOrders o2 where o1.EMAILADDRESS = o2.EMAILADDRESS order by o2.ORDERDATE desc)