vlapenkov

select carrier.id , cc.car_id , rank (*) over (partition by carrier_id ORDER BY cc.created  DESC) 
from carrier.carrier carrier join carrier.carrier_car cc on carrier.id = cc.carrier_id 
order by carrier.id 

vlapenkov

var query =
          from artId in artIds
          join artIdArticle in _dbContext.DetArticle.Select(p => p.Artid)
              on artId equals artIdArticle into outer
          from itemArticle in outer.DefaultIfEmpty()
          select new { artId, itemArticle };