symphonycms / symphony-2

            $sort = sprintf('ORDER BY `e`.`modification_date_gmt` %s', self::$_fetchSortDirection);

        // Handle sorting for System ID

        } elseif (self::$_fetchSortField === 'system:id' || self::$_fetchSortField === 'id') {

            $sort = sprintf('ORDER BY `e`.`id` %s', self::$_fetchSortDirection);

        // Handle when the sort field is an actual Field

        } elseif (self::$_fetchSortField && $field = FieldManager::fetch(self::$_fetchSortField)) {

            if ($field->isSortable()) {

                $field->buildSortingSQL($joins, $where, $sort, self::$_fetchSortDirection);

            }

            if (!empty($field) && !$group) {

                $group = $field->requiresSQLGrouping();

            }

        } else if (self::$_fetchSortField === 'system:id' || self::$_fetchSortField === 'id') {

            $sort = 'ORDER BY `e`.`id` ' . self::$_fetchSortDirection;

        } else {

            $sort = sprintf('ORDER BY `e`.`id` %s', self::$_fetchSortDirection);

        }

        if ($field && !$group) {

            $group = $field->requiresSQLGrouping();