Attention

TYPO3 v7 has reached its end-of-life November 30th, 2018 and is not maintained by the community anymore. Looking for a stable version? Use the version switch on the top left.

There is no further ELTS support. It is recommended that you upgrade your project and use a supported version of TYPO3.

select

The select function generates a SQL SELECT query, which is used to read records from the database. select automatically checks whether the records might be "hidden", "deleted", or if they have a "start and end date". If pidInList is used (meaning a list of pages is rendered), the function also checks if the current user is allowed to see all records.

With the help of the select function, it is possible to show the content of a page on all pages. For example:

temp.leftContent = CONTENT
temp.leftContent {

    table = tt_content
    select {

        # The page with ID = 123 is the source.
        pidInList = 123

        # Sorting is the same as in the backend.
        orderBy = sorting

        # Only select the content of the left column.
        where = colPos=1

        # Define the field with the language ID in tt_content.
        languageField = sys_language_uid
    }
}

# Replace the mark ###LEFT### with the output of temp.leftContent.
marks.LEFT < temp.leftContent