... let posts = await Posts .query() .leftJoin(‘post_titles’, function () { this .on(‘post_titles.post_id’, ‘posts.id’) .andOn(‘post_titles.lang_code’, Database.raw(’?’, [‘EN’])) }) ...