How to get locations with names?

Question

1C-Bitrix

How to get locations with names in one or more languages ​​using D7 WITHOUT FILTERING by name existence?
An example from here: https://dev.1c-bitrix.ru/learning/course/index.php...
does not fit because it is simply not signed correctly there - there is an example "Getting a list of locations with names in the current language with names in current language...", and I need "Getting a list of locations with names in the current language"

Answer 1

$cities = \Bitrix\Sale\Location\LocationTable::getList([
    "select" => ["*", 'NAME_RU' => 'RU_LAN.NAME'],
    'runtime' => [
        'RU_LAN' => [
            'data_type' => \Bitrix\Sale\Location\Name\LocationTable::class,
            'reference' => [
                '=this.ID' => 'ref.LOCATION_ID',
                '=ref.LANGUAGE_ID' => new \Bitrix\Main\DB\SqlExpression('?i', 'ru'),
            ],
            ['join_type' => 'LEFT']
        ],
    ]
])->fetchAll();