isEncDateRagesValied

DELIMITER //
CREATE PROCEDURE isDateRangeValid()
  foo : BEGIN
    
    SET @i = 0;
    SET @j = 1;
    
    DECLARE dates CURSOR FOR SELECT joined FROM user GROUP BY joined LIMIT 10;
    
    WHILE @i < 9 AND @j < 9 DO
      
      SET @d1 = (SELECT joined FROM (SELECT joined FROM user GROUP BY joined LIMIT 10) AS u LIMIT @i, 1);
      SET @d2 = (SELECT joined FROM (SELECT joined FROM user GROUP BY joined LIMIT 10) AS a LIMIT @j, 1);
      
      IF TIMESTAMPDIFF(DAY, @d1, @d2) != 1 THEN
        LEAVE foo;
      END IF;
      
      SET @i = @i + 1;
      SET @j = @j + 1;
      
    END WHILE ;
  END//

DELIMITER ;