public function appendJoins(QueryBuilder $queryBuilder, $alias, $locale)
{
$queryBuilder->addSelect('type')->addSelect('collection')->addSelect('file')->addSelect('tag')->addSelect('fileVersion')->addSelect('fileVersionMeta')->addSelect('fileVersionDefaultMeta')->addSelect('fileVersionContentLanguage')->addSelect('fileVersionPublishLanguage')->addSelect('creator')->addSelect('changer')->addSelect('creatorContact')->addSelect('changerContact')->leftJoin($alias . '.type', 'type')->leftJoin($alias . '.collection', 'collection')->leftJoin($alias . '.files', 'file')->leftJoin('file.fileVersions', 'fileVersion', 'WITH', 'fileVersion.version = file.version')->leftJoin('fileVersion.tags', 'tag')->leftJoin('fileVersion.categories', 'categories')->leftJoin('categories.translations', 'categoryTranslations')->leftJoin('fileVersion.meta', 'fileVersionMeta')->leftJoin('fileVersion.defaultMeta', 'fileVersionDefaultMeta')->leftJoin('fileVersion.contentLanguages', 'fileVersionContentLanguage')->leftJoin('fileVersion.publishLanguages', 'fileVersionPublishLanguage')->leftJoin($alias . '.creator', 'creator')->leftJoin('creator.contact', 'creatorContact')->leftJoin($alias . '.changer', 'changer')->leftJoin('changer.contact', 'changerContact');
}