Search in 3 tables

If it is a join you are looking to do, you can do it in this manner inside your controller:

$result = $this->modelsManager->executeQuery(
    'SELECT * FROM \Placeholder\Models\ModelOne m1, ' .
    '\Placeholder\Models\ModelTwo m2 ' .
    '\Placeholder\Models\ModelThree m3 ' .
    'WHERE m1.id=m2.id AND m2.id=m3.id' .
    'AND m3.id=:id:',
    ['id' => $id]
);