Constant LIST_SOLUTIONS

pub const LIST_SOLUTIONS: &str = "SELECT\n    sol.content_addr,\n    sol.solution,\n    sub.timestamp_secs,\n    sub.timestamp_nanos\nFROM\n    solution sol\nJOIN\n    submission sub\nON\n    sol.id = sub.solution_id\nWHERE\n    (sub.timestamp_secs > :start_secs OR\n    (sub.timestamp_secs = :start_secs AND sub.timestamp_nanos >= :start_nanos))\nAND\n    (sub.timestamp_secs < :end_secs OR\n    (sub.timestamp_secs = :end_secs AND sub.timestamp_nanos < :end_nanos))\nLIMIT :limit\n";

SELECT
    sol.content_addr,
    sol.solution,
    sub.timestamp_secs,
    sub.timestamp_nanos
FROM
    solution sol
JOIN
    submission sub
ON
    sol.id = sub.solution_id
WHERE
    (sub.timestamp_secs > :start_secs OR
    (sub.timestamp_secs = :start_secs AND sub.timestamp_nanos >= :start_nanos))
AND
    (sub.timestamp_secs < :end_secs OR
    (sub.timestamp_secs = :end_secs AND sub.timestamp_nanos < :end_nanos))
LIMIT :limit