Recurring bug fixed: only rds that have previous interest was being calculated due to JOIN.. now converted to LEFT JOIN and used expr IFNULL