Constant LIST_BLOCKS_BY_TIME

pub const LIST_BLOCKS_BY_TIME: &str = "SELECT\n    block.block_address,\n    block.number,\n    block.timestamp_secs,\n    block.timestamp_nanos,\n    solution_set.content_addr\n\nFROM\n    block\n    LEFT JOIN block_solution_set ON block.id = block_solution_set.block_id\n    LEFT JOIN solution_set ON block_solution_set.solution_set_id = solution_set.id\nWHERE\n    (\n        block.timestamp_secs >= :start_secs\n        OR (\n            block.timestamp_secs = :start_secs\n            AND block.timestamp_nanos >= :start_nanos\n        )\n    )\n    AND (\n        block.timestamp_secs < :end_secs\n        OR (\n            block.timestamp_secs = :end_secs\n            AND block.timestamp_nanos < :end_nanos\n        )\n    )\nORDER BY\n    block.number ASC,\n    block.block_address ASC,\n    block_solution_set.solution_set_index ASC\nLIMIT\n    :page_size OFFSET :page_number * :page_size;\n";

SELECT
    block.block_address,
    block.number,
    block.timestamp_secs,
    block.timestamp_nanos,
    solution_set.content_addr

FROM
    block
    LEFT JOIN block_solution_set ON block.id = block_solution_set.block_id
    LEFT JOIN solution_set ON block_solution_set.solution_set_id = solution_set.id
WHERE
    (
        block.timestamp_secs >= :start_secs
        OR (
            block.timestamp_secs = :start_secs
            AND block.timestamp_nanos >= :start_nanos
        )
    )
    AND (
        block.timestamp_secs < :end_secs
        OR (
            block.timestamp_secs = :end_secs
            AND block.timestamp_nanos < :end_nanos
        )
    )
ORDER BY
    block.number ASC,
    block.block_address ASC,
    block_solution_set.solution_set_index ASC
LIMIT
    :page_size OFFSET :page_number * :page_size;