SELECT id, internaldate_time_t
    FROM MessageTable
    INDEXED BY MessageTableInternalDateTimeTIndex

        WHERE id IN (
            SELECT docid
            FROM MessageSearchTable
            WHERE 1=1
     AND MessageSearchTable MATCH "d*") AND id NOT IN (
    SELECT message_id
    FROM MessageLocationTable
    WHERE remove_marker = 0
        AND folder_id IN (
2, 5, 7) UNION
    SELECT id
    FROM MessageTable
    WHERE id NOT IN (
        SELECT message_id
        FROM MessageLocationTable
        WHERE remove_marker = 0
    )
) ORDER BY internaldate_time_t DESC LIMIT 1000 OFFSET 0;