TypoScript Reference (TSref)

The change refers to http://docs.typo3.org/typo3cms/TyposcriptReference/Functions/Select/Index.html

select.pidInList now supports the new values "root" and "-1".

Add to documentation

Since TYPO3 CMS 6.2 it is possible to select records from the root-page level, like from the table "sys_category". For this case, it is required that "root" is set.
Besides that, version records can be selected directly by setting the value to "-1", this allows to directly select workspace versioned records.

Special keyword: "this" is replaced with the id of the current page, "root" is replaced with the root-page level (records with pid=0)

Example:

// Fetching related sys_category records
// stored in the MM intermediate table
10 = CONTENT
10 {
    table = sys_category
    select {
        pidInList = root,-1
        selectFields = sys_category.*
        join = sys_category_record_mm ON sys_category_record_mm.uid_local = sys_category.uid
        where.data = field:_ORIG_uid // field:uid
        where.intval = 1
        where.wrap = sys_category_record_mm.uid_foreign=|
        orderBy = sys_category_record_mm.sorting_foreign
        languageField = sys_category.sys_language_uid
    }
}

See #57168