Select
    lu.lot_id,
    clu.type ,
    lu.purchase_object_type
From public.cm_lot_units clu
Inner join public.lot_units lu on lu.id = clu.lot_unit_id and lu.actual= true
Where lu.lot_id in (5050791,5049246,4385259)
Order By lu.lot_id Desc
limit 123