public static function delete_by_competencyids($competencyids) {
        global $DB;
        if (empty($competencyids)) {
            return true;
        }
        list($insql, $params) = $DB->get_in_or_equal($competencyids);
        return $DB->delete_records_select(self::TABLE, "competencyid $insql", $params);
    }