Constant QUERY_STATE_AT_SOLUTION_SET_FINALIZED

pub const QUERY_STATE_AT_SOLUTION_SET_FINALIZED: &str = "SELECT\n    mutation.value\nFROM\n    mutation\n    JOIN solution ON solution.id = mutation.solution_id\n    JOIN block_solution_set ON block_solution_set.solution_set_id = solution.solution_set_id\n    JOIN finalized_block ON finalized_block.block_id = block_solution_set.block_id\nWHERE\n    solution.contract_addr = :contract_ca\n    AND mutation.key = :key\n    AND (\n        finalized_block.block_number,\n        block_solution_set.solution_set_index\n    ) <= (:block_number, :solution_set_index)\nORDER BY\n    finalized_block.block_number DESC,\n    block_solution_set.solution_set_index DESC\nLIMIT\n    1;\n";

SELECT
    mutation.value
FROM
    mutation
    JOIN solution ON solution.id = mutation.solution_id
    JOIN block_solution_set ON block_solution_set.solution_set_id = solution.solution_set_id
    JOIN finalized_block ON finalized_block.block_id = block_solution_set.block_id
WHERE
    solution.contract_addr = :contract_ca
    AND mutation.key = :key
    AND (
        finalized_block.block_number,
        block_solution_set.solution_set_index
    ) <= (:block_number, :solution_set_index)
ORDER BY
    finalized_block.block_number DESC,
    block_solution_set.solution_set_index DESC
LIMIT
    1;