TYPO3 Core

"Recently updated pages" in special menus content elements cause an SQL error.

Unknown column 'SYS_LASTCHANGED DESC' in 'order clause'

Error appear on line 723 in "typo3/sysext/frontend/Classes/Page/PageRepository.php" when it try to set order

$res->orderBy($sortField);

and $sortField is "SYS_LASTCHANGED DESC".

Suggest fix

$res->orderBy(...GeneralUtility::trimExplode(' ', $sortField, true));