SELECT ID , FOO , BAR FROM SAMPLE WHERE 1 = 1 ORDER BY ID DESC LIMIT #{pageSize} OFFSET (#{currentPage} - 1) * #{pageSize}