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);

                }

                    $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 (!empty($field) && !$group) {

                $group = $field->requiresSQLGrouping();