php - Finding last entity of a joined entity in entityRepository (Symfony2 & Doctrine2)

In my Symfony2 app that represents an Asset Management System there is an entity called Asset. This entity has a OneToMany relationship with another entity called AssetLog. Each AssetLog is linked to one Status which is also an entity.

For example: There might be an asset called Car. This car has a log of what has happened to it, when it has happened and who is responsible for this. Each log entry is linked to a status which could be for: perfect condition, damaged, lost, stolen, etc.

What I am trying to do is writing a query in the assetRepository that will give me all assets with a certain status, say Stolen.

This means for example: all cars of which their most recent log entry is linked to the status Stolen.

I am struggling with the fact that I need the last log entry of each asset. And only if that entry is linked to a specific status, do I want the asset.

In my specific example cars that were once stolen but returned again, should not appear in the list.

Does anyone know if this is possible using the Querybuilder, and if so, how to do it?

EDIT:

Maybe it will help if I describe what I've done to get the desired result in SQL. This is my SQL-query:

select *
from asset a
join asset_log l
on l.asset_id = a.id
left join asset_log l2
on l2.asset_id = l.asset_id
and l.id > l2.id
where l.receiver_id = 12345
group by l.asset_id
Copy code

This works perfectly, but how do write this in DQL? This is my best attempt:

$qb->select('a', 'l', 'l2')
->from('AssetBundle:Asset', 'a')
->join('a.logEntries', 'l')
->leftJoin('a.logEntries', 'l2', 'ON', 'l2.asset = l.asset')
->where("l.receiver = 12345")
->andWhere('l.id > l2.id')
->groupBy('a.id')
Copy code

This DQL query is executed without error, but gives a different result: assets that should be visible (as they are in the SQL-query) are missing.