distant relations via many-to-many relation

nested relationship can , or distant can be eagerloaded with dot annotation Region::with('countries.tours')->get()

As long as you define the relationship you have no problem at all

$region->tours will not work with above sooution.

I want to use it for something like this: Tour::where('region_id', $region->id)->get();

Is this possible?

Anyone?

for example how should i get total tours in a region?

in an eager loaded relationship... you just query it as normal

$region->countries()->find('id_of_country')->tours()->get()

get the instance of the region.. then find the country you want then load its tours... it is simple as that

@iffifan Sounds like you're wanting to set up hasManyThrough relationships: https://laravel.com/docs/5.2/eloquent-relationships#has-many-through

@supervip this seems better to me

@willvincent I know "Has Many Through" but this is usable when intermediate relation is one-to-many but my intermediate relation is many-to-many How will it work with many-to-many intermediate relation?

I tried this

public function tours()
    {
        return $this->hasManyThrough(Tour::class, Country::class, "region_id", "country_id");
    }

but "country_id" is not available in Tours table. Because Tours and Countries has many to many relation and country_id is in pivot table.