FROM (
SELECT r0_.id AS id0
,r0_.Naam AS Naam1
,r0_.Omschrijving AS Omschrijving2
,r0_.aangemaakt AS aangemaakt3
,r0_.gewijzigd AS gewijzigd4
,r0_.verwijderd AS verwijderd5
,g1_.username AS username6
,g1_.username_canonical AS username_canonical7
,g1_.email AS email8
,g1_.email_canonical AS email_canonical9
,g1_.enabled AS enabled10
,g1_.salt AS salt11
,g1_.password AS password12
,g1_.last_login AS last_login13
,g1_.locked AS locked14
,g1_.expired AS expired15
,g1_.expires_at AS expires_at16
,g1_.confirmation_token AS confirmation_token17
,g1_.password_requested_at AS password_requested_at18
,g1_.roles AS roles19
,g1_.credentials_expired AS credentials_expired20
,g1_.credentials_expire_at AS credentials_expire_at21
,g1_.id AS id22
,r0_.GebruikerId AS GebruikerId23
,g1_.group_id AS group_id24
,ROW_NUMBER() OVER (
ORDER BY r0_.aangemaakt DESC
) AS doctrine_rownum
FROM Rapporten r0_ WITH (NOLOCK)
INNER JOIN Gebruiker g1_ ON r0_.GebruikerId = g1_.id
WHERE (g1_.id = ?)
AND (r0_.verwijderd IS NULL)
) AS doctrine_tbl
WHERE doctrine_rownum BETWEEN 1
AND 10