eloquent left join with multiple conditions in Laravel

Laravel Redirect To Another URL / Web Page - HTTP Laravel Redirects

Laravel Eloquent Relationships Join Multiple Tables