pub const GET_SOLUTION_PRED_DATA: &str = "SELECT\n pred_data.value\nFROM\n solution_set\n JOIN solution ON solution.solution_set_id = solution_set.id\n JOIN pred_data ON pred_data.solution_id = solution.id\nWHERE\n solution_set.content_addr = :content_addr AND solution.solution_index = :solution_index;\nORDER BY\n pred_data.pred_data_index ASC\n";
Expand description
SELECT
pred_data.value
FROM
solution_set
JOIN solution ON solution.solution_set_id = solution_set.id
JOIN pred_data ON pred_data.solution_id = solution.id
WHERE
solution_set.content_addr = :content_addr AND solution.solution_index = :solution_index;
ORDER BY
pred_data.pred_data_index ASC