/** * Возвращает идентификаторы родителей указанной ноды. */ public static function getNodeParentIds(Database $db, $id) { $sql = "SELECT `parent`.`id` as `id` " . "FROM `node` AS `self`, `node` AS `parent` " . "WHERE `self`.`left` BETWEEN `parent`.`left` " . "AND `parent`.`right` AND `self`.`id` = ? " . "ORDER BY `parent`.`left`"; return $db->getResultsV("id", $sql, array($id)); }