leftJoin('menu_router', 'm', 'm.path = ml.router_path'); $query->fields('ml'); // Weight should be taken from {menu_links}, not {menu_router}. $query->addField('ml', 'weight', 'link_weight'); $query->fields('m'); $query->condition('ml.i18n_tsid', $this->tsid); foreach ($query->execute()->fetchAll(PDO::FETCH_ASSOC) as $item) { $item['weight'] = $item['link_weight']; _menu_link_translate($item); $translations[$item['language']] = $item; } return $translations; } }