SELECT SUM(mi_distance) AS midi FROM runs WHERE is_delete!='Y' AND challenge=3 AND accnt_idx='1973' AND r_date>='2018-10-29' AND idx<=12707