select('i18n_blocks', 'i18n') ->fields('i18n', ['ibid', 'module', 'delta', 'type', 'language']) ->fields('b', ['bid', 'module', 'delta', 'theme', 'title']); $query->addField('b', 'module', 'block_module'); $query->addField('b', 'delta', 'block_delta'); $query->leftJoin($this->blockTable, 'b', ('b.module = i18n.module AND b.delta = i18n.delta')); return $query; } /** * {@inheritdoc} */ public function fields() { $fields = parent::fields(); $fields['language'] = $this->t('Language for this field.'); return $fields; } /** * {@inheritdoc} */ public function getIds() { $ids = parent::getIds(); $ids['module']['alias'] = 'b'; $ids['delta']['alias'] = 'b'; $ids['language']['type'] = 'string'; return $ids; } }