laravel query join with only latest record

Question

I'm using Laravel 5.3 and trying to return a heist with it's product and only the latest order and with the latest price history. Both joins don't return anything but if I remove the $q->latest()->first(); and replace it with a simple orderBy() I get all results. My query is:

$data = $heist->with(['product'=> function($query) {
  $query->with(['orders' => function($q) {
    return $q->latest()->first();
  }]);
  $query->with(['price_history' => function($q) {
    return $q->latest()->first();
  }]);
}])->orderBy('completed_at', 'DESC')->orderBy('active', 'DESC')->get();

Answer 1

As discussed in the comments, I believe the simplest way of doing this is

$heists = $heist->with(['product'=> function($query) {
  $query->with([
    'orders' => function($q) {
      return $q->orderBy('created_at', 'desc')->take(1)->get();
    },
    'price_history' => function($q) {
      return $q->orderBy('created_at', 'desc')->take(1)->get();
    }
  ]);
}])->orderBy('completed_at', 'desc')->orderBy('active', 'desc')->get();

Hope this helps :)