fixed joins for sensor data