TYPO3 Core

In workspaces preview, during the initialization of the result set of Extbase queries, the SQL LIMIT clause is applied too early. This results in an incomplete or incorrect preview of records. The LIMIT should be applied only after the overlaying process has taken place to ensure that all relevant records are correctly considered in the Workspace preview.

Steps to Reproduce:

1. Create a new workspace and add some records, both enabled and disabled.
2. In an Extbase repository, create a query and set a limit to fetch the records, for example

   $this->createQuery()->setLimit(2);

3. Execute the query in the workspace context and initialize the result set to trigger the overlay process
4. Observe that not all expected records are retrieved, as the LIMIT has been applied before the records are properly overlaid.

Expected Behavior:
The LIMIT should be applied after the result set has been overlaid for the Workspace preview, ensuring all records are correctly processed before limiting the result.