LIST_SOLUTION_SETS

Constant LIST_SOLUTION_SETS 

Source
pub const LIST_SOLUTION_SETS: &str = "SELECT\n    sol_set.content_addr,\n    sol_set.solution_set,\n    sub.timestamp_secs,\n    sub.timestamp_nanos\nFROM\n    solution_set sol_set\nJOIN\n    submission sub\nON\n    sol_set.id = sub.solution_set_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";
Expand description
SELECT
    sol_set.content_addr,
    sol_set.solution_set,
    sub.timestamp_secs,
    sub.timestamp_nanos
FROM
    solution_set sol_set
JOIN
    submission sub
ON
    sol_set.id = sub.solution_set_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