TYPO3 Core

\TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer getQuery()

$this->getQueryConstraints($table, $conf); returns the correct $queryParts Array but the orderBy is not used in the resulting SQL Statement.

Because of this the content elements shown in frontend are not ordered anymore.

Used like this:

lib.dynamicContent = COA
lib.dynamicContent{
...

20 = CONTENT
20 {
    table = tt_content
    select {
        includeRecordsWithoutDefaultTranslation = 1
        where = colPos=0
        pidInList = this
        orderBy = sorting
    }
}

...
}