DECLARE _Events CURSOR FOR
      SELECT `i`.`d`, `i`.`st`, `i`.`v`, `loc`
      FROM `in` AS i
      WHERE
        `i`.UID = `_ID`
      ORDER BY `i`.`d` LIMIT 1000;


OPEN _Events;

    read_loop: LOOP

      FETCH _Events INTO `_date`, `_stat`, `_val`, `_loc`;

      IF done THEN LEAVE read_loop; END IF;

      -- code
      
      END LOOP;

    CLOSE _Events;