episode_feed.php

  $episodes = App\Episode::with(['related'])
    ->visible()
    ->recent()
    ->withSlug('pk')
    ->orWhere(function($query){
      $query->withSlug('tf')->
        whereHas('related', function($query){
          $query->where('type', '=', 'parent')
                ->whereHas('related.series', function($query){
                  $query->where('slug', '=', 'pk');
                });
          });
    })
    ->get();

output.txt

array:1 [▼
  0 => array:3 [▼
    "query" => "select * from `episodes` where `hidden` = ? and `unlisted` = ? and `state` = ? and exists (select * from `series` where `episodes`.`series_id` = `series`.`id` and `slug` = ?) and (exists (select * from `series` where `episodes`.`series_id` = `series`.`id` and `slug` = ?) and exists (select * from `episodes_relations` as `self_9e8d1f05b12ae4be32b4eba78bbc6315` where `self_9e8d1f05b12ae4be32b4eba78bbc6315`.`episode_id` = `episodes`.`id` and `type` = ? and exists (select * from `episodes` inner join `episodes_relations` on `episodes`.`id` = `episodes_relations`.`episode_related_id` where `episodes_relations`.`episode_id` = `episodes`.`id` and exists (select * from `series` where `episodes`.`series_id` = `series`.`id` and `slug` = ?) and `episodes`.`deleted_at` is null) and `episodes`.`deleted_at` is null)) and `episodes`.`deleted_at` is null order by `published_at` desc, `created_at` desc"
    "bindings" => array:7 [▼
      0 => false
      1 => false
      2 => "published"
      3 => "pk"
      4 => "tf"
      5 => "parent"
      6 => "pk"
    ]
    "time" => 7.32
  ]
]