protected function buildQueryJoins(array $joins, array $leftJoinConditions = [])
{
$return = '';
foreach ($joins as list($joinTable, $joinAlias, $table, $tableColumn, $joinColumn)) {
$return .= " LEFT JOIN {$joinTable}" . ($joinTable !== $joinAlias ? " {$joinAlias}" : '') . " ON {$table}.{$tableColumn} = {$joinAlias}.{$joinColumn}" . (isset($leftJoinConditions[$joinAlias]) ? " {$leftJoinConditions[$joinAlias]}" : '');
}
return $return;
}