Speed up last_raw_sampling_time & fix the new sensor form bug

- last_raw_sampling_time used an unnecessary, slow join
- result_type is deleted from the new sensor form