public static function fetchByParentID($id, $maskLanguages = false, $onlyPrioritized = false, $includeRedirections = true) { $db = eZDB::instance(); $id = (int) $id; $langMask = trim(eZContentLanguage::languagesSQLFilter('ezurlalias_ml', 'lang_mask')); $redirSQL = ''; if (!$includeRedirections) { $redirSQL = " AND is_original = 1"; } $langMask = ''; if ($maskLanguages) { $langMask = "(" . trim(eZContentLanguage::languagesSQLFilter('ezurlalias_ml', 'lang_mask')) . ") AND "; } $query = "SELECT * FROM ezurlalias_ml WHERE {$langMask} parent = {$id} {$redirSQL}"; $rows = $db->arrayQuery($query); $rows = eZURLAliasML::filterRows($rows, $onlyPrioritized); return eZPersistentObject::handleRows($rows, 'eZURLAliasML', true); }