title: Laravel Query where All
body: <p>I wondered how to make a Where All clause with Laravel
  I'm trying to check if the episodes that a user saw are all the episodes of the series.</p>
  
  <p>I'm using the WhereIn clause but i returns the results if i saw one episode of the serie. </p>
  
  <p>$alleps get all the episodes of the serie
  $seriessaw get all the episodes a user saw</p>
  
  <p>Thank you for your answers ! </p>
  
  <pre><code>    $alleps = DB::table('episodes')
          -&gt;select('episodes.id as ep_id')
          -&gt;join('seasonsepisodes', 'episodes.id', '=', 'seasonsepisodes.episode_id')
          -&gt;join('seriesseasons', 'seasonsepisodes.season_id', '=', 'seriesseasons.season_id')
          -&gt;where('seriesseasons.series_id', '=', $id);
  
      $seriesSaw = DB::table('usersepisodes')
      -&gt;select('usersepisodes.episode_id as ep_id')
      -&gt;where('usersepisodes.user_id', '=', Auth::user()-&gt;id)
      -&gt;whereIn('usersepisodes.episode_id', $alleps)
      -&gt;get();
  </code></pre>