WITH
    params AS (
        SELECT
            2199023256684 AS id,
            CAST ('2011-05-08' AS TIMESTAMP(3)) AS dte
    ),
    messages AS (
            SELECT persons.id, persons.firstName, persons.lastName, posts.id AS message_id, posts.content, posts.creationDate FROM posts, persons
            WHERE posts.creator = (SELECT id FROM params) AND
                persons.id = posts.creator AND posts.creationDate <= (SELECT dte FROM params)
    )
SELECT * FROM messages
ORDER BY creationDate DESC, message_id
;