SS Many_many Join

ss_many_many_sql.php

  <?php
  
  public function filterStuff() {
    // Can't use Search Filter since the object has a base class of SiteTree
    // $results = PostPage::get()->filter(array('Authors.URLSegment:ExactMatch' = 'Trev'));

    // Lets go manually
    $results = PostPage::get()->leftJoin(
      'PostPage_Authors',
      '"PostPage_Authors"."PostPageID" = "PostPage"."ID"'
    )->leftJoin(
      'AuthorPage',
      '"PostPage_Authors"."AuthorPageID" = "AuthorPage"."ID"'
    )->leftJoin(
      'SiteTree_Live',
      '"SL2"."ID" = "PostPage_Authors"."AuthorPageID"',
      'SL2'
    )->where('"SL2"."URLSegment" =  \'Trev\'');

    return $results->renderWith('SomeTemplate');
  }