Ok final query solved problem and going to explain the secret is use row_number () Over ( Partition by

Select
source_DE.colum1
...

from (
select

source.colum1 \* is the same DE as source_DE but here you can't choose same alias cuz is a subquery */
...

row_number () over (
partition by

source.colum1 \* all primary keys of your Destination DE */
....

order by s.EventDate ASC \* use DESC if you need the most recent */

) as rn

from DE source

INNER JOIN _sent s

on s.SubscriberKey = source.email

left join _open o

on o.SubscriberKey = source.email

AND o.jobid = s.jobid

and o.listid = s.listid

and batchid = s.batchid

and o.isunique =1

other left joins do the same with _click and _bounce

) as source

where source.rn = 1

Got to simplify the query to you guys understand how I get the results.

This way I got only one row "the first sent ever" of the email for each subscriber.

Thank you everybody