```php
//without defined relations
return Thread::find()
    ->select('
      boards.name as boardName,
      threads.number as threadNumber,
      threads.sticked as isSticked,
      threads.locked as isLocked,
      threads.is_op_mark_enabled as opMark,
      threads.is_chat as isChat,
      post_data.*')
        ->join('INNER JOIN', 'boards', 'boards.id = board_id')
        ->join('INNER JOIN', 'post_data', 'post_data.id = post_data_id')
        ->all();

//with defined relations
return Thread::find()->innerjoinWith([
'board' => function ($query) use ($boardName){
    $query->where('boards.name = :name', [':name' => $boardName]);
}])
->innerjoinWith('postData')
    ->andWhere('threads.id = post_data.id')
    ->select('post_data.*')
    ->all();

//another example
return Board::find()
    ->where('boards.name = :boardName', [':boardName' => $boardName])
    ->one()
    ->threads;g
```