$query->
from('s_core_countries', 'country'
) ->
leftJoin('country', 's_core_countries_attributes', 'countryAttribute', 'countryAttribute.countryID = country.id'
) ->
where('country.id IN (:ids)'
) ->
setParameter(':ids',
$ids, Connection::PARAM_INT_ARRAY
);
$this->fieldHelper->
addCountryTranslation($query,
$context);
$data =
$query->
execute()->
fetchAll(PDO::FETCH_ASSOC
);
$countries =
[];
foreach ($data as $row) { $country =
$this->countryHydrator->
hydrateCountry($row);
$countries[$country->
getId()] =
$country;
} return $this->
sortByIds($ids,
$countries);
} public function getFallbackCountry(ShopContextInterface
$context): ?Country
{ $query =
$this->connection->
createQueryBuilder();
$query->
select($this->fieldHelper->
getCountryFields());